Element Type Definition: UNIQUE_KEY

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	UNIQUE_KEY_CONSTRAINT
Short Name	UCO
View Name	CI_UNIQUE_KEY_CONSTRAINTS
Description
Sub-type of	CONSTRAINT
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:	TABLE_REFERENCE NAME
Used by:	Oracle Designer
Underlying table:	SDD_OCO
Changes:	Summary of changes to UNIQUE_KEY_CONSTRAINT in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
TABLE_REFERENCE	N	Prompt: Table Transferable only if null Defined on OCO supertype	Must be placed on one and only one RELATION_DEFINITION
UNIQUE_IDENTIFIER_REFERENCE	Y	Prompt: Unique Identifier	May be implementing one and only one UNIQUE_IDENTIFIER

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
COMPLETE_FLAG	VARCHAR2(1)	N	Indicates whether the definition of the constraint is complete and ready to be used by the generators Prompt: Complete ? Uppercase Defined on OCO supertype	YESNO	Y
CONSTRAINT_TYPE	VARCHAR2(10)	N	Sub-type discriminator. Internal property indicating the type of CONSTRAINT i.e. PRIMARY, UNIQUE, CHECK, FOREIGN or DOMAIN Not displayed Uppercase System maintained Not updatable by user Defined on OCO supertype	OCO_CONSTRAINT_TYPE
DEFER_STATUS	VARCHAR2(16)	N	Indicates whether constraint checking can be deferred until the end of the transaction (as opposed to end of each DML statement) Prompt: Defer Status Uppercase Defined on OCO supertype	DEFER_STATUS	NOT DEFERRED
ENABLED_FLAG	VARCHAR2(1)	N	Specifies if constraint is ENABLED or DISABLED when it it is created on the database Prompt: Enable ? Uppercase	YESNO	Y
ERROR_MESSAGE	VARCHAR2(70)	Y	An error message that is issued when data violates the constraint. Prompt: Error Message Defined on OCO supertype
EXCEPTION_TABLE	VARCHAR2(40)	Y	Contains the name of the table which is to hold exceptions when an attempt is made to create the constraint on the database Prompt: Exceptions Table Uppercase
IMPLEMENTATION_LEVEL	VARCHAR2(6)	N	Indicates if constraints are implemented in the database or application Prompt: Validate In Uppercase	IMPLEMENTATION_LEVEL	BOTH
KEY_UPDATEABLE	VARCHAR2(1)	N	Indicates if a primary/unique key can be updated. Prompt: Update ? Uppercase	YESNO	Y
MANDATORY_FLAG	VARCHAR2(1)	N	Indicates whether the unique key must exist Prompt: Mandatory ? Uppercase	YESNO	N
NAME	VARCHAR2(30)	N	The name of the key constraint. Prompt: Name Uppercase Defined on OCO supertype
NULL_IS_DISCRETE_VALUE_FLAG	VARCHAR2(1)	N	Indicates whether null is to be treated as a discrete value Prompt: NULL is Discrete Value ? 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
DESCRIPTION	CDIDSC Defined on OCO supertype	Description
NOTES	CDINOT Defined on OCO supertype	Notes

Other Properties
UNIQUE_KEY_CONSTRAINT 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 UNIQUE_KEY_CONSTRAINT:

Each CONSTRAINT_USAGE must be a usage of one and only one CONSTRAINT
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 FOREIGN_KEY_CONSTRAINT may be for joining to one and only one UNIQUE_KEY_CONSTRAINT (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 KEY_COMPONENT must be within one and only one CONSTRAINT
Each PREFERENCE_SET_USAGE must be for 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
Each USER_OBJECT_INDEX_STORAGE must be for the index implementing one and only one UNIQUE_KEY_CONSTRAINT (in arc)
Each USER_PREFERENCE must be for one and only one CIELEMENT (in arc)

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