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

admins

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

users

id increments
timestamps timestamps
name string
profile_link string
phone string
password string
gouvernment_id ^FK bigInteger
address text
type string
balancd bigInteger
country_id ^FK bigInteger

cities

id increments
timestamps timestamps
name string
gouvernment_id ^FK bigInteger

pages

id increments
timestamps timestamps
name string
page_id ^FK bigInteger
link string
user_id ^FK bigInteger
budget bigInteger

shippings

id increments
timestamps timestamps
country_id ^FK bigInteger
gouvernment_id ^FK bigInteger
city_id ^FK bigInteger
price bigInteger
duration bigInteger
type string

notifications

id increments
timestamps timestamps
title string
description string
notifiable string
notifiable_id bigInteger

warehouses

id increments
timestamps timestamps
name string
capacity bigInteger
category_id ^FK bigInteger
quantity bigInteger
total bigInteger

deprecation_orders

id increments
timestamps timestamps
order_id ^FK bigInteger
product_id ^FK bigInteger
category_id ^FK bigInteger
quantity bigInteger
reason string

orders

id increments
timestamps timestamps
name string
date date
shipping_address string
sub_total string
fees bigInteger
total bigInteger
delivery_date date
status string
shipping_id ^FK bigInteger
page_id ^FK bigInteger

order_items

id increments
timestamps timestamps
order_id ^FK bigInteger
product_id ^FK bigInteger
quantity bigInteger
price bigInteger

return_orders

id increments
timestamps timestamps
order_id ^FK bigInteger
product_id ^FK bigInteger
quantity bigInteger
reason string

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