©Mike Moxcey 2002

ci_entities Table Description

ANNUAL_GROWTH_RATE                NUMBER(3)
CHANGED_BY                        VARCHAR2(30)
CREATED_BY               NOT NULL VARCHAR2(30)
DATAWAREHOUSE_TYPE                VARCHAR2(10)
DATE_CHANGED                      DATE
DATE_CREATED             NOT NULL DATE
ELEMENT_TYPE_NAME        NOT NULL VARCHAR2(10)
    (“ENT”)
ID                       NOT NULL NUMBER
    (to ci_folder_members.member_object)
INITIAL_VOLUME                    NUMBER(38)
INSTANTIABLE_FLAG        NOT NULL VARCHAR2(1)
IRID                     NOT NULL NUMBER
IVID                     NOT NULL NUMBER
MAXIMUM_VOLUME                    NUMBER(38)
NAME (of entity)         NOT NULL VARCHAR2(40)
NUMBER_OF_TIMES_MODIFIED NOT NULL NUMBER(38)
PLURAL                   NOT NULL VARCHAR2(40)
SHORT_NAME (of entity)   NOT NULL VARCHAR2(10)
SUPERTYPE_REFERENCE               NUMBER(38)
TYPES                    NOT NULL NUMBER(38)
USER_DEFINED_PROPERTY_0           VARCHAR2(240)
   .........
USER_DEFINED_PROPERTY_19          VARCHAR2(240)
VOLUME                            NUMBER(38)

home