Table zfindb.public.ontology Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ont_pk_id bigserial 19  √  nextval('ontology_ont_pk_id_seq'::regclass)
term.term_ontology_id term_ontology_foreign_key R
ont_ontology_name text 2147483647  √  null
ont_order int4 10
ont_format_version text 2147483647  √  null
ont_default_namespace text 2147483647  √  null
ont_data_version text 2147483647  √  null
ont_current_date text 2147483647  √  null
ont_saved_by text 2147483647  √  null
ont_import text 2147483647  √  null
ont_remark text 2147483647  √  null

Table contained 19 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
ont_pk_id Primary key Asc ontology_primary_key  
ont_ontology_name Must be unique Asc ontology_name_unique This unique column is also nullable

Close relationships  within of separation: