os_order_items

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
ORDER_ID BIGINT 19 null
os_orders.IDENTIFIER FK_OS_OI_DO_IDR
QUANTITY DOUBLE 22 √ null
SPECIMEN_ID BIGINT 19 null
catissue_specimen.IDENTIFIER FK_OS_OI_SPECIMEN_IDR
STATUS VARCHAR 32 √ null
RETURNED_QUANTITY DOUBLE 22 √ null
RETURNING_CONTAINER BIGINT 19 √ null
os_storage_containers.IDENTIFIER FK_OS_OI_RETURNING_CONTR
RETURNING_ROW VARCHAR 8 √ null
RETURNING_COLUMN VARCHAR 8 √ null
RETURNED_BY BIGINT 19 √ null
catissue_user.IDENTIFIER FK_OS_OI_RETURNED_BYR
RETURN_DATE TIMESTAMP 19 √ null
RETURN_COMMENTS VARCHAR 255 √ null
FREEZE_THAW_INCR_ON_RETURN SMALLINT 5 √ null
COST DOUBLE 22 √ null
LABEL VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_OS_OI_DO_ID Performance Asc ORDER_ID
FK_OS_OI_RETURNED_BY Performance Asc RETURNED_BY
FK_OS_OI_RETURNING_CONT Performance Asc RETURNING_CONTAINER
FK_OS_OI_SPECIMEN_ID Performance Asc SPECIMEN_ID

Relationships

Close relationships within degrees of separation