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
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_source_key serial 10  √  nextval('prb_source_seq'::regclass)
gxd_antigen
prb_probe
seq_source_assoc
primary key
_segmenttype_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 10 (Segment Type)
_vector_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 24 (Segment Vector Type)
_organism_key int4 10
mgi_organism
organism (foreign key to MGI_Organism)
_strain_key int4 10
prb_strain
foreign key to PRB_Strain
_tissue_key int4 10
prb_tissue
foreign key to PRB_Tissue
_gender_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 17 (Gender)
_cellline_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 18 (Cell Line)
_refs_key int4 10  √  null
bib_refs
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 who created the record
_modifiedby_key int4 10 1001
mgi_user
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 85,511 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort
_source_key Primary key Asc
_cellline_key Performance Asc
_organism_key + _source_key Performance Asc/Asc
_createdby_key Performance Asc
_gender_key Performance Asc
_modifiedby_key Performance Asc
name Performance Asc
_refs_key Performance Asc
_segmenttype_key Performance Asc
_strain_key Performance Asc
_tissue_key Performance Asc
_vector_key Performance Asc

Close relationships  within of separation: