©Mike Moxcey 2002

ci_synonyms Table Description

Has the synonyms for various pieces of the ERD
Look at distinct SYNONYM_FOR to see the various kinds

 CHANGED_BY                            VARCHAR2(30)
 CREATED_BY                NOT NULL    VARCHAR2(30)
 DATE_CHANGED                          DATE
 DATE_CREATED              NOT NULL    DATE
 ELEMENT_TYPE_NAME         NOT NULL    VARCHAR2(10)
 ENTITY_REFERENCE (to ci_entities.id)  NUMBER(38)
 ID                        NOT NULL    NUMBER
 IRID                      NOT NULL    NUMBER
 IVID                      NOT NULL    NUMBER
 NAME                      NOT NULL    VARCHAR2(40)
 NUMBER_OF_TIMES_MODIFIED  NOT NULL    NUMBER(38)
 SYNONYM_FOR               NOT NULL    VARCHAR2(3)
 TERM_REFERENCE                        NUMBER(38)
 TYPES                     NOT NULL    NUMBER(38)
 USER_DEFINED_PROPERTY_0               VARCHAR2(240)
.....................
 USER_DEFINED_PROPERTY_19              VARCHAR2(240)


home