Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name SYNONYM
Short Name SYN
View NameCI_SYNONYMS
Description Analysis level synonyms (of entities and terms)
Sub-type of SHAREABLE_ELEMENT
Versioning: Structure of SYNONYM versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: NAME
ENTITY_REFERENCE
TERM_REFERENCE
Used by: Oracle Designer
Underlying table:SDD_SYN
Changes: Summary of changes to SYNONYM in Release 6i

Reference Properties
Name Opt ? Notes Relationship In Arc
ENTITY_REFERENCE N Prompt: Entity
Transferable only if null 		Must be for one and only one ENTITY 55
TERM_REFERENCE N Prompt: Term
Transferable only if null 		Must be for one and only one TERM 55

Properties
Name Datatype Opt ? Notes Domain Default Value
NAME VARCHAR2(40) N Another name by which this term/entity is known.
Prompt: Name
Uppercase
SYNONYM_FOR VARCHAR2(3) N Arc 55 discriminator. Indicates whether the synonym is for an entity or a term
Not displayed
Uppercase
System maintained
Not updatable by user 		SYNONYM_FOR

Multi-line Text
Name Text Type Prompt
DESCRIPTION CDIDSC Description
NOTES CDINOT Notes

Other Properties
SYNONYM 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 SYNONYM:


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
    •