Element Type Definition: RELATION

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	RELATION_DEFINITION
Short Name	TAB
View Name	CI_RELATION_DEFINITIONS
Description	Definition of a table, view, snapshot or record

Sub-type of	SHAREABLE_ELEMENT
Non-instantiable super-type of	RECORD
	SNAPSHOT_DEFINITION
	TABLE_DEFINITION
	VIEW_DEFINITION

	As this is a non-instantiable supertype, follow links (above) to its instantiable subtypes to find versioning information for each subtype, uniqueness criteria, API rules etc
Underlying table:	SDD_TAB
Changes:	Summary of changes to RELATION_DEFINITION in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
NAME	VARCHAR2(30)	N	The unique table name. Prompt: Name Uppercase
REMARK	VARCHAR2(2000)	Y	A brief comment about this table, view, snapshot or record Prompt: Comment
TABLE_TYPE	VARCHAR2(6)	Y	Sub-type discriminator. Internal property indicating whether the RELATION_DEFINITION is a TABLE_DEFINITION (TABLE), VIEW_DEFINITION (VIEW), RECORD (RECORD), or SNAPSHOT_DEFINITION (SNAP). Not displayed Uppercase System maintained Not updatable by user	TAB_TABLE_TYPE

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

Each ASSUMPTION_TO_TABLE must be a use for one and only one RELATION_DEFINITION
Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each COLUMN must be of one and only one RELATION_DEFINITION (in arc)
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 JOIN_CONSTRAINT must be for joining to one and only one RELATION_DEFINITION
Each MODULE_DETAIL_TABLE_USAGE must be of one and only one RELATION_DEFINITION
Each CONSTRAINT must be placed on one and only one RELATION_DEFINITION
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each TABLE_ENTITY must be by one and only one RELATION_DEFINITION
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 RELATION_SELECTION must be in one and only one RELATION_DEFINITION
Each RELATION_SELECTION must be of one and only one RELATION_DEFINITION

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