Element Type Definition: UNIQUENESS

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	UNIQUENESS_RULE
Short Name	UNR
View Name	CI_UNIQUENESS_RULES
Description	Uniqueness rules provide a mechanism for asserting the uniqueness
	requirements for entity objects, generic classes, interfaces and view
	objects. The data components associated with the uniqueness rule
	identify a set of attributes and/or associations of the classifier
	to which the rule applies, whose combination of values must be unique

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
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
DESIGNATED_PRIMARY_KEY_FLAG	VARCHAR2(1)	N	Indicates whether this uniqueness rule is to be transformed to the primary key (as opposed to a unique key) in the server model Prompt: Is Designated Primary Key Uppercase	YESNO	N
NAME	VARCHAR2(100)	N	Name of this rule Prompt: Name Defined on CRU supertype
SHORT_DESCRIPTION	VARCHAR2(240)	Y	A short description of the rule Prompt: Short Description Defined on CRU 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 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 UNIQUENESS_RULE:

Each ASSOCIATION_END may be joined using one and only one UNIQUENESS_RULE
Each DATA_COMPONENT must be within one and only one UNIQUENESS_RULE (in arc)
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 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 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)

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