Home
pm4exec
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
project
id
increments
timestamps
timestamps
name
string
(255)
short_descr
text
owner
FK
integer
start_date
date
end_date
date
wizard_mode
boolean
restrictions
boolean
project_type
FK
integer
project_level
FK
integer
program1
FK
integer
program2
FK
integer
cost_center
FK
integer
project_director
FK
integer
head_of_project
FK
integer
project_status
FK
integer
guarantor1
FK
integer
guarantor2
FK
integer
guarantor3
FK
integer
pm_definition_role
id
increments
timestamps
timestamps
pm_definition_role
string
(25)
abbreviation
string
(25)
description
text
role_mapping
id
increments
timestamps
timestamps
custom_role
string
(25)
custom_abbreviation
string
(25)
pm_definition_role
FK
integer
description
text
participants
id
increments
timestamps
timestamps
id_project
FK
integer
resource
FK
integer
role
FK
integer
resource
id
increments
timestamps
timestamps
name
string
(255)
surname
string
(255)
office
FK
integer
image
string
(255)
wbs
id
increments
timestamps
timestamps
id_project
FK
integer
name
string
(255)
short_descr
text
id_parent
FK
integer
planned_effort
bigInteger
final_effort
bigInteger
material_cost_budget
bigInteger
material_cost_actual
bigInteger
internal_resource_cost_budget
bigInteger
internal_resource_cost_actual
bigInteger
external_resource_cost_budget
bigInteger
external_resource_cost_actual
string
owner
FK
integer
planned_start_date
date
actual_start_date
date
planned_final_date
date
actual_closing_date
date
milestone
boolean
actual_completion
integer
suspend_activity
boolean
output_phrase
text
link_to_repository
string
(600)
quick_creation
boolean
wbs_sequence
id
increments
timestamps
timestamps
id_project
FK
integer
id_activity
FK
integer
id_predecessor
FK
integer
wbs_contributors
id
increments
timestamps
timestamps
id_project
FK
integer
id_activity
FK
integer
contributor
FK
integer
business_case
id
increments
timestamps
timestamps
id_project
FK
integer
file
string
(600)
it_investments
bigInteger
it_costs
bigInteger
other_non_it_costs
bigInteger
costs_in_progress
bigInteger
internal_it_days
bigInteger
internal_non_it_days
bigInteger
ex_post_approval_date
date
responsible_for_approval
FK
integer
project_type
id
increments
timestamps
timestamps
project_type
string
(255)
description
text
project_level
id
increments
timestamps
timestamps
project_level
string
(255)
description
text
program
id
increments
timestamps
timestamps
program_name
string
(255)
description
text
cost_center
id
increments
timestamps
timestamps
cost_center_label
string
(255)
description
text
funding
id
increments
timestamps
timestamps
id_project
FK
integer
description
text
category
FK
integer
attachment
string
(600)
status
boolean
category_funding
id
increments
timestamps
timestamps
funding_name
string
(255)
project_requisites
id
increments
timestamps
timestamps
id_project
FK
integer
name
string
(255)
deliverable_connected
FK
integer
description
text
attachment
string
(600)
steering_commitee
id
increments
timestamps
timestamps
id_project
FK
integer
resource
FK
integer
project_unit
id
increments
timestamps
timestamps
id_project
FK
integer
unit_name
string
(255)
unit_key_person
FK
integer
critical_resources
FK
integer
effort
bigInteger
stakeholder
id
increments
timestamps
timestamps
id_project
FK
integer
name
string
(255)
mail
string
(255)
stakeholder_flag
FK
integer
notes
text
stakeholder_flag
id
increments
timestamps
timestamps
label
string
(255)
description
text
project_scope
id
increments
timestamps
timestamps
id_project
FK
integer
objectives
text
expected_benefits
text
success_criteria
text
group_companies_involved
id
increments
timestamps
timestamps
id_project
FK
integer
description
text
key_impact
FK
integer
key_people
FK
integer
corporate_functions
id
increments
timestamps
timestamps
id_project
FK
integer
description
text
key_impact
FK
integer
key_people
FK
integer
corporate_processes
id
increments
timestamps
timestamps
id_project
FK
integer
description
text
key_impact
FK
integer
key_people
FK
integer
it_area_involved
id
increments
timestamps
timestamps
id_project
FK
integer
description
text
key_impact
FK
integer
key_people
FK
integer
connected_projects
id
increments
timestamps
timestamps
id_project
FK
integer
description
text
key_impact
FK
integer
key_people
FK
integer
key_impact
id
increments
timestamps
timestamps
label
string
(255)
description
text
office
id
increments
timestamps
timestamps
office_name
string
(255)
description
text
pjt_unit_critical_resources
id
increments
timestamps
timestamps
id_project
FK
integer
resource_id
FK
integer
project_status
id
increments
timestamps
timestamps
project_status
string
(255)
description
text
user
id
increments
timestamps
timestamps
username
string
(255)
password
string
(255)
email
string
(255)
resource_id
FK
integer
user_role
id
increments
timestamps
timestamps
user_id
FK
integer
role_id
FK
integer
operation
id
increments
timestamps
timestamps
name
string
(255)
object
id
increments
timestamps
timestamps
name
string
(255)
permission
id
increments
timestamps
timestamps
operation_id
FK
integer
object_id
FK
integer
description
string
(255)
scope_id
FK
integer
role_permission
id
increments
timestamps
timestamps
role_id
FK
integer
permission_id
FK
integer
scope
id
increments
timestamps
timestamps
name
string
(255)
description
string
(255)
×
Comments for pm4exec
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01