ERP-Systeam - Laravel Schema Designer

countries

id increments
timestamps timestamps
name string (191)

cities

id increments
timestamps timestamps
country_id ^FK integer
name string (191)

units

id increments
timestamps timestamps
name string (191)

vats

id increments
timestamps timestamps
name string (191)
value integer

employees

id increments
timestamps timestamps
full_name string (191)
mobile_number string
tel_number string (191)
email string (191)
designation text
address text
country_id ^FK integer
branch string (191)
remark string (191)
employee string (191)
image string (191)
user_name string (191)
password string (191)

currencies

id increments
timestamps timestamps
name string (191)
symbol string (191)

currency_convertions

id increments
timestamps timestamps
rate string (191)
currency_name string (191)
converted_currency_name string (191)

customers

id increments
timestamps timestamps
name string (191)
name_arabic string (191)
city_id ^FK integer
address text
designation text
phone string (191)
mobile string
contact_person string (191)
contact_person_no string (191)
trn_no string
email string (191)
credit_limit string (191)
credit_days string (191)
vat_type string (191)
fax_no string (191)
license_no string
license_expay_date date

vendors

id increments
timestamps timestamps
name string (191)
name_arabic string (191)
city_id integer
address text
designation text
phone string (191)
mobile string
contact_person string (191)
contact_person_no string (191)
trn_no string
email string (191)
credit_limit string (191)
credit_days string (191)
vat_type string (191)
fax_no string (191)
license_no string
license_expay_date date

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