ONTOLOGY_ITEM 
Logical Entity Name  Ontology_Item 
Default Table Name  ONTOLOGY_ITEM 
Physical Only  NO 
Do Not Generate  False 
Owner   
Definition 
 
Note 
 
PreSQL   
DDL Code  CREATE TABLE ONTOLOGY_ITEM(
     ONTOLOGY_ITEM_ID     NUMBER(19, 0)     NOT NULL,
     ONTOLOGY_ID          NUMBER(19, 0)     NOT NULL,
     ELEMENT_ID           NUMBER(19, 0),
     ITEM_REFERENCE       VARCHAR2(20),
     VERSION              NUMBER(38, 0)     DEFAULT 0 NOT NULL,
     Date_Created         TIMESTAMP(6)      DEFAULT sysdate NOT NULL,
     Last_Updated         TIMESTAMP(6),
     MODIFIED_BY          VARCHAR2(40),
     CONSTRAINT PK_ONTOLOGY_ITEM PRIMARY KEY (ONTOLOGY_ITEM_ID),
     CONSTRAINT FK_ONTOLOGY_ITEM_ONTOLOGY FOREIGN KEY (ONTOLOGY_ID)
     REFERENCES ONTOLOGY(ONTOLOGY_ID),
     CONSTRAINT FK_ONTOLOGY_ITEM_ELEMENT FOREIGN KEY (ELEMENT_ID)
     REFERENCES ELEMENT(ELEMENT_ID) ON DELETE CASCADE
)
;



CREATE INDEX FK_ONTOLOGY_ITEM_ONTOLOGY ON ONTOLOGY_ITEM(ONTOLOGY_ID)
;
CREATE INDEX FK_ONTOLOGY_ITEM_ELEMENT ON ONTOLOGY_ITEM(ELEMENT_ID)
;
 
PostSQL   

ONTOLOGY_ITEM Columns 
ColumnName  Domain  Datatype  NULL  Definition 
ONTOLOGY_ITEM_ID(PK)  Identifier  NUMBER(19, 0)  NO 
 
ONTOLOGY_ID(FK)  Identifier  NUMBER(19, 0)  NO 
 
ELEMENT_ID(FK)  Identifier  NUMBER(19, 0)  YES 
 
ITEM_REFERENCE    VARCHAR2(20)  YES  
Concatenate this with the Ontology.system_URL for a full URI for the item
 
VERSION  Version  NUMBER(38, 0)  NO 
 
Date_Created  Date_Created  TIMESTAMP(6)  NO 
 
Last_Updated  Last_Updated  TIMESTAMP(6)  YES 
 
MODIFIED_BY  Modified_by  VARCHAR2(40)  YES 
 

ONTOLOGY_ITEM Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_ONTOLOGY_ITEM  PrimaryKey  ONTOLOGY_ITEM_ID 

ONTOLOGY_ITEM Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
ELEMENT  Non-Identifying  Zero or One to Zero or More  FK_ONTOLOGY_ITEM_ELEMENT      ELEMENT_ID  NO  NO  NO 
ONTOLOGY  Non-Identifying  One To Zero or More  FK_ONTOLOGY_ITEM_ONTOLOGY      ONTOLOGY_ID  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 

ONTOLOGY_ITEM Check Constraints 
Check Constraint Name  CheckConstraint 

ONTOLOGY_ITEM Storage 
STORAGE OPTION  STORAGE VALUE 
TABLESPACE   
PctFree  10 
PCTUSED   0 
MinExtents  1 
MaxExtents  2147483645 
Initial  64 
Next  0 
PctIncrease  0 
InitTrans  1 
MaxTrans  255 
Organization  Heap 
Cache  NO 
Logging  Logged 
Parallel  NO 
Parallel Degrees   
Parallel Instances   
FREELISTS   
FREELIST GROUPS   
Buffer Pool   
Table Compression  NO 
Row Movement  Disabled 

ONTOLOGY_ITEM Growth Metrics 
TABLE METRIC  TABLE METRIC VALUE 
Current Row Count  4500 
Growth  200 
Growth Type  Rows 
Growth Period  per Month 
Maximum Rows  10000 

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)
BARD_CAP_PROD.ONTOLOGY_ITEM 		 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 
Current Production (Oracle)  Main Model 
Current Production (Oracle)  Dictionary 
Current Production (Oracle)  RI hierarchy