Element Type Definition: KEY

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	KEY_COMPONENT
Short Name	OKY
View Name	CI_KEY_COMPONENTS
Description	A key component applies to a primary, unique or foreign key and
	identifies a column used in that key. In the case of a foreign
	key it also identifies the column in the referenced table to which
	the foreign key column joins.

	In addition, key components for range based foreign keys include a
	second foreign key to COLUMN indicating the column used for the
	upper limit of the range. The range based foreign key on the source
	table is joined to the referenced table by the fact that its value
	falls within the corresponding upper and lower limits in the
	referenced table.

	A primary, unique or foreign key can be made up of any number
	of "ordinary" key components, but a foreign key can only have a
	maximum of one range key component.


Sub-type of	SECONDARY_ACCESS_ELEMENT
Versioning:	Belongs to: RECORD versionable object SNAPSHOT_DEFINITION versionable object TABLE_DEFINITION versionable object VIEW_DEFINITION versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	CONSTRAINT_REFERENCE COLUMN_REFERENCE CQA_REFERENCE FOREIGN_COLUMN_REFERENCE FOREIGN_CQA_REFERENCE SEQUENCE_NUMBER
Used by:	Oracle Designer
Underlying table:	SDD_OKY
Changes:	Summary of changes to KEY_COMPONENT in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
COLUMN_REFERENCE	N	Prompt: Column Transferable only if null	Must be the use of one and only one COLUMN	72
CQA_REFERENCE	N	Not displayed Transferable only if null	Must be the use of one and only one COLUMN_QUALIFIED_ATTRIBUTE	72
CONSTRAINT_REFERENCE	N	Prompt: Constraint Transferable only if null	Must be within one and only one CONSTRAINT
FOREIGN_COLUMN_REFERENCE	Y	Prompt: Join Column	May be for joining column to one and only one COLUMN	73
FOREIGN_CQA_REFERENCE	Y	Not displayed	May be for joining column to one and only one COLUMN_QUALIFIED_ATTRIBUTE	73
FOREIGN_COLUMN_REFERENCE2	Y	Prompt: Second Join Column	May be subject to upper limit defined in one and only one COLUMN	74
FOREIGN_CQA_REFERENCE2	Y	Not displayed	May be subject to upper limit defined in one and only one COLUMN_QUALIFIED_ATTRIBUTE	74

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
CONSTRAINT_TYPE	VARCHAR2(10)	N	The table key constaint type i.e. primary, unique or foreign.Denormalisation Prompt: Constraint Type Uppercase System maintained Not updatable by user	OKY_CONSTRAINT_TYPE
CONVERSION_FORMAT_MODIFIER	VARCHAR2(60)	Y	Applicable only to key components of domain constraints. Specifies conversion when column in domain table is VARCHAR2 but column joined to it is DATE or NUMBER Prompt: Conversion Format Mask
OKY_ARC1_FOR	VARCHAR2(3)	N	Arc 72 discriminator. Indicates whether the "use of" arc is for a COLUMN (COL) or a COLUMN_QUALIFIED_ATTRIBUTE (CQA) Not displayed Uppercase System maintained Not updatable by user	COLUMN_OR_CQA
OKY_ARC2_FOR	VARCHAR2(3)	N	Arc 73 discriminator. Indicates whether the "for joining column to" arc is for a COLUMN (COL) or a COLUMN_QUALIFIED_ATTRIBUTE (CQA) Not displayed Uppercase System maintained Not updatable by user	COLUMN_OR_CQA
OKY_ARC3_FOR	VARCHAR2(3)	N	Arc 74 discriminator. Indicates whether the "subject to upper limit defined in" arc is for a COLUMN (COL) or a COLUMN_QUALIFIED_ATTRIBUTE (CQA) Not displayed Uppercase System maintained Not updatable by user	COLUMN_OR_CQA
REMARK	VARCHAR2(240)	Y	A brief description of the use of the column in this key. Prompt: Comment
SEQUENCE_NUMBER	NUMBER(6, 0)	Y	The sequence of the column within the key. Prompt: Sequence in Key
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
KEY_COMPONENT 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: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference KEY_COMPONENT:

Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each MAPPING_ELEMENT must be sourced from one and only one CIELEMENT (in arc)
Each MAPPING_ELEMENT must be targeted to one and only one CIELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype