restaurant - Laravel Schema Designer

tables

id increments
table_number integer
table_max_num integer
user_id integer
timestamps timestamps
softDeletes softDeletes

table_bills

id increments
bill_id integer
status integer
table_id integer
total_bill integer
discount integer
user_id integer
timestamps timestamps
softDeletes softDeletes

adds

id increments
add_name string
add_value decimal (8,2)
add_type boolean
user_id integer
timestamps timestamps
softDeletes softDeletes

table_bill_add

id increments
table_bill_id integer
add_id integer
add_value decimal (8,2)
timestamps timestamps
softDeletes softDeletes

Reservation

id increments
date datetime
client_id integer
client_name string (255)
client_phone string (255)
table_num tinyInteger
people_num tinyInteger
user_id integer
timestamps timestamps
softDeletes softDeletes

Delivery_add

id increments
name string (255)
address string (255)
area_id tinyInteger
salary integer
phone string (20)
delivery_car tinyInteger
user_id integer
timestamps timestamps
softDeletes softDeletes

areas

id increments
area_name string (255)
user_id integer
timestamps timestamps
softDeletes softDeletes

Delivery_bill

id increments
delivery_bill_id integer
status integer
total_bill integer
discount integer
user_id integer
Delivery_man integer
area_id integer
timestamps timestamps
softDeletes softDeletes

table_bill_details

id increments
bill_id integer
item_id integer
item_price decimal
quanitiy integer
total_item_price decimal
timestamps timestamps
softDeletes softDeletes

Delivery_bill_details

id increments
bill_id integer
item_id integer
item_price decimal
quantity integer
total_item_price integer
timestamps timestamps
softDeletes softDeletes

takeaway_bill

id increments
bill_id integer
total_bill decimal
status integer
discount integer
user_id integer
timestamps timestamps
softDeletes softDeletes

takeaway_bill_details

id increments
bill_id integer
item_id integer
item_price decimal
quanitiy integer
total_item_price decimal
timestamps timestamps
softDeletes softDeletes

item_add

id increments
item_name string (255)
price decimal
user_id integer
timestamps timestamps
softDeletes softDeletes

item_add_Ingredients

id increments
material_id integer
item_id integer
user_id integer
timestamps timestamps
softDeletes softDeletes

materials_add

id increments
material_name string (255)
unit_id integer
user_id integer
timestamps timestamps
softDeletes softDeletes

materials_store

id increments
material_id integer
quanitiy integer
timestamps timestamps
softDeletes softDeletes

main_store

id increments
item_id integer
quanitiy integer
timestamps timestamps
softDeletes softDeletes

units

id increments
unit_name string (255)
timestamps timestamps
softDeletes softDeletes

clients

id increments
client_name string (255)
address string (255)
area_id integer
phone1 string (50)
phone2 string (50)
timestamps timestamps
softDeletes softDeletes

users

id increments
name string (255)
email string (255)
password string (50)
remember_token string (100)
timestamps timestamps
softDeletes softDeletes

log_system

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date_event datetime
event string (100)

suppliers

id increments
supplier_name string (255)
tel integer
address string (255)
balance decimal
user_id integer
timestamps timestamps
softDeletes softDeletes

purchases_bill

id increments
purchase_id integer
purchase_date datetime
supplier_id integer
total_bill decimal
discount integer
mony_safe integer
user_id integer
timestamps timestamps
softDeletes softDeletes

purchases_bill_details

id increments
purchase_id integer
material_id integer
material_price decimal
quantity integer
total_material_price decimal
timestamps timestamps
softDeletes softDeletes

Delivery_bill_add

id increments
delivery_bill_id integer
add_id integer
add_value decimal
timestamps timestamps
softDeletes softDeletes

takeaway_bill_add

id increments
timestamps timestamps
softDeletes softDeletes
takeaway_bill_id integer
add_id integer
add_value integer

items_cats

id increments
cat_name string (255)
timestamps timestamps
softDeletes softDeletes