Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | ATTRIBUTE_QUALIFIER |
| Short Name | CQACOL |
| View Name | CI_ATTRIBUTE_QUALIFIERS |
| Description | ATTRIBUTE_QUAlIFIERs form an ordered set of columns/attributes that |
| constitute the path of a COLUMN_QUALIFIED_ATTRIBUTE (CQA). | |
| For example, for the COLUMN_QUALIFIED_ATTRIBUTE that represents | |
| "work_address.city" there will be 2 ATTRIBUTE_QUALIFIERS, the | |
| first being for "work_address" and the second for "city" | |
| The first ATTRIBUTE_QUALIFIER for a CQA will be either: | |
| * a column belonging to the table the CQA is for, and in this case | |
| the table is a relational table | |
| or | |
| * an attribute belonging to a type, and in this case the table the | |
| CQA is for is an object table based on that type | |
| The subsequent ATTRIBUTE_QUALIFIERS are the remaining attributes in | |
| the order in which they make up the full path of the CQA | |
| Sub-type of | INTERSECTION |
| Versioning: | Belongs to: TABLE_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
CQA_REFERENCE COLUMN_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_CQACOL |
| Changes: | Summary of changes to ATTRIBUTE_QUALIFIER in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| COLUMN_REFERENCE | N |
Prompt: Column or Attribute
Transferable only if null |
Must be a usage of one and only one COLUMN | |
| CQA_REFERENCE | N |
Prompt: Column Qualified Attribute
Transferable only if null |
Must be in the context of one and only one COLUMN_QUALIFIED_ATTRIBUTE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| SEQUENCE | NUMBER(6, 0) | N | Position of the column or attribute in the path of the COLUMN_QUALIFIED_ATTRIBUTE
Prompt: Sequence in Path System maintained: API provides a value only if left null by the user | ||
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Common repository version identifier of owning PAC
Not displayed System maintained Updatable only if null Defined on SE supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs
Not displayed System maintained Not updatable by user Defined on SE supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| Other Properties |
|---|
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference ATTRIBUTE_QUALIFIER:
Note: