cateringcrm - Laravel Schema Designer

contacts

id increments
firstname string (200)
lastname string (200)
email string (200)
phone string (200)
soft_delete smallInteger
created timestamp
updated timestamp
deleted timestamp

organizations

id increments
firstname string (200)
lastname string (200)
email string (200)
phone string (200)
company_name string
soft_delete smallInteger
created timestamp
updated timestamp
deleted string

organizations_orders

id increments
order_id ^FK integer
organization_id ^FK integer
order_date timestamp

menuitems

id increments
title string (200)
price float
quantity integer
image string (200)
deleted smallInteger

orders

id increments
store_id ^FK integer
total_price float
delivery_date timestamp
delivery_address1 string (200)
delivery_address2 string (200)
delivery_city string (200)
delivery_state string (200)
delivery_country string (200)
delivery_zipcode string (200)
created timestamp
updated timestamp
deleted timestamp
soft_delete smallInteger
ordertaken_by ^FK integer

orderdetails

id increments
order_id ^FK integer
menuitem_id ^FK integer
price float
quantity integer
description string (1000)

statuses

id increments
name string (200)

stores

id increments
name string (200)
description string (1000)
email string (200)
soft_delete smallInteger
created timestamp
updated timestamp
deleted timestamp

users

id increments
firstname string (200)
lastname string (200)
email string (200)
password string (200)
created timestamp
updated string
deleted string
soft_delete smallInteger
type enum

subdomains

id increments
organization_id ^FK integer

addresses

id increments
address string (200)
city string (200)
state string (200)
country string (200)
zip_code string (200)

addresses_contacts

id increments
contact_id ^FK integer

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