SchemaSpy - Table mgd.mgd.all_allele

	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

_allele_key

int4

10

all_allele_cellline._allele_key	all_allele_cellline__allele_key R
all_allele_mutation._allele_key	Implied Constraint R
all_cre_cache._allele_key	all_cre_cache__allele_key R
all_knockout_cache._allele_key	all_knockout_cache__allele_key R
all_label._allele_key	Implied Constraint R
all_marker_assoc._allele_key	Implied Constraint R
gxd_allelegenotype._allele_key	gxd_allelegenotype__allele_key R
gxd_allelepair._allele_key_1	gxd_allelepair__allele_key_1 R
gxd_allelepair._allele_key_2	gxd_allelepair__allele_key_2 R
mld_expt_marker._allele_key	mld_expt_marker__allele_key R
mrk_omim_cache._allele_key	mrk_omim_cache__allele_key R
prb_allele._allele_key	Implied Constraint R
prb_strain_marker._allele_key	Implied Constraint R
seq_allele_assoc._allele_key	seq_allele_assoc__allele_key R
voc_allele_cache._allele_key	Implied Constraint R

_marker_key

int4

10

√

null

mrk_marker._marker_key

all_allele__marker_key R

_strain_key

int4

10

prb_strain._strain_key

all_allele__strain_key R

_mode_key

int4

10

voc_term._term_key

all_allele__mode_key R

_allele_type_key

int4

10

voc_term._term_key

all_allele__allele_type_key R

_allele_status_key

int4

10

voc_term._term_key

all_allele__allele_status_key R

_transmission_key

int4

10

voc_term._term_key

all_allele__transmission_key R

symbol

varchar

60

name

varchar

255

nomensymbol

varchar

50

√

null

iswildtype

int2

5

isextinct

int2

5

√

null

ismixed

int2

5

√

null

_createdby_key

int4

10

mgi_user._user_key

all_allele__createdby_key R

_modifiedby_key

int4

10

mgi_user._user_key

all_allele__modifiedby_key R

_approvedby_key

int4

10

√

null

mgi_user._user_key

all_allele__approvedby_key R

approval_date

timestamp

29,6

√

null

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 756,115 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_allele_key	Primary key	Asc	all_allele_pkey
_allele_key	Must be unique	Asc	all_allele_idx_allele_key
_allele_status_key	Performance	Asc	all_allele_idx_allele_status_key
_allele_type_key	Performance	Asc	all_allele_idx_allele_type_key
_createdby_key	Performance	Asc	all_allele_idx_createdby_key
_marker_key	Performance	Asc	all_allele_idx_marker_key
_mode_key	Performance	Asc	all_allele_idx_mode_key
_modifiedby_key	Performance	Asc	all_allele_idx_modifiedby_key
name	Performance	Asc	all_allele_idx_name
nomensymbol	Performance	Asc	all_allele_idx_nomensymbol
_strain_key	Performance	Asc	all_allele_idx_strain_key
symbol	Performance	Asc	all_allele_idx_symbol
_transmission_key	Performance	Asc	all_allele_idx_transmission_key