catissue_saved_queries

23 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_distribution_protocol.REPORT_ID FK_DP_REPORT_IDR
catissue_query_audit_logs.QUERY_ID FK_QAUDIT_LOG_QID_QUERIES_IDR
catissue_query_folder_queries.QUERY_ID CAT_QFQ_QUERY_ID_CAT_SQ_IDR
os_cp_catalog_settings.QUERY_ID FK_OS_CP_CAT_SETTINGS_QUERYR
os_cp_report_settings.DATA_QUERY_ID FK_CP_RPT_SETTINGS_QUERY_IDR
os_saved_query_deps.QUERY_ID FK_DEPS_PARENT_QUERYR
os_saved_query_deps.SUB_QUERY_ID FK_DEPS_CHILD_QUERYR
os_scheduled_jobs.QUERY_ID FK_SCHED_QUERY_IDR
os_specimen_catalogs.QUERY_ID FK_CATALOGS_QUERY_IDR
os_specimen_catalogs.REQ_QUERY_ID FK_CATALOGS_REQ_QUERY_IDR
TITLE VARCHAR 128 null
CREATED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_SAVED_QUERIES_CREATED_BYR
LAST_UPDATED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_SAVED_QUERIES_UPDATED_BYR
LAST_UPDATED_ON TIMESTAMP 19 CURRENT_TIMESTAMP
QUERY_DEF TEXT 65535 null
DELETED_ON TIMESTAMP 19 √ null
CP_ID BIGINT 19 √ null
catissue_collection_protocol.IDENTIFIER FK_SAVED_QUERY_CPR
CP_GROUP_ID BIGINT 19 √ null
os_cp_groups.IDENTIFIER FK_SAVED_QUERIES_CP_GRP_IDR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_SAVED_QUERIES_CP_GRP_ID Performance Asc CP_GROUP_ID
FK_SAVED_QUERIES_CREATED_BY Performance Asc CREATED_BY
FK_SAVED_QUERIES_UPDATED_BY Performance Asc LAST_UPDATED_BY
FK_SAVED_QUERY_CP Performance Asc CP_ID
IDX_QUERY_DELETED_ON Performance Asc DELETED_ON

Relationships

Close relationships within degrees of separation