Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.voc_evidence
A record in this table represents one evidence statement which supports one Annotation. There can be one or more Evidence records per Annotation. Although the schema supports zero or more Evidence records per Annotation, editorially at least one Evidence record is required per Annotation.

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_fkey C
voc_evidence_view._annotevidence_key Implied Constraint R
voc_evidenceproperty_view._annotevidence_key Implied Constraint R
primary key
_annot_key int4 10
voc_annot._annot_key voc_evidence__annot_key_fkey C
foreign key to VOC_Annot
_evidenceterm_key int4 10
voc_term._term_key voc_evidence__evidenceterm_key_fkey R
foreign key to VOC_Term; based on VOC_AnnotType; example _Vocab_key:3:GO Evidence Codes:IDA, IMP, IPI, TAS, etc.
_refs_key int4 10
bib_refs._refs_key voc_evidence__refs_key_fkey R
foreign key to BIB_Refs
inferredfrom text 2147483647  √  null supporting acc id for the evidence
_createdby_key int4 10 1001
mgi_user._user_key voc_evidence__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key voc_evidence__modifiedby_key_fkey R
user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 1,302,423 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_annotevidence_key Primary key Asc voc_evidence_pkey
_annot_key Performance Asc voc_evidence_idx_clustered
_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: