restaurant_DB - Laravel Schema Designer

tbl_user

id increments
user_name string (120)
password string (100)
address string (200)
email string (100)
phone string
status integer
bithedate date
timestamps timestamps

tbl_food

id increments
dish_name string (200)
category integer
discerption string (300)
restaurant_id integer
price decimal
price_status integer
status integer
imag binary
timestamps timestamps

tbl_category

id increments
name string (200)
restaurant_id integer
statuse integer
image binary
timestamps timestamps

tbl_order

id increments
restaurant_id string
total decimal
service double
total_after_sev double
tax decimal
tax_value decimal
net decimal
status integer
timestamps timestamps

tbl_order_dtl

id increments
order_id integer
dish_name string (200)
QTY integer
price decimal
service decimal
tax decimal
total string
timestamps timestamps

tbl_reservation

id increments
restaurant_id bigInteger
name string (200)
phone string (100)
email string (100)
vist_count integer
reserv_type string (100)
reserv_date datetime
timestamps timestamps
status integer

restaurant

id increments
name string (200)
address string (300)
phone string (100)
open_days text
open_time text
status integer
timestamps timestamps

tbl_setting

id increments
timestamps timestamps
vat_register string (100)
vat integer
service integer
email_type string (100)
email_host string (100)
port string (100)
user_name string (100)
password string
ssl string

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