Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.voc_annotheader
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: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_annotheader_key int4 10 primary key
_annottype_key int4 10
voc_annottype
foreign key to VOC_AnnotType
_object_key int4 10 foreign key to any object defined in ACC_MGIType
_term_key int4 10
voc_term
Header Term for the annotation; foreign key to VOC_Term
sequencenum int4 10 order of the Header Term for a specific Object
isnormal int2 5 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 10 1001
mgi_user
user who created the record
_modifiedby_key int4 10 1001
mgi_user
user who last modified the record
_approvedby_key int4 10  √  null
mgi_user
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
_annotheader_key Primary key Asc
_approvedby_key Performance Asc
_annottype_key + _object_key + _term_key Performance Asc/Asc/Asc
_createdby_key Performance Asc
_modifiedby_key Performance Asc
_object_key Performance Asc
_term_key Performance Asc

Close relationships  within of separation: