ParkNWash Sep 2 - Laravel Schema Designer

fixed_assets

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
date datetime
price double
description_en text
description_ar text
category_id integer
country_id integer
mall_id integer

asset_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

capital_transaction

id increments
timestamps timestamps
softDeletes softDeletes
partner_id integer
amount double
date datetime
notes text
country_id integer
mall_id integer

vendor

id increments
timestamps timestamps
softDeletes softDeletes
mall_id integer
name_en string
name_ar string
phone string
email string
company_name_en string
company_name_ar string
country_id integer
city_id integer
address_en string
address_ar string
balance double
tax_number string
status enum

product

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
serial string
category_id integer
barcode string
amount integer
buy_price double
sellable boolean
country_id integer
mall_id integer

bill

id increments
timestamps timestamps
softDeletes softDeletes
vendor_id integer
issue_date datetime
due_date datetime
supply_date datetime
notes text
country_id integer
mall_id string

product_category

id increments
timestamps timestamps
softDeletes softDeletes

bill_product

id increments
timestamps timestamps
softDeletes softDeletes
bill_id integer
product_id integer
amount integer
price integer
total double
country_id integer
mall_id integer

country

id increments
timestamps timestamps
softDeletes softDeletes

city

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

mall

id increments
timestamps timestamps
softDeletes softDeletes

partner

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
phone string
percent double
total double
country_id integer
mall_id integer

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