aslak-crm - Laravel Schema Designer

client

id increments
card_code string (20)
card_name string (255)
email string (100)
price_list_id integer
group_id integer
active boolean
logged_at datetime
timestamps timestamps
softDeletes softDeletes

client_assignment

id increments
client_id integer
user_id integer
timestamps timestamps
softDeletes softDeletes

order

id increments
client_id integer
sap_number string
b2b_number string
status integer
total_amount float
shipping_costs float
address mediumText
postal_code string
city string
country string
phone string
registered_at datetime
delivery_date datetime
timestamps timestamps
softDeletes softDeletes

order_line

id increments
order_id integer
sku string
name string
quantity integer
amount float
discount decimal
timestamps timestamps
softDeletes softDeletes

order_document

id increments
order_id integer
type string
path string
timestamps timestamps
softDeletes softDeletes

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