Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name DOCUMENT_ATTACHMENT
Short Name DOCXXX
View NameCI_DOCUMENT_ATTACHMENTS
Description The attachment of an element to a document
Sub-type of INTERSECTION
Versioning: Belongs to:
DOCUMENT versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: DOCUMENT_REFERENCE
ELEMENT_REFERENCE
Used by: Oracle Designer
Underlying table:SDD_DOCXXX
Changes: Summary of changes to DOCUMENT_ATTACHMENT in Release 6i

Reference Properties
Name Opt ? Notes Relationship In Arc
ELEMENT_REFERENCE N Prompt: Element
Transferable only if null
Must be from one and only one ACCESS_CONTROLLED_ELEMENT 129
DOCUMENT_REFERENCE N Prompt: Document
Transferable only if null
Must be to one and only one DOCUMENT

Properties
Name Datatype Opt ? Notes Domain Default Value
ELEMENT_TYPE_FOR VARCHAR2(10) N Arc 129 discriminator. Internal property indicating the type of element this document attachment is for. Contains a denormalization of the el_type_of, or el_occur_type when element is a subtype
Not displayed
Uppercase
Updatable only if null
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
DOCUMENT_ATTACHMENT 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 DOCUMENT_ATTACHMENT:


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