os_storage_containers

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_site.CONTAINER_ID FK_SITE_CONT_IDR
os_container_activity_logs.CONTAINER_ID FK_CONT_ACT_LOG_CONT_IDR
os_container_positions.BLOCKED_FOR_CONTAINER_ID FK_POS_BLOCK_FOR_CONT_IDR
os_container_positions.OCCUPYING_CONTAINER_ID FK_OS_POS_ST_CONTS_OCPIDR
os_container_positions.STORAGE_CONTAINER_ID FK_OS_POS_ST_CONTS_CONT_IDR
os_container_store_lists.CONTAINER_ID FK_STORE_LIST_CONTAINER_IDR
os_container_transfer_events.CONTAINER_ID FK_CONT_TRAF_EVT_CONTAINERR
os_container_transfer_events.FROM_CONTAINER_ID FK_CONT_TRAF_EVT_FROM_CONTR
os_container_transfer_events.TO_CONTAINER_ID FK_CONT_TRAF_EVT_TO_CONTR
os_containers_hierarchy.ANCESTOR_ID FK_OS_CONT_HIERARCHY_AIDR
os_containers_hierarchy.DESCENDENT_ID FK_OS_CONT_HIERARCHY_DIDR
os_order_items.RETURNING_CONTAINER FK_OS_OI_RETURNING_CONTR
os_sched_cont_activities.CONTAINER_ID FK_SCHED_ACTIVITIES_CONT_IDR
os_shipment_containers.CONTAINER_ID OS_SHIP_CONT_CONT_FKR
os_stor_cont_comp_spec_classes.STORAGE_CONTAINER_ID FK_OS_ST_CONT_CSC_CONT_IDR
os_stor_cont_comp_spec_types.STORAGE_CONTAINER_ID FK_OS_ST_CONT_CST_CONT_IDR
os_stor_cont_spec_classes.STORAGE_CONTAINER_ID FK_OS_ST_CONT_SC_CONT_IDR
os_stor_cont_spec_types.STORAGE_CONTAINER_ID FK_OS_ST_CONT_ST_CONT_IDR
os_stor_container_comp_cps.STORAGE_CONTAINER_ID FK_OS_ST_CONT_CCPS_CONT_IDR
os_stor_container_comp_dps.STORAGE_CONTAINER_ID FK_OS_STORE_CONT_CDPS_CONT_IDR
os_stor_container_cps.STORAGE_CONTAINER_ID FK_OS_ST_CONT_CPS_CONT_IDR
os_stor_container_dps.STORAGE_CONTAINER_ID FK_OS_STORE_CONT_DP_CONT_IDR
os_storage_containers.PARENT_CONTAINER_ID FK_OS_ST_CONT_PARENT_CONTR
NAME VARCHAR 64 null
BARCODE VARCHAR 64 √ null
TEMPERATURE DOUBLE 22 √ null
NO_OF_COLS BIGINT 19 √ null
NO_OF_ROWS BIGINT 19 √ null
COLUMN_LABELING_SCHEME VARCHAR 64 √ Numbers
ROW_LABELING_SCHEME VARCHAR 64 √ Numbers
SITE_ID BIGINT 19 null
catissue_site.IDENTIFIER FK_OS_ST_CONT_SITE_IDR
PARENT_CONTAINER_ID BIGINT 19 √ null
os_storage_containers.IDENTIFIER FK_OS_ST_CONT_PARENT_CONTR
CREATED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_OS_ST_CONT_CREATED_BYR
ACTIVITY_STATUS VARCHAR 16 √ null
POSITION_ID BIGINT 19 √ null
COMMENTS VARCHAR 255 √ null
STORE_SPECIMENS BIT 1 b'0'
TYPE_ID BIGINT 19 √ null
os_container_types.IDENTIFIER FK_OS_ST_CONT_TYPE_IDR
POS_LABELING_MODE VARCHAR 16 TWO_D
CELL_DISPLAY_PROP VARCHAR 16 √ null
CAPACITY BIGINT 19 √ null
AUTOMATED BIT 1 b'0'
AUTO_FREEZER_PROVIDER_ID BIGINT 19 √ null
os_auto_freezer_providers.IDENTIFIER FK_STOR_CONT_AUTO_PROVIDER_IDR
POS_ASSIGNMENT VARCHAR 32 HZ_TOP_DOWN_LEFT_RIGHT
USED_FOR VARCHAR 32 STORAGE
UTILISATION BIGINT 19 √ 0
DISPLAY_NAME VARCHAR 255 √ null
STATUS VARCHAR 32 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
BARCODE Must be unique Asc BARCODE
FK_OS_ST_CONT_CREATED_BY Performance Asc CREATED_BY
FK_OS_ST_CONT_PARENT_CONT Performance Asc PARENT_CONTAINER_ID
FK_OS_ST_CONT_SITE_ID Performance Asc SITE_ID
FK_OS_ST_CONT_TYPE_ID Performance Asc TYPE_ID
FK_STOR_CONT_AUTO_PROVIDER_ID Performance Asc AUTO_FREEZER_PROVIDER_ID
NAME Must be unique Asc NAME
OS_STAT_VIEW_IDX Must be unique Asc/Asc/Asc/Asc IDENTIFIER + NAME + NO_OF_COLS + NO_OF_ROWS

Relationships

Close relationships within degrees of separation