Project baseline, variations and actual costs
Keeps baseline versions, actual costs and authorized changes independently auditable. Original worked design example; adapt responsibilities, thresholds and assumptions to your system.
Rendering…
What this template contains
- Diagram type
- Entity-relationship diagram
- Source
- 53 lines
Make it your own.
erDiagram
PROJECT ||--|{ BASELINE_VERSION : versions
BASELINE_VERSION ||--o{ WORK_PACKAGE : plans
WORK_PACKAGE ||--o{ COST_ENTRY : incurs
PROJECT ||--o{ CHANGE_REQUEST : receives
CHANGE_REQUEST ||--o{ CHANGE_IMPACT : affects
WORK_PACKAGE ||--o{ CHANGE_IMPACT : impacted
CHANGE_REQUEST ||--o| CHANGE_DECISION : resolved
BASELINE_VERSION o|--o{ CHANGE_DECISION : establishes
WORK_PACKAGE ||--o{ PROGRESS_MEASURE : measured
PROJECT {
string project_id PK
string name
}
BASELINE_VERSION {
string baseline_id PK
string project_id FK
string approved_at
}
WORK_PACKAGE {
string package_id PK
string baseline_id FK
string budget
}
COST_ENTRY {
string cost_id PK
string package_id FK
string amount
string period
}
CHANGE_REQUEST {
string change_id PK
string project_id FK
string reason
}
CHANGE_IMPACT {
string impact_id PK
string change_id FK
string package_id FK
string cost_delta
}
CHANGE_DECISION {
string decision_id PK
string change_id FK
string baseline_id FK
string outcome
}
PROGRESS_MEASURE {
string measure_id PK
string package_id FK
string period
string earned_value
}