EMAF - Laravel Schema Designer

client

id increments
timestamps timestamps
softDeletes softDeletes
name string
mark string
email string
account_number string
company_name string
phone string
mobile string
fax string
country_id integer
city_id integer
address string
bank_name string
swift_code string
account_name string
iban string
branch string
passport string
user_id integer
status string
shipping_cost double
total_amount double

country

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

city

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

currency

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

receipt

id increments
timestamps timestamps
softDeletes softDeletes
account_type string
receipt_type string
amount double
currency_id integer
fund_id integer
details text
client_id integer
type_id integer
user_id integer

fund_history

id increments
timestamps timestamps
softDeletes softDeletes
fund_id integer
user_id integer
receipt_id integer
client_id integer

fund

id increments
timestamps timestamps
softDeletes softDeletes
number string
country_id integer
user_id integer
currency_id integer

shipping

id increments
timestamps timestamps
softDeletes softDeletes
number string
container_type_id integer
transport_company_id integer
from_port_id integer
to_port_id integer
who_use string
date string
status string
expense_total double
total double
revenue double
user_id integer
total_shipping double
arrival_date datetime

shipping_client

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
shipping_id integer
client_id integer
total double
total_after double
total_contents integer
total_square double
status enum
pay_status enum

shipping_expense

id increments
timestamps timestamps
softDeletes softDeletes
shiping_id integer
amount double
type_id integer
user_id integer
currency_id string
details integer

shipping_content

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
client_id integer
source string
type enum
goods_type string
height double
width double
length double
number integer
cofactor_id integer
amount double
area double
note text
shipping_id integer
chassis_number string
car_type string
price double
arrival_date datetime
exit_number integer
still_in integer

cofactor

id increments
timestamps timestamps
softDeletes softDeletes
number double

store

timestamps timestamps
id increments
softDeletes softDeletes
number string
phone string
country_id integer
user_id integer
address text
type string

branch

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

content_history

id increments
timestamps timestamps
softDeletes softDeletes
content_id integer
user_id integer
date datetime
details text

user

id increments
timestamps timestamps
softDeletes softDeletes

quotation

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
client_id integer
notes text
price double
total double
expired_at datetime

quotation_items

id increments
timestamps timestamps
softDeletes softDeletes
name string
quantity integer
price double
shipping_price double
quotation_id integer
description string

port

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

transport_company

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string

type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

invoice_items

id increments
timestamps timestamps
softDeletes softDeletes
name string
quantity integer
price double
invoice_id integer
description string

invoice

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
client_id integer
price double
notes text
paid double
remain double

invoice_payment

id increments
timestamps timestamps
softDeletes softDeletes
fund_id integer
amount double
paid_at datetime
note text
invoice_id integer
user_id integer

store_entry

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
store_id integer
client_id integer
source string
type enum
number integer
goods_type string
height double
width double
length double
exit_number integer
still_in integer
amount double
area double
note text
chassis_number string
car_type string
price double
cofactor_id integer

store_exit

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
client_id integer
source string
type enum
goods_type string
height double
width double
length double
number integer
exit_number integer
still_in integer
amount double
area double
note text
chassis_number string
car_type string
price double
cofactor_id integer
shipping_id integer
store_id integer
arrival_date datetime

exit_history

id increments
timestamps timestamps
softDeletes softDeletes
store_exit_id integer
exit_number integer
user_id integer

container_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
price double