Represents a relationship between active CIs and users
Data model
Fields
| Field | Type | Description |
|---|---|---|
| fl_int_ci_id* | INT | CI ID, reference table CMDB_CI.id |
| fl_int_user_id* | INT | User ID, reference the AFW_USERS.user_id table |
Primary Key
| PK_CMDB_CI_USER |
|---|
| fl_int_user_id, fl_int_ci_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| fl_int_ci_id* | dbo.CMDB_CI | id | FK01_CMDB_CI_USER |
| fl_int_user_id* | dbo.AFW_USERS | user_id | FK02_CMDB_CI_USER |