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
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

View Definition

Possibly Referenced Tables/Views