tonicocafe - Laravel Schema Designer

roles

id increments
timestamps timestamps
name string (100)
description string (255)
slug string (100)

permissions

id increments
timestamps timestamps
softDeletes softDeletes
title string (100)
description string (255)
slug string (100)

rolepermissions

id increments
timestamps timestamps
role_id increments
permission_id increments

user_role

id increments
timestamps timestamps
user_id bigIncrements
role_id bigIncrements

customer

id increments
timestamps timestamps
firstname string (100)
email string (155)
mobile bigInteger
password text
is_active tinyInteger
image string (155)
lastname string (100)
address_id integer
customer_gourp_id integer
outletid integer

admin_users

id increments
timestamps timestamps
name string (100)
email string (155)
mobile bigInteger
is_active tinyInteger
image text
password text

customergroup

id increments
timestamps timestamps
name string (100)
description text
slug string (100)

customer_reward

id increments
timestamps timestamps
customer_id integer
order_id integer
description string (155)
date_added datetime
points integer

customeraddress

id increments
timestamps timestamps
firstname string (100)
lastname string (100)
addressline1 string (200)
addressline2 string (200)
city string (100)
postcode integer
district string (100)

outlets

id increments
timestamps timestamps
title string (200)
email string (155)
city string (100)
pincode integer
contactno bigInteger
image text
customfield text
district string (100)
state string (100)
latitude string (10)
longitude string (10)

bankdetails

id increments
timestamps timestamps
outletid integer
bankname string (100)
ifsc string (30)
bankbranch string (155)
accountno string (40)
status integer

category

id increments
timestamps timestamps
name string (100)
slug string (100)
image text
parentid integer
status tinyInteger

menu

id increments
timestamps timestamps
title string (100)
categoryid integer
price decimal (15,4)
taxclass integer
is_available tinyInteger
quantity integer
stock_status_id tinyInteger
description text
image text

outletcategories

id increments
timestamps timestamps
outlet_id integer
category_id integer

outletmenus

id increments
timestamps timestamps
outlet_id integer
menu_id integer

taxclass

id increments
timestamps timestamps
name string (100)
rate decimal (15,4)

desk

id increments
timestamps timestamps
deskcode string (30)
capacity integer
status tinyInteger
outletid integer

booking

id increments
timestamps timestamps
tableid integer
userid integer
token string (30)
status tinyInteger
addressid integer
totalguest integer
bkdatetime datetime
outletid integer

orders

id increments
timestamps timestamps
userid integer
orderdate datetime
ordertype integer
subtotal decimal (14,4)
tax decimal (14,4)
shipping decimal (14,4)
total decimal (14,4)
promocode string (30)
discount decimal (14,4)
grandtotal decimal (14,4)
addressid integer
totalitems integer
outletid integer

order_items

id increments
timestamps timestamps
order_id integer
item_id integer
price decimal (14,4)
discount decimal (14,4)
quantity integer

table_orders

id increments
timestamps timestamps
order_id integer
table_code string
orderdatetime datetime
taken_by integer
status integer
outletid integer

payments

id increments
timestamps timestamps
paymentid string (30)
orderid integer
transaction_no string (100)
status tinyInteger
paymentdate datetime
paymentmethod string (100)

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