©Mike Moxcey 2002

ci_attribute_values Table Description

Name                       Null?    Type
-------------------------- -------- ----
ABBREVIATION                         VARCHAR2(20)
(of the value)
ATTRIBUTE_REFERENCE                  NUMBER(38)
(to ci_attributes.id)
ATTRIBUTE_VALUE_FOR        NOT NULL VARCHAR2(3)
CHANGED_BY                          VARCHAR2(30)
COLUMN_REFERENCE                    NUMBER(38)
CREATED_BY                 NOT NULL VARCHAR2(30)
DATE_CHANGED                        DATE
DATE_CREATED               NOT NULL DATE
DOMAIN_REFERENCE                    NUMBER(38)
(to ci_domains.id)
ELEMENT_TYPE_NAME          NOT NULL VARCHAR2(10)
HIGH_VALUE                          VARCHAR2(40)
HIGH_VALUE_TYPE            NOT NULL VARCHAR2(15)
ID                         NOT NULL NUMBER
IRID                       NOT NULL NUMBER
IVID                       NOT NULL NUMBER
LOW_VALUE                  NOT NULL VARCHAR2(40)
(actual value of the entry)
LOW_VALUE_TYPE             NOT NULL VARCHAR2(15)
MEANING                             VARCHAR2(240)
MODULE_ARGUMENT_REFERENCE           NUMBER(38)
NUMBER_OF_TIMES_MODIFIED   NOT NULL NUMBER(38)
PAC_REFERENCE              NOT NULL NUMBER
PARENT_IVID                NOT NULL NUMBER
RADIO_SEQUENCE                      NUMBER(6)
TYPES                      NOT NULL NUMBER(38)
UNBOUND_ITEM_REFERENCE              NUMBER(38)
USER_DEFINED_PROPERTY_0             VARCHAR2(240)
USER_DEFINED_PROPERTY_1             VARCHAR2(240)
...
USER_DEFINED_PROPERTY_19            VARCHAR2(240)

home