MVIKAS-ORDERS-MANAGEMENT-SCM - Laravel Schema Designer

order_items

id increments
timestamps timestamps
softDeletes softDeletes

sub_dispatches

id increments
order_id bigInteger
price_basis_id ^FK bigInteger
freight_charges double
timestamps timestamps
softDeletes softDeletes

price_basis

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

orders

id increments
timestamps timestamps
softDeletes softDeletes

vendors

id increments
sub_dispatch_id ^FK bigInteger
name string
address text
payment_term_id integer
pickup_address text
quantity mediumInteger
email string
softDeletes softDeletes
timestamps timestamps

transportations

id increments
sub_dispatch_id ^FK bigInteger
name string
phone string
address text
email string
payment_term_id integer
freight double
gst_tin string (15)
driver_name string
driver_phone string
vehicle_no string
carrying_capacity smallInteger
vehicle_type_id integer
quantity mediumInteger
vehicle_tracking_url string
timestamps timestamps
softDeletes softDeletes

payment_terms

id increments
timestamps timestamps

vehicle_types

id increments
name string
slug string
timestamps timestamps
softDeletes softDeletes

documents

id increments
timestamps timestamps
softDeletes softDeletes

approval

id increments
timestamps timestamps
user_id string
approvaable morphs
status string
comment string

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