os_dq_queries

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_dq_query_comments.QUERY_ID FK_DQ_COMMENT_QUERY_IDR
AUDITOR_ID BIGINT 19 null
catissue_user.IDENTIFIER FK_DQ_QRY_AUDITORR
CREATION_TIME TIMESTAMP 19 null
QUERY_TEXT TEXT 65535 null
CP_ID BIGINT 19 null
catissue_collection_protocol.IDENTIFIER FK_DQ_QRY_CPR
CPR_ID BIGINT 19 √ null
catissue_coll_prot_reg.IDENTIFIER FK_DQ_QRY_CPRR
VISIT_ID BIGINT 19 √ null
catissue_specimen_coll_group.IDENTIFIER FK_DQ_QRY_VISITR
SPECIMEN_ID BIGINT 19 √ null
catissue_specimen.IDENTIFIER FK_DQ_QRY_SPECIMENR
FORM_ID BIGINT 19 √ null
dyextn_containers.IDENTIFIER FK_DQ_QRY_FORMR
FORM_RECORD_ID BIGINT 19 √ null
catissue_form_record_entry.IDENTIFIER FK_DQ_QRY_FRER
FIELD_LABEL VARCHAR 255 null
FIELD_NAME VARCHAR 255 null
FIELD_TYPE VARCHAR 32 null
QUERY_VALUE TEXT 65535 null
RESOLUTION_VALUE TEXT 65535 √ null
ASSIGNED_TO BIGINT 19 √ null
catissue_user.IDENTIFIER FK_DQ_QRY_ASSIGNEDR
STATUS VARCHAR 32 null
CLOSE_TIME TIMESTAMP 19 √ null
ACTIVITY_STATUS VARCHAR 32 null
RESOLUTION_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_DQ_QUERY_RESOLUTIONR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_DQ_QRY_ASSIGNED Performance Asc ASSIGNED_TO
FK_DQ_QRY_AUDITOR Performance Asc AUDITOR_ID
FK_DQ_QRY_CP Performance Asc CP_ID
FK_DQ_QRY_CPR Performance Asc CPR_ID
FK_DQ_QRY_FORM Performance Asc FORM_ID
FK_DQ_QRY_FRE Performance Asc FORM_RECORD_ID
FK_DQ_QRY_SPECIMEN Performance Asc SPECIMEN_ID
FK_DQ_QRY_VISIT Performance Asc VISIT_ID
FK_DQ_QUERY_RESOLUTION Performance Asc RESOLUTION_ID

Relationships

Close relationships within degrees of separation