Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | NESTED_TABLE_STORAGE |
| Short Name | NCS |
| View Name | CI_NESTED_TABLE_STORAGES |
| Description | This element type provides the capability to specify the storage |
| table to be used for a nested item, and its storage parameters. | |
| A 'nested item' being a column or column qualified attribute whose | |
| whose type is a nested table. | |
| Specification of the storage table is mandatory when creating the | |
| table containing the nested item. However, it is only necessary to | |
| create a NESTED_TABLE_COLUMN_STORAGE if the user wants control over | |
| the name of the storage table (or its storage parameters). If the | |
| server generator encounters a nested item for which this information | |
| has not been set up, it will be defaulted. | |
| Unique Identifier(s) | |
| The UID is defined on the COLUMN_STORAGE super-type and is applicable | |
| across both sub-types, it is: | |
| TABLE_IMPLEMENTATION_REFERENCE | |
| COLUMN_REFERENCE | |
| CQA_REFERENCE | |
| The sub-type discriminator is NOT part of the UID, ie it will not be | |
| possible to create a LOB_COLUMN_STORAGE and a NESTED_TABLE_COLUMN_ | |
| STORAGE for the same column or attribute within the same table | |
| implementation | |
| Sub-type of | COLUMN_STORAGE |
| Versioning: | Belongs to: NON_ORACLE_DATABASE versionable object ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
TABLE_IMPLEMENTATION_REFERENCE COLUMN_REFERENCE CQA_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_CST |
| Changes: | Summary of changes to NESTED_TABLE_STORAGE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| COLUMN_REFERENCE | N |
Prompt: Column
Transferable only if null Defined on CST supertype |
Must be specifying storage for one and only one COLUMN | 69 |
| CQA_REFERENCE | N |
Prompt: Column Qualified Attribute
Transferable only if null Defined on CST supertype |
Must be specifying storage for one and only one COLUMN_QUALIFIED_ATTRIBUTE | 69 |
| TABLE_IMPLEMENTATION_REFERENCE | N |
Prompt: Table Implementation
Transferable only if null Defined on CST supertype |
Must be in the context of one and only one TABLE_IMPLEMENTATION | |
| STORAGE_DEFINITION_REFERENCE | Y | Prompt: Storage Definition | May be limited by one and only one STORAGE_DEFINITION | |
| TABLESPACE_REFERENCE | Y | Prompt: Tablespace | May be created in one and only one TABLESPACE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| COLUMN_STORAGE_FOR | VARCHAR2(3) | N | Arc 69 discriminator. Indicates whether the COLUMN_STORAGE is for a COLUMN (COL) or a COLUMN_QUALIFIED_ATTRIBUTE (CQA)
Not displayed Uppercase System maintained Not updatable by user Defined on CST supertype | COLUMN_OR_CQA | |
| COLUMN_STORAGE_TYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating whether this COLUMN_STORAGE is a LOB_COLUMN_STORAGE (LCS) or a NESTED_TABLE_STORAGE (NCS)
Not displayed Uppercase System maintained Not updatable by user Defined on CST supertype | COLUMN_STORAGE_TYPE | |
| STORAGE_TABLE_NAME | VARCHAR2(30) | N | Name of the table to be used as the storage table
Prompt: Storage Table Name Uppercase | ||
| 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 Defined on CST supertype |
Description |
| NOTES | CDINOT Defined on CST supertype |
Notes |
| Other Properties |
|---|
| NESTED_TABLE_STORAGE 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 NESTED_TABLE_STORAGE:
Note: