catissue_form_context

31 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_form_record_entry.FORM_CTXT_ID FK_RE_CTXT_ID_FC_IDENTIFIERR
os_form_data_entry_tokens.FORM_CTXT_ID FK_FDE_TOKENS_FORM_CTXT_IDR
os_form_notif_user_grps.FORM_CTXT_ID FK_FORM_NOTIF_CTXTR
os_specimen_array_events.FORM_CTXT_ID FK_OS_SPMN_ARR_EVENT_FORM_CTXR
os_specimen_slide_events.FORM_CTXT_ID FK_OS_SPMN_SLD_EVENT_FORM_CTXR
CONTAINER_ID BIGINT 19 null
dyextn_containers.IDENTIFIER FK_FC_CNTR_ID_DC_IDENTIFIERR
ENTITY_TYPE VARCHAR 32 null
CP_ID BIGINT 19 null
os_cp_workflows.CP_ID Implied ConstraintR
SORT_ORDER SMALLINT 5 √ null
IS_MULTIRECORD BIT 1 √ b'0'
IS_SYS_FORM BIT 1 √ b'0'
deleted_on TIMESTAMP 19 √ null
ENTITY_ID BIGINT 19 √ null
NOTIFS_ENABLED BIT 1 b'0'
DATA_IN_NOTIF BIT 1 b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_FC_CNTR_ID_DC_IDENTIFIER Performance Asc CONTAINER_ID
IDX_FC_DELETED_ON Performance Asc deleted_on

Relationships

Close relationships within degrees of separation