EXT_ONTOLOGY_TREE Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
NODE_ID		NUMERIC(19, 0)	NO
PARENT_NODE_ID		NUMERIC(19, 0)	YES
ELEMENT_ID		NUMERIC(19, 0)	NO
ELEMENT_STATUS		VARCHAR(20)	NO
LABEL		VARCHAR(128)	NO
IS_LEAF		CHAR(1)	NO
FULL_PATH		VARCHAR(3000)	YES
DESCRIPTION		VARCHAR(1000)	YES
ABBREVIATION		VARCHAR(20)	YES
SYNONYMS		VARCHAR(1000)	YES
EXTERNAL_URL		VARCHAR(1000)	YES
UNIT_ID		NUMERIC(19, 0)	YES

EXT_ONTOLOGY_TREE Keys

Key Name	Key Type	Keys
PK_EXT_ONTOLOGY_TREE	PrimaryKey	NODE_ID
IDX_EXT_ONTOLOGY_TREE_ELMNT_ID	Inversion Entry	ELEMENT_ID
IDX_EXT_ONTOLOGY_TREE_LABEL	Inversion Entry	LABEL
FK_EXT_ONTOLOGY_TREE_PARENT	Inversion Entry	PARENT_NODE_ID

EXT_ONTOLOGY_TREE Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
EXT_ONTOLOGY_TREE	Non-Identifying	Zero or One to Zero or More				PARENT_NODE_ID	NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
EXT_ONTOLOGY_TREE	Non-Identifying	One To Zero or More					NO

EXT_ONTOLOGY_TREE Check Constraints

Check Constraint Name

CheckConstraint

EXT_ONTOLOGY_TREE Security Types

Name	Current Value

EXT_ONTOLOGY_TREE Where Used - Model Usage

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

EXT_ONTOLOGY_TREE Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Dictionary
BARD_Dev (Oracle)	Main Model
BARD_Dev (Oracle)	Dictionary
Current Production (Oracle)	Main Model
Current Production (Oracle)	Dictionary