Table rice-2.1.1.krms_agenda_t Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
AGENDA_ID varchar 40
krms_agenda_attr_t.AGENDA_ID KRMS_AGENDA_ATTR_FK1 R
krms_agenda_itm_t.AGENDA_ID KRMS_AGENDA_ITM_FK2 R
krms_agenda_itm_t.SUB_AGENDA_ID KRMS_AGENDA_ITM_FK3 R
NM varchar 100
CNTXT_ID varchar 40
krms_cntxt_t.CNTXT_ID KRMS_AGENDA_FK1 R
INIT_AGENDA_ITM_ID varchar 40  √  null
TYP_ID varchar 40  √  null
krew_typ_t.TYP_ID Implied Constraint R
ACTV varchar 1 Y
VER_NBR decimal 8 0

Table contained 3 rows at Tue Sep 18 22:24 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
AGENDA_ID Primary key Asc PRIMARY
NM + CNTXT_ID Must be unique Asc/Asc KRMS_AGENDA_TC1
CNTXT_ID Performance Asc KRMS_AGENDA_TI1

Close relationships  within of separation: