SchemaSpy - Table pub.mgd.all_variant

A record in this table represents a sequence associated with a variant.n have multiple variants. Since each variant will have two records in ALL_Variant_Variant (one a source record, the other a curated record), there will be sequence records associated with both types of variant records.

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

_variantsequence_key

serial

√

nextval('all_variantsequence_seq'::regclass)

primary key, uniquely identifying the record

_variant_key

int4

all_variant._variant_key

all_variant_sequence__variant_key_fkey C

foreign key to ALL_Variant_Variant, identifying the variant with this sequence

_sequence_type_key

int4

voc_term._term_key

all_variant_sequence__sequence_type_key_fkey R

foreign key to VOC_Term, identifies the type of this sequence (_Vocab_key = 21)

startcoordinate

numeric

131089

√

null

endcoordinate

numeric

131089

√

null

referencesequence

text

2147483647

√

null

text string identifying the reference (non-variant) version of this sequence

variantsequence

text

2147483647

√

null

text string identifying the variant version of this sequence

version

text

2147483647

√

null

_createdby_key

int4

1001

mgi_user._user_key

all_variant_sequence__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

1001

mgi_user._user_key

all_variant_sequence__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 2,175 rows at Mon Mar 09 10:28 EDT 2020

Indexes:

Column(s)	Type	Sort	Constraint Name
_variantsequence_key	Primary key	Asc	all_variant_sequence_pkey
_createdby_key	Performance	Asc	all_variant_sequence_idx_createdby_key
_modifiedby_key	Performance	Asc	all_variant_sequence_idx_modifiedby_key
_sequence_type_key	Performance	Asc	all_variant_sequence_idx_sequence_type_key
_variant_key	Performance	Asc	all_variant_sequence_idx_variant_key