mvikas-orders-management-order - Laravel Schema Designer

payment_terms

id increments
parent_id ^FK bigInteger
name string
slug string
status boolean
timestamps timestamps
softDeletes softDeletes

order_items

id increments
order_id ^FK bigInteger
name string
hsn string
make string
quantity smallInteger
unit_id ^FK bigInteger
price double
gst smallInteger
tat timestamp
sales_tat datetime
dispatch_tat datetime
shortage_excess tinyInteger
shortage_excess_type tinyInteger
remarks text
timestamps timestamps
softDeletes softDeletes

units

id increments
name string
slug string
status boolean
timestamps timestamps
softDeletes softDeletes

orders

id increments
order_no bigInteger
mvikas_id ^FK bigInteger
user_id ^FK bigInteger
customer_id ^FK bigInteger
payment_term_id ^FK bigInteger
billing_address text
shipping_address text
billing_gst_tin string (15)
shipping_gst_tin string (15)
note text
term_and_conditions mediumText
created_on timestamp
timestamps timestamps
softDeletes softDeletes

customers

id increments
name string
phone string
email string
company_name string
company_legal_name string
gst_tin string (15)
address text
timestamps timestamps
softDeletes softDeletes

users

id increments
timestamps timestamps
softDeletes softDeletes

mvikas

id increments
name string
email string
phone string
gst_tin string (15)
address text
timestamps timestamps

documents

id increments
timestamps timestamps
softDeletes softDeletes

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