lumiere - Laravel Schema Designer

suppliers

id increments
timestamps timestamps
name string (50)
cash_balance double
good_balance double
status tinyInteger

categories

id increments
timestamps timestamps
name string (50)
status tinyInteger

brands

id increments
timestamps timestamps
category_id ^FK bigInteger
name string (50)
release integer
status tinyInteger

country

id increments
timestamps timestamps
name string (50)

governates

id increments
timestamps timestamps
name string (50)
country_id ^FK bigInteger
status tinyInteger

region

id increments
timestamps timestamps
name string
governate_id bigInteger

products

id increments
timestamps timestamps
name string (50)
category_id ^FK bigInteger
brand_id ^FK bigInteger
price double

supplier_orders

id increments
timestamps timestamps
softDeletes softDeletes
num integer
supplier_id ^FK bigInteger
total double
status tinyInteger

supplier_order_items

id increments
timestamps timestamps
supplier_order_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
status tinyInteger

warehouses

id increments
timestamps timestamps
name string (50)
capicty integer
category_id ^FK bigInteger
total_stock integer
status tinyInteger

deprecation

id increments
timestamps timestamps
supplier_order_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
type string
status tinyInteger

shippings

id increments
timestamps timestamps
name string
country_id ^FK bigInteger
governate_id ^FK bigInteger
region_id ^FK bigInteger
price double
type tinyInteger
time_of_delivery string

users

id increments
timestamps timestamps
name string (50)
link string (100)
phone string (50)
country_id ^FK bigInteger
governate_id ^FK bigInteger
region_id ^FK bigInteger
address string
page_id ^FK bigInteger
type string
wallet double
status tinyInteger

pages

id increments
timestamps timestamps
name string (50)
link string (100)
admin_id string

order

id increments
timestamps timestamps
user_id ^FK bigInteger
sub_total double
shipping_id ^FK bigInteger
status integer
total double

order_items

id increments
timestamps timestamps
order_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
status tinyInteger

return_orders

id increments
timestamps timestamps
order_id ^FK bigInteger
product_id ^FK bigInteger
reason string
status tinyInteger

review_orders

id increments
timestamps timestamps
order_id ^FK bigInteger
rate integer
comment text
status tinyInteger

carriers

id increments
timestamps timestamps
name string (50)
wallet double
type tinyInteger
status tinyInteger

admins

id increments
timestamps timestamps
name string
email string
phone string
password string

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