eat db fit - Laravel Schema Designer

users

id increments
uuid uuid
name string
phone string
username string (64)
email string
password string
gender char (1)
avatar_url string
created_by integer
updated_by integer
deleted_by integer
softDeletes softDeletes
timestamps timestamps

file_infos

id increments
uuid uuid
fileable morphs
url string
name string
disk string (64)
path string
size integer
slug string (64)
data json
updated_by integer
created_by integer
timestamps timestamps

drivers

id increments
uuid uuid
name string
email string
plat_no string
phone string (64)
dob date
gender char (1)
created_by integer
updated_by integer
timestamps timestamps

customers

id increments
uuid uuid
phone string (64)
email string
name string
dob date
lead_id integer
weight smallInteger
target_weight smallInteger
created_by integer
updated_by integer
timestamps timestamps

order_types

id increments
uuid uuid
title string
description text
created_by integer
updated_by integer
start_day string (20)
timestamps timestamps

countries

id increments
uuid uuid
title string
code string (5)
phone_code smallInteger
created_by integer
updated_by integer
timestamps timestamps

provinces

id increments
uuid uuid
title string
country_id integer
created_by integer
updated_by integer
timestamps timestamps

cities

id increments
uuid uuid
title string
province_id integer
created_by integer
updated_by integer
timestamps timestamps

suburbs

id increments
uuid uuid
title string
city_id integer
created_by integer
updated_by integer
timestamps timestamps

menu_categories

id increments
uuid uuid
title string
description text
is_show boolean
created_by integer
updated_by integer
timestamps timestamps

addresses

id increments
uuid uuid
title string
address text
addressable morphs
is_default boolean
country_id integer
province_id integer
city_id integer
suburb_id integer
area_id integer
country_name string
province_name string
city_name string
suburb_name string
area_name string
postcode string (10)
created_by integer
updated_by integer
timestamps timestamps
softDeletes softDeletes
deleted_by integer

customer_leads

id increments
uuid uuid
title string
description text
created_by integer
updated_by integer
timestamps timestamps

orders

id increments
uuid uuid
number string
customer_id integer
customer_lead_id integer
order_type_id integer
menu_category_id integer
package_id integer
data json
description text
pax integer
started_at date
finished_at date
expired_at date
status smallInteger
batch_start_id integer
batch_end_id integer
total integer
created_by integer
updated_by integer
timestamps timestamps
package_qouta integer
total_order integer
total_deliver integer

invoices

id increments
uuid uuid
number string
order_id integer
discount integer
paid_at timestamp
proof_image_url string
bank_name string
bank_account_number string
bank_account_name string
package_order_type string
package_price integer
pax integer
service_fee integer
delivery_fee integer
total_discount integer
total integer
customer_bank_name string
customer_bank_account_number string
customer_bank_account_name string
remark text
data json
created_by integer
updated_by integer
timestamps timestamps
package_menu_category string
tax integer

order_items

id increments
uuid uuid
order_id integer
title string
index integer
created_by integer
updated_by integer
timestamps timestamps

order_releases

id increments
uuid uuid
order_id integer
order_menu_id integer
driver_id integer
notes text
proof_image_url string
status smallInteger
delivered_at timestamp
address text
customer_name string
customer_phone string
is_confirm boolean
confirm_by integer
last_edit_by integer
created_by integer
updated_by integer
timestamps timestamps
batch_date date

news_feeds

id increments
uuid uuid
name string
job_title string
message text
user_id integer
is_save boolean
created_by integer
updated_by integer
timestamps timestamps

batches

id increments
uuid uuid
title string
description text
index integer
is_active boolean
started_at date
finished_at date
promotion_id integer
created_by integer
updated_by integer
timestamps timestamps

batch_menus

id increments
uuid uuid
date date
title text
image_url string
description text
batch_id integer
category_id integer
created_by integer
updated_by integer
timestamps timestamps

packages

id increments
uuid uuid
order_type_id integer
menu_category_id integer
price integer
qouta integer
created_by integer
updated_by integer
timestamps timestamps

order_menus

id increments
uuid uuid
order_id integer
order_item_id integer
batch_id integer
batch_menu_id integer
address_id integer
utensil boolean
is_check boolean
check_by integer
created_by integer
updated_by integer
timestamps timestamps
is_printed boolean
is_ready boolean
plating_by integer
is_deliver boolean
full_note text

test

id increments
uuid uuid
title string
description text
created_by integer
updated_by integer
timestamps timestamps

custom_menus

id increments
uuid uuid
note string
tag_menu_id integer
order_menu_id integer
custom_type_id integer
created_by integer
updated_by integer
timestamps timestamps
total_tag_ids integer

custom_menu_types

id increments
uuid uuid
title string
description text
created_by integer
updated_by integer
timestamps timestamps

promotions

id increments
uuid uuid
title string
amount integer
amount_percent smallInteger
max_amount integer
description text
discount_type smallInteger
created_by integer
updated_by integer
timestamps timestamps

settings

id increments
uuid uuid
label string
slug string
group string
value string
rule_validations string
type_value string
description text
created_by integer
updated_by integer
timestamps timestamps

tag_menus

id increments
uuid uuid
title string
created_by integer
updated_by integer
timestamps timestamps

menu_attributes

id increments
uuid uuid
title string
description text
unit string
created_by integer
updated_by integer
timestamps timestamps
softDeletes softDeletes

batch_menu_attributes

id increments
uuid uuid
batch_menu_id integer
menu_attribute_id integer
value string
created_by integer
updated_by integer
softDeletes softDeletes
timestamps timestamps

package_promotions

id increments
uuid uuid
package_id integer
promo_id integer
is_active boolean
created_by integer
updated_by integer
timestamps timestamps

areas

id increments
uuid uuid
title string
suburb_id integer
postcode string (20)
created_by integer
updated_by integer
timestamps timestamps