emaf program - Laravel Schema Designer

client

id increments
timestamps timestamps
softDeletes softDeletes
account_number string
name string
fax string
phone string
mobile string
mark string
company string
country_id integer
city_id integer
user_id integer

country

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

city

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
name_en string
name_ar string

user

id increments
timestamps timestamps
softDeletes softDeletes

currency

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

fund

id increments
timestamps timestamps
softDeletes softDeletes
name string
description text
active boolean

client_fund

id increments
timestamps timestamps
softDeletes softDeletes
client_id integer
currency_id integer
amount double

fund_account

id increments
timestamps timestamps
softDeletes softDeletes
fund_id integer
currency_id integer
amount double

client_fund_history

id increments
timestamps timestamps
softDeletes softDeletes
client_id integer
client_fund_id integer
credit_before double
credit_after double
amount_add double
amount_deduct double
details text
type string
user_id integer

fund_history

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
fund_id integer
fund_account_id integer
credit double
debit double
type string
balance double

shipping_company

id increments
timestamps timestamps
softDeletes softDeletes
name string

port

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

container

id increments
timestamps timestamps
softDeletes softDeletes
number string
type enum
price double
company_id integer
from_port_id integer
to_port_id integer
date datetime
locked boolean
details text
note text

container_client

id increments
timestamps timestamps
softDeletes softDeletes
client_id integer
container_id integer

container_item

id increments
timestamps timestamps
softDeletes softDeletes
container_client_id integer
type string
length double
width double
height double
quantity integer
coeffecient double
volume double
price double

invoice

id increments
timestamps timestamps
softDeletes softDeletes
customer_name string
phone string
date datetime
country string
city string
container_number string
note text

invoice_item

id increments
timestamps timestamps
softDeletes softDeletes
invoice_id integer
details text
quantity integer
price double
total double

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