SchemaSpy - Table pub.mgd.voc

A record in this table represents the unique use of a Header term for a specific annotated Object of a specific Annotation Type. A set of records grouped by Annot Type/Object represents the ordered list of Header terms for an annotated Object of a specific Annotation Type.

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

_annotheader_key

int4

primary key

_annottype_key

int4

voc_annottype._annottype_key

voc_annotheader__annottype_key_fkey R

foreign key to VOC_AnnotType

_object_key

int4

foreign key to any object defined in ACC_MGIType

_term_key

int4

voc_term._term_key

voc_annotheader__term_key_fkey R

Header Term for the annotation; foreign key to VOC_Term

sequencenum

int4

order of the Header Term for a specific Object

isnormal

int2

If all of the qualifiers for a given header term = 'norm' (see VOC_Annot._Qualifier_key) then isNormal = 1 (true), else 0 (false)

_createdby_key

int4

1001

mgi_user._user_key

voc_annotheader__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

1001

mgi_user._user_key

voc_annotheader__modifiedby_key_fkey R

user who last modified the record

_approvedby_key

int4

√

null

mgi_user._user_key

voc_annotheader__approvedby_key_fkey R

user who approved the record

approval_date

timestamp

29,6

√

now()

date record was approved

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 217,832 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_annotheader_key	Primary key	Asc	voc_annotheader_pkey
_approvedby_key	Performance	Asc	voc_annotheader_idx_approvedby_key
_annottype_key + _object_key + _term_key	Performance	Asc/Asc/Asc	voc_annotheader_idx_clustered
_createdby_key	Performance	Asc	voc_annotheader_idx_createdby_key
_modifiedby_key	Performance	Asc	voc_annotheader_idx_modifiedby_key
_object_key	Performance	Asc	voc_annotheader_idx_object_key
_term_key	Performance	Asc	voc_annotheader_idx_term_key