Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name UNIQUE_IDENTIFIER_ENTRY
Short Name ENTUIE
View NameCI_UNIQUE_IDENTIFIER_ENTRIES
Description Attribute/ relationships used in the unique identifier of an entity.
Sub-type of OTHER_SE
Versioning: Belongs to:
ENTITY versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: UNIQUE_IDENTIFIER_REFERENCE
ATTRIBUTE_REFERENCE
RELATIONSHIP_END_REFERENCE
Used by: Oracle Designer
Underlying table:SDD_ENTUIE
Changes: Summary of changes to UNIQUE_IDENTIFIER_ENTRY in Release 6i

Reference Properties
Name Opt ? Notes Relationship In Arc
ATTRIBUTE_REFERENCE N Prompt: Attribute
Transferable only if null 		Must be for one and only one ATTRIBUTE 21
RELATIONSHIP_END_REFERENCE N Prompt: Relationship
Transferable only if null 		Must be for one and only one RELATIONSHIP_END 21
UNIQUE_IDENTIFIER_REFERENCE N Prompt: Unique Identifier
Transferable only if null 		Must be belong to one and only one UNIQUE_IDENTIFIER

Properties
Name Datatype Opt ? Notes Domain Default Value
ATTRIBUTE_OR_RELATION VARCHAR2(1) N Arc 21 discriminator. Indicates whether UID entry is for an attribute or relationship
Not displayed
Uppercase
System maintained
Not updatable by user 		ATT_REL_FLAG
SEQUENCE_WITHIN_UID NUMBER(6, 0) N Sequence of the attribute or relationship within the unique identifier
Prompt: Sequence in UID
System maintained: API provides a value only if left null by the user
PARENT_IVID NUMBER(38, 0) Y Internal use only. Common repository version identifier of owning PAC
Not displayed
System maintained
Updatable only if null
Defined on SE supertype
PAC_REFERENCE NUMBER(38, 0) Y Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs
Not displayed
System maintained
Not updatable by user
Defined on SE supertype

Multi-line Text
Name Text Type Prompt

Other Properties
UNIQUE_IDENTIFIER_ENTRY has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility
The following 'standard' properties are also inherited by all element types:
  • ID
  • IRID
  • IVID
  • ELEMENT_TYPE_NAME
  • DATE_CREATED
  • CREATED_BY
  • DATE_CHANGED
  • CHANGED_BY
  • NUMBER_OF_TIMES_MODIFIED
  • TYPES

Other element types that reference UNIQUE_IDENTIFIER_ENTRY:


Note:

  • All properties are displayed and updatable by the user unless indicated otherwise
  • All reference properties are displayed and transferable unless indicated otherwise
  • All domains are enforced unless indicated otherwise
  • All properties and reference properties are defined on this element type unless indicated as inherited from a supertype
    •