Represents the relationship between a cost center and a project
Data model
Fields
| Field | Type | Description |
|---|---|---|
| cost_id* | INT | Related cost center identifier, reference table ASMS_COST_CENTER.id |
| proj_id* | INT | Related project ID, reference table ASMS_PROJECTS.proj_id |
Primary Key
| PK_ASMS_COST_CENTER_PROJECT |
|---|
| proj_id, cost_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| cost_id* | dbo.ASMS_COST_CENTER | id | FK02_ASMS_COST_CENTER_PROJECT |
| proj_id* | dbo.ASMS_PROJECTS | proj_id | FK01_ASMS_COST_CENTER_PROJECT |