Contains the relationship between a project and a company/supplier
Data model
Fields
| Field | Type | Description |
|---|---|---|
| proj_id* | INT | Unique identifier of the project, reference to the ASMS_PROJECTS.proj_id table |
| type_id* | INT | Type identifier for the project and the company/vendor, reference the ASMS_TYPES.id table |
| vendor_id* | INT | Unique identifier of the company/supplier, reference to table ASMS_COMPANY. Id |
Primary Key
| PK_ASMS_PROJECT_VENDOR |
|---|
| vendor_id, type_id, proj_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| proj_id* | dbo.ASMS_PROJECTS | proj_id | FK02_ASMS_PROJECT_VENDOR |
| vendor_id* | dbo.ASMS_COMPANY | id | FK01_ASMS_PROJECT_VENDOR |