SchemaSpy - Table mgd.mgd.seq_sequence

	Schema Browser
Home \| About \| Help \| FAQ

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

_sequence_key

int4

10

seq_allele_assoc._sequence_key	seq_allele_assoc__sequence_key R
seq_coord_cache._sequence_key	seq_coord_cache__sequence_key R
seq_description_cache._sequence_key	seq_description_cache__sequence_key R
seq_genemodel._sequence_key	seq_genemodel__sequence_key R
seq_genetrap._sequence_key	seq_genetrap__sequence_key R
seq_probe_cache._sequence_key	seq_probe_cache__sequence_key R
seq_sequence_assoc._sequence_key_1	seq_sequence_assoc__sequence_key_1 R
seq_sequence_assoc._sequence_key_2	seq_sequence_assoc__sequence_key_2 R
seq_sequence_raw._sequence_key	seq_sequence_raw__sequence_key R
seq_source_assoc._sequence_key	seq_source_assoc__sequence_key R

_sequencetype_key

int4

10

voc_term._term_key

seq_sequence__sequencetype_key R

_sequencequality_key

int4

10

voc_term._term_key

seq_sequence__sequencequality_key R

_sequencestatus_key

int4

10

voc_term._term_key

seq_sequence__sequencestatus_key R

_sequenceprovider_key

int4

10

voc_term._term_key

seq_sequence__sequenceprovider_key R

_organism_key

int4

10

mgi_organism._organism_key

seq_sequence__organism_key R

length

int4

10

√

null

description

varchar

255

√

null

version

varchar

15

√

null

division

bpchar

3

√

null

virtual

int2

5

numberoforganisms

int4

10

√

null

seqrecord_date

timestamp

29,6

sequence_date

timestamp

29,6

_createdby_key

int4

10

mgi_user._user_key

seq_sequence__createdby_key R

_modifiedby_key

int4

10

mgi_user._user_key

seq_sequence__modifiedby_key R

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 11,959,131 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_sequence_key	Primary key	Asc	seq_sequence_pkey
_sequence_key	Must be unique	Asc	seq_sequence_idx_sequence_key
_createdby_key	Performance	Asc	seq_sequence_idx_createdby_key
length	Performance	Asc	seq_sequence_idx_length
_modifiedby_key	Performance	Asc	seq_sequence_idx_modifiedby_key
seqrecord_date	Performance	Asc	seq_sequence_idx_seqrecord_date
_sequencetype_key + _sequenceprovider_key + length	Performance	Asc/Asc/Asc	seq_sequence_idx_sequence_type_key
_sequenceprovider_key	Performance	Asc	seq_sequence_idx_sequenceprovider_key
_sequencequality_key	Performance	Asc	seq_sequence_idx_sequencequality_key
_sequencestatus_key	Performance	Asc	seq_sequence_idx_sequencestatus_key