os_specimen_catalogs

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_catalog_req_managers.CATALOG_ID FK_REQ_MGRS_CATALOG_IDR
os_catalog_resources.CATALOG_ID FK_RS_CATALOG_IDR
os_catalog_user_groups.CATALOG_ID FK_USER_GROUPS_CATALOG_IDR
TITLE VARCHAR 64 null
DESCRIPTION VARCHAR 255 √ null
QUERY_ID BIGINT 19 √ null
catissue_saved_queries.IDENTIFIER FK_CATALOGS_QUERY_IDR
REQ_QUERY_ID BIGINT 19 √ null
catissue_saved_queries.IDENTIFIER FK_CATALOGS_REQ_QUERY_IDR
REQ_FORM_ID BIGINT 19 null
dyextn_containers.IDENTIFIER FK_CATALOGS_REQ_FORM_IDR
REQ_NOTIF_RCPTS VARCHAR 255 √ null
UPDATED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_CATALOGS_UPDATED_USR_IDR
UPDATE_TIME TIMESTAMP 19 null
ACTIVITY_STATUS VARCHAR 16 null
REQUIRES_SIGN_IN BIT 1 b'0'
SHOW_DASHBOARD BIT 1 b'1'
SHOW_APP_BUTTONS BIT 1 b'1'
QUERY_MODEL_TYPE VARCHAR 32 √ STANDARD
SPMN_DB_TYPE VARCHAR 32 √ INTEGRATED
DEF_COLUMNS TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_CATALOGS_QUERY_ID Performance Asc QUERY_ID
FK_CATALOGS_REQ_FORM_ID Performance Asc REQ_FORM_ID
FK_CATALOGS_REQ_QUERY_ID Performance Asc REQ_QUERY_ID
FK_CATALOGS_UPDATED_USR_ID Performance Asc UPDATED_BY

Relationships

Close relationships within degrees of separation