catissue_container

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_container_position.CONTAINER_ID FK_CONTAINERR
catissue_container_position.PARENT_CONTAINER_ID FK_OCCUPIED_CONTAINERR
catissue_storage_container.IDENTIFIER FK28429D01BC7298A9R
ACTIVITY_STATUS VARCHAR 50 √ null
BARCODE VARCHAR 255 √ null
CAPACITY_ID BIGINT 19 √ null
COMMENTS TEXT 65535 √ null
CONT_FULL BIT 1 √ null
NAME VARCHAR 255 null

Indexes

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

Relationships

Close relationships within degrees of separation