Table rice-2.2.0-SNAPSHOT.kren_chnl_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
CHNL_ID decimal 8 0
kren_chnl_prodcr_t.CHNL_ID KREN_CHNL_PRODCR_FK1 R
kren_chnl_subscrp_t.CHNL_ID KREN_CHAN_SUBSCRP_FK1 R
kren_ntfctn_t.CHNL_ID KREN_NTFCTN_FK1 R
kren_recip_list_t.CHNL_ID KREN_RECIP_LIST_FK1 R
kren_rvwer_t.CHNL_ID NOTIFICATION_REVIEWERS_N_FK1 R
NM varchar 200
DESC_TXT varchar 4000
SUBSCRB_IND char 1
VER_NBR decimal 8 1
OBJ_ID varchar 36  √  null

Table contained 6 rows at Fri May 10 14:36 PDT 2013

Indexes:
Column(s) Type Sort Constraint Name
CHNL_ID Primary key Asc PRIMARY
NM Must be unique Asc KREN_CHNL_TC0

Close relationships  within of separation: