frotest - Laravel Schema Designer

mst_employees

id increments
full_name string (50)
email string (50)
created_at timestamps
updated_at timestamps

mst_departments

id increments
depart_name string (50)
cerated_at timestamps
updated_at timestamps

mst_positions

id increments
position_name string (50)
created_at timestamps
updated_at timestamps

mst_clients

id increments
company_name string (50)
pic string (50)
phone string (50)
created_at timestamps
updated_at timestamps

mst_work_categories

id increments
work_cat_name string (50)
created_at timestamps
updated_at timestamps

mst_tasks

id increments
work_cat_id ^FK integer
task_name string (50)
created_at timestamps
modified_at timestamps

trx_employees

id increments
employees_id ^FK integer
departments_id ^FK integer
position_id ^FK integer
created_at timestamp
modified_at timestamp

trx_projects

id increments
project_name string (50)
clients_id ^FK integer
start_date date
end_date date
created_at timestamps
modified_at timestamp

trx_project_members

id increments
projects_id ^FK integer
employees_id ^FK integer
is_pm integer
created_at timestamps
modified_at timestamps

trx_reports

id increments

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