jp-system - Laravel Schema Designer

restaurants

id increments
unique_code string (20)
is_enabled tinyInteger
is_featured tinyInteger
is_pickup tinyInteger
sequence integer
email string (255)
rd_commission_value float (10,3)
jd_commission_value float (10,3)
rd_commission_type tinyInteger
jd_commission_type tinyInteger
commission_from tinyInteger
delivery_pay tinyInteger
registration_fees float (10,3)
is_trial tinyInteger
trial_end_date date
live_on_date date
same_day_delivery tinyInteger
food_type tinyInteger
status tinyInteger
cover_image string (255)
logo_image string (255)
mobile string (255)
phone string (255)
accept_time integer
prep_time integer
website string (255)
is_catering tinyInteger
avg_order_imit float (10,3)
contact1 string (255)
contact2 string (255)
has_delivery tinyInteger
pick_time_settings tinyInteger
pickup_min_time integer
pickup_max_time integer
delivery_type tinyInteger
timestamps timestamps
softDeletes softDeletes

restaurant_translations

id increments
restaurant_id ^FK integer
locale string (255)
name string (255)
note_msg string (255)
info text
timestamps timestamps
softDeletes softDeletes

restaurant_activations

id increments
restaurant_id ^FK integer
fees float (10,3)
start_date date
end_date date
current tinyInteger
timestamps timestamps
softDeletes softDeletes

payments

id increments
name string (255)
image string (255)
timestamps timestamps
softDeletes softDeletes
is_enabled tinyInteger

restaurant_payments

restaurant_id ^FK integer
payment_id ^FK integer
active tinyInteger

users

id increments
timestamps timestamps
softDeletes softDeletes

countries

id increments
is_default boolean
is_enabled boolean
code string (255)
logo string (255)
image string (255)
timestamps timestamps
softDeletes softDeletes

country_translations

id increments
country_id ^FK integer
locale string (255)
name string (255)
currency string (255)
timestamps timestamps

cities

id increments
country_id ^FK integer
is_enabled tinyInteger
timestamps timestamps
softDeletes softDeletes

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