Home
ini_custom
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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