SchemaSpy - Table pub.mgd.prb

A record in this table represents a unique strain or genetic background. Accession IDs for Strains (MGI, JRS, EMMA, MMRC, etc.) are stored in the ACC_Accession table.

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

_strain_key

serial

√

nextval('prb_strain_seq'::regclass)

all_allele._strain_key	all_allele__strain_key_fkey R
all_cellline._strain_key	all_cellline__strain_key_fkey R
all_variant._strain_key	all_variant__strain_key_fkey R
crs_cross._femalestrain_key	crs_cross__femalestrain_key_fkey R
crs_cross._malestrain_key	crs_cross__malestrain_key_fkey R
crs_cross._strainho_key	crs_cross__strainho_key_fkey R
crs_cross._strainht_key	crs_cross__strainht_key_fkey R
gxd_genotype._strain_key	gxd_genotype__strain_key_fkey R
mld_fish._strain_key	mld_fish__strain_key_fkey R
mld_insitu._strain_key	mld_insitu__strain_key_fkey R
mrk_strainmarker._strain_key	mrk_strainmarker__strain_key_fkey R
prb_allele_strain._strain_key	prb_allele_strain__strain_key_fkey R
prb_source._strain_key	prb_source__strain_key_fkey R
prb_strain_genotype._strain_key	prb_strain_genotype__strain_key_fkey C
prb_strain_marker._strain_key	prb_strain_marker__strain_key_fkey C
ri_riset._strain_key_1	ri_riset__strain_key_1_fkey R
ri_riset._strain_key_2	ri_riset__strain_key_2_fkey R

primary key

_species_key

int4

voc_term._term_key

prb_strain__species_key_fkey R

foreign key to VOC_Term where _Vocab_key = 26 (Strain Species)

_straintype_key

int4

voc_term._term_key

prb_strain__straintype_key_fkey R

foreign key to VOC_Term where _Vocab_key = 55 (Strain Type)

strain

text

2147483647

strain description

standard

int2

if 1, then the strain is official.

private

int2

if 1, then the Strain record is private (deleted from public copies of the database)

geneticbackground

int2

genetic background/strain prefix

_createdby_key

int4

1001

mgi_user._user_key

prb_strain__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

1001

mgi_user._user_key

prb_strain__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 89,555 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_strain_key	Primary key	Asc	prb_strain_pkey
_createdby_key	Performance	Asc	prb_strain_idx_createdby_key
creation_date	Performance	Asc	prb_strain_idx_creation_date
modification_date	Performance	Asc	prb_strain_idx_modification_date
_modifiedby_key	Performance	Asc	prb_strain_idx_modifiedby_key
_species_key	Performance	Asc	prb_strain_idx_species_key
strain	Performance	Asc	prb_strain_idx_strain
_straintype_key	Performance	Asc	prb_strain_idx_straintype_key