Contains the relationship between a project and a contract
Data model
Fields
| Field | Type | Description |
|---|---|---|
| cont_contractid* | INT | Unique Contract Identifier |
| cont_projectid* | INT | Unique Project Identifier |
Primary Key
| PK_ASMS_PROJECT_CONTRACT |
|---|
| cont_contractid, cont_projectid |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| cont_contractid* | dbo.ASMS_CONTRACT | contractid | FK02_ASMS_PROJECT_CONTRACT |
| cont_projectid* | dbo.ASMS_PROJECTS | proj_id | FK01_ASMS_PROJECT_CONTRACT |