| Element Type Name | CLUSTER_COLUMN |
| Short Name | CCD |
| View Name | CI_CLUSTER_COLUMNS |
| Description | The CLUSTER_COLUMNS belonging to a cluster constitute its cluster key. |
| Columns of the tables in the cluster are mapped to these | |
| CLUSTER_COLUMNS | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to:
CLUSTER versionable object |
| Rules: | API
Spec
Uniqueness Criteria Deletion Rules |
| Descriptor: | CLUSTER_REFERENCE
NAME SEQUENCE_NUMBER |
| Used by: | Oracle Designer
|
| Underlying table: | SDD_CCD |
| Changes: | Summary of changes to CLUSTER_COLUMN in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| CLUSTER_REFERENCE | N | Prompt: Cluster
Transferable only if null |
Must be within one and only one CLUSTER | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| DATATYPE | VARCHAR2(35) | Y | The datatype of the cluster column key.
Prompt: Datatype Uppercase System maintained Not updatable by user |
CLUSTER_COLUMN_DATATYPE | |
| LENGTH | NUMBER(6, 0) | Y | The total number of digits that can be specified in a
numeric column.
Prompt: Length System maintained Not updatable by user |
||
| NAME | VARCHAR2(30) | N | The name of one of the columns comprising the cluster
key.
Prompt: Name Uppercase |
||
| SCALE | NUMBER(6, 0) | Y | The total number of digits that may be used to the right
of the decimal point in a numeric column.
Prompt: Decimal Places System maintained Not updatable by user |
||
| SEQUENCE_NUMBER | NUMBER(6, 0) | N | The sequence of the ORACLE cluster key columns.
Prompt: Usage Sequence System maintained: API provides a value only if left null by the user |
||
| 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 |
|---|
| CLUSTER_COLUMN 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 CLUSTER_COLUMN:
Note: