Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | COLUMN_QUALIFIED_ATTRIBUTE |
| Short Name | CQA |
| View Name | CI_COLUMN_QUALIFIED_ATTRIBUTES |
| Description | COLUMN_QUALIFIED_ATTRIBUTE represents the usage of an attribute in the |
| context of a specific table via a specified usage path | |
| (eg work_address.city) | |
| The existence of this element type provides the capability for the | |
| user to specify overrides to characteristics of an attribute (such | |
| as its default value) in the context of its usage in a specific table. | |
| Also, the ability to reference a specific usage of an attribute in | |
| a table is required, for example to specify it as part of the index | |
| on that table. | |
| A COLUMN_QUALIFIED_ATTRIBUTE is made up of an ordered set of | |
| ATTRIBUTE_QUALIFIERs that explicitly define the elements in its path | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: TABLE_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
TABLE_DEFINITION_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_CQA |
| Changes: | Summary of changes to COLUMN_QUALIFIED_ATTRIBUTE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| TABLE_DEFINITION_REFERENCE | N | Prompt: Table Definition | Must be within one and only one TABLE_DEFINITION | |
| CLUSTER_COLUMN_REFERENCE | Y | Prompt: Cluster Column | May be used in one and only one CLUSTER_COLUMN | |
| SCOPE_TABLE_REFERENCE | Y | Prompt: Scope Table | May be scoped by one and only one TABLE_DEFINITION | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| DEFAULT_VALUE | VARCHAR2(60) | Y | If OVERRIDE_DEFAULT_FLAG = 'Y' then this property indicates the default value to be used. Null is a valid default value with which to override the "normal" default
Prompt: Default Value | ||
| NULL_INDICATOR | VARCHAR2(8) | N | Value with which to override the equivalent property defined for the attribute (ie COLUMN.NULL_INDICATOR). A null value means there is no override, ie that the value is inherited from the attribute
Prompt: Optional ? Uppercase | OVERRIDE_NULL_INDICATOR | INHERIT |
| OVERRIDE_DEFAULT_FLAG | VARCHAR2(1) | N | Indicates whether the normal default value of the attribute is to be overridden in this particular usage of the attribute
Prompt: Override Default ? Uppercase | YESNO | N |
| QUALIFIED_NAME | VARCHAR2(2000) | N | Internal property containing concatenation of the column/attribute names delimited by a '.' that are represented by the ordered set of its ATTRIBUTE_QUALIFIERS (eg "work_address.town")
Prompt: Qualified Name System maintained Not updatable by user | ||
| STORE_REF_WITH_ROWID_FLAG | VARCHAR2(1) | N | Indicates whether the ROWID is to be stored with a REF column/attribute
Prompt: Store REF with ROWID ? Uppercase | YESNO | N |
| 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 |
| Other Properties |
|---|
| COLUMN_QUALIFIED_ATTRIBUTE 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 COLUMN_QUALIFIED_ATTRIBUTE:
Note: