os_shipment_specimens

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
SHIPMENT_ID BIGINT 19 null
os_shipments.IDENTIFIER OS_FK_SHIP_ITEMS_SHIP_IDR
SPECIMEN_ID BIGINT 19 null
catissue_specimen.IDENTIFIER OS_FK_SHIP_ITEMS_SPEC_IDR
RECEIVED_QUALITY VARCHAR 255 √ null
SHIPMENT_CONTAINER_ID BIGINT 19 √ null
os_shipment_containers.IDENTIFIER FK_SHIP_SPMN_CONT_IDR
RECEIVED_QUALITY_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SHIP_SPMN_RECV_QLTYR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_SHIP_SPMN_CONT_ID Performance Asc SHIPMENT_CONTAINER_ID
FK_SHIP_SPMN_RECV_QLTY Performance Asc RECEIVED_QUALITY_ID
OS_FK_SHIP_ITEMS_SHIP_ID Performance Asc SHIPMENT_ID
OS_FK_SHIP_ITEMS_SPEC_ID Performance Asc SPECIMEN_ID

Relationships

Close relationships within degrees of separation