©Mike Moxcey 2002

ci_attributes Table Description

AUTHORITY                          VARCHAR2(10)
AVERAGE_LENGTH                     NUMBER(5)
AVERAGE_USAGE             NOT NULL NUMBER(3)
CHANGED_BY                         VARCHAR2(30)
CREATED_BY                NOT NULL VARCHAR2(30)
DATE_CHANGED                       DATE
DATE_CREATED              NOT NULL DATE
DEFAULT_VALUE                      VARCHAR2(60)
DERIVATION                         VARCHAR2(240)
DOMAIN_REFERENCE                   NUMBER(38)
   (to ci_domains.id)
ELEMENT_TYPE_NAME         NOT NULL VARCHAR2(10)
   ( “ATT”)
ENTITY_REFERENCE          NOT NULL NUMBER(38)
   (to ci_entities.id)
FORMAT                    NOT NULL VARCHAR2(10)
ID                        NOT NULL NUMBER
INITIAL_USAGE             NOT NULL NUMBER(3)
IRID                      NOT NULL NUMBER
IVID                      NOT NULL NUMBER
MAXIMUM_LENGTH                     NUMBER(5)
NAME                      NOT NULL VARCHAR2(40)
NOTES                              VARCHAR2(2000)
NULL_VALUE                         VARCHAR2(40)
NUMBER_OF_TIMES_MODIFIED NOT NULL NUMBER(38)
OPTION_CONDITION                   VARCHAR2(80)
OPTIONAL_FLAG             NOT NULL VARCHAR2(1)
ORDER_SEQUENCE                     NUMBER(6)
PAC_REFERENCE             NOT NULL NUMBER
PARENT_IVID               NOT NULL NUMBER
PRECISION                          NUMBER(4)
RESPONSIBLE                        VARCHAR2(10)
SEQUENCE_NUMBER                    NUMBER(6)
SHORT_NAME                         VARCHAR2(10)
SORTING_ORDER                      VARCHAR2(1)
TYPES                     NOT NULL NUMBER(38)
UNIT_OF_MEASURE                    VARCHAR2(10)
USER_DEFINED_PROPERTY_0            VARCHAR2(240)
USER_DEFINED_PROPERTY_1            VARCHAR2(240)
..............
USER_DEFINED_PROPERTY_19           VARCHAR2(240)

home