gobazar - Laravel Schema Designer

users

id increments
upazila_id ^FK integer
union_id ^FK integer
name string (100)
email string (50)
mobile string (20)
username string (20)
password string (100)
timestamps timestamps
created_by bigInteger
updated_by bigInteger
created_by_ip string (15)
updated_by_ip string (15)
softDeletes softDeletes

locations

id increments
parent_id mediumInteger
name string (191)
post_code integer
type tinyInteger

categories

id increments
name string (100)
timestamps timestamps
created_by bigInteger
created_by_ip string (15)
updated_by bigInteger
updated_by_ip string (15)
softDeletes softDeletes

units

id increments
name string (25)
timestamps timestamps
created_by bigInteger
created_by_ip string (15)
updated_by bigInteger
updated_by_ip string (15)
softDeletes softDeletes

farmers

id increments
upazila_id ^FK integer
union_id mediumInteger
nid bigInteger
name string (100)
phone string (20)
address text
timestamps timestamps
created_by bigInteger
created_by_ip string (15)
updated_by bigInteger
updated_by_ip string (15)
softDeletes softDeletes

products

id increments
union_id mediumInteger
category_id mediumInteger
farmer_id mediumInteger
unit_id mediumInteger
quantity integer
price double
loadin_point mediumText
timestamps timestamps
created_by bigInteger
created_by_ip string (15)
updated_by bigInteger
updated_by_ip string (15)
softDeletes softDeletes

orders

id increments
order_id string (15)
union_id mediumInteger
customer_id mediumInteger
order_amount double
status enum
created_by bigInteger
timestamps timestamps
created_by_ip string (15)
updated_by bigInteger
updated_by_ip string (15)
softDeletes softDeletes

inventories

id increments
union_id mediumInteger
order_id string (15)
product_id mediumInteger
type enum
quantity float
created_by mediumInteger
created_by_ip string (15)
updated_by mediumInteger
updated_by_ip string (15)
timestamps timestamps
softDeletes softDeletes

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