os_specimen_shipments_view

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
shipment_id BIGINT 19 0
shipment_name VARCHAR 255 null
shipment_type VARCHAR 16 SPECIMEN
request BIT 1 b'0'
request_status BIGINT 19 √ null
requester_id BIGINT 19 √ null
request_date TIMESTAMP 19 √ null
requester_comments VARCHAR 255 √ null
courier_name VARCHAR 255 √ null
tracking_number VARCHAR 255 √ null
tracking_url VARCHAR 255 √ null
sending_site_id BIGINT 19 null
sender_id BIGINT 19 √ null
shipped_date TIMESTAMP 19 √ null
sender_comments VARCHAR 255 √ null
receiving_site_id BIGINT 19 null
received_date TIMESTAMP 19 √ null
receiver_id BIGINT 19 √ null
receiver_comments VARCHAR 255 √ null
received_quality_id BIGINT 19 √ null
container_name VARCHAR 64 √ null
status VARCHAR 16 null
specimen_id BIGINT 19 null
shipment_container_id BIGINT 19 √ 0

View Definition

Possibly Referenced Tables/Views