Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | COLUMN_STORAGE |
| Short Name | CST |
| View Name | CI_COLUMN_STORAGES |
| Description | COLUMN_STORAGE provides the ability to associate storage |
| information with a specific column in the context of a particular | |
| implementation of the table to which it belongs | |
| It is used to define storage for LOB columns and nested tables | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Non-instantiable super-type of | LOB_COLUMN_STORAGE |
| NESTED_TABLE_STORAGE | |
| As this is a non-instantiable supertype, follow links (above) to its instantiable subtypes to find versioning information for each subtype, uniqueness criteria, API rules etc | |
| Underlying table: | SDD_CST |
| Changes: | Summary of changes to COLUMN_STORAGE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| COLUMN_REFERENCE | N |
Prompt: Column
Transferable only if null |
Must be specifying storage for one and only one COLUMN | 69 |
| CQA_REFERENCE | N |
Prompt: Column Qualified Attribute
Transferable only if null |
Must be specifying storage for one and only one COLUMN_QUALIFIED_ATTRIBUTE | 69 |
| TABLE_IMPLEMENTATION_REFERENCE | N |
Prompt: Table Implementation
Transferable only if null |
Must be in the context of one and only one TABLE_IMPLEMENTATION | |
| 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 | 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 | COLUMN_STORAGE_TYPE | |
| 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 |
|---|
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference COLUMN_STORAGE:
Note: