Element Type Definition: INTEGRITY

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	INTEGRITY_RULE
Short Name	INR
View Name	CI_INTEGRITY_RULES
Description	An integrity rule restricts the value of one or more attributes of a
	classifier. It is a condition that must be true at all times, for all
	instances of the classifier. It is similar to, and may be implemented
	as, a column or table level check constraint

Sub-type of	CLASSIFIER_RULE
Versioning:	Belongs to: ENTITY_OBJECT versionable object GENERIC_CLASS versionable object INTERFACE_CLASSIFIER versionable object VIEW_OBJECT versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	ENTITY_OBJECT_REFERENCE GENERIC_CLASS_REFERENCE VIEW_OBJECT_REFERENCE INTERFACE_CLASSIFIER_REFERENCE NAME
Used by:	JDeveloper Enterprise Edition
Underlying table:	SDD_CRU

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
ENTITY_OBJECT_REFERENCE	N	Prompt: Entity Object Transferable only if null Defined on CRU supertype	Must be applied to one and only one ENTITY_OBJECT	113
GENERIC_CLASS_REFERENCE	N	Prompt: Generic Class Transferable only if null Defined on CRU supertype	Must be applied to one and only one GENERIC_CLASS	113
INTERFACE_CLASSIFIER_REFERENCE	N	Prompt: Interface Transferable only if null Defined on CRU supertype	Must be applied to one and only one INTERFACE_CLASSIFIER	113
VIEW_OBJECT_REFERENCE	N	Prompt: View Object Transferable only if null Defined on CRU supertype	Must be applied to one and only one VIEW_OBJECT	113
CLASSIFIER_ATTRIBUTE_REFERENCE	Y	Prompt: Classifier Attribute	May be applied to one and only one CLASSIFIER_ATTRIBUTE
LANGUAGE_REFERENCE	Y	Prompt: Language Defined on CRU supertype	May be written in one and only one LANGUAGE
METHOD_REFERENCE	Y	Prompt: Method Defined on CRU supertype	May be implemented by one and only one METHOD

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
CLASSIFIER_RULE_FOR	VARCHAR2(3)	N	Arc 113 discriminator. Internal property indicating the type of element the arc points at Not displayed Uppercase System maintained Not updatable by user Defined on CRU supertype	CLASSIFIER_RULE_FOR
CLASSIFIER_RULE_SUBTYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal property indicating the type of classifier rule Not displayed Uppercase System maintained Not updatable by user Defined on CRU supertype	CLASSIFIER_RULE_SUBTYPE
CONTEXT	VARCHAR2(10)	N	Level at which the rule is enforced Prompt: Context Uppercase	RULE_CONTEXT	CLASSIFIER
DATABASE_CHECK_CONSTRAINT_FLAG	VARCHAR2(1)	N	Indicates whether a database check constraint is to be generated for this integrity rule by the transformers Prompt: Database Check Constraint ? Uppercase	YESNO	N
NAME	VARCHAR2(100)	N	Name of this rule Prompt: Name Defined on CRU supertype
SEQUENCE	NUMBER(6, 0)	N	Sequence of the rule within the classifier Prompt: Sequence in Classifier System maintained: API provides a value only if left null by the user
SHORT_DESCRIPTION	VARCHAR2(240)	Y	A short description of the rule Prompt: Short Description Defined on CRU supertype
VALIDATOR_OPERATOR	VARCHAR2(3)	N	Indicates whether validator usages for this rule are to be AND-ed or OR-ed with those for previous rule in sequence Prompt: Validator Operator Uppercase	VALIDATOR_OPERATOR	AND
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 CRU supertype	Description
NOTES	CDINOT Defined on CRU supertype	Notes
RULE_TEXT	RULTXT Defined on CRU supertype	Rule Text

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 INTEGRITY_RULE:

Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each ELEMENT_RULE_USAGE must be applicable to one and only one CIELEMENT (in arc)
Each MEMBER_COMPONENT must be within one and only one INTEGRITY_RULE (in arc)
Each METHOD_RULE_USAGE must be a usage of one and only one CLASSIFIER_RULE (in arc)
Each TAGGED_VALUE must be in the context of one and only one CIELEMENT (in arc)
Each UML_DEPENDENCY_CLIENT must be identifying as client one and only one CIELEMENT (in arc)
Each UML_DEPENDENCY_SUPPLIER must be identifying as supplier one and only one CIELEMENT (in arc)
Each VALIDATOR must be used by one and only one INTEGRITY_RULE (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