os_cp_catalog_settings

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
CP_ID BIGINT 19 null
catissue_collection_protocol.IDENTIFIER FK_OS_CP_CAT_SETTINGS_CP_IDR
QUERY_ID BIGINT 19 null
catissue_saved_queries.IDENTIFIER FK_OS_CP_CAT_SETTINGS_QUERYR
CREATED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_OS_CP_CAT_SETTINGS_CREATORR
CREATION_TIME TIMESTAMP 19 null
LAST_UPDATED_BY BIGINT 19 √ null
catissue_user.IDENTIFIER FK_OS_CP_CAT_SETTINGS_UPDATERR
LAST_UPDATE_TIME TIMESTAMP 19 √ null
ACTIVITY_STATUS VARCHAR 16 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_OS_CP_CAT_SETTINGS_CP_ID Performance Asc CP_ID
FK_OS_CP_CAT_SETTINGS_CREATOR Performance Asc CREATED_BY
FK_OS_CP_CAT_SETTINGS_QUERY Performance Asc QUERY_ID
FK_OS_CP_CAT_SETTINGS_UPDATER Performance Asc LAST_UPDATED_BY

Relationships

Close relationships within degrees of separation