Ontology_Item Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Ontology_Item_ID	Identifier	BIGINT	NO
Ontology_ID	Identifier	BIGINT	NO
Element_ID	Identifier	BIGINT	YES
Item_Reference		VARCHAR(20)	YES	Concatenate this with the Ontology.system_URL for a full URI for the item
Version	Version	INTEGER	NO
Date_Created	Date_Created	TIMESTAMP/DATE	NO
Last_Updated	Last_Updated	DATETIME	YES
Modified_by	Modified_by	VARCHAR(40)	YES

Ontology_Item Keys

Key Name	Key Type	Keys
PK_Ontology_item	PrimaryKey	Ontology_Item_ID
FK_ONTOLOGY_ITEM_ONTOLOGY	Inversion Entry	Ontology_ID
FK_ONTOLOGY_ITEM_ELEMENT	Inversion Entry	Element_ID

Ontology_Item Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Element	Non-Identifying	Zero or One to Zero or More				Element_ID	NO
Ontology	Non-Identifying	One To Zero or More				Ontology_ID	NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Ontology_Item Check Constraints

Check Constraint Name

CheckConstraint

Ontology_Item Security Types

Name	Current Value

Ontology_Item Where Used - Model Usage

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

Ontology_Item Where Used - Submodel Usage

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