Element Type Definition: CHECK

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	CHECK_CONSTRAINT
Short Name	CCO
View Name	CI_CHECK_CONSTRAINTS
Description	The definition of a check constraint

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

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
CHECK_CONSTRAINT_TYPE	VARCHAR2(14)	Y	Indicates whether the 'Where/Validation' CDWHCL text contains an expression or a function Prompt: Where/Validation Type Uppercase	DERIVATION_EXPRESSION_TYPE
CLIENT_ENFORCE_WHEN_NULL_FLAG	VARCHAR2(1)	N	Indicates whether check constraint to be validated client side even when some column values are null. Replaces Forms Generator preference CCEWN Prompt: Enforce When Null ? Uppercase	YESNO	Y
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
NAME	VARCHAR2(30)	N	The name of the key constraint. Prompt: Name Uppercase Defined on OCO supertype
REMARK	VARCHAR2(70)	Y	A comment on this constraint. Prompt: Comment
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
WHERE_CLAUSE	CDWHCL	Where/Validation Condition

Other Properties
CHECK_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 CHECK_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 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_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