os_supply_shipments

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_supply_shipment_items.SHIPMENT_ID FK_SUPPLY_SHIPMENT_SUPPLYR
CP_ID BIGINT 19 null
catissue_collection_protocol.IDENTIFIER FK_SUPPLY_SHIPMENT_CPR
SENDER_ID BIGINT 19 null
catissue_user.IDENTIFIER FK_SUPPLY_SHIPMENT_SENDERR
SHIPPED_TIME TIMESTAMP 19 null
SENDER_COMMENTS VARCHAR 255 √ null
RECEIVER_ID BIGINT 19 √ null
catissue_user.IDENTIFIER FK_SUPPLY_SHIPMENT_RECEIVERR
RECEIVED_TIME TIMESTAMP 19 √ null
RECEIVER_COMMENTS VARCHAR 255 √ null
COURIER VARCHAR 255 √ null
TRACKING_NUMBER VARCHAR 255 √ null
TRACKING_URL VARCHAR 255 √ null
STATUS VARCHAR 32 null
SENDING_SITE_ID BIGINT 19 null
catissue_site.IDENTIFIER FK_SUPPLY_SHIP_SEND_SITE_IDR
RECEIVING_SITE_ID BIGINT 19 null
catissue_site.IDENTIFIER FK_SUPPLY_SHIP_RECV_SITE_IDR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_SUPPLY_SHIP_RECV_SITE_ID Performance Asc RECEIVING_SITE_ID
FK_SUPPLY_SHIP_SEND_SITE_ID Performance Asc SENDING_SITE_ID
FK_SUPPLY_SHIPMENT_CP Performance Asc CP_ID
FK_SUPPLY_SHIPMENT_RECEIVER Performance Asc RECEIVER_ID
FK_SUPPLY_SHIPMENT_SENDER Performance Asc SENDER_ID

Relationships

Close relationships within degrees of separation