Element Type Definition: DATASTRUCTURE

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	DATASTRUCTURE
Short Name	DAT
View Name	CI_DATASTRUCTURES
Description	Definition of a PL/SQl composite datatype, eg a PL/SQL record, table
	or cursor

Sub-type of	SECONDARY_ACCESS_ELEMENT
Versioning:	Belongs to: ORACLE_OBJECT_TYPE versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	PLSQL_MODULE_REFERENCE NAME
Used by:	Oracle Designer
Underlying table:	SDD_DAT
Changes:	Summary of changes to DATASTRUCTURE in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
PLSQL_MODULE_REFERENCE	N	Prompt: PL/SQL Definition	Must be owned and used by one and only one PLSQL_MODULE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
DATASTRUCTURE_TYPE	VARCHAR2(6)	N	The data structure type. e.g. a PL/SQL record or a PL/SQL table Prompt: Type Uppercase	DAT_TYPES	RECORD
NAME	VARCHAR2(30)	N	The name of the data structure. Prompt: Name Uppercase
REMARK	VARCHAR2(240)	Y	A brief comment about this data structure. Prompt: Comment
SCOPE	VARCHAR2(10)	N	Indicates whether the datastructure is public or private Prompt: Scope Uppercase	PGD_SCOPE	PUBLIC
SEQUENCE	NUMBER(6, 0)	Y	Sequence for datastructure if ordering is significant, for example when dependencies need to be managed (eg datastructure has a datastructure item whose definition is another datastructure) Prompt: Usage Sequence
PARENT_IVID	NUMBER(38, 0)	Y	Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs Not displayed System maintained Updatable only if null Defined on SAC supertype
PAC_REFERENCE	NUMBER(38, 0)	Y	Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs Not displayed System maintained Not updatable by user Defined on SAC supertype

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

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

Each MODULE_ARGUMENT may be defined by one and only one DATASTRUCTURE (in arc)
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each DATASTRUCTURE_ITEM may be defined by one and only one DATASTRUCTURE (in arc)
Each DATASTRUCTURE_ITEM must be of one and only one DATASTRUCTURE
Each PROGRAM_DATUM may be defined by one and only one DATASTRUCTURE (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT

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