Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | DATASTRUCTURE_ITEM |
| Short Name | ITM |
| View Name | CI_DATASTRUCTURE_ITEMS |
| Description | A component in a specific datastructure (eg a field within a PL/SQL |
| record) | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: ORACLE_OBJECT_TYPE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
DATASTRUCTURE_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_ITM |
| Changes: | Summary of changes to DATASTRUCTURE_ITEM in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| DATASTRUCTURE_REFERENCE | N |
Prompt: Parent Datastructure
Transferable only if null |
Must be of one and only one DATASTRUCTURE | |
| COLUMN_REFERENCE | Y | Prompt: Column | May be defined by one and only one COLUMN | 13 |
| CQA_REFERENCE | Y | Not displayed | May be defined by one and only one COLUMN_QUALIFIED_ATTRIBUTE | 13 |
| CURSOR_REFERENCE | Y | Prompt: Cursor | May be defined by one and only one PLSQL_MODULE | 13 |
| DATASTRUCTURE_REFERENCE2 | Y | Prompt: Datastructure | May be defined by one and only one DATASTRUCTURE | 13 |
| DOMAIN_REFERENCE | Y | Prompt: Domain | May be defined by one and only one DOMAIN | 13 |
| ORACLE_TYPE_REFERENCE | Y | Prompt: Oracle Type | May be defined by one and only one ORACLE_TYPE | 13 |
| PROGRAM_DATUM_REFERENCE | Y | Prompt: Program Datum | May be defined by one and only one PROGRAM_DATUM | 13 |
| TABLE_DEFINITION_REFERENCE | Y | Prompt: Table | May be defined by one and only one TABLE_DEFINITION | 13 |
| PLSQL_MODULE_REFERENCE | Y | Prompt: PL/SQL Definition | May be for plsql module of one and only one PLSQL_MODULE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| DATATYPE | VARCHAR2(70) | Y | The datatype for this data item
Prompt: Datatype | PLS_DATATYPE Non-enforced | |
| DEFAULT_VALUE | VARCHAR2(60) | Y | A default value for the datastructure item.
Prompt: Default Value | ||
| DEFAULT_VALUE_TYPE | VARCHAR2(15) | N | Indicates the nature of the default value
Prompt: Default Value Type Uppercase | DEFAULT_VALUE_TYPE_2 | LITERAL |
| ITEM_TYPE | VARCHAR2(10) | N | Arc 13 discriminator. The type of object that this data item is based on. Discriminator for the arc.
Not displayed Uppercase System maintained Not updatable by user | ITM_DATA_TYPE | |
| MAXIMUM_LENGTH | NUMBER(5, 0) | Y | The maximum length of data that this data item can contain
Prompt: Length | ||
| NAME | VARCHAR2(30) | N | The name of this data item
Prompt: Name | ||
| NULLS | VARCHAR2(1) | N | Indicates whether or not this data item contains null values
Prompt: Optional ? Uppercase | YESNO | Y |
| SCALE | NUMBER(3, 0) | Y | For numeric datatypes, specifies the number of decimal places allowed for this data item
Prompt: Decimal Places | ||
| SEQUENCE | NUMBER(6, 0) | Y | A number used to order the datastructure item when the PL/SQL record is created.
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_ITEM 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:
|
Other element types that reference DATASTRUCTURE_ITEM:
Note: