Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.voc_evidence 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
_annotevidence_key int4 10
voc_evidence_property._annotevidence_key voc_evidence_property__annotevidence_key R
_annot_key int4 10
voc_annot._annot_key voc_evidence__annot_key R
_evidenceterm_key int4 10
voc_term._term_key voc_evidence__evidenceterm_key R
_refs_key int4 10
bib_refs._refs_key voc_evidence__refs_key R
inferredfrom varchar 255  √  null
_createdby_key int4 10
mgi_user._user_key voc_evidence__createdby_key R
_modifiedby_key int4 10
mgi_user._user_key voc_evidence__modifiedby_key R
creation_date timestamp 29,6
modification_date timestamp 29,6

Table contained 646,087 rows at Mon Sep 26 19:11 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
_annotevidence_key Primary key Asc voc_evidence_pkey
_annotevidence_key Must be unique Asc voc_evidence_idx_annotevidence_key
_annot_key Performance Asc voc_evidence_idx_annot_key
_createdby_key Performance Asc voc_evidence_idx_createdby_key
_evidenceterm_key Performance Asc voc_evidence_idx_evidenceterm_key
_modifiedby_key Performance Asc voc_evidence_idx_modifiedby_key
_refs_key Performance Asc voc_evidence_idx_refs_key

Close relationships  within of separation: