agrii - Laravel Schema Designer

users

id increments
tenant_id ^FK integer
name string
email string
phone string
type tinyInteger
password string
timestamps timestamps

tenants

id increments
owner_id ^FK integer
tanent_type_id ^FK integer
name string
email string
phone string
is_vendor tinyInteger
is_supplier tinyInteger
timestamps timestamps

tenant_types

id increments
name string
timestamps timestamps

governorates

id increments
name string
timestamps timestamps

areas

id increments
governorate_id ^FK integer
blocks_num tinyInteger
timestamps timestamps

items

id increments
name string
tenant_id ^FK integer
sell_type tinyInteger
price decimal
tax decimal
discount_amount decimal (3,1)
image string
quantity tinyInteger
is_active tinyInteger
timestamps timestamps

area_tenant

area_id ^FK integer
tenant_id ^FK integer

orders

id increments
order_serial_number string
store_id ^FK integer
customer_id ^FK integer
order_status tinyInteger
payment_status integer
order_type tinyInteger
total_amount string
timestamps timestamps

order_items

id increments
customer_id ^FK integer
order_id ^FK integer
item_id ^FK integer
type tinyInteger
price decimal
quantity integer
timestamps timestamps

order_status_logs

id increments
user_id ^FK integer
status tinyInteger
timestamps timestamps

order_notes

id increments
type tinyInteger
user_id ^FK integer
note string
timestamps timestamps
order_id ^FK integer

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