crm_backend - Laravel Schema Designer

Users

id increments
name string
phone string (10)
password string
email string
role_type enum
timestamps timestamps

Rolls

id increments
User_id ^FK integer
unit_id ^FK integer
manufacturing_id ^FK integer
total string
role_type string
roll_material string
roll_weight string
received_by string
received_at string
purchased_from string
approved_by string
timestamps timestamps

Transporations

id increments
name string
transport_email string
transport_phone string
timestamps timestamps

Drivers

id increments
transporation_id ^FK integer
name string
phone string
email string
vehicle_details string
timestamps timestamps

Manufacturing

id increments
roll_id ^FK integer
name string
Location longText
contact_number string
timestamps timestamps

Products

id increments
user_id ^FK integer
Roll_id ^FK integer
total integer
total_weight integer
total_difference integer
product_type enum
timestamps timestamps

Dispatchs

id increments
product_id ^FK integer
transporation_id ^FK integer
name string
email string
phone string
location longText
Transporter enum
timestamps timestamps

Payments

id increments
product_id ^FK integer
payment_method_id ^FK integer
payment_term enum
amount double
timestamps timestamps

Units

id increments
roll_unit enum
value float
timestamps timestamps

documents

id increments
documentable_id integer
documentable_type string
label string
url string
documentable morphs
timestamps timestamps

Methods

id increments
name string
type enum
timestamps timestamps

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