SchemaSpy - Table pub.mgd.dag

A record in this table represents a specific Node within a DAG. The _Object_key/DAG_DAG._MGIType_key combination
identifies the specific Node object. In the case of a GO DAG, this is a specific Vocabulary Term.
The DAG_DAG._MGIType_key identifies the type of object (a Vocabulary Term) and the _Object_key identifies the
object itself.

Generated by
SchemaSpy

Legend:

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

_node_key

int4

dag_closure._ancestor_key	dag_closure__ancestor_key_fkey C
dag_closure._descendent_key	dag_closure__descendent_key_fkey C
dag_edge._child_key	dag_edge__child_key_fkey C
dag_edge._parent_key	dag_edge__parent_key_fkey C
dag_node_view._node_key	Implied Constraint R

primary key

_dag_key

int4

dag_dag._dag_key

dag_node__dag_key_fkey C

foreign key to DAG_DAG

_object_key

int4

foreign key to any object defined in ACC_MGIType

_label_key

int4

dag_label._label_key

dag_node__label_key_fkey R

foreign key to DAG_Label

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 140,300 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_node_key	Primary key	Asc	dag_node_pkey
_dag_key + _object_key	Performance	Asc/Asc	dag_node_idx_clustered
_label_key	Performance	Asc	dag_node_idx_label_key
_object_key	Performance	Asc	dag_node_idx_object_key