emaf - Laravel Schema Designer

client

id increments
timestamps timestamps
name text
mobile string
whatsapp string
mark string
account_number string
email string
company string
balance_aed double
balance_mru double

container

id increments
timestamps timestamps
container_number string
is_fcl boolean
client_id integer
transporting_company_id integer
from_harbor_id integer
to_harbor_id integer
total_cost double
status enum
shipping_date date
arrival_date date
collected_fund double
shipping_yard double
labor double
tax double
other_fees double

shipment

id increments
timestamps timestamps
container_id integer
client_id integer
total_items integer
total_price double
total_area double

harbor

id increments
timestamps timestamps
name string

transporting_company

id increments
timestamps timestamps
name string

account

id increments
timestamps timestamps
name string
balance_aed double
balance_mru double

transaction

id increments
timestamps timestamps
amount double
client_id integer
container_id integer
account_id integer
currency enum
balance_before double
balance_after double

invoice

id increments
timestamps timestamps
client_id integer
date date
total double
account_id integer

invoice_item

id increments
timestamps timestamps
description text
amount double
currency enum
quantity integer
total double

shipment_item

id increments
timestamps timestamps
shipment_id integer
width double
height double
quantity integer
price double
area double
type string

invoice_payment

id increments
timestamps timestamps
invoice_id integer
details text
amount double
date datetime

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