SchemaSpy - Table pub.mgd.mgi_organism

	Schema Browser
Mouse Genome Informatics
MGI Home Help

A record in this table represents an Organism.

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

serial

10

√

nextval('mgi_organism_seq'::regclass)

acc_logicaldb._organism_key	acc_logicaldb__organism_key_fkey R
gxd_antibody._organism_key	gxd_antibody__organism_key_fkey R
gxd_htsample._organism_key	gxd_htsample__organism_key_fkey R
gxd_htsample_rnaseqset._organism_key	gxd_htsample_rnaseqset__organism_key_fkey R
mgi_organism_mgitype._organism_key	mgi_organism_mgitype__organism_key_fkey C
mgi_synonymtype._organism_key	mgi_synonymtype__organism_key_fkey R
mrk_chromosome._organism_key	mrk_chromosome__organism_key_fkey C
mrk_do_cache._organism_key	mrk_do_cache__organism_key_fkey R
mrk_label._organism_key	mrk_label__organism_key_fkey R
mrk_label._orthologorganism_key	mrk_label__orthologorganism_key_fkey R
mrk_location_cache._organism_key	mrk_location_cache__organism_key_fkey R
mrk_marker._organism_key	mrk_marker__organism_key_fkey R
prb_source._organism_key	prb_source__organism_key_fkey R
seq_marker_cache._organism_key	seq_marker_cache__organism_key_fkey R
seq_sequence._organism_key	seq_sequence__organism_key_fkey R

organism (foreign key to MGI_Organism)

commonname

text

2147483647

common name of organism

latinname

text

2147483647

√

null

latin name of organism

_createdby_key

int4

10

1001

mgi_user._user_key

mgi_organism__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

10

1001

mgi_user._user_key

mgi_organism__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 110 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_organism_key	Primary key	Asc	mgi_organism_pkey
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