Element Type Definition: DOMAIN

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	DOMAIN_CONSTRAINT
Short Name	DCO
View Name	CI_DOMAIN_CONSTRAINTS
Description	A data constraint that will not exist as a database constraint, only
	as a database trigger. It identifies the use of a domain that has
	not been modelled using the DOMAIN element type. The set of valid
	values exist in a table that has been modelled and which may be of a
	generic nature, containing the valid values for several such domains.

	For example:

	A table may exist called APP_REF_CODES, which contains the allowed
	values for several logical domains, including the domain of valid
	job titles. In order for the JOB column in the EMP table to use this
	domain, a domain constraint would be created on JOB for APP_REF_CODES.
	The definition of the domain constraint includes the specification
	of the restriction to apply to the domain table. such as:

	APP_REF_CODES.DOMAIN_NAME = 'JOBS'

	There would be one KEY_COMPONENT that mapped EMP.JOB to
	APP_REF_CODES.DOMAIN_VALUE

Sub-type of	JOIN_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 FOREIGN_TABLE_REFERENCE NAME
Used by:	Oracle Designer
Underlying table:	SDD_OCO

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
FOREIGN_TABLE_REFERENCE	N	Prompt: Join Table Transferable only if null Defined on JCO supertype	Must be for joining to one and only one RELATION_DEFINITION
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
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
ERROR_MESSAGE	VARCHAR2(70)	Y	An error message that is issued when data violates the constraint. Prompt: Error Message Defined on OCO supertype
FK_CASCADE_DELETE	VARCHAR2(1)	N	Indicates the actions required following an attempt to delete a related row in the join table Prompt: Delete Rule Uppercase Defined on JCO supertype	CASCADE_RULE	X
FK_CASCADE_UPDATE	VARCHAR2(1)	N	Indicates the actions required following an attempt to update a related row in the join table Prompt: Update Rule Uppercase Defined on JCO supertype	CASCADE_RULE	X
FK_TRANSFERABLE	VARCHAR2(1)	N	Indicates whether or not the foreign key can be updated. Prompt: Transferable ? Uppercase Defined on JCO supertype	YESNO	Y
IMPLEMENTATION_LEVEL	VARCHAR2(6)	N	Indicates if constraints are implemented in the database, application, both or neither Prompt: Validate in Uppercase Defined on JCO supertype	FCO_IMPLEMENTATION_LEVEL	BOTH
MANDATORY_FLAG	VARCHAR2(1)	N	Indicates whether the foreign key must exist Prompt: Mandatory ? Uppercase Defined on JCO supertype	YESNO	Y
NAME	VARCHAR2(30)	N	The name of the key constraint. Prompt: Name Uppercase Defined on OCO supertype
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	WHERCL	Where Condition

Other Properties
DOMAIN_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 DOMAIN_CONSTRAINT:

Each CONSTRAINT_USAGE must be a usage of one and only one CONSTRAINT
Each COLUMN may be denormalised via one and only one JOIN_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_BASED_LINK must be via one and only one JOIN_CONSTRAINT (in arc)
Each MODULE_DETAIL_TABLE_USAGE may be linked via one and only one JOIN_CONSTRAINT
Each MODULE_DETAIL_TABLE_USAGE may be tree walked using one and only one JOIN_CONSTRAINT
Each MODULE_DETAIL_TABLE_USAGE may be tree walked via table using one and only one JOIN_CONSTRAINT
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