catissue_specimen_coll_group

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_deidentified_report.SCG_ID FKCDD0DF7B91741663R
catissue_identified_report.SCG_ID FK6A2246DC91741663R
catissue_report_queue.SPECIMEN_COLL_GRP_ID FK214246228CA560D1R
catissue_specimen.SPECIMEN_COLLECTION_GROUP_ID FK1674810433BF33C5R
catissue_specimen_event_param.SPECIMEN_COLL_GRP_ID FK753F33AD8CA560D1R
os_visit_clin_diagnoses.VISIT_ID FK_OS_VISIT_CDS_VISIT_IDR
NAME VARCHAR 255 √ null
BARCODE VARCHAR 255 √ null
COMMENTS VARCHAR 2000 √ null
ENCOUNTER_TIMESTAMP DATETIME 19 √ null
COLLECTION_PROTOCOL_REG_ID BIGINT 19 √ null
catissue_coll_prot_reg.IDENTIFIER FKDEBAF1677E07C4ACR
SURGICAL_PATHOLOGY_NUMBER VARCHAR 50 √ null
COLLECTION_PROTOCOL_EVENT_ID BIGINT 19 √ null
catissue_coll_prot_event.IDENTIFIER FKDEBAF16753B01F66R
COLLECTION_STATUS VARCHAR 50 √ null
DATE_OFFSET INT 10 √ null
COLLECTOR_ID BIGINT 19 √ null
catissue_user.IDENTIFIER FK_USER_EVENT_MAPPINGR
COLLECTION_CONTAINER VARCHAR 50 √ null
COLLECTION_PROCEDURE VARCHAR 50 √ null
COLLECTION_COMMENTS VARCHAR 500 √ null
COLLECTION_TIMESTAMP DATETIME 19 null
RECEIVER_ID BIGINT 19 √ null
catissue_user.IDENTIFIER FK_RECEIVER_ID_SCGR
RECEIVED_COMMENTS VARCHAR 500 √ null
RECEIVED_TIMESTAMP DATETIME 19 √ null
RECEIVED_QUALITY VARCHAR 50 √ null
CLINICAL_STATUS VARCHAR 50 √ null
ACTIVITY_STATUS VARCHAR 50 √ null
SITE_ID BIGINT 19 √ null
catissue_site.IDENTIFIER FK_SITE_ID_SCGR
SPR_NAME VARCHAR 255 √ null
SPR_LOCKED BIT 1 √ b'0'
MISSED_REASON VARCHAR 255 √ null
MISSED_BY BIGINT 19 √ null
COHORT VARCHAR 64 √ null
EXTENSION_REV BIGINT 19 √ null
CREATION_TIME TIMESTAMP 19 √ null
CREATOR BIGINT 19 √ null
UPDATE_TIME TIMESTAMP 19 √ null
UPDATER BIGINT 19 √ null
CLINICAL_STATUS_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_VISIT_CLINICAL_STATUSR
COHORT_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_VISIT_COHORTR
MISSED_REASON_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_VISIT_MISSED_REASONR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
BARCODE Must be unique Asc BARCODE
CATISSUE_SPC_COL_GRP_COL_STAT Performance Asc COLLECTION_STATUS
FK_RECEIVER_ID_SCG Performance Asc RECEIVER_ID
FK_SITE_ID_SCG Performance Asc SITE_ID
FK_USER_EVENT_MAPPING Performance Asc COLLECTOR_ID
FK_VISIT_CLINICAL_STATUS Performance Asc CLINICAL_STATUS_ID
FK_VISIT_COHORT Performance Asc COHORT_ID
FK_VISIT_MISSED_REASON Performance Asc MISSED_REASON_ID
FKDEBAF16753B01F66 Performance Asc COLLECTION_PROTOCOL_EVENT_ID
NAME Must be unique Asc NAME
OS_CPR_VISIT_STAT_VIEW_IDX Performance Asc/Asc/Asc/Asc COLLECTION_PROTOCOL_REG_ID + COLLECTION_PROTOCOL_EVENT_ID + COLLECTION_STATUS + IDENTIFIER
OS_SPR_NO_IDX Performance Asc SURGICAL_PATHOLOGY_NUMBER

Relationships

Close relationships within degrees of separation