os_shipments

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_shipment_containers.SHIPMENT_ID OS_SHIP_CONT_SHIP_FKR
os_shipment_notify_users.SHIPMENT_ID OS_FK_SHIP_NOTIFY_SHIP_IDR
os_shipment_specimens.SHIPMENT_ID OS_FK_SHIP_ITEMS_SHIP_IDR
os_specimen_request_items.SHIPMENT_ID FK_OS_REQ_SPMNS_SHIP_IDR
NAME VARCHAR 255 null
COURIER_NAME VARCHAR 255 √ null
TRACKING_NUMBER VARCHAR 255 √ null
TRACKING_URL VARCHAR 255 √ null
SENDING_SITE_ID BIGINT 19 null
catissue_site.IDENTIFIER OS_FK_SHIP_SENDING_SITE_IDR
RECEIVING_SITE_ID BIGINT 19 null
catissue_site.IDENTIFIER OS_FK_SHIP_RECV_SITE_IDR
SHIPPED_DATE TIMESTAMP 19 √ null
SENDER_ID BIGINT 19 √ null
catissue_user.IDENTIFIER OS_FK_SHIP_SENDER_IDR
SENDER_COMMENTS VARCHAR 255 √ null
RECEIVED_DATE TIMESTAMP 19 √ null
RECEIVER_ID BIGINT 19 √ null
catissue_user.IDENTIFIER OS_FK_SHIP_RECEIVER_IDR
RECEIVER_COMMENTS VARCHAR 255 √ null
STATUS VARCHAR 16 null
ACTIVITY_STATUS VARCHAR 16 null
REQUEST_ID BIGINT 19 √ null
os_specimen_requests.IDENTIFIER FK_OS_SHIPMENTS_REQ_IDR
TYPE VARCHAR 16 SPECIMEN
REQUEST BIT 1 b'0'
REQUESTER_ID BIGINT 19 √ null
catissue_user.IDENTIFIER FK_SHIPMENT_REQUESTERR
REQUEST_DATE TIMESTAMP 19 √ null
REQUESTER_COMMENTS VARCHAR 255 √ null
REQUEST_STATUS BIGINT 19 √ null
catissue_permissible_value.identifier FK_SHIPMENT_REQ_STATUSR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_OS_SHIPMENTS_REQ_ID Performance Asc REQUEST_ID
FK_SHIPMENT_REQ_STATUS Performance Asc REQUEST_STATUS
FK_SHIPMENT_REQUESTER Performance Asc REQUESTER_ID
NAME Must be unique Asc NAME
OS_FK_SHIP_RECEIVER_ID Performance Asc RECEIVER_ID
OS_FK_SHIP_RECV_SITE_ID Performance Asc RECEIVING_SITE_ID
OS_FK_SHIP_SENDER_ID Performance Asc SENDER_ID
OS_FK_SHIP_SENDING_SITE_ID Performance Asc SENDING_SITE_ID

Relationships

Close relationships within degrees of separation