ini_custom - Laravel Schema Designer

users

id increments
username string
first_name string
last_name string
email string
password string
photo string
remember_token string (100)
activated boolean
token string
email_token string
signup_ip_address ipAddress
softDeletes softDeletes
timestamps timestamps

projects

id increments
name string
package_no string
project_owner string
epc_contractor string
project_type string
starting_date date
construction_period string
schedule_date_of_completion date
project_location string
progress decimal (5,2)
user_id ^FK integer
softDeletes softDeletes
timestamps timestamps

project_tasks

id increments
description text
origin string
unit string
quantity integer
usd decimal
bdt decimal
equivalent_usd decimal
project_id ^FK integer
user_id ^FK integer
softDeletes softDeletes
timestamps timestamps

departments

id increments
name string
note text
timestamps timestamps

status

id increments
name string
note text
timestamps timestamps

project_departments

id increments
project_id ^FK integer
department_id ^FK integer
percentage decimal (5,2)
progress decimal (5,2)
timestamps timestamps

task_status_percentage_details

id increments
task_details_id ^FK integer
status_id ^FK integer
percentage decimal (5,2)
timestamps timestamps
status boolean

task_details

id increments
project_task_id ^FK integer
project_department_id ^FK integer
starting_date date
ending_date date
progress decimal (5,2)
timestamps timestamps

task_users

id increments
task_details_id ^FK integer
user_id ^FK integer
timestamps timestamps

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