catissue_cp_req_specimen

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_cp_req_specimen.PARENT_SPECIMEN_ID FK_PARENT_CP_REQ_SPECIMENR
catissue_cp_req_specimen.POOLED_SPMN_REQ_ID FK_POOLED_SPMN_REQR
catissue_specimen.REQ_SPECIMEN_ID FK_REQ_SPECIMEN_IDR
catissue_tissue_req_specimen.IDENTIFIER FK_TISSUE_REQ_SPECIMENR
os_supply_items.SR_ID FK_SUPPLY_ITEM_SR_IDR
STORAGE_TYPE VARCHAR 255
COLLECTION_PROTOCOL_EVENT_ID BIGINT 19 √ null
catissue_coll_prot_event.IDENTIFIER FK111110456906F39R
LABELFORMAT VARCHAR 255 √ null
SPEC_REQ_LABEL VARCHAR 255 √ null
ACTIVITY_STATUS VARCHAR 20 √ null
SPECIMEN_CLASS VARCHAR 50 √ null
SPECIMEN_TYPE VARCHAR 50 √ null
CONCENTRATION DOUBLE 22 √ null
PARENT_SPECIMEN_ID BIGINT 19 √ null
catissue_cp_req_specimen.IDENTIFIER FK_PARENT_CP_REQ_SPECIMENR
INITIAL_QUANTITY DECIMAL 24,8 √ null
PATHOLOGICAL_STATUS VARCHAR 50 √ null
LINEAGE VARCHAR 50 √ null
COLLECTOR_ID BIGINT 19 √ null
catissue_user.IDENTIFIER FK_COLLECTOR_CP_REQ_SPECIMENR
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_CP_REQ_SPECIMENR
RECEIVED_COMMENTS VARCHAR 500 √ null
RECEIVED_TIMESTAMP DATETIME 19 √ null
RECEIVED_QUALITY VARCHAR 50 √ null
TISSUE_SITE VARCHAR 150 √ null
TISSUE_SIDE VARCHAR 50 √ null
SORT_ORDER SMALLINT 5 √ null
CODE VARCHAR 32 √ null
POOLED_SPMN_REQ_ID BIGINT 19 √ null
catissue_cp_req_specimen.IDENTIFIER FK_POOLED_SPMN_REQR
LABEL_AUTO_PRINT_MODE VARCHAR 32 √ null
LABEL_PRINT_COPIES BIGINT 19 √ null
ANATOMIC_SITE_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_REQ_ANATOMIC_SITER
LATERALITY_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_REQ_LATERALITYR
COLLECTION_PROCEDURE_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_REQ_COLL_PROCR
COLLECTION_CONTAINER_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_REQ_COLL_CONTR
SPECIMEN_CLASS_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_REQ_CLASSR
SPECIMEN_TYPE_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_REQ_TYPER
PATHOLOGICAL_STATUS_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_REQ_PATH_STATUSR
DEFAULT_CUSTOM_FIELD_VALUES TEXT 65535 √ null
PRE_BARCODED_TUBE BIT 1 b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK111110456906F39 Performance Asc COLLECTION_PROTOCOL_EVENT_ID
FK_COLLECTOR_CP_REQ_SPECIMEN Performance Asc COLLECTOR_ID
FK_PARENT_CP_REQ_SPECIMEN Performance Asc PARENT_SPECIMEN_ID
FK_POOLED_SPMN_REQ Performance Asc POOLED_SPMN_REQ_ID
FK_RECEIVER_CP_REQ_SPECIMEN Performance Asc RECEIVER_ID
FK_SPMN_REQ_ANATOMIC_SITE Performance Asc ANATOMIC_SITE_ID
FK_SPMN_REQ_CLASS Performance Asc SPECIMEN_CLASS_ID
FK_SPMN_REQ_COLL_CONT Performance Asc COLLECTION_CONTAINER_ID
FK_SPMN_REQ_COLL_PROC Performance Asc COLLECTION_PROCEDURE_ID
FK_SPMN_REQ_LATERALITY Performance Asc LATERALITY_ID
FK_SPMN_REQ_PATH_STATUS Performance Asc PATHOLOGICAL_STATUS_ID
FK_SPMN_REQ_TYPE Performance Asc SPECIMEN_TYPE_ID
idx_spec_req_pathology_stat Performance Asc PATHOLOGICAL_STATUS
idx_specimen_req_class Performance Asc SPECIMEN_CLASS
idx_specimen_req_type Performance Asc SPECIMEN_TYPE

Relationships

Close relationships within degrees of separation