os_container_types

19 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_container_types.CAN_HOLD FK_OS_CONT_TYPE_CAN_HOLDR
os_storage_containers.TYPE_ID FK_OS_ST_CONT_TYPE_IDR
NAME VARCHAR 64 null
NAME_FORMAT VARCHAR 255 √ 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
STORE_SPECIMENS BIT 1 b'0'
CAN_HOLD BIGINT 19 √ null
os_container_types.IDENTIFIER FK_OS_CONT_TYPE_CAN_HOLDR
ACTIVITY_STATUS VARCHAR 16 √ null
POS_LABELING_MODE VARCHAR 16 TWO_D
POS_ASSIGNMENT VARCHAR 32 HZ_TOP_DOWN_LEFT_RIGHT

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_OS_CONT_TYPE_CAN_HOLD Performance Asc CAN_HOLD
NAME Must be unique Asc NAME

Relationships

Close relationships within degrees of separation