Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.dag_closure 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
_dag_key int4 10
dag_dag._dag_key dag_closure__dag_key R
_mgitype_key int4 10
acc_mgitype._mgitype_key dag_closure__mgitype_key R
_ancestor_key int4 10
dag_node._node_key dag_closure__ancestor_key R
_descendent_key int4 10
dag_node._node_key dag_closure__descendent_key R
_ancestorobject_key int4 10
_descendentobject_key int4 10
_ancestorlabel_key int4 10
dag_label._label_key dag_closure__ancestorlabel_key R
_descendentlabel_key int4 10
dag_label._label_key dag_closure__descendentlabel_key R
creation_date timestamp 29,6
modification_date timestamp 29,6

Table contained 702,441 rows at Mon Sep 26 19:11 EDT 2011

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_ancestorobject_key
_dag_key + _ancestor_key + _descendent_key Performance Asc/Asc/Asc dag_closure_idx_dagancestordescendent
_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

Close relationships  within of separation: