Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | LOB_COLUMN_STORAGE |
| Short Name | LCS |
| View Name | CI_LOB_COLUMN_STORAGES |
| Description | LOB_COLUMN_STORAGE provides the ability to associate LOB storage |
| information with a specific column in the context of a particular | |
| implementation of the table to which it belongs | |
| 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_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 LOB_COLUMN_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 |
| LOB_STORAGE_REFERENCE | N | Prompt: LOB Storage | Must be using one and only one LOB_STORAGE | |
| 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 | |
| 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 | |
| LOB_INDEX_NAME | VARCHAR2(30) | Y | Name of the LOB index segment
Prompt: LOB Index Name Uppercase | ||
| LOB_SEGMENT_NAME | VARCHAR2(30) | Y | Name of the LOB data segment (lob_segname)
Prompt: LOB Segment 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 |
|---|
| LOB_COLUMN_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 LOB_COLUMN_STORAGE:
Note: