Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.dag_edge
A record in this table represents an edge of a DAG, the relationship between 2 nodes.

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
_edge_key int4 10 primary key
_dag_key int4 10
dag_dag._dag_key dag_edge__dag_key_fkey C
foreign key to DAG_DAG
_parent_key int4 10
dag_node._node_key dag_edge__parent_key_fkey C
foreign key to DAG_Node._Node_key
_child_key int4 10
dag_node._node_key dag_edge__child_key_fkey C
foreign key to DAG_Node._Node_key
_label_key int4 10
dag_label._label_key dag_edge__label_key_fkey R
foreign key to DAG_Label
sequencenum int4 10 sequence number for ordering records
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 203,383 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_edge_key Primary key, Used to cluster data Asc dag_edge_pkey
_child_key Performance Asc dag_edge_idx_child_key
_parent_key + _child_key + _label_key Performance Asc/Asc/Asc dag_edge_idx_clustered
_dag_key Performance Asc dag_edge_idx_dag_key
_label_key Performance Asc dag_edge_idx_label_key

Close relationships  within of separation: