Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.dag_closure
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: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_dag_key int4 10
dag_dag
foreign key to DAG_DAG
_mgitype_key int4 10
acc_mgitype
foreign key to ACC_MGIType
_ancestor_key int4 10
dag_node
foreign key to DAG_Node._Node_key
_descendent_key int4 10
dag_node
foreign key to DAG_Node._Node_key
_ancestorobject_key int4 10 the MGI object to which the Ancestor node refers
_descendentobject_key int4 10 the MGI object to which the Descendent node refers
_ancestorlabel_key int4 10
dag_label
foreign key to DAG_Label; the label of the Ancestor
_descendentlabel_key int4 10
dag_label
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
_dag_key + _ancestor_key + _descendent_key Primary key Asc/Asc/Asc
_ancestor_key Performance Asc
_ancestorlabel_key Performance Asc
_ancestorobject_key + _descendentobject_key + _dag_key Performance Asc/Asc/Asc
_descendent_key Performance Asc
_descendentlabel_key Performance Asc
_descendentobject_key + _ancestorobject_key + _dag_key Performance Asc/Asc/Asc
_mgitype_key Performance Asc

Close relationships  within of separation: