keza - Laravel Schema Designer

users

id increments
firstname string (45)
lastname string (45)
email string (255)
password string (255)
profile_img text
role_id ^FK integer
softDeletes softDeletes
timestamps timestamps

sessions

id increments
user_id ^FK integer
device_type string (255)
device_id string (255)
session_key string (255)
remember_token string (255)
timestamps timestamps

roles

id increments
name string (45)
desc string (255)
timestamps timestamps

restaurants

id increments
user_id ^FK integer
name string (45)
address text
desc text
phone_no text
loc_lat decimal (15,8)
loc_long decimal (15,8)
profile_img text
cover_img text
rating float
price_range tinyInteger
city string (255)
country string (255)
softDeletes softDeletes
timestamps timestamps

restaurants_users

id increments
user_id ^FK integer
resturant_id ^FK integer
timestamps timestamps

menu_items

id increments
user_id ^FK integer
restaurant_id ^FK integer
name string (45)
img text
desc text
price decimal
linked_ids text
deleted tinyInteger
updated_to integer
softDeletes softDeletes
timestamps timestamps

menu_items_feedbacks

id increments
user_id ^FK integer
comment text
rating tinyInteger
softDeletes softDeletes
timestamps timestamps

menus

id increments
user_id ^FK integer
restaurant_id ^FK integer
name string (45)
img text
softDeletes softDeletes
timestamps timestamps

menus_menu_items

id increments
menu_id ^FK integer
menu_item_id ^FK integer
timestamps timestamps

orders

id increments
restaurant_id ^FK integer
table_id ^FK integer
user_id ^FK integer
coupon_id integer
order_state_id ^FK integer
order_type_id ^FK integer
order_payment_type_id ^FK integer
ref_code string (15)
timestamps timestamps

order_types

id increments
desc string (255)
name string (15)
timestamps timestamps

tables

id increments
user_id ^FK integer
waiter_user_id ^FK integer
restaurant_id ^FK integer
table_state_id ^FK integer
ref_code string (15)
merged_ids string (255)
softDeletes softDeletes
timestamps timestamps

order_states

id increments
name string (15)
desc string (255)
timestamps timestamps

table_states

id increments
name string (15)
desc string (255)
timestamps timestamps

order_payment_types

id increments
name string (15)
desc string (255)
timestamps timestamps

cc_tokens

id increments
user_id ^FK integer
card_type string (15)
last_4 string (4)
token text
gateway string (15)
timestamps timestamps

orders_menu_items

id increments
order_id ^FK integer
menu_item_id ^FK integer
comment text
timestamps timestamps

menu_items_users_likes

id increments
user_id ^FK integer
menu_item_id ^FK integer
timestamps timestamps

resturants_users_like

id increments
user_id ^FK integer
restaurant_id ^FK integer
timestamps timestamps

restaurant_feedbacks

id increments
user_id ^FK integer
order_id ^FK integer
restaurant_id ^FK integer
rating_1 tinyInteger
rating_2 tinyInteger
rating_3 tinyInteger
rating_4 tinyInteger
rating_5 tinyInteger
comment text
timestamps timestamps

notifications_draft

id bigIncrements
timestamps timestamps

notification_types_draft

id increments
timestamps timestamps

email_queue_draft

id bigIncrements
timestamps timestamps
user_id integer
body text
subject text

invoices_draft

id increments
user_id integer
price decimal
state string
timestamps timestamps

orders_history

id increments
order_history_event_id ^FK integer
order_id ^FK integer
user_id ^FK integer
restaurant_id ^FK integer
order_state_id ^FK integer
coupon_id integer
order_type_id ^FK integer
order_payment_type_id ^FK integer
ref_code string (15)
hist_updated_at timestamp
hist_created_at timestamp
timestamps timestamps
table_id ^FK integer

tables_history

id increments
table_history_event_id ^FK integer
table_id ^FK integer
user_id ^FK integer
waiter_user_id ^FK integer
restaurant_id ^FK integer
table_state_id ^FK integer
ref_code string (15)
merged_ids string (255)
softDeletes softDeletes
timestamps timestamps
hist_updated_at timestamp
hist_created_at timestamp

tables_diners

id increments
user_id ^FK integer
table_id ^FK integer
timestamps timestamps

diners_activity_history_draft

id increments
softDeletes softDeletes
timestamps timestamps

diners_activity_draft

id increments
event string
timestamps timestamps

table_history_event

id increments
name string (15)
desc string (255)
timestamps timestamps

order_history_event

id increments
name string (15)
desc string (255)
timestamps timestamps