SchemaSpy - Table pub.mgd.voc_evidence

A record in this table represents the association between an Annotation Evidence record and a Property. This stores the contextual data of a particular Annotation row. Each stanza that occurs in a given Annotation experiment (row) is stored as separate contextual data within the Annotation experiment. Each individual stanza is treated as a distinct contextual set of data that is associated with the proper Annotation row.

Generated by
SchemaSpy

Legend:

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

_evidenceproperty_key

serial

√

nextval('voc_evidence_property_seq'::regclass)

primary key

_annotevidence_key

int4

voc_evidence._annotevidence_key

voc_evidence_property__annotevidence_key_fkey C

foreign key to VOC_Evidence

_propertyterm_key

int4

voc_term._term_key

voc_evidence_property__propertyterm_key_fkey R

foreign key to VOC_Term; examples include: _Vocab_key = 82 (GO Property); 'evidence', 'anatomy', 'cell tyupe', 'text', etc.

stanza

int4

a stanza represents a group of proeprties within the same evidence; group by _AnnotEvidence_key/stranza/sequenceNumber to retreive the ordered set of stanza's for a given annotation/evidence

sequencenum

int4

sequnence number of the property within each stanza

value

text

2147483647

the value that is assigned (i.e. the text) to the property

_createdby_key

int4

1001

mgi_user._user_key

voc_evidence_property__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

1001

mgi_user._user_key

voc_evidence_property__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 3,647,657 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_evidenceproperty_key	Primary key, Used to cluster data	Asc	voc_evidence_property_pkey
_annotevidence_key	Performance	Asc	voc_evidence_property_idx_clustered
_createdby_key	Performance	Asc	voc_evidence_property_idx_createdby_key
_modifiedby_key	Performance	Asc	voc_evidence_property_idx_modifiedby_key
_propertyterm_key	Performance	Asc	voc_evidence_property_idx_propertyterm_key