Contains information about CI’s relationship with projects
Data model
Fields
| Field | Type | Description |
|---|---|---|
| ci_ciid* | INT | CI ID, reference table CMDB_CI.id |
| ci_projectid* | INT | Project ID, reference table ASMS_PROJECTS.proj_id |
Primary Key
| PK_CMDB_CI_PROJECT |
|---|
| ci_ciid, ci_projectid |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| ci_ciid* | dbo.CMDB_CI | id | FK02_CMDB_CI_PROJECT |
| ci_projectid* | dbo.ASMS_PROJECTS | proj_id | FK01_CMDB_CI_PROJECT |