©Mike Moxcey 2002

ci_relationship_ends Table Description

This has info about the relationships. The ckentdef report looks at ci_diagrams for this so you’ll need to investigate the report queries for more info.

ACCESS_CONTROL_FLAG                  VARCHAR2(1)
ARC_NUMBER                           NUMBER(6)
ARC_REFERENCE                        NUMBER(38)
AVERAGE_VOLUME                       NUMBER(9)
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)
FROM_ENTITY_REFERENCE      NOT NULL NUMBER(38)
ID                         NOT NULL NUMBER
IRID                       NOT NULL NUMBER
IVID                       NOT NULL NUMBER
MAXIMUM_CARDINALITY                  NUMBER(10)
MAXIMUM_VOLUME                       NUMBER(9)
MINIMUM_CARDINALITY        NOT NULL NUMBER(10)
MINIMUM_VOLUME                       NUMBER(9)
NAME                       NOT NULL VARCHAR2(60)
NUMBER_OF_TIMES_MODIFIED   NOT NULL NUMBER(38)
OTHER_RELATIONSHIP_END_REF           NUMBER(38)
PAC_REFERENCE              NOT NULL NUMBER
PARENT_IVID                NOT NULL NUMBER
REMARK                               VARCHAR2(240)
TO_ENTITY_REFERENCE                  NUMBER(38)
TRANSFER                   NOT NULL VARCHAR2(1)
TYPES                      NOT NULL NUMBER(38)
USER_DEFINED_PROPERTY_0              VARCHAR2(240)
.................
USER_DEFINED_PROPERTY_19             VARCHAR2(240)

home