Element_Hierarchy Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
element_hierarchy_ID	Identifier	BIGINT	NO
parent_element_id	Identifier	BIGINT	NO
Child_Element_ID	Identifier	BIGINT	NO
Relationship_type		VARCHAR(40)	NO
Version	Version	INTEGER	NO
Date_Created	Date_Created	TIMESTAMP/DATE	NO
Last_Updated	Last_Updated	DATETIME	YES
Modified_by	Modified_by	VARCHAR(40)	YES

Element_Hierarchy Keys

Key Name	Key Type	Keys
PK_element_hierarchy	PrimaryKey	element_hierarchy_ID
AK_Element_Hierarchy	Alternate Key	Child_Element_ID, parent_element_id, Relationship_type
FK_E_HIERARCHY_PARENT_ELEM_ID	Inversion Entry	parent_element_id
FK_E_HIERARCHY_CHILD_ELEM_ID	Inversion Entry	Child_Element_ID

Element_Hierarchy Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Element	Non-Identifying	One To Zero or More				Child_Element_ID	NO
Element	Non-Identifying	One To Zero or More				parent_element_id	NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Element_Hierarchy Check Constraints

Check Constraint Name

CheckConstraint

Element_Hierarchy Security Types

Name	Current Value

Element_Hierarchy Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical Element_Hierarchy	NO
BARD - MySQL (MySQL) Does Not Exist	NO
BARD_Dev (Oracle) ELEMENT_HIERARCHY	NO
Current Production (Oracle) Does Not Exist	NO

Element_Hierarchy Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Dictionary
Logical	RI hierarchy
BARD_Dev (Oracle)	Main Model
BARD_Dev (Oracle)	Dictionary
BARD_Dev (Oracle)	RI hierarchy