MyRest - Laravel Schema Designer

tables

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes
paid timestamp

sub_tables

id increments
table_id ^FK integer
timestamps timestamps
softDeletes softDeletes

menu_items

id increments
area_id ^FK integer
price float (8,2)
name string (255)
ttc integer
active tinyInteger
timestamps timestamps
softDeletes softDeletes

menu_categories

id increments
name string (255)
softDeletes softDeletes

areas

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

menu_item_categories

id increments
menu_category_id ^FK integer
menu_item_id ^FK integer
softDeletes softDeletes

ingredients

id increments
name string (255)
softDeletes softDeletes

menu_item_ingredients

id increments
softDeletes softDeletes
menu_item_id ^FK integer
ingredient_id ^FK integer

menu_category_ingredients

id increments
softDeletes softDeletes
ingredient_id ^FK integer
menu_category_id ^FK integer

waiters

id increments
name string (255)
email string (255)
phone string (255)
level integer
softDeletes softDeletes
timestamps timestamps

orders

id increments
sub_table_id ^FK integer
table_id ^FK integer
waiter_id ^FK integer
status integer
time integer
timestamps timestamps
softDeletes softDeletes

order_items

id increments
menu_item_id ^FK integer
status integer
urgent integer
timestamps timestamps
softDeletes softDeletes

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01