catissue_specimen

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_cell_spe_review_param.SPECIMEN_ID FK_SPEC_CELL_REV_EVENTR
catissue_disposal_event_param.SPECIMEN_ID FK_SPEC_DISPOSAL_EVENTR
catissue_distri_event_param.SPECIMEN_ID FK_SPEC_DISTRI_EVENTR
catissue_embedded_event_param.SPECIMEN_ID FK_SPEC_EMBEDDED_EVENTR
catissue_external_identifier.SPECIMEN_ID FK5CF2FA2160773DB2R
catissue_fixed_event_param.SPECIMEN_ID FK_SPEC_FIXED_EVENTR
catissue_fluid_spe_event_param.SPECIMEN_ID FK_SPEC_FLUID_REV_EVENTR
catissue_frozen_event_param.SPECIMEN_ID FK_SPEC_FROZEN_EVENTR
catissue_in_out_event_param.SPECIMEN_ID FK_SPEC_IN_OUT_EVENTR
catissue_mol_spe_review_param.SPECIMEN_ID FK_SPEC_MOL_REV_EVENTR
catissue_procedure_event_param.SPECIMEN_ID FK_SPEC_PROCEDURE_EVENTR
catissue_spec_tag_items.OBJ_ID FK_SPECLIST_OBJ_IDR
catissue_specimen.PARENT_SPECIMEN_ID FK_PARENT_SPECIMENR
catissue_specimen.POOLED_SPECIMEN_ID FK_POOLED_SPECIMEN_IDR
catissue_specimen_biohz_rel.SPECIMEN_ID FK7A3F553960773DB2R
catissue_specimen_hierarchy.ANCESTOR_ID catissue_specimen_hierarchy_ibfk_2R
catissue_specimen_hierarchy.DESCENDENT_ID catissue_specimen_hierarchy_ibfk_1R
catissue_specimen_position.SPECIMEN_ID FK_SPECIMENR
catissue_spun_event_parameters.SPECIMEN_ID FK_SPEC_SPUN_EVENTR
catissue_thaw_event_parameters.SPECIMEN_ID FK_SPEC_THAW_EVENTR
catissue_tis_spe_event_param.SPECIMEN_ID FK_SPEC_TISSUE_REV_EVENTR
catissue_transfer_event_param.SPECIMEN_ID FK_SPEC_TRANSFER_EVENTR
os_child_spmn_events.SPECIMEN_ID FK_CHILD_SPMN_EVENTS_SPMN_IDR
os_cont_transfer_evt_spmns.SPECIMEN_ID FK_CONT_TRAF_SPMN_IDR
os_container_positions.CHECKOUT_SPECIMEN_ID FK_POS_CHECKED_OUT_SPMN_IDR
os_container_positions.OCCUPYING_SPECIMEN_ID FK_OS_POS_ST_CONTS_OSPIDR
os_container_store_list_items.SPECIMEN_ID FK_STORE_LIST_ITEM_SPMN_IDR
os_delete_spmn_events.SPECIMEN_ID FK_DELETE_EVENT_SPMN_IDR
os_dq_queries.SPECIMEN_ID FK_DQ_QRY_SPECIMENR
os_kit_specimens.SPECIMEN_ID FK_KIT_SPECIMENS_SPECIMEN_IDR
os_order_items.SPECIMEN_ID FK_OS_OI_SPECIMEN_IDR
os_pooled_specimen_items.SPECIMEN_ID FK_POOLED_ITEM_SPECIMEN_IDR
os_pooled_specimens.SPECIMEN_ID FK_POOLED_EVENT_SPMN_IDR
os_shipment_specimens.SPECIMEN_ID OS_FK_SHIP_ITEMS_SPEC_IDR
os_specimen_biohazards.SPECIMEN_ID FK_OS_BIOHZ_SPECIMEN_IDR
os_specimen_request_items.SPECIMEN_ID FK_OS_REQ_SPMNS_SPMN_IDR
os_spmn_external_ids.SPECIMEN_ID FK_EXT_IDS_SPMN_IDR
os_spmn_reserved_events.SPECIMEN_ID FK_RESERVED_SPMN_IDR
os_task_instance_out_items.SPECIMEN_ID FK_TASK_INST_OUT_ITEM_SPMNR
os_workflow_instance_in_items.SPECIMEN_ID FK_WF_INPUT_ITEM_SPECIMEN_IDR
os_workflow_queue_items.SPECIMEN_ID FK_WF_QUEUE_SPECIMEN_IDR
os_workflow_task_deviations.SPECIMEN_ID FK_DEVIATION_TASK_SPMNR
LABEL VARCHAR 255 √ null
BARCODE VARCHAR 255 √ null
COMMENTS TEXT 65535 √ null
ACTIVITY_STATUS VARCHAR 50 √ null
SPECIMEN_COLLECTION_GROUP_ID BIGINT 19 √ null
catissue_specimen_coll_group.IDENTIFIER FK1674810433BF33C5R
REQ_SPECIMEN_ID BIGINT 19 √ null
catissue_cp_req_specimen.IDENTIFIER FK_REQ_SPECIMEN_IDR
AVAILABLE_QUANTITY DECIMAL 24,8 √ null
CREATED_ON TIMESTAMP 19 √ null
COLLECTION_STATUS VARCHAR 50 √ null
SPECIMEN_CLASS VARCHAR 50 √ null
SPECIMEN_TYPE VARCHAR 50 √ null
CONCENTRATION DECIMAL 24,8 √ null
PARENT_SPECIMEN_ID BIGINT 19 √ null
catissue_specimen.IDENTIFIER FK_PARENT_SPECIMENR
INITIAL_QUANTITY DECIMAL 24,8 √ null
PATHOLOGICAL_STATUS VARCHAR 50 √ null
LINEAGE VARCHAR 50 √ null
TISSUE_SITE VARCHAR 150 √ null
TISSUE_SIDE VARCHAR 50 √ null
MORPHOLOGICAL_ABNORMALITY VARCHAR 255 √ null
RF_ID VARCHAR 255 √ null
POOLED_SPECIMEN_ID BIGINT 19 √ null
catissue_specimen.IDENTIFIER FK_POOLED_SPECIMEN_IDR
FREEZE_THAW_CYCLES MEDIUMINT 7 √ null
COLLECTION_PROTOCOL_ID BIGINT 19 null
catissue_collection_protocol.IDENTIFIER FK_SPEC_CP_IDR
PARENT_EVENT_ID BIGINT 19 √ null
os_child_spmn_events.IDENTIFIER FK_PARENT_SPMN_EVENT_IDR
RESERVED_EVENT_ID BIGINT 19 √ null
os_spmn_reserved_events.IDENTIFIER FK_SPMN_RESERVE_EVENT_IDR
IMAGE_ID VARCHAR 255 √ null
EXTENSION_REV BIGINT 19 √ null
CREATION_TIME TIMESTAMP 19 √ null
CREATOR BIGINT 19 √ null
UPDATE_TIME TIMESTAMP 19 √ null
UPDATER BIGINT 19 √ null
ANATOMIC_SITE_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_ANATOMIC_SITER
LATERALITY_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_LATERALITYR
SPECIMEN_CLASS_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_CLASSR
SPECIMEN_TYPE_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_TYPER
PATHOLOGICAL_STATUS_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_PATH_STATUSR
AVAILABILITY_STATUS VARCHAR 32 √ null
POOLED_EVENT_ID BIGINT 19 √ null
os_pooled_specimens.IDENTIFIER FK_SPECIMEN_POOLED_EVENT_IDR
POOL_ITEM BIT 1 b'0'
ADDITIONAL_LABEL VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
CAT_SPECIMEN_BARCODE_IDX Performance Asc BARCODE
CATISSUE_SPECIMEN_ACT_STAT Performance Asc ACTIVITY_STATUS
CATISSUE_SPECIMEN_COLL_STAT Performance Asc COLLECTION_STATUS
CATISSUE_SPECIMEN_LABEL_IDX Performance Asc LABEL
FK_PARENT_SPECIMEN Performance Asc PARENT_SPECIMEN_ID
FK_PARENT_SPMN_EVENT_ID Performance Asc PARENT_EVENT_ID
FK_POOLED_SPECIMEN_ID Performance Asc POOLED_SPECIMEN_ID
FK_REQ_SPECIMEN_ID Performance Asc REQ_SPECIMEN_ID
FK_SPECIMEN_POOLED_EVENT_ID Performance Asc POOLED_EVENT_ID
FK_SPMN_ANATOMIC_SITE Performance Asc ANATOMIC_SITE_ID
FK_SPMN_CLASS Performance Asc SPECIMEN_CLASS_ID
FK_SPMN_LATERALITY Performance Asc LATERALITY_ID
FK_SPMN_PATH_STATUS Performance Asc PATHOLOGICAL_STATUS_ID
FK_SPMN_RESERVE_EVENT_ID Performance Asc RESERVED_EVENT_ID
FK_SPMN_TYPE Performance Asc SPECIMEN_TYPE_ID
idx_init_quantity Performance Asc INITIAL_QUANTITY
idx_pathology_stat Performance Asc PATHOLOGICAL_STATUS
idx_specimen_class Performance Asc SPECIMEN_CLASS
idx_specimen_lineage Performance Asc LINEAGE
idx_specimen_type Performance Asc SPECIMEN_TYPE
INDX_CATISSUE_SPECIMEN_AVQTY Performance Asc AVAILABLE_QUANTITY
OS_CPR_SPMN_STAT_VIEW_IDX Performance Asc/Asc/Asc SPECIMEN_COLLECTION_GROUP_ID + REQ_SPECIMEN_ID + COLLECTION_STATUS
OS_SPMN_ADD_LABEL_UQ Must be unique Asc/Asc ADDITIONAL_LABEL + COLLECTION_PROTOCOL_ID
OS_SPMN_ANATOMIC_SITE_IDX Performance Asc TISSUE_SITE
OS_SPMN_BARCODE_UQ Must be unique Asc/Asc BARCODE + COLLECTION_PROTOCOL_ID
OS_SPMN_CP_IDX Performance Asc COLLECTION_PROTOCOL_ID
OS_SPMN_CREATION_TIME_IDX Performance Asc CREATED_ON
OS_SPMN_LABEL_UQ Must be unique Asc/Asc LABEL + COLLECTION_PROTOCOL_ID

Relationships

Close relationships within degrees of separation