©Mike Moxcey 2002

ci_domains Table Description

ATTRIBUTE_PRECISION                NUMBER(4)
AUTHORITY                          VARCHAR2(10)
AVERAGE_ATTRIBUTE_LENGTH           NUMBER(5)
AVERAGE_COLUMN_LENGTH              NUMBER(5)
CHANGED_BY                         VARCHAR2(30)
COLUMN_PRECISION                   NUMBER(4)
CREATED_BY                NOT NULL VARCHAR2(30)
DATATYPE                           VARCHAR2(16)
DATE_CHANGED                       DATE
DATE_CREATED              NOT NULL DATE
DEFAULT_VALUE                      VARCHAR2(60)
DEFAULT_VALUE_TYPE        NOT NULL VARCHAR2(15)
DERIVATION                         VARCHAR2(240)
DESCRIPTION                        VARCHAR2(240)
ELEMENT_TYPE_NAME         NOT NULL VARCHAR2(10)
FORMAT                    NOT NULL VARCHAR2(10)
ID                        NOT NULL NUMBER
IRID                      NOT NULL NUMBER
IVID                      NOT NULL NUMBER
MAXIMUM_ATTRIBUTE_LENGTH           NUMBER(5)
MAXIMUM_COLUMN_LENGTH              NUMBER(5)
NAME                      NOT NULL VARCHAR2(40)
NULL_VALUE                         VARCHAR2(40)
NUMBER_OF_TIMES_MODIFIED NOT NULL NUMBER(38)
SOFT_LOV                  NOT NULL VARCHAR2(1)
SUPERTYPE_REFERENCE                NUMBER(38)
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