Represents the relationship between a cost center and a project
Data model
Fields
Field | Type | Description |
---|---|---|
cost_id* | INT | Related cost center ID |
proj_id* | INT | Related Project 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 |