pm4exec - Laravel Schema Designer

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)