Element Type Definition: CONSTRAINT

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	CONSTRAINT_USAGE
Short Name	CNU
View Name	CI_CONSTRAINT_USAGES
Description	A constraint usage represents the usage of a particular constraint
	(ie foreign key, unique key, primary key or check constraint)
	within a particular DTU (MODULE_DETAILED_TABLE_USAGE).

	The reason for existance of constraint usages is the granularity
	of preferences required for the generators. The ability to record
	preferences against a constraint usage provides the user with the
	capability of varying constraint preferences at the individual
	constraint level within a DTU.

Sub-type of	SECONDARY_ACCESS_ELEMENT
Versioning:	Belongs to: GENERAL_MODULE versionable object REUSABLE_LOV versionable object REUSABLE_MCO versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	CONSTRAINT_REFERENCE TABLE_USAGE_REFERENCE
Used by:	Oracle Designer
Underlying table:	SDD_CNU
Changes:	Summary of changes to CONSTRAINT_USAGE in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
CONSTRAINT_REFERENCE	N	Prompt: Constraint System maintained Not transferable	Must be a usage of one and only one CONSTRAINT
TABLE_USAGE_REFERENCE	N	Prompt: Module Detail Table Usage System maintained Not transferable	Must be for one and only one MODULE_DETAIL_TABLE_USAGE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
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
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 CONSTRAINT_USAGE:

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 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_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