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
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_annotheader_key int4 10
voc_annotheader_view._annotheader_key Implied Constraint R
primary key
_annottype_key int4 10
voc_annottype._annottype_key voc_annotheader__annottype_key_fkey R
foreign key to VOC_AnnotType
_object_key int4 10 foreign key to any object defined in ACC_MGIType
_term_key int4 10
voc_term._term_key voc_annotheader__term_key_fkey R
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_key voc_annotheader__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key voc_annotheader__modifiedby_key_fkey R
user who last modified the record
_approvedby_key int4 10  √  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 171,329 rows at Mon Nov 20 05:26 EST 2017

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

Close relationships  within of separation: