Elsoady - Laravel Schema Designer

expense_items

id increments
timestamps timestamps
softDeletes softDeletes
name string

positions

id increments
timestamps timestamps
softDeletes softDeletes
name string

missions

id increments
timestamps timestamps
softDeletes softDeletes
name string

employees

id increments
timestamps timestamps
softDeletes softDeletes
name string
position string
daily_salary double
national_id string
mobile string
job_number integer
house_allowance double
site_id integer

vendors

id increments
timestamps timestamps
softDeletes softDeletes
name string
phone string
mobile string
manager string
address text

sites

id increments
timestamps timestamps
softDeletes softDeletes
name string
employee_id integer

stores

id increments
timestamps timestamps
softDeletes softDeletes
site_id integer
employee_id integer

capitals

id increments
timestamps timestamps
softDeletes softDeletes
amount double
site_id integer
employee_id integer

capital_reports

id increments
timestamps timestamps
softDeletes softDeletes
expense_item string
amount double
date datetime
notes text
capital_id integer

storestocks

id increments
timestamps timestamps
softDeletes softDeletes
store_id integer
item_id integer
vendor_id integer
quantity integer
amount double
date date
user_id integer

loans

id increments
timestamps timestamps
softDeletes softDeletes
employee_id integer
amount double
type enum
monthly_amount double
months integer
remain double

expenses

id increments
timestamps timestamps
softDeletes softDeletes
site_id integer
amount double
date datetime
note text
type enum
expense_item string

salary

id increments
timestamps timestamps
softDeletes softDeletes
month date
employee_id integer
total_hours double
deduction double
loan double
site_id integer
total double
salary double
total_days integer

income

id increments
timestamps timestamps
softDeletes softDeletes
site_id integer
name string
amount double
note string
check_number string
check_date date

partnerexpenses

id increments
timestamps timestamps
softDeletes softDeletes
site_id integer
amount double
date date
note string
expense_item string
type enum
partner_id integer

partners

id increments
timestamps timestamps
softDeletes softDeletes
name string

sitesalary

id increments
timestamps timestamps
softDeletes softDeletes
site_id integer
date datetime
total double

items

id increments
timestamps timestamps
softDeletes softDeletes
name string
item_type string
type string
amount double
quantity integer

stockin

id increments
timestamps timestamps
softDeletes softDeletes
item_id integer
quantity integer
amount double
date datetime
user_id string

users

id increments
timestamps timestamps
softDeletes softDeletes

flat

id increments
timestamps timestamps
softDeletes softDeletes
name string
address string
amount double
note text
last_payment datetime

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