Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.prb_source
Defines the biological context from which a Probe is derived, e.g., species, strain, tissue, etc. Some sources are well-defined "libraries". Every Probe has one and only one Source.

See PRB_Probe.

Generated by
SchemaSpy
Legend: SourceForge.net
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
_source_key int4 10
gxd_antibodyantigen_view._source_key Implied Constraint R
gxd_antigen._source_key gxd_antigen__source_key_fkey R
gxd_antigen_view._source_key Implied Constraint R
prb_probe._source_key prb_probe__source_key_fkey R
prb_probe_view._source_key Implied Constraint R
prb_source_view._source_key Implied Constraint R
prb_sourceref_view._source_key Implied Constraint R
seq_source_assoc._source_key seq_source_assoc__source_key_fkey R
primary key
_segmenttype_key int4 10
voc_term._term_key prb_source__segmenttype_key_fkey R
foreign key to VOC_Term where _Vocab_key = 10 (Segment Type)
_vector_key int4 10
voc_term._term_key prb_source__vector_key_fkey R
foreign key to VOC_Term where _Vocab_key = 24 (Segment Vector Type)
_organism_key int4 10
mgi_organism._organism_key prb_source__organism_key_fkey R
organism (foreign key to MGI_Organism)
_strain_key int4 10
prb_strain._strain_key prb_source__strain_key_fkey R
foreign key to PRB_Strain
_tissue_key int4 10
prb_tissue._tissue_key prb_source__tissue_key_fkey R
foreign key to PRB_Tissue
_gender_key int4 10
voc_term._term_key prb_source__gender_key_fkey R
foreign key to VOC_Term where _Vocab_key = 17 (Gender)
_cellline_key int4 10
voc_term._term_key prb_source__cellline_key_fkey R
foreign key to VOC_Term where _Vocab_key = 18 (Cell Line)
_refs_key int4 10  √  null
bib_refs._refs_key prb_source__refs_key_fkey R
foreign key to BIB_Refs
name text 2147483647  √  null source name
description text 2147483647  √  null description of library source
age text 2147483647 age of source
agemin numeric 131089 minimum age range determined by age field; system calculated
agemax numeric 131089 maximum age range determined by age field; system calculated
iscuratoredited int2 5 has any attribute of this record been modified by a curator?
_createdby_key int4 10 1001
mgi_user._user_key prb_source__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key prb_source__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 66,839 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_source_key Primary key, Used to cluster data Asc prb_source_pkey
_cellline_key Performance Asc prb_source_idx_cellline_key
_organism_key + _source_key Performance Asc/Asc prb_source_idx_clustered
_createdby_key Performance Asc prb_source_idx_createdby_key
_gender_key Performance Asc prb_source_idx_gender_key
_modifiedby_key Performance Asc prb_source_idx_modifiedby_key
name Performance Asc prb_source_idx_name
_refs_key Performance Asc prb_source_idx_refs_key
_segmenttype_key Performance Asc prb_source_idx_segmenttype_key
_strain_key Performance Asc prb_source_idx_strain_key
_tissue_key Performance Asc prb_source_idx_tissue_key
_vector_key Performance Asc prb_source_idx_vector_key

Close relationships  within of separation: