SchemaSpy - Table mgd.mgd.mgi

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

_organism_key

int4

acc_logicaldb._organism_key	Implied Constraint R
gxd_antibody._organism_key	gxd_antibody__organism_key R
mgi_organism_mgitype._organism_key	mgi_organism_mgitype__organism_key R
mgi_synonymtype._organism_key	mgi_synonymtype__organism_key R
mrk_chromosome._organism_key	mrk_chromosome__organism_key R
mrk_homology_cache._organism_key	Implied Constraint R
mrk_label._organism_key	mrk_label__organism_key R
mrk_label._orthologorganism_key	mrk_label__orthologorganism_key R
mrk_marker._organism_key	mrk_marker__organism_key R
mrk_omim_cache._organism_key	Implied Constraint R
prb_source._organism_key	prb_source__organism_key R
seq_marker_cache._organism_key	Implied Constraint R
seq_sequence._organism_key	seq_sequence__organism_key R

commonname

varchar

latinname

varchar

√

null

_createdby_key

int4

mgi_user._user_key

mgi_organism__createdby_key R

_modifiedby_key

int4

mgi_user._user_key

mgi_organism__modifiedby_key R

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 50 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_organism_key	Primary key	Asc	mgi_organism_pkey
_organism_key	Must be unique	Asc	mgi_organism_idx_organism_key
commonname	Performance	Asc	mgi_organism_idx_commonname
_createdby_key	Performance	Asc	mgi_organism_idx_createdby_key
_modifiedby_key	Performance	Asc	mgi_organism_idx_modifiedby_key