SchemaSpy - Table pub.mgd.dag

A record in this table represents an ancestor/descendent pair within a DAG. It caches data for performance reasons. Two
common queries of a DAG are:

1. retrieve all the descendents of a node
2. retrieve all the ancestors of a node

This table provides a mechanism for performing such queries within one SQL statement.

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

_dag_key

int4

dag_dag._dag_key

dag_closure__dag_key_fkey C

foreign key to DAG_DAG

_mgitype_key

int4

acc_mgitype._mgitype_key

dag_closure__mgitype_key_fkey R

foreign key to ACC_MGIType

_ancestor_key

int4

dag_node._node_key

dag_closure__ancestor_key_fkey C

foreign key to DAG_Node._Node_key

_descendent_key

int4

dag_node._node_key

dag_closure__descendent_key_fkey C

foreign key to DAG_Node._Node_key

_ancestorobject_key

int4

the MGI object to which the Ancestor node refers

_descendentobject_key

int4

the MGI object to which the Descendent node refers

_ancestorlabel_key

int4

dag_label._label_key

dag_closure__ancestorlabel_key_fkey R

foreign key to DAG_Label; the label of the Ancestor

_descendentlabel_key

int4

dag_label._label_key

dag_closure__descendentlabel_key_fkey R

foreign key to DAG_Label; the label of the Descendent

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 1,850,004 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_dag_key + _ancestor_key + _descendent_key	Primary key	Asc/Asc/Asc	dag_closure_pkey
_ancestor_key	Performance	Asc	dag_closure_idx_ancestor_key
_ancestorlabel_key	Performance	Asc	dag_closure_idx_ancestorlabel_key
_ancestorobject_key + _descendentobject_key + _dag_key	Performance	Asc/Asc/Asc	dag_closure_idx_clustered
_descendent_key	Performance	Asc	dag_closure_idx_descendent_key
_descendentlabel_key	Performance	Asc	dag_closure_idx_descendentlabel_key
_descendentobject_key + _ancestorobject_key + _dag_key	Performance	Asc/Asc/Asc	dag_closure_idx_descendentobject_key
_mgitype_key	Performance	Asc	dag_closure_idx_mgitype_key