tycas - Laravel Schema Designer

Users

id increments
timestamps timestamps
softDeletes softDeletes
Name string
email string
mobile_no string (11)
user_type enum
client_id ^FK bigInteger

Client

id bigInteger
timestamps timestamps
softDeletes softDeletes
restaurant_name string
unique_code string
gst_number string
primary_contact_no string (11)
secondary_contact_no string
address string
is_razorpay_allowed boolean
is_cred_allowed string

category

id increments
timestamps timestamps
softDeletes softDeletes
client_id ^FK bigInteger
name string
image string

food_item

id increments
timestamps timestamps
softDeletes softDeletes
client_id ^FK bigInteger
name string
image string
base_price string
category_id ^FK bigInteger
item_status enum
is_drink boolean
is_hard_drink boolean

food_size_options

id increments
timestamps timestamps
softDeletes softDeletes
food_item_id ^FK bigInteger
size string
price string

food_customization_type

id increments
timestamps timestamps
softDeletes softDeletes
food_item_id ^FK bigInteger
name string
min_selection_count smallInteger
max_selection_count integer

food_customization_option

id increments
timestamps timestamps
customization_type_id string
name string
price string

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