©Mike Moxcey 2002
 

cdi_text Table Description

Holds the text for everything, Notes, Description, etc

 IRID              NOT NULL  NUMBER
 IVID              NOT NULL  NUMBER
 PAC_REF           NOT NULL  NUMBER
 PARENT_IVID       NOT NULL  NUMBER
 TXT_REF           NOT NULL  NUMBER(38)
 TXT_SEQ           NOT NULL  NUMBER(6)
 TXT_TYPE          NOT NULL  VARCHAR2(10)
 ELEMENT_TYPE_FOR  NOT NULL  VARCHAR2(6)
 TXT_NOTM                    NUMBER(38)
 TXT_TEXT                    VARCHAR2(2000)

SQL> select distinct txt_type from cdi_text;
 CDEXPR, CDHELP, CDIDOC, CDIDSC, CDINOT, CGMHST

SQL> select distinct ELEMENT_TYPE_FOR from cdi_text;
 ATT,      COL,      DIA,       DOM,   ENT,    FUN,    TBL
Attribute, Column, Diagram, Domain, Entity, Function, Table and many more


home