ProductTables - Laravel Schema Designer

products

id bigIncrements
product string
description text
picture string (32)
timestamps timestamps
softDeletes softDeletes

sizes

id bigIncrements
size string (64)
timestamps timestamps
softDeletes softDeletes

product_size

id bigIncrements
product_id ^FK bigInteger
size_id ^FK bigInteger
price double
status boolean
timestamps timestamps
softDeletes softDeletes

product_pictures

id bigIncrements
product_id ^FK bigInteger
picture_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

combos

id bigIncrements
combo string (64)
price double
status boolean
timestamps timestamps
softDeletes softDeletes

combo_items

id bigIncrements
combo_id ^FK bigInteger
product_size_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

combo_Item_options

id bigIncrements
combo_items_id ^FK bigInteger
product_size_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

menu_classifications

id bigIncrements
classification string (32)
timestamps timestamps
softDeletes softDeletes

menu_classification_products

id bigIncrements
classification_id ^FK bigInteger
product_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

ingredients

id bigIncrements
ingredient string (64)
timestamps timestamps
softDeletes softDeletes

measuring_units

id bigIncrements
measuring_unit string (16)
abbreviation string (8)
timestamps timestamps
softDeletes softDeletes

product_size_ingredients

id bigIncrements
product_size_id ^FK bigInteger
ingredient_id ^FK bigInteger
measuring_unit_id ^FK bigInteger
value double
timestamps timestamps
softDeletes softDeletes

pictures

id bigIncrements
picture string
width integer
height integer
size integer
thumbnail string (64)
timestamps timestamps
softDeletes softDeletes

categories

id bigIncrements
category string (64)
description longText
picture_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

inventory

id bigIncrements
inventory string (32)
central boolean
status boolean
timestamps timestamps
softDeletes softDeletes

branches

id bigIncrements
branch string (32)
status boolean
timestamps timestamps
softDeletes softDeletes

branch_inventory

id bigIncrements
inventory_id ^FK bigInteger
branch_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

branch_inventory_ingredients

id increments
branch_inventory_id ^FK bigInteger
ingredient_id ^FK bigInteger
measuring_unit_id ^FK bigInteger
value decimal
timestamps timestamps
softDeletes softDeletes

branch_categories

id bigIncrements
branch_id ^FK bigInteger
category_id ^FK bigInteger
status boolean
timestamps timestamps
softDeletes softDeletes

branch_category_products

id bigIncrements
branch_category_id ^FK bigInteger
product_id ^FK bigInteger
status boolean
timestamps timestamps
softDeletes softDeletes

cashiers

id bigIncrements
branch_id ^FK bigInteger
name string (32)
email string
code integer
password string
status boolean
timestamps timestamps
softDeletes softDeletes

managers

id bigIncrements
branch_id ^FK bigInteger
name string (32)
email string
code integer
password string
status boolean
timestamps timestamps
softDeletes softDeletes

backend_users

id bigIncrements
name string (32)
email string
username string (32)
password string
status boolean
timestamps timestamps
softDeletes softDeletes

activation_codes

id bigIncrements
user_id integer
user_type integer
code string (64)
used boolean
timestamps timestamps
softDeletes softDeletes

cashier_shifts

id bigIncrements
cashier_id ^FK bigInteger
manager_id ^FK bigInteger
start_cash double
end_cash double
cash_status double
timestamps timestamps
softDeletes softDeletes

orders

id bigIncrements
code bigInteger
subtotal double
discount double
tax double
service_fees double
delivery_fees double
total double
paid boolean
source tinyInteger
payment_method tinyInteger
timestamps timestamps
softDeletes softDeletes

cashier_shift_orders

id bigIncrements
cashier_shift_id ^FK bigInteger
order_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

order_products

id bigIncrements
order_id ^FK bigInteger
product_size_id ^FK bigInteger
quantity smallInteger
subtotal double
discount double
combo_id ^FK bigInteger
product_size_price double
timestamps timestamps
softDeletes softDeletes

order_product_combo_item_options

id bigIncrements
timestamps timestamps

order_details

id bigIncrements
timestamps timestamps
softDeletes softDeletes