mobi_ark - Laravel Schema Designer

products

id increments
name string (255)
parent_id ^FK integer
product_category_id ^FK integer
timestamps timestamps
softDeletes softDeletes

products_categories

id increments
name string (255)
parent_id ^FK integer
timestamps timestamps
softDeletes softDeletes

products_variations

id increments
name string (255)
parent_id ^FK integer
product_id ^FK integer
timestamps timestamps
softDeletes softDeletes

products_instances

id increments
name string (255)
product_variation_id ^FK integer
timestamps timestamps
softDeletes softDeletes

products_abstractions

id increments
abstractable_Id integer
abstractable_type string (255)
timestamps timestamps
softDeletes softDeletes

products_identifiers

id increments
name string (255)
product_abstraction_id ^FK integer
product_identifier_type_id ^FK integer
timestamps timestamps
softDeletes softDeletes

products_identifiers_types

id increments
name string (255)
person_id ^FK integer
timestamps timestamps
softDeletes softDeletes

person

id increments
name string (255)
preferred_name string (255)
timestamps timestamps
softDeletes softDeletes

listings

id increments
currency_id ^FK integer
marketplace_id ^FK integer
product_abstraction_id ^FK integer
price decimal (8,2)
quantity_available integer
timestamps timestamps
softDeletes softDeletes

marketplaces

id increments
name string (255)
parent_id ^FK integer
person_id ^FK integer
timestamps timestamps
softDeletes softDeletes

currencies

id increments
name string (255)
iso_4217_code string (255)
timestamps timestamps
softDeletes softDeletes

products_attributes

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

products_attributes_values

id increments
name string (255)
product_attribute_id ^FK integer
timestamps timestamps
softDeletes softDeletes
parent_id ^FK integer

products_allowed_attributes

id increments
product_abstraction_id ^FK integer
product_allowed_attribute_id ^FK integer
timestamps timestamps
softDeletes softDeletes

products_allowed_attributes_values

id increments
product_abstraction_id ^FK integer
product_attribute_value_id ^FK integer
timestamps timestamps
softDeletes softDeletes

products_actual_attribute_values

id increments
product_abstraction_id ^FK integer
product_attribute_value_id ^FK integer
timestamps timestamps
softDeletes softDeletes

stock

id increments
location_id ^FK integer
quantity_available decimal (8,4)
products_abstraction_id ^FK integer
timestamps timestamps
softDeletes softDeletes

locations

id increments
name string (255)
parent_id ^FK integer
timestamps timestamps
softDeletes softDeletes

lines

id increments
name string (255)
description text
currency_id ^FK integer
lineable_id integer
lineable_type string (255)
listing_id ^FK integer
product_abstraction_id ^FK integer
product_unique_stockbook_number string (255)
quantity_of_product decimal (8,4)
net_value_per_product decimal (8,4)
vat_value_per_product decimal (8,4)
gross_value_per_product decimal (8,4)
net_total decimal (8,2)
vat_total decimal (8,2)
gross_total decimal (8,2)
net_value_per_product_currency decimal (8,4)
vat_value_per_product_currency decimal (8,4)
gross_value_per_product_currency decimal (8,4)
net_total_currency decimal (8,2)
vat_total_currency decimal (8,2)
gross_total_currency decimal (8,4)
timestamps timestamps
softDeletes softDeletes

order

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK integer
supplier_id ^FK integer
datetime_accepted datetimeTz
accepted_by_person_id ^FK integer
is_accepted boolean
is_cancelled boolean
datetime_cancelled datetimeTz
cancelled_by_person_id ^FK integer

delivery

id increments
courier_id ^FK integer
customer_id ^FK integer
supplier_id ^FK integer
courier_tracking_number string (255)
datetime_courier_delivery datetimeTz
date_actual date
date_expected date
quantity_total decimal (8,4)
timestamps timestamps
softDeletes softDeletes
order_id ^FK integer

invoice

id increments
name string (255)
description text
currency_id ^FK integer
customer_id ^FK integer
supplier_id ^FK integer
settlement_days integer
settlement_days_is_eom boolean
date_ledger date
date_tax_point date
net_total_currency decimal (8,2)
vat_total_currency decimal (8,2)
gross_total_currency decimal (8,2)
net_total decimal (8,2)
vat_total decimal (8,2)
gross_total decimal (8,2)
timestamps timestamps
softDeletes softDeletes
financial_period_id ^FK integer

settlement

id increments
bank_account_from_id ^FK integer
bank_account_to_id ^FK integer
currency_id ^FK integer
customer_id ^FK integer
supplier_id ^FK integer
date_ledger date
datetime_actual datetimeTz
amount decimal (8,2)
amount_currency decimal (8,2)
timestamps timestamps
softDeletes softDeletes

cost_codes

id increments
timestamps timestamps
softDeletes softDeletes

quotes

id increments
name string (255)
description text
customer_id ^FK integer
supplier_id ^FK integer
date_expires date
timestamps timestamps
softDeletes softDeletes

bank_account

id increments
person_id ^FK integer
sort_code integer
account_number integer
iban string (255)
bic string (255)
timestamps timestamps
softDeletes softDeletes
name string (255)

invoices_reconciliations

id increments
invoice_id ^FK integer
settlement_id ^FK integer
invoice_amount_reconciled decimal (8,2)
invoice_currency_id ^FK integer
settlement_amount_reconciled decimal (8,2)
settlement_currency_Id ^FK integer
timestamps timestamps
softDeletes softDeletes

appointments

id increments
timestamps timestamps
softDeletes softDeletes
date_from date
date_to date
hours_per_week decimal (8,2)
date_continuous_employment date
position_id ^FK integer
person_id ^FK integer

positions

id increments
job_id ^FK integer
location_id ^FK integer
team_id ^FK integer
hours_per_week decimal (8,2)
timestamps timestamps
softDeletes softDeletes

jobs

id increments
timestamps timestamps
softDeletes softDeletes

teams

id increments
timestamps timestamps
softDeletes softDeletes

jobs_grades

id increments
timestamps timestamps
softDeletes softDeletes

sickness

id increments
appointment_id ^FK integer
approver_id ^FK integer
datetime_approved datetimeTz
date_from date
date_to date
category_sickness_type_id integer
timestamps timestamps
softDeletes softDeletes

holidays

id increments
appointment_id ^FK integer
approver_id ^FK integer
datetime_approved datetimeTz
date_from date
date_to date
timestamps timestamps
softDeletes softDeletes

pay_rates

id increments
appointment_id ^FK integer
date_from date
date_to string
pay_per_hour decimal (8,2)
pay_per_month decimal (8,2)
pension_match_limit_1 decimal (8,2)
pension_multiplier_1 decimal (8,2)
pension_match_limit_2 decimal (8,2)
pension_multiplier_2 decimal (8,2)
pension_match_limit_3 decimal (8,2)
pension_multiplier_3 decimal (8,2)
timestamps timestamps
softDeletes softDeletes

contracts

id increments
name string (255)
description text
full_markdown text
days_holiday decimal (8,2)
bank_holidays_mandatory boolean
is_zero_hours boolean
is_fixed_term boolean
timestamps timestamps
softDeletes softDeletes

appointments_contracts

id increments
timestamps timestamps
softDeletes softDeletes
appointment_id ^FK integer
contract_id ^FK integer
date_from date
date_to date

timesheets

id increments
appointment_id ^FK integer
gross_pay_id ^FK integer
project_id ^FK integer
process_id ^FK integer
mins_logged integer
timestamps timestamps
softDeletes softDeletes

processes

id increments
timestamps timestamps
softDeletes softDeletes

projects

id increments
name string (255)
description text
appointment_id ^FK integer
cost_code_id ^FK integer
document_brief_id integer
budget decimal (8,2)
timestamps timestamps
softDeletes softDeletes
document_plan_id ^FK integer
document_lessons_learned_id ^FK integer
document_closure_id ^FK integer

financial_periods

id increments
timestamps timestamps
softDeletes softDeletes

appointments_gross_pay

id increments
appointment_id ^FK integer
financial_period_id ^FK integer
gross_pay decimal (8,2)
timestamps timestamps
softDeletes softDeletes

roles

id increments
timestamps timestamps
softDeletes softDeletes

jobs_roles

id increments
timestamps timestamps
softDeletes softDeletes

roles_routes

id increments
timestamps timestamps
softDeletes softDeletes

view

id increments
timestamps timestamps
softDeletes softDeletes

routes

id increments
timestamps timestamps
softDeletes softDeletes

documents

id increments
timestamps timestamps
softDeletes softDeletes

projects_tasks

id increments
timestamps timestamps
softDeletes softDeletes

projects_schedules

id increments
timestamps timestamps
softDeletes softDeletes

projects_reports

id increments
timestamps timestamps
softDeletes softDeletes

projects_changes

id increments
timestamps timestamps
softDeletes softDeletes