os_orders

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_dist_invoices.ORDER_ID FK_OS_DIST_INVOICES_ORD_IDR
os_order_items.ORDER_ID FK_OS_OI_DO_IDR
os_specimen_request_items.DISTRIBUTION_ID FK_OS_REQ_SPMNS_DIST_IDR
NAME VARCHAR 255 null
REQUESTER_ID BIGINT 19 null
catissue_user.IDENTIFIER FK_OS_DO_REQUESTER_IDR
CREATION_DATE TIMESTAMP 19 null
EXECUTION_DATE TIMESTAMP 19 √ null
STATUS VARCHAR 64 null
ORDER_TYPE VARCHAR 64 √ null
ACTIVITY_STATUS VARCHAR 16 √ null
SITE_ID BIGINT 19 √ null
catissue_site.IDENTIFIER FK_OS_DO_SITE_IDR
DISTRIBUTION_PROTOCOL_ID BIGINT 19 null
catissue_distribution_protocol.IDENTIFIER FK_OS_DO_DP_IDR
DISTRIBUTOR_ID BIGINT 19 √ null
catissue_user.IDENTIFIER FK_OS_DO_DISTRIBUTER_IDR
TRACKING_URL VARCHAR 128 √ null
COMMENTS VARCHAR 255 √ null
REQUEST_ID BIGINT 19 √ null
os_specimen_requests.IDENTIFIER FK_OS_ORDERS_REQ_IDR
SPECIMEN_LIST_ID BIGINT 19 √ null
catissue_specimenlist_tags.IDENTIFIER FK_OS_DO_SPMN_LIST_IDR
SPMNS_RESERVED_FOR_DP BIT 1 √ null
CLEAR_LIST_MODE VARCHAR 16 √ null
CLEAR_LIST_ID BIGINT 19 √ null
catissue_specimenlist_tags.IDENTIFIER FK_DO_CLEAR_LIST_IDR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_DO_CLEAR_LIST_ID Performance Asc CLEAR_LIST_ID
FK_OS_DO_DISTRIBUTER_ID Performance Asc DISTRIBUTOR_ID
FK_OS_DO_DP_ID Performance Asc DISTRIBUTION_PROTOCOL_ID
FK_OS_DO_REQUESTER_ID Performance Asc REQUESTER_ID
FK_OS_DO_SITE_ID Performance Asc SITE_ID
FK_OS_DO_SPMN_LIST_ID Performance Asc SPECIMEN_LIST_ID
FK_OS_ORDERS_REQ_ID Performance Asc REQUEST_ID

Relationships

Close relationships within degrees of separation