| EXT_ONTOLOGY_TREE |
| Logical Entity Name | EXT_ONTOLOGY_TREE |
| Default Table Name | EXT_ONTOLOGY_TREE |
| Physical Only | NO |
| Do Not Generate | False |
| Owner | |
| Definition | |
| Note | |
| PreSQL | |
| DDL Code | CREATE TABLE EXT_ONTOLOGY_TREE( NODE_ID NUMBER(19, 0) NOT NULL, PARENT_NODE_ID NUMBER(19, 0), ELEMENT_ID NUMBER(19, 0) NOT NULL, ELEMENT_STATUS VARCHAR2(20) NOT NULL, LABEL VARCHAR2(128) NOT NULL, IS_LEAF CHAR(1) NOT NULL, FULL_PATH VARCHAR2(3000), DESCRIPTION VARCHAR2(1000), ABBREVIATION VARCHAR2(20), SYNONYMS VARCHAR2(1000), EXTERNAL_URL VARCHAR2(1000), UNIT_ID NUMBER(19, 0), CONSTRAINT PK_EXT_ONTOLOGY_TREE PRIMARY KEY (NODE_ID), CONSTRAINT FK_EXT_ONTOLOGY_TREE_PARENT FOREIGN KEY (PARENT_NODE_ID) REFERENCES EXT_ONTOLOGY_TREE(NODE_ID) ) ; CREATE INDEX IDX_EXT_ONTOLOGY_TREE_ELMNT_ID ON EXT_ONTOLOGY_TREE(ELEMENT_ID) ; CREATE INDEX IDX_EXT_ONTOLOGY_TREE_LABEL ON EXT_ONTOLOGY_TREE(LABEL) ; CREATE INDEX FK_EXT_ONTOLOGY_TREE_PARENT ON EXT_ONTOLOGY_TREE(PARENT_NODE_ID) ; |
| PostSQL |
| EXT_ONTOLOGY_TREE Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| NODE_ID |
NUMBER(19, 0) | NO | ||
| PARENT_NODE_ID |
NUMBER(19, 0) | YES | ||
| ELEMENT_ID | NUMBER(19, 0) | NO | ||
| ELEMENT_STATUS | VARCHAR2(20) | NO | ||
| LABEL | VARCHAR2(128) | NO | ||
| IS_LEAF | CHAR(1) | NO | ||
| FULL_PATH | VARCHAR2(3000) | YES | ||
| DESCRIPTION | VARCHAR2(1000) | YES | ||
| ABBREVIATION | VARCHAR2(20) | YES | ||
| SYNONYMS | VARCHAR2(1000) | YES | ||
| EXTERNAL_URL | VARCHAR2(1000) | YES | ||
| UNIT_ID | NUMBER(19, 0) | YES |
| EXT_ONTOLOGY_TREE Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_EXT_ONTOLOGY_TREE | PrimaryKey | NODE_ID |
| EXT_ONTOLOGY_TREE Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
| EXT_ONTOLOGY_TREE | Non-Identifying | Zero or One to Zero or More | FK_EXT_ONTOLOGY_TREE_PARENT | PARENT_NODE_ID | NO | NO | NO |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
| EXT_ONTOLOGY_TREE | Non-Identifying | One To Zero or More | FK_EXT_ONTOLOGY_TREE_PARENT | NO | NO | NO |
| EXT_ONTOLOGY_TREE Check Constraints |
| Check Constraint Name | CheckConstraint |
| EXT_ONTOLOGY_TREE Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | 10 |
| PCTUSED | 0 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 1 |
| MaxTrans | 255 |
| Organization | Heap |
| Cache | NO |
| Logging | Logged |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Table Compression | NO |
| Row Movement | Disabled |
| EXT_ONTOLOGY_TREE Growth Metrics |
| TABLE METRIC | TABLE METRIC VALUE |
| Current Row Count | 0 |
| Growth | Static |
| Growth Type | N/A |
| Growth Period | N/A |
| Maximum Rows | 0 |
| 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 |