Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name DIAGRAM
Short Name DIA
View NameCI_DIAGRAMS
Description Element representing a diagram, providing a "user handle" on the set
of elements appearing on the diagram
Sub-type of NON_SHAREABLE_ELEMENT
Versioning: Structure of DIAGRAM versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: NAME
DIAGRAM_TYPE
Used by: Oracle Designer
JDeveloper Enterprise Edition


Underlying table:SDD_DIA
Changes: Summary of changes to DIAGRAM in Release 6i

Reference Properties
Name Opt ? Notes Relationship In Arc
PACKAGE_REFERENCE Y Prompt: Package May be in the context of one and only one PACKAGE

Properties
Name Datatype Opt ? Notes Domain Default Value
AUTHOR VARCHAR2(30) Y Author(s) of diagram in free format text
Prompt: Author
DIAGRAM_TYPE VARCHAR2(3) N Classification of diagram, eg ERD, DFD etc
Prompt: Diagram Type
Uppercase
Updatable only if null
DIAGRAM_TYPE
DTD_FILENAME VARCHAR2(30) Y Name of the DTD file used for this diagram
Not displayed
NAME VARCHAR2(40) N Name of diagram
Prompt: Name
Uppercase
SCENARIO VARCHAR2(6) Y Indicates whether the diagram depicts the 'as is' or 'to be' scenario
Prompt: Scenario
Uppercase
DIAGRAM_SCENARIO
SUB_DIAGRAM_ID NUMBER(38, 0) Y Internal property containing the ID of the function forming the frame of a DFD
Not displayed
System maintained
Not updatable by user
SUB_DIAGRAM_TYPE VARCHAR2(30) Y Internal property qualifying certain diagram types. MD uses it for concatenation of x-axis || y-axis || intersection (eg BUN || FUN || FUNBUN). DFD uses it for label of frame function. OBM diagrammers also use this, eg Activity Modeler
Not displayed
Uppercase
System maintained
Not updatable by user
TITLE VARCHAR2(40) Y Mixed case title of diagram
Prompt: Title

Multi-line Text
Name Text Type Prompt
CHANGE_HISTORY CDICHI Change History
DESCRIPTION CDIDSC Description
NOTES CDINOT Notes

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


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