os_specimen_request_items

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
REQUEST_ID BIGINT 19 null
os_specimen_requests.IDENTIFIER FK_OS_REQ_SPMNS_REQ_IDR
SPECIMEN_ID BIGINT 19 null
catissue_specimen.IDENTIFIER FK_OS_REQ_SPMNS_SPMN_IDR
STATUS VARCHAR 32 null
DISTRIBUTION_ID BIGINT 19 √ null
os_orders.IDENTIFIER FK_OS_REQ_SPMNS_DIST_IDR
SHIPMENT_ID BIGINT 19 √ null
os_shipments.IDENTIFIER FK_OS_REQ_SPMNS_SHIP_IDR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_OS_REQ_SPMNS_DIST_ID Performance Asc DISTRIBUTION_ID
FK_OS_REQ_SPMNS_REQ_ID Performance Asc REQUEST_ID
FK_OS_REQ_SPMNS_SHIP_ID Performance Asc SHIPMENT_ID
FK_OS_REQ_SPMNS_SPMN_ID Performance Asc SPECIMEN_ID

Relationships

Close relationships within degrees of separation