dyextn_containers

24 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 null
catissue_distribution_protocol.ORDER_EXTN_FORM_ID FK_ORDER_EXTN_FORM_IDR
catissue_form_context.CONTAINER_ID FK_FC_CNTR_ID_DC_IDENTIFIERR
os_cp_group_forms.FORM_ID FK_GRP_FORMS_FORM_IDR
os_specimen_catalogs.REQ_FORM_ID FK_CATALOGS_REQ_FORM_IDR
NAME VARCHAR 64 null
CAPTION VARCHAR 255 null
CREATED_BY BIGINT 19 √ null
CREATE_TIME TIMESTAMP 19 √ null
LAST_MODIFIED_BY BIGINT 19 √ null
LAST_MODIFY_TIME TIMESTAMP 19 √ null
XML LONGBLOB 2147483647 null
DELETED_ON TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
DE_FORM_NAME_IDX Performance Asc/Asc NAME + DELETED_ON
IDX_DE_FORM_DELETED_ON Performance Asc DELETED_ON

Relationships

Close relationships within degrees of separation