Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
SchemaSpy Analysis of pub.mgd - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Sep 28 09:47 EDT 2020
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

pub.mgd contains 4327 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
crs_cross femaleallele1 bpchar 1  √  null first allele of maternal strain; used during construction of maternal genotype
crs_cross_view femaleallele1 bpchar 1  √  null
mld_matrix_view femaleallele1 bpchar 1  √  null
crs_cross femaleallele2 bpchar 1  √  null second allele of maternal strain; used during construction of maternal genotype
crs_cross_view femaleallele2 bpchar 1  √  null
mld_matrix_view femaleallele2 bpchar 1  √  null
crs_cross maleallele1 bpchar 1  √  null first allele of paternal strain; used during construction of paternal genotype
crs_cross_view maleallele1 bpchar 1  √  null
mld_matrix_view maleallele1 bpchar 1  √  null
crs_cross maleallele2 bpchar 1  √  null second allele of paternal strain; used during construction of paternal genotype
crs_cross_view maleallele2 bpchar 1  √  null
mld_matrix_view maleallele2 bpchar 1  √  null
mrk_mcv_cache qualifier bpchar 1 'D' = direct, 'I' = infered
prb_marker relationship bpchar 1  √  null relationship of Probe and Marker (H,E,A,M,P)
prb_marker_view relationship bpchar 1  √  null
crs_progeny sex bpchar 1 sex of progeny (M, F)
map_coord_feature strand bpchar 1  √  null if '+', the object is on the positive strand, else negative strand
mrk_location_cache strand bpchar 1  √  null strand for genome coordinate
seq_coord_cache strand bpchar 1 3' or 5' strand
seq_sequence division bpchar 3  √  null GenBank division
seq_sequence_view division bpchar 3  √  null
bib_citation_cache isreviewarticlestring bpchar 3 string representation of isReviewArticle
mgi_reference_allele_view isreviewarticlestring bpchar 3  √  null
mgi_reference_allelevariant_view isreviewarticlestring bpchar 3  √  null
mgi_reference_antibody_view isreviewarticlestring bpchar 3  √  null
mgi_reference_marker_view isreviewarticlestring bpchar 3  √  null
mgi_reference_sequence_view isreviewarticlestring bpchar 3  √  null
mgi_reference_strain_view isreviewarticlestring bpchar 3  √  null
dag_dag abbreviation bpchar 5 abbreviated name
acc_actualdb active int2 5 should the link be constructed? yes (1), no (0)
crs_cross allelefromsegparent int2 5 is the allele from the segregating parent?
crs_cross_view allelefromsegparent int2 5  √  null
mld_matrix_view allelefromsegparent int2 5  √  null
mgi_refassoctype allowonlyone int2 5 does this reference type allow only one association?
mgi_reference_allele_view allowonlyone int2 5  √  null
mgi_reference_allelevariant_view allowonlyone int2 5  √  null
mgi_reference_antibody_view allowonlyone int2 5  √  null
mgi_reference_marker_view allowonlyone int2 5  √  null
mgi_reference_sequence_view allowonlyone int2 5  √  null
mgi_reference_strain_view allowonlyone int2 5  √  null
mgi_reftype_allele_view allowonlyone int2 5  √  null
mgi_reftype_antibody_view allowonlyone int2 5  √  null
mgi_reftype_marker_view allowonlyone int2 5  √  null
mgi_reftype_sequence_view allowonlyone int2 5  √  null
mgi_reftype_strain_view allowonlyone int2 5  √  null
mgi_synonym_allele_view allowonlyone int2 5  √  null
mgi_synonym_goterm_view allowonlyone int2 5  √  null
mgi_synonym_musmarker_view allowonlyone int2 5  √  null
mgi_synonym_strain_view allowonlyone int2 5  √  null
mgi_synonymtype allowonlyone int2 5 if 1, then there can be at most one Synonym of this type for a given object
mgi_synonymtype_allele_view allowonlyone int2 5  √  null
mgi_synonymtype_goterm_view allowonlyone int2 5  √  null
mgi_synonymtype_musmarker_view allowonlyone int2 5  √  null
mgi_synonymtype_strain_view allowonlyone int2 5  √  null
acc_actualdb allowsmultiple int2 5 does the URL support a query using more than one accession number? yes (1), no (0)
acc_view allowsmultiple int2 5  √  null
mld_hybrid chrsorgenes int2 5 does MLD_Concordance table contain Chromosome (0) or Marker (1) values?
mld_hybrid_view chrsorgenes int2 5  √  null
dag_node_view dagabbrev bpchar 5  √  null
voc_go_cache dagabbrev bpchar 5 DAG abbreviation name ('C', 'F', 'O', 'P')
voc_vocabdag_view dagabbrev bpchar 5  √  null
crs_cross displayed int2 5 does this cross get displayed in the Cross Lookup list? yes (1), no (0)
crs_cross_view displayed int2 5  √  null
mld_matrix_view displayed int2 5  √  null
gxd_expression expressed int2 5 is Marker expressed in Structure? yes (1), no (0)
crs_cross f1directionknown int2 5 is the F1 direction known?
crs_cross_view f1directionknown int2 5  √  null
mld_matrix_view f1directionknown int2 5  √  null
prb_strain geneticbackground int2 5 genetic background/strain prefix
prb_strain_view geneticbackground int2 5  √  null
gxd_expression hasimage int2 5 if 1 (true), the this Assay contains an Image
bib_workflow_data haspdf int2 5 0 does Reference have a PDF?
prb_reference hasrmap int2 5 does reference have restriction map information? yes (1), no (0)
prb_reference_view hasrmap int2 5  √  null
prb_reference hassequence int2 5 is sequence information presented in reference? yes (1), no (0)
prb_reference_view hassequence int2 5  √  null
gxd_genotype isconditional int2 5 is this a conditional genotype?
gxd_genotype_view isconditional int2 5  √  null
prb_source iscuratoredited int2 5 has any attribute of this record been modified by a curator?
prb_source_view iscuratoredited int2 5  √  null
bib_workflow_status iscurrent int2 5 1 if 1, then current Status for this Reference/Group
bib_all2_view isdiscard int2 5  √  null
bib_all_view isdiscard int2 5  √  null
bib_citation_cache isdiscard int2 5
bib_refs isdiscard int2 5 is this a discarded reference?
bib_view isdiscard int2 5  √  null
pwi_bib_refs_view isdiscard int2 5  √  null
all_allele isextinct int2 5 if 1 (yes), then the Allele is extinct, else 0
all_allele_view isextinct int2 5  √  null
pwi_all_allele_view isextinct int2 5  √  null
gxd_expression isforgxd int2 5 if 1 (true), then this Assay will appear in GXD counts and queries (in front-end)
gxd_assay_view isgelassay int2 5  √  null
gxd_assaytype isgelassay int2 5 is assay type a gel assay? yes (1), no (0)
all_allele ismixed int2 5 if 1 (yes), then the Allele is mixed (from both male and female mice), else 0
all_allele_view ismixed int2 5  √  null
pwi_all_allele_view ismixed int2 5  √  null
all_allele_cellline_view ismutant int2 5  √  null
all_cellline ismutant int2 5 if 1, then this ES Cell line is a Mutant, else Parental
all_cellline_view ismutant int2 5  √  null
voc_annotheader isnormal int2 5 If all of the qualifiers for a given header term = 'norm' (see VOC_Annot._Qualifier_key) then isNormal = 1 (true), else 0 (false)
voc_annotheader_view isnormal int2 5  √  null
voc_term isobsolete int2 5  √  null if 1, the term is obsolete and cannot be used in future annotations
voc_term_cellline_view isobsolete int2 5  √  null
voc_term_mcv_view isobsolete int2 5  √  null
voc_term_repqualifier_view isobsolete int2 5  √  null
voc_term_strainallele_view isobsolete int2 5  √  null
voc_term_strainspecies_view isobsolete int2 5  √  null
voc_term_view isobsolete int2 5  √  null
img_imagepane_assoc isprimary int2 5 if = 1, then the association is primary, else secondary
img_imagepane_assoc_view isprimary int2 5  √  null
voc_vocab isprivate int2 5  √  null if 1, then the Accession IDs of the Vocabulary Terms are private, else they are public
voc_vocab_view isprivate int2 5  √  null
gxd_expression isrecombinase int2 5 if 1 (true), then this Assay has a Recombinase Reporter Gene (VOC_Term._Vocab_key = 14)
go_tracking isreferencegene int2 5 if 1, then the gene is a reference gene, else 0.
go_tracking_view isreferencegene int2 5  √  null
bib_all2_view isreviewarticle int2 5  √  null
bib_all_view isreviewarticle int2 5  √  null
bib_citation_cache isreviewarticle int2 5 is this a review article?
bib_refs isreviewarticle int2 5 is this a review article?
bib_view isreviewarticle int2 5  √  null
mgi_reference_allele_view isreviewarticle int2 5  √  null
mgi_reference_allelevariant_view isreviewarticle int2 5  √  null
mgi_reference_antibody_view isreviewarticle int2 5  √  null
mgi_reference_marker_view isreviewarticle int2 5  √  null
mgi_reference_sequence_view isreviewarticle int2 5  √  null
mgi_reference_strain_view isreviewarticle int2 5  √  null
mrk_reference_view isreviewarticle int2 5  √  null
pwi_bib_refs_view isreviewarticle int2 5  √  null
all_variant isreviewed int2 5 has this variant been reviewed by a curator (1) or not (0)?
gxd_assay_view isrnaassay int2 5  √  null
gxd_assaytype isrnaassay int2 5 does assay type detect RNA? yes (1), no (0)
voc_vocab issimple int2 5  √  null if 1, the Vocabulary is a simple vocabulary (no DAG), else the Vocabulary is structured (has 1 or more DAGS)
voc_vocab_view issimple int2 5  √  null
all_allele iswildtype int2 5 if 1, Allele is a wild type allele, else 0
all_allele_view iswildtype int2 5  √  null
pwi_all_allele_view iswildtype int2 5  √  null
mld_expt_marker matrixdata int2 5 is Marker typed in haplotype data? yes (1), no (0) (MLD_MCDataList)
mld_expt_marker_view matrixdata int2 5  √  null
acc_accession preferred int2 5 flags accession number as preferred/primary (1) or not preferred/secondary (0). there can only be one preferred accession number for logical database MGI. The default is 1.
acc_view preferred int2 5  √  null
all_acc_view preferred int2 5  √  null
all_cellline_acc_view preferred int2 5  √  null
all_derivation_summary_view preferred int2 5  √  null
all_summary_view preferred int2 5  √  null
bib_acc_view preferred int2 5  √  null
bib_summary_all_view preferred int2 5  √  null
gxd_antibody_acc_view preferred int2 5  √  null
gxd_antigen_acc_view preferred int2 5  √  null
gxd_antigen_summary_view preferred int2 5  √  null
gxd_assay_acc_view preferred int2 5  √  null
gxd_genotype_acc_view preferred int2 5  √  null
gxd_genotype_summary_view preferred int2 5  √  null
img_image_acc_view preferred int2 5  √  null
img_image_summary_view preferred int2 5  √  null
mgi_organism_acc_view preferred int2 5  √  null
mgi_organism_summary_view preferred int2 5  √  null
mld_acc_view preferred int2 5  √  null
mld_summary_view preferred int2 5  √  null
mrk_acc_view preferred int2 5  √  null
mrk_accnoref_view preferred int2 5  √  null
mrk_accref1_view preferred int2 5  √  null
mrk_accref2_view preferred int2 5  √  null
mrk_accref_view preferred int2 5  √  null
mrk_summary_view preferred int2 5  √  null
prb_acc_view preferred int2 5  √  null
prb_accnoref_view preferred int2 5  √  null
prb_accref_view preferred int2 5  √  null
prb_accrefnoseq_view preferred int2 5  √  null
prb_source_acc_view preferred int2 5  √  null
prb_source_summary_view preferred int2 5  √  null
prb_strain_acc_view preferred int2 5  √  null
prb_strain_summary_view preferred int2 5  √  null
prb_tissue_summary_view preferred int2 5  √  null
seq_allele_assoc_view preferred int2 5  √  null
seq_sequence_acc_view preferred int2 5  √  null
seq_summary_view preferred int2 5  √  null
voc_term_acc_view preferred int2 5  √  null
voc_term_summary_view preferred int2 5  √  null
acc_accession private int2 5 is this accession number private? yes (1), no (0)
acc_view private int2 5  √  null
all_acc_view private int2 5  √  null
all_cellline_acc_view private int2 5  √  null
all_derivation_summary_view private int2 5  √  null
all_summary_view private int2 5  √  null
bib_acc_view private int2 5  √  null
bib_summary_all_view private int2 5  √  null
gxd_antibody_acc_view private int2 5  √  null
gxd_antigen_acc_view private int2 5  √  null
gxd_antigen_summary_view private int2 5  √  null
gxd_assay_acc_view private int2 5  √  null
gxd_genotype_acc_view private int2 5  √  null
gxd_genotype_summary_view private int2 5  √  null
img_image_acc_view private int2 5  √  null
img_image_summary_view private int2 5  √  null
mgi_notetype private int2 5 are notes of this type private?
mgi_notetype_alldriver_view private int2 5  √  null
mgi_notetype_allele_view private int2 5  √  null
mgi_notetype_derivation_view private int2 5  √  null
mgi_notetype_genotype_view private int2 5  √  null
mgi_notetype_image_view private int2 5  √  null
mgi_notetype_marker_view private int2 5  √  null
mgi_notetype_mrkgo_view private int2 5  √  null
mgi_notetype_probe_view private int2 5  √  null
mgi_notetype_sequence_view private int2 5  √  null
mgi_notetype_source_view private int2 5  √  null
mgi_notetype_strain_view private int2 5  √  null
mgi_notetype_vocevidence_view private int2 5  √  null
mgi_organism_acc_view private int2 5  √  null
mgi_organism_summary_view private int2 5  √  null
mld_acc_view private int2 5  √  null
mld_summary_view private int2 5  √  null
mrk_acc_view private int2 5  √  null
mrk_accnoref_view private int2 5  √  null
mrk_accref1_view private int2 5  √  null
mrk_accref2_view private int2 5  √  null
mrk_accref_view private int2 5  √  null
mrk_summary_view private int2 5  √  null
prb_acc_view private int2 5  √  null
prb_accnoref_view private int2 5  √  null
prb_accref_view private int2 5  √  null
prb_accrefnoseq_view private int2 5  √  null
prb_source_acc_view private int2 5  √  null
prb_source_summary_view private int2 5  √  null
prb_strain private int2 5 if 1, then the Strain record is private (deleted from public copies of the database)
prb_strain_acc_view private int2 5  √  null
prb_strain_summary_view private int2 5  √  null
prb_strain_view private int2 5  √  null
prb_tissue_summary_view private int2 5  √  null
seq_sequence_acc_view private int2 5  √  null
seq_summary_view private int2 5  √  null
voc_term_acc_view private int2 5  √  null
voc_term_summary_view private int2 5  √  null
mgi_translationstrain_view regularexpression int2 5  √  null
mgi_translationtype regularexpression int2 5 if true (1), then apply a regular expression algorithm to the lookup of the translation target.
prb_source_view sstandard int2 5  √  null
prb_strain standard int2 5 if 1, then the strain is official.
prb_strain_view standard int2 5  √  null
prb_tissue standard int2 5 is the tissue a standard, official tissue? yes (1), no (0)
prb_source_view tstandard int2 5  √  null
seq_sequence virtual int2 5 is this sequence virtual (consensus)?
seq_sequence_view virtual int2 5  √  null
acc_actualdb delimiter bpchar 8  √  null the delimiter which separates multiple accession numbers; used when construcuting the full URL.
acc_view delimiter bpchar 8  √  null
acc_accession _accession_key int4 10 primary key
acc_accessionreference _accession_key int4 10 primary key of the Accession number to which the Reference refers
acc_view _accession_key int4 10  √  null
all_acc_view _accession_key int4 10  √  null
all_cellline_acc_view _accession_key int4 10  √  null
all_derivation_summary_view _accession_key int4 10  √  null
all_summary_view _accession_key int4 10  √  null
bib_acc_view _accession_key int4 10  √  null
bib_summary_all_view _accession_key int4 10  √  null
gxd_antibody_acc_view _accession_key int4 10  √  null
gxd_antigen_acc_view _accession_key int4 10  √  null
gxd_antigen_summary_view _accession_key int4 10  √  null
gxd_assay_acc_view _accession_key int4 10  √  null
gxd_genotype_acc_view _accession_key int4 10  √  null
gxd_genotype_summary_view _accession_key int4 10  √  null
img_image_acc_view _accession_key int4 10  √  null
img_image_summary_view _accession_key int4 10  √  null
mgi_organism_acc_view _accession_key int4 10  √  null
mgi_organism_summary_view _accession_key int4 10  √  null
mld_acc_view _accession_key int4 10  √  null
mld_summary_view _accession_key int4 10  √  null
mrk_acc_view _accession_key int4 10  √  null
mrk_accnoref_view _accession_key int4 10  √  null
mrk_accref1_view _accession_key int4 10  √  null
mrk_accref2_view _accession_key int4 10  √  null
mrk_accref_view _accession_key int4 10  √  null
mrk_mouse_view _accession_key int4 10  √  null
mrk_nonmouse_view _accession_key int4 10  √  null
mrk_summary_view _accession_key int4 10  √  null
prb_acc_view _accession_key int4 10  √  null
prb_accnoref_view _accession_key int4 10  √  null
prb_accref_view _accession_key int4 10  √  null
prb_accrefnoseq_view _accession_key int4 10  √  null
prb_source_acc_view _accession_key int4 10  √  null
prb_source_summary_view _accession_key int4 10  √  null
prb_strain_acc_view _accession_key int4 10  √  null
prb_strain_summary_view _accession_key int4 10  √  null
prb_tissue_summary_view _accession_key int4 10  √  null
seq_allele_assoc_view _accession_key int4 10  √  null
seq_sequence_acc_view _accession_key int4 10  √  null
seq_summary_view _accession_key int4 10  √  null
voc_term_acc_view _accession_key int4 10  √  null
voc_term_summary_view _accession_key int4 10  √  null
acc_actualdb _actualdb_key serial 10  √  nextval('acc_actualdb_seq'::regclass) primary key
mrk_alias _alias_key int4 10 primary key
mrk_alias_view _alias_key int4 10  √  null
prb_alias _alias_key int4 10 primary key
all_allele _allele_key serial 10  √  nextval('all_allele_seq'::regclass) primary key
all_allele_cellline _allele_key int4 10 foreign key to ALL_Allele
all_allele_cellline_view _allele_key int4 10  √  null
all_allele_driver_view _allele_key int4 10  √  null
all_allele_mutation _allele_key int4 10 foreign key to ALL_Allele
all_allele_mutation_view _allele_key int4 10  √  null
all_allele_subtype_view _allele_key int4 10  √  null
all_allele_view _allele_key int4 10  √  null
all_annot_view _allele_key int4 10  √  null
all_cre_cache _allele_key int4 10 foreign key to ALL_Allele
all_genotype_view _allele_key int4 10  √  null
all_knockout_cache _allele_key int4 10  √  null foreign key to ALL_Allele
all_label _allele_key int4 10 foreign key to ALL_Allele
all_variant _allele_key int4 10 foreign key to ALL_Allele, identifies the allele for this variant
gxd_allelegenotype _allele_key int4 10 foreign key to ALL_Allele
gxd_assay_allele_view _allele_key int4 10  √  null
mld_expt_marker _allele_key int4 10  √  null foreign key to ALL_Allele
mld_expt_marker_view _allele_key int4 10  √  null
prb_allele _allele_key int4 10 foreign key to ALL_Allele
prb_allele_strain _allele_key int4 10 foreign key to ALL_Allele
prb_rflv_view _allele_key int4 10  √  null
prb_strain_marker _allele_key int4 10  √  null foreign key to ALL_Allele
prb_strain_marker_view _allele_key int4 10  √  null
pwi_all_allele_view _allele_key int4 10  √  null
seq_allele_assoc _allele_key int4 10 foreign key to ALL_Allele
seq_allele_assoc_view _allele_key int4 10  √  null
seq_allele_view _allele_key int4 10  √  null
voc_allele_cache _allele_key int4 10 foreign key to ALL_Allele
gxd_allelepair _allele_key_1 int4 10 foreign key to ALL_Allele
gxd_allelepair_view _allele_key_1 int4 10  √  null
gxd_allelepair _allele_key_2 int4 10  √  null foreign key to ALL_Allele
gxd_allelepair_view _allele_key_2 int4 10  √  null
all_allele _allele_status_key int4 10 foreign key to VOC_Term where _Vocab_key = 37 (Allele Status); 'In Progress', 'Deleted', 'Reserved', 'Approved', 'Autoload'
all_allele_view _allele_status_key int4 10  √  null
pwi_all_allele_view _allele_status_key int4 10  √  null
all_allele _allele_type_key int4 10 foreign key to VOC_Term where _Vocab_key = 38 (Allele Type); 'Spontaneous', 'Targeted', 'Gene trapped'
all_allele_view _allele_type_key int4 10  √  null
all_cre_cache _allele_type_key int4 10 foreign key to VOC_Term where _Vocab_key = 38 (Allele Type)
pwi_all_allele_view _allele_type_key int4 10  √  null
gxd_allelepair _allelepair_key serial 10  √  nextval('gxd_allelepair_seq'::regclass) primary key
gxd_allelepair_view _allelepair_key int4 10  √  null
dag_closure _ancestor_key int4 10 foreign key to DAG_Node._Node_key
dag_closure _ancestorlabel_key int4 10 foreign key to DAG_Label; the label of the Ancestor
dag_closure _ancestorobject_key int4 10 the MGI object to which the Ancestor node refers
all_allele_subtype_view _annot_key int4 10  √  null
all_annot_view _annot_key int4 10  √  null
prb_strain_attribute_view _annot_key int4 10  √  null
prb_strain_needsreview_view _annot_key int4 10  √  null
voc_annot _annot_key serial 10  √  nextval('voc_annot_seq'::regclass) primary key
voc_annot_view _annot_key int4 10  √  null
voc_evidence _annot_key int4 10 foreign key to VOC_Annot
voc_evidence_view _annot_key int4 10  √  null
voc_evidence _annotevidence_key serial 10  √  nextval('voc_evidence_seq'::regclass) primary key
voc_evidence_property _annotevidence_key int4 10 foreign key to VOC_Evidence
voc_evidence_view _annotevidence_key int4 10  √  null
voc_evidenceproperty_view _annotevidence_key int4 10  √  null
voc_annotheader _annotheader_key int4 10 primary key
voc_annotheader_view _annotheader_key int4 10  √  null
all_allele_subtype_view _annottype_key int4 10  √  null
all_annot_view _annottype_key int4 10  √  null
prb_strain_needsreview_view _annottype_key int4 10  √  null
voc_annot _annottype_key int4 10 foreign key to VOC_AnnotType; examples include 1000:GO/Marker), 1002:Mammelian Phenotypes/Genotype, 1020:DO/Genotype
voc_annot_view _annottype_key int4 10  √  null
voc_annotheader _annottype_key int4 10 foreign key to VOC_AnnotType
voc_annotheader_view _annottype_key int4 10  √  null
voc_annottype _annottype_key int4 10 primary key
gxd_antibody _antibody_key serial 10  √  nextval('gxd_antibody_seq'::regclass) primary key
gxd_antibody_view _antibody_key int4 10  √  null
gxd_antibodyalias _antibody_key int4 10 foreign key to GXD_Antibody
gxd_antibodyalias_view _antibody_key int4 10  √  null
gxd_antibodyaliasref_view _antibody_key int4 10  √  null
gxd_antibodyantigen_view _antibody_key int4 10  √  null
gxd_antibodymarker _antibody_key int4 10 foreign key to GXD_Antibody
gxd_antibodymarker_view _antibody_key int4 10  √  null
gxd_antibodyprep _antibody_key int4 10 foreign key to GXD_Antibody
gxd_antibodyprep_view _antibody_key int4 10  √  null
gxd_antibodyalias _antibodyalias_key serial 10  √  nextval('gxd_antibodyalias_seq'::regclass) primary key
gxd_antibodyalias_view _antibodyalias_key int4 10  √  null
gxd_antibodyaliasref_view _antibodyalias_key int4 10  √  null
gxd_antibody _antibodyclass_key int4 10 foreign key to GXD_AntibodyClass
gxd_antibody_view _antibodyclass_key int4 10  √  null
gxd_antibodyclass _antibodyclass_key int4 10 primary key
gxd_antibodymarker _antibodymarker_key serial 10  √  nextval('gxd_antibodymarker_seq'::regclass)
gxd_antibodyprep _antibodyprep_key serial 10  √  nextval('gxd_antibodyprep_seq'::regclass) primary key
gxd_antibodyprep_view _antibodyprep_key int4 10  √  null
gxd_assay _antibodyprep_key int4 10  √  null foreign key to GXD_AntibodyPrep
gxd_assay_view _antibodyprep_key int4 10  √  null
gxd_antibody _antibodytype_key int4 10 foreign key to GXD_AntibodyType
gxd_antibody_view _antibodytype_key int4 10  √  null
gxd_antibodytype _antibodytype_key int4 10 primary key
gxd_antibody _antigen_key int4 10 foreign key to GXD_Antigen
gxd_antibody_view _antigen_key int4 10  √  null
gxd_antibodyantigen_view _antigen_key int4 10  √  null
gxd_antigen _antigen_key serial 10  √  nextval('gxd_antigen_seq'::regclass) primary key
gxd_antigen_view _antigen_key int4 10  √  null
all_allele _approvedby_key int4 10  √  null user who approved record (foreign key to MGI_User)
all_allele_view _approvedby_key int4 10  √  null
pwi_all_allele_view _approvedby_key int4 10  √  null
voc_annotheader _approvedby_key int4 10  √  null user who approved the record
voc_annotheader_view _approvedby_key int4 10  √  null
all_cre_cache _assay_key int4 10  √  null foreign key to GXD_Assay
gxd_antibodyprep_view _assay_key int4 10  √  null
gxd_assay _assay_key serial 10  √  nextval('gxd_assay_seq'::regclass) primary key
gxd_assay_allele_view _assay_key int4 10  √  null
gxd_assay_view _assay_key int4 10  √  null
gxd_assaynote _assay_key int4 10 foreign key to GXD_Assay
gxd_expression _assay_key int4 10 foreign key to GXD_Assay
gxd_gelband_view _assay_key int4 10  √  null
gxd_gellane _assay_key int4 10 foreign key to GXD_Assay
gxd_gellane_view _assay_key int4 10  √  null
gxd_gellanestructure_view _assay_key int4 10  √  null
gxd_gelrow _assay_key int4 10 foreign key to GXD_Assay
gxd_gelrow_view _assay_key int4 10  √  null
gxd_probeprep_view _assay_key int4 10  √  null
gxd_specimen _assay_key int4 10 foreign key to GXD_Assay
gxd_specimen_view _assay_key int4 10  √  null
mld_assay_types _assay_type_key int4 10 primary key
mld_expt_marker _assay_type_key int4 10 foreign key to MLD_Assay_Types
mld_expt_marker_view _assay_type_key int4 10  √  null
gxd_assaynote _assaynote_key serial 10  √  nextval('gxd_assaynote_seq'::regclass)
gxd_assay _assaytype_key int4 10 foreign key to GXD_AssayType
gxd_assay_view _assaytype_key int4 10  √  null
gxd_assaytype _assaytype_key int4 10 primary key
gxd_expression _assaytype_key int4 10 foreign key to GXD_AssayType
all_allele_cellline _assoc_key serial 10  √  nextval('all_allele_cellline_seq'::regclass) primary key
all_allele_cellline_view _assoc_key int4 10  √  null
all_allele_mutation _assoc_key serial 10  √  nextval('all_allele_mutation_seq'::regclass)
all_allele_mutation_view _assoc_key int4 10  √  null
bib_workflow_data _assoc_key serial 10  √  nextval('bib_workflow_data_seq'::regclass) primary key
bib_workflow_status _assoc_key serial 10  √  nextval('bib_workflow_status_seq'::regclass)
bib_workflow_tag _assoc_key serial 10  √  nextval('bib_workflow_tag_seq'::regclass)
img_imagepane_assoc _assoc_key serial 10  √  nextval('img_imagepane_assoc_seq'::regclass) primary key
img_imagepane_assoc_view _assoc_key int4 10  √  null
mgi_reference_allele_view _assoc_key int4 10  √  null
mgi_reference_allelevariant_view _assoc_key int4 10  √  null
mgi_reference_antibody_view _assoc_key int4 10  √  null
mgi_reference_assoc _assoc_key serial 10  √  nextval('mgi_reference_assoc_seq'::regclass) primary key
mgi_reference_marker_view _assoc_key int4 10  √  null
mgi_reference_sequence_view _assoc_key int4 10  √  null
mgi_reference_strain_view _assoc_key int4 10  √  null
mrk_history _assoc_key serial 10  √  nextval('mrk_history_seq'::regclass)
mrk_history_view _assoc_key int4 10  √  null
seq_allele_assoc _assoc_key int4 10 primary key
seq_allele_assoc_view _assoc_key int4 10  √  null
seq_sequence_assoc _assoc_key int4 10 primary key
seq_source_assoc _assoc_key serial 10  √  nextval('seq_source_assoc_seq'::regclass) primary key
seq_marker_cache _biotypeconflict_key int4 10 foreign key to VOC_Term where _Vocab_key = 76 (BioType Conflict); 'Conflict', 'Not Applicable'
mrk_biotypemapping _biotypemapping_key int4 10 primary key
mrk_biotypemapping _biotypeterm_key int4 10 fk to voc_term
mrk_biotypemapping _biotypevocab_key int4 10 fk to voc_vocab; 1 of 3 provider biotype vocabs (103,104,105)
all_cre_cache _cache_key int4 10 primary key
mrk_do_cache _cache_key int4 10 primary key
seq_marker_cache _cache_key int4 10 primary key
voc_allele_cache _cache_key serial 10  √  nextval('voc_allele_cache_seq'::regclass)
voc_annot_count_cache _cache_key serial 10  √  nextval('voc_annot_count_cache_seq'::regclass)
voc_go_cache _cache_key serial 10  √  nextval('voc_go_cache_seq'::regclass)
voc_marker_cache _cache_key serial 10  √  nextval('voc_marker_cache_seq'::regclass)
mgi_relationship _category_key int4 10 The category, or type, of this relationship
mgi_relationship_category _category_key int4 10 Primary key
mgi_relationship_markertss_view _category_key int4 10  √  null
all_cellline _cellline_key serial 10  √  nextval('all_cellline_seq'::regclass) primary key
all_cellline_view _cellline_key int4 10  √  null
gxd_antibodyantigen_view _cellline_key int4 10  √  null
gxd_antigen_view _cellline_key int4 10  √  null
prb_source _cellline_key int4 10 foreign key to VOC_Term where _Vocab_key = 18 (Cell Line)
prb_source_view _cellline_key int4 10  √  null
all_cellline _cellline_type_key int4 10 foreign key to VOC_Term where _Vocab_key = 63 (Cell Line Type)
all_cellline_view _cellline_type_key int4 10  √  null
dag_edge _child_key int4 10 foreign key to DAG_Node._Node_key
mrk_chromosome _chromosome_key int4 10 primary key
mrk_cluster _cluster_key int4 10 Primary key
mrk_clustermember _cluster_key int4 10 Foreign key to MRK_Cluster
mrk_clustermember _clustermember_key int4 10 Primary key
mrk_cluster _clustersource_key int4 10 The term for the source or 'provider' of the cluster
mrk_cluster _clustertype_key int4 10 The term for the type of cluster
all_allele _collection_key int4 10 foreign key to VOC_Term where _Vocab_key = 92
(Allele Collection); 'KOMP-CSD', 'NorCOMM', 'EUCOMM'
all_allele_view _collection_key int4 10  √  null
map_coord_collection _collection_key int4 10 primary key
map_coordinate _collection_key int4 10 foreign key to MAP_Coord_Collection
pwi_all_allele_view _collection_key int4 10  √  null
go_tracking _completedby_key int4 10  √  null user who completed the record
go_tracking_view _completedby_key int4 10  √  null
gxd_allelepair _compound_key int4 10 foreign key to VOC_Term where _Vocab_key = 74 (GXD Conditional Mutants)
gxd_allelepair_view _compound_key int4 10  √  null
gxd_index _conditionalmutants_key int4 10 foreign key to VOC_Term where _Vocab_key = 74 (GXD Conditional Mutants); 'Both tg & KI', 'Induce (minor)', 'Inducile', 'Knocked in', 'Tg (minor amt)', 'Transgenic', 'Not Specified', 'Not Applicable'
gxd_index_view _conditionalmutants_key int4 10  √  null
mld_contig _contig_key int4 10 primary key
mld_contigprobe _contig_key int4 10 foreign key to MLD_Contig
acc_accession _createdby_key int4 10 1001 user who created the record
acc_accessionreference _createdby_key int4 10 1001 user who created the record
acc_actualdb _createdby_key int4 10 1001 user who created the record
acc_logicaldb _createdby_key int4 10 1001 user who created the record
acc_logicaldb_view _createdby_key int4 10  √  null
acc_mgitype _createdby_key int4 10 1001 user who created the record
acc_view _createdby_key int4 10  √  null
all_acc_view _createdby_key int4 10  √  null
all_allele _createdby_key int4 10 1001 user who created the record
all_allele_cellline _createdby_key int4 10 1001 user who created the record
all_allele_cellline_view _createdby_key int4 10  √  null
all_allele_view _createdby_key int4 10  √  null
all_cellline _createdby_key int4 10 1001 user who created the record
all_cellline_acc_view _createdby_key int4 10  √  null
all_cellline_derivation _createdby_key int4 10 1001 user who created the record
all_cellline_derivation_view _createdby_key int4 10  √  null
all_cellline_view _createdby_key int4 10  √  null
all_cre_cache _createdby_key int4 10 1001 user who created the record
all_knockout_cache _createdby_key int4 10 1001 user who created the record
all_summary_view _createdby_key int4 10  √  null
all_variant _createdby_key int4 10 1001 user who created the record
all_variant_sequence _createdby_key int4 10 1001 user who created the record
bib_acc_view _createdby_key int4 10  √  null
bib_all2_view _createdby_key int4 10  √  null
bib_all_view _createdby_key int4 10  √  null
bib_refs _createdby_key int4 10 1001 user who created the record
bib_summary_all_view _createdby_key int4 10  √  null
bib_view _createdby_key int4 10  √  null
bib_workflow_data _createdby_key int4 10 1001 user who created the record
bib_workflow_status _createdby_key int4 10 1001 user who created the record
bib_workflow_tag _createdby_key int4 10 1001 user who created the record
go_tracking _createdby_key int4 10 1001 user who created the record
go_tracking_view _createdby_key int4 10  √  null
gxd_allelegenotype _createdby_key int4 10 1001 user who created the record
gxd_allelepair _createdby_key int4 10 1001 user who created the record
gxd_allelepair_view _createdby_key int4 10  √  null
gxd_antibody _createdby_key int4 10 1001 user who created the record
gxd_antibody_acc_view _createdby_key int4 10  √  null
gxd_antibody_view _createdby_key int4 10  √  null
gxd_antibodyantigen_view _createdby_key int4 10  √  null
gxd_antigen _createdby_key int4 10 1001 user who created the record
gxd_antigen_acc_view _createdby_key int4 10  √  null
gxd_antigen_summary_view _createdby_key int4 10  √  null
gxd_antigen_view _createdby_key int4 10  √  null
gxd_assay _createdby_key int4 10 1001 user who created the record
gxd_assay_acc_view _createdby_key int4 10  √  null
gxd_assay_view _createdby_key int4 10  √  null
gxd_genotype _createdby_key int4 10 1001 user who created the record
gxd_genotype_acc_view _createdby_key int4 10  √  null
gxd_genotype_summary_view _createdby_key int4 10  √  null
gxd_genotype_view _createdby_key int4 10  √  null
gxd_htexperiment _createdby_key int4 10 1001 foreign key to MGI_User; user who created the record
gxd_htsample _createdby_key int4 10 1001 foreign key to MGI_User; user who created the record
gxd_htsample_rnaseq _createdby_key int4 10 1001 user who created the record
gxd_htsample_rnaseqcombined _createdby_key int4 10 1001 user who created the record
gxd_htsample_rnaseqset _createdby_key int4 10 1001 user who created the record
gxd_htsample_rnaseqsetmember _createdby_key int4 10 1001 user who created the record
gxd_index _createdby_key int4 10 1001 user who created the record
gxd_index_stages _createdby_key int4 10 1001 user who created the record
gxd_index_view _createdby_key int4 10  √  null
img_image _createdby_key int4 10 1001 user who created the record
img_image_acc_view _createdby_key int4 10  √  null
img_image_summary_view _createdby_key int4 10  √  null
img_image_view _createdby_key int4 10  √  null
img_imagepane_assoc _createdby_key int4 10 1001 user who created the record
img_imagepane_assoc_view _createdby_key int4 10  √  null
map_coord_collection _createdby_key int4 10 1001 user who created the record
map_coord_feature _createdby_key int4 10 1001 user who created the record
map_coordinate _createdby_key int4 10 1001 user who created the record
mgi_note _createdby_key int4 10 1001 user who created the record
mgi_note_allele_view _createdby_key int4 10  √  null
mgi_note_allelevariant_view _createdby_key int4 10  √  null
mgi_note_derivation_view _createdby_key int4 10  √  null
mgi_note_genotype_view _createdby_key int4 10  √  null
mgi_note_image_view _createdby_key int4 10  √  null
mgi_note_marker_view _createdby_key int4 10  √  null
mgi_note_mrkgo_view _createdby_key int4 10  √  null
mgi_note_probe_view _createdby_key int4 10  √  null
mgi_note_sequence_view _createdby_key int4 10  √  null
mgi_note_source_view _createdby_key int4 10  √  null
mgi_note_strain_view _createdby_key int4 10  √  null
mgi_note_vocevidence_view _createdby_key int4 10  √  null
mgi_notechunk _createdby_key int4 10 1001 user who created the record
mgi_notetype _createdby_key int4 10 1001 user who created the record
mgi_notetype_alldriver_view _createdby_key int4 10  √  null
mgi_notetype_allele_view _createdby_key int4 10  √  null
mgi_notetype_derivation_view _createdby_key int4 10  √  null
mgi_notetype_genotype_view _createdby_key int4 10  √  null
mgi_notetype_image_view _createdby_key int4 10  √  null
mgi_notetype_marker_view _createdby_key int4 10  √  null
mgi_notetype_mrkgo_view _createdby_key int4 10  √  null
mgi_notetype_probe_view _createdby_key int4 10  √  null
mgi_notetype_sequence_view _createdby_key int4 10  √  null
mgi_notetype_source_view _createdby_key int4 10  √  null
mgi_notetype_strain_view _createdby_key int4 10  √  null
mgi_notetype_vocevidence_view _createdby_key int4 10  √  null
mgi_organism _createdby_key int4 10 1001 user who created the record
mgi_organism_acc_view _createdby_key int4 10  √  null
mgi_organism_allele_view _createdby_key int4 10  √  null
mgi_organism_antigen_view _createdby_key int4 10  √  null
mgi_organism_marker_view _createdby_key int4 10  √  null
mgi_organism_mgitype _createdby_key int4 10 1001 user who created the record
mgi_organism_mgitype_view _createdby_key int4 10  √  null
mgi_organism_probe_view _createdby_key int4 10  √  null
mgi_organism_view _createdby_key int4 10  √  null
mgi_property _createdby_key int4 10 1001 user who created the record
mgi_propertytype _createdby_key int4 10 1001 user who created the record
mgi_refassoctype _createdby_key int4 10 1001 user who created the record
mgi_reference_allele_view _createdby_key int4 10  √  null
mgi_reference_allelevariant_view _createdby_key int4 10  √  null
mgi_reference_antibody_view _createdby_key int4 10  √  null
mgi_reference_assoc _createdby_key int4 10 1001 user who created the record
mgi_reference_marker_view _createdby_key int4 10  √  null
mgi_reference_sequence_view _createdby_key int4 10  √  null
mgi_reference_strain_view _createdby_key int4 10  √  null
mgi_reftype_allele_view _createdby_key int4 10  √  null
mgi_reftype_antibody_view _createdby_key int4 10  √  null
mgi_reftype_marker_view _createdby_key int4 10  √  null
mgi_reftype_sequence_view _createdby_key int4 10  √  null
mgi_reftype_strain_view _createdby_key int4 10  √  null
mgi_relationship _createdby_key int4 10 1001 user who created the record
mgi_relationship_category _createdby_key int4 10 1001 user who created the record
mgi_relationship_markertss_view _createdby_key int4 10  √  null
mgi_relationship_property _createdby_key int4 10 1001 user who created the record
mgi_roletask _createdby_key int4 10 1001 user who created the record
mgi_roletask_view _createdby_key int4 10  √  null
mgi_set _createdby_key int4 10 1001 user who created the record
mgi_setmember _createdby_key int4 10 1001 user who created the record
mgi_setmember_emapa _createdby_key int4 10 1001 user who created the record
mgi_synonym _createdby_key int4 10 1001 user who created the record
mgi_synonym_allele_view _createdby_key int4 10  √  null
mgi_synonym_goterm_view _createdby_key int4 10  √  null
mgi_synonym_musmarker_view _createdby_key int4 10  √  null
mgi_synonym_strain_view _createdby_key int4 10  √  null
mgi_synonymtype _createdby_key int4 10 1001 user who created the record
mgi_synonymtype_allele_view _createdby_key int4 10  √  null
mgi_synonymtype_goterm_view _createdby_key int4 10  √  null
mgi_synonymtype_musmarker_view _createdby_key int4 10  √  null
mgi_synonymtype_strain_view _createdby_key int4 10  √  null
mgi_translation _createdby_key int4 10 1001 user who created the record
mgi_translation_view _createdby_key int4 10  √  null
mgi_translationstrain_view _createdby_key int4 10  √  null
mgi_translationtype _createdby_key int4 10 1001 user who created the record
mgi_user _createdby_key int4 10 1001 user who created the record
mgi_user_active_view _createdby_key int4 10  √  null
mgi_userrole _createdby_key int4 10 1001 user who created the record
mgi_userrole_view _createdby_key int4 10  √  null
mgi_usertask_view _createdby_key int4 10  √  null
mld_acc_view _createdby_key int4 10  √  null
mld_summary_view _createdby_key int4 10  √  null
mrk_acc_view _createdby_key int4 10  √  null
mrk_accnoref_view _createdby_key int4 10  √  null
mrk_accref1_view _createdby_key int4 10  √  null
mrk_accref2_view _createdby_key int4 10  √  null
mrk_accref_view _createdby_key int4 10  √  null
mrk_biotypemapping _createdby_key int4 10 1001 user who created the record
mrk_chromosome _createdby_key int4 10 1001 user who created the record
mrk_cluster _createdby_key int4 10 1001 user who created the record
mrk_history _createdby_key int4 10 1001 user who created the record
mrk_history_view _createdby_key int4 10  √  null
mrk_location_cache _createdby_key int4 10 1001 user who created the record
mrk_marker _createdby_key int4 10 1001 user who created the record
mrk_marker_view _createdby_key int4 10  √  null
mrk_mcv_cache _createdby_key int4 10 1001 user who created the record
mrk_mcv_count_cache _createdby_key int4 10 1001 user who created the record
mrk_mouse_view _createdby_key int4 10  √  null
mrk_nonmouse_view _createdby_key int4 10  √  null
mrk_strainmarker _createdby_key int4 10 1001 user who created the record
mrk_summary_view _createdby_key int4 10  √  null
prb_acc_view _createdby_key int4 10  √  null
prb_accnoref_view _createdby_key int4 10  √  null
prb_accref_view _createdby_key int4 10  √  null
prb_accrefnoseq_view _createdby_key int4 10  √  null
prb_alias _createdby_key int4 10 1001 user who created the record
prb_allele _createdby_key int4 10 1001 user who created the record
prb_allele_strain _createdby_key int4 10 1001 user who created the record
prb_marker _createdby_key int4 10 1001 user who created the record
prb_probe _createdby_key int4 10 1001 user who created the record
prb_probe_view _createdby_key int4 10  √  null
prb_reference _createdby_key int4 10 1001 user who created the record
prb_reference_view _createdby_key int4 10  √  null
prb_rflv _createdby_key int4 10 1001 user who created the record
prb_rflv_view _createdby_key int4 10  √  null
prb_source _createdby_key int4 10 1001 user who created the record
prb_source_acc_view _createdby_key int4 10  √  null
prb_source_view _createdby_key int4 10  √  null
prb_strain _createdby_key int4 10 1001 user who created the record
prb_strain_acc_view _createdby_key int4 10  √  null
prb_strain_genotype _createdby_key int4 10 1001 user who created the record
prb_strain_genotype_view _createdby_key int4 10  √  null
prb_strain_marker _createdby_key int4 10 1001 user who created the record
prb_strain_marker_view _createdby_key int4 10  √  null
prb_strain_view _createdby_key int4 10  √  null
pwi_all_allele_view _createdby_key int4 10  √  null
pwi_bib_refs_view _createdby_key int4 10  √  null
pwi_mrk_marker_view _createdby_key int4 10  √  null
seq_allele_assoc _createdby_key int4 10 1001 user who created the record
seq_allele_assoc_view _createdby_key int4 10  √  null
seq_coord_cache _createdby_key int4 10 1001 user who created the record
seq_genemodel _createdby_key int4 10 1001 user who created the record
seq_genetrap _createdby_key int4 10 1001 user who created the record
seq_marker_cache _createdby_key int4 10 1001 user who created the record
seq_probe_cache _createdby_key int4 10 1001 user who created the record
seq_sequence _createdby_key int4 10 1001 user who created the record
seq_sequence_acc_view _createdby_key int4 10  √  null
seq_sequence_assoc _createdby_key int4 10 1001 user who created the record
seq_sequence_raw _createdby_key int4 10 1001 user who created the record
seq_sequence_view _createdby_key int4 10  √  null
seq_source_assoc _createdby_key int4 10 1001 user who created the record
seq_summary_view _createdby_key int4 10  √  null
voc_annotheader _createdby_key int4 10 1001 user who created the record
voc_annotheader_view _createdby_key int4 10  √  null
voc_evidence _createdby_key int4 10 1001 user who created the record
voc_evidence_property _createdby_key int4 10 1001 user who created the record
voc_evidence_view _createdby_key int4 10  √  null
voc_evidenceproperty_view _createdby_key int4 10  √  null
voc_term _createdby_key int4 10 1001 user who created the record
voc_term_acc_view _createdby_key int4 10  √  null
voc_term_cellline_view _createdby_key int4 10  √  null
voc_term_emapa _createdby_key int4 10 1001 user who created the record
voc_term_emaps _createdby_key int4 10 1001 user who created the record
voc_term_mcv_view _createdby_key int4 10  √  null
voc_term_repqualifier_view _createdby_key int4 10  √  null
voc_term_strainallele_view _createdby_key int4 10  √  null
voc_term_strainspecies_view _createdby_key int4 10  √  null
voc_term_view _createdby_key int4 10  √  null
all_allele_cellline_view _creator_key int4 10  √  null
all_cellline_derivation _creator_key int4 10 foreign key to VOC_Term where _Vocab_key = 62 (Cell Line Creator)
all_cellline_derivation_view _creator_key int4 10  √  null
all_cellline_view _creator_key int4 10  √  null
crs_cross _cross_key int4 10 primary key
crs_cross_view _cross_key int4 10  √  null
crs_matrix _cross_key int4 10 foreign key to CRS_Cross
crs_progeny _cross_key int4 10 foreign key to CRS_Cross
crs_references _cross_key int4 10 foreign key to CRS_Cross
crs_typings _cross_key int4 10 foreign key to CRS_Cross
mld_matrix _cross_key int4 10 foreign key to CRS_Cross
mld_matrix_view _cross_key int4 10  √  null
gxd_htexperiment _curationstate_key int4 10 foreign key to VOC_Term, identifying whether curation for this experiment has finished
mrk_current _current_key int4 10 foreign key to MRK_Marker
mrk_current_view _current_key int4 10  √  null
dag_closure _dag_key int4 10 foreign key to DAG_DAG
dag_dag _dag_key int4 10 primary key
dag_edge _dag_key int4 10 foreign key to DAG_DAG
dag_node _dag_key int4 10 foreign key to DAG_DAG
dag_node_view _dag_key int4 10  √  null
voc_go_cache _dag_key int4 10 foreign key to DAG_DAG
voc_vocabdag _dag_key int4 10 foreign key to DAG_DAG
voc_vocabdag_view _dag_key int4 10  √  null
voc_term_emapa _defaultparent_key int4 10  √  null An EMAPA term can have multiple parents, this defines the single default.
voc_term_emaps _defaultparent_key int4 10  √  null An EMAPS term can have multiple parents, this defines the single default.
all_cellline _derivation_key int4 10  √  null foreign key to ALL_CellLine_Derivation
all_cellline_derivation _derivation_key serial 10  √  nextval('all_cellline_derivation_seq'::regclass) primary key
all_cellline_derivation_view _derivation_key int4 10  √  null
all_cellline_view _derivation_key int4 10  √  null
all_cellline_derivation _derivationtype_key int4 10 foreign key to VOC_Term where _Vocab_key = 38 (Allele Type)
all_cellline_derivation_view _derivationtype_key int4 10  √  null
all_cellline_view _derivationtype_key int4 10  √  null
dag_closure _descendent_key int4 10 foreign key to DAG_Node._Node_key
dag_closure _descendentlabel_key int4 10 foreign key to DAG_Label; the label of the Descendent
dag_closure _descendentobject_key int4 10 the MGI object to which the Descendent node refers
dag_edge _edge_key int4 10 primary key
gxd_htsample _emapa_key int4 10  √  null foreign key to VOC_Term, identifying the EMAPA structure for this sample
gxd_htsample_rnaseqset _emapa_key int4 10 foreign key to VOC_Term
all_cre_cache _emapa_term_key int4 10  √  null foreign key to VOC_Term where _Vocab_key = 90 (EMAPA)
gxd_expression _emapa_term_key int4 10 foreign key to VOC_Term where _Vocab_key = 90 (EMAPA)
gxd_gellanestructure _emapa_term_key int4 10 foreign key to VOC_Term where _Vocab_key = 90 (EMAPA)
gxd_gellanestructure_view _emapa_term_key int4 10  √  null
gxd_isresultstructure _emapa_term_key int4 10 foreign key to VOC_Term where _Vocab_key = 90 (EMAPA)
gxd_isresultstructure_view _emapa_term_key int4 10  √  null
voc_term_emaps _emapa_term_key int4 10 The EMAPA term
gxd_embeddingmethod _embedding_key int4 10 primary key
gxd_specimen _embedding_key int4 10 foreign key to GXD_EmbeddingMethod
gxd_specimen_view _embedding_key int4 10  √  null
gxd_htexperiment _evaluatedby_key int4 10  √  null foreign key to MGI_User; user who evaluated this experiment and set its _Relevance_key
gxd_htexperiment _evaluationstate_key int4 10 foreign key to VOC_Term, identifying whether this experiment has been curated or not
mgi_relationship _evidence_key int4 10 The term for the relationship evidence
mgi_relationship_markertss_view _evidence_key int4 10  √  null
voc_evidence_property _evidenceproperty_key serial 10  √  nextval('voc_evidence_property_seq'::regclass) primary key
voc_evidenceproperty_view _evidenceproperty_key int4 10  √  null
voc_evidence _evidenceterm_key int4 10 foreign key to VOC_Term; based on VOC_AnnotType; example _Vocab_key:3:GO Evidence Codes:IDA, IMP, IPI, TAS, etc.
voc_evidence_view _evidenceterm_key int4 10  √  null
mgi_relationship_category _evidencevocab_key int4 10 Vocabulary that relationships draw their evidence terms from
voc_annot_view _evidencevocab_key int4 10  √  null
voc_annottype _evidencevocab_key int4 10 foreign key to VOC_Term; examples include 3:GO Evidence Codes, 2:Mammalian Phenotype Evidence, 80:MCV Evidence Codes Codes
gxd_genotype _existsas_key int4 10 foreign key to VOC_Term where _Vocab_key = 60 (Genotype Exists As); this genotype exists as 'Mouse Line', 'Cell Line', 'Chimeric', 'Not Specified', 'Not Applicable'
gxd_genotype_view _existsas_key int4 10  √  null
gxd_htexperiment _experiment_key int4 10 primary key
gxd_htexperimentvariable _experiment_key int4 10 foreign key to GXD_Experiment, identifies the experiment of the variable
gxd_htsample _experiment_key int4 10 foreign key to GXD_HTExperiment, identifies the experiment with which this sample is associated
gxd_htsample_rnaseqset _experiment_key int4 10 foreign key to GXD_HTExperiment
gxd_htexperiment _experimenttype_key int4 10 foreign key to VOC_Term, in identifying the MGI curated value for experiment type
gxd_htexperimentvariable _experimentvariable_key int4 10 primary key
gxd_expression _expression_key int4 10 primary key
mld_concordance _expt_key int4 10 foreign key to MLD_Expts
mld_concordance_view _expt_key int4 10  √  null
mld_contig _expt_key int4 10 foreign key to MLD_Expts
mld_expt_marker _expt_key int4 10 foreign key to MLD_Expts
mld_expt_marker_view _expt_key int4 10  √  null
mld_expt_notes _expt_key int4 10 foreign key to MLD_Expts
mld_expt_view _expt_key int4 10  √  null
mld_expts _expt_key int4 10 primary key
mld_fish _expt_key int4 10 foreign key to MLD_Expts
mld_fish_region _expt_key int4 10 foreign key to MLD_Expts
mld_fish_view _expt_key int4 10  √  null
mld_hit _expt_key int4 10 foreign key to MLD_Expts
mld_hybrid _expt_key int4 10 foreign key to MLD_Expts
mld_hybrid_view _expt_key int4 10  √  null
mld_insitu _expt_key int4 10 foreign key to MLD_Expts
mld_insitu_view _expt_key int4 10  √  null
mld_isregion _expt_key int4 10 foreign key to MLD_Expts
mld_matrix _expt_key int4 10 foreign key to MLD_Expts
mld_matrix_view _expt_key int4 10  √  null
mld_mc2point _expt_key int4 10 foreign key to MLD_Expts
mld_mc2point_view _expt_key int4 10  √  null
mld_mcdatalist _expt_key int4 10 foreign key to MLD_Expts
mld_ri _expt_key int4 10 foreign key to MLD_Expts
mld_ri2point _expt_key int4 10 foreign key to MLD_Expts
mld_ri2point_view _expt_key int4 10  √  null
mld_ri_view _expt_key int4 10  √  null
mld_ridata _expt_key int4 10 foreign key to MLD_Expts
mld_ridata_view _expt_key int4 10  √  null
mld_statistics _expt_key int4 10 foreign key to MLD_Expts
mld_statistics_view _expt_key int4 10  √  null
ri_summary_expt_ref _expt_key int4 10 foreign key to MLD_Expts
bib_workflow_data _extractedtext_key int4 10 foreign key to VOC_Term where_Vocab_key = 142 (Lit Triage Extracted Text Section)
map_coord_feature _feature_key int4 10 primary key
crs_cross _femalestrain_key int4 10 foreign key to PRB_Strain; maternal strain
crs_cross_view _femalestrain_key int4 10  √  null
mld_matrix_view _femalestrain_key int4 10  √  null
gxd_fixationmethod _fixation_key int4 10 primary key
gxd_specimen _fixation_key int4 10 foreign key to GXD_FixationMethod
gxd_specimen_view _fixation_key int4 10  √  null
gxd_gelband _gelband_key serial 10  √  nextval('gxd_gelband_seq'::regclass) primary key
gxd_gelband_view _gelband_key int4 10  √  null
gxd_gelcontrol _gelcontrol_key int4 10 primary key
gxd_gellane _gelcontrol_key int4 10 foreign key to GXD_GelControl
gxd_gellane_view _gelcontrol_key int4 10  √  null
gxd_expression _gellane_key int4 10  √  null foreign key to GXD_GelLane
gxd_gelband _gellane_key int4 10 foreign key to GXD_GelLane
gxd_gelband_view _gellane_key int4 10  √  null
gxd_gellane _gellane_key serial 10  √  nextval('gxd_gellane_seq'::regclass) primary key
gxd_gellane_view _gellane_key int4 10  √  null
gxd_gellanestructure _gellane_key int4 10 foreign key to GXD_GelLane
gxd_gellanestructure_view _gellane_key int4 10  √  null
gxd_gellanestructure _gellanestructure_key serial 10  √  nextval('gxd_gellanestructure_seq'::regclass)
gxd_gellanestructure_view _gellanestructure_key int4 10  √  null
gxd_gellane _gelrnatype_key int4 10 foreign key to GXD_GelRNAType
gxd_gellane_view _gelrnatype_key int4 10  √  null
gxd_gelrnatype _gelrnatype_key int4 10 primary key
gxd_gelband _gelrow_key int4 10 foreign key to GXD_GelRow
gxd_gelband_view _gelrow_key int4 10  √  null
gxd_gelrow _gelrow_key serial 10  √  nextval('gxd_gelrow_seq'::regclass) primary key
gxd_gelrow_view _gelrow_key int4 10  √  null
gxd_gelrow _gelunits_key int4 10 foreign key to GXD_GelUnits
gxd_gelrow_view _gelunits_key int4 10  √  null
gxd_gelunits _gelunits_key int4 10 primary key
gxd_antibodyantigen_view _gender_key int4 10  √  null
gxd_antigen_view _gender_key int4 10  √  null
prb_source _gender_key int4 10 foreign key to VOC_Term where _Vocab_key = 17 (Gender)
prb_source_view _gender_key int4 10  √  null
all_genotype_view _genotype_key int4 10  √  null
gxd_allelegenotype _genotype_key int4 10 foreign key to GXD_Genotype
gxd_allelepair _genotype_key int4 10 foreign key to GXD_Genotype
gxd_allelepair_view _genotype_key int4 10  √  null
gxd_expression _genotype_key int4 10 foreign key to GXD_Genotype
gxd_gellane _genotype_key int4 10 foreign key to GXD_Genotype
gxd_gellane_view _genotype_key int4 10  √  null
gxd_genotype _genotype_key serial 10  √  nextval('gxd_genotype_seq'::regclass) primary key
gxd_genotype_dataset_view _genotype_key int4 10  √  null
gxd_genotype_view _genotype_key int4 10  √  null
gxd_htsample _genotype_key int4 10 foreign key to GXD_Genotype, identifying the genotype of the sample
gxd_htsample_rnaseqset _genotype_key int4 10 foreign key to GXD_Genotype
gxd_specimen _genotype_key int4 10 foreign key to GXD_Genotype
gxd_specimen_view _genotype_key int4 10  √  null
mrk_do_cache _genotype_key int4 10 foreign key to GXD_Genotype
prb_strain_genotype _genotype_key int4 10 foreign key to GXD_Genotype
prb_strain_genotype_view _genotype_key int4 10  √  null
seq_genemodel _gmmarker_type_key int4 10  √  null the _Marker_Type_key (foreign key to MRK_Types) corresponding to the 'rawBiotype' attribute.
bib_workflow_status _group_key int4 10 foreign key to VOC_Term where _Vocab_key = 127 (Workflow Group)
mgi_user _group_key int4 10  √  null foreign key to VOC_Term where _Vocab_key = 127 (Workflow Group)
mgi_user_active_view _group_key int4 10  √  null
mrk_history _history_key int4 10 foreign key to MRK_Marker
mrk_history_view _history_key int4 10  √  null
gxd_isresultimage_view _image_key int4 10  √  null
img_image _image_key serial 10  √  nextval('img_image_seq'::regclass) primary key
img_image_view _image_key int4 10  √  null
img_imagepane _image_key int4 10 foreign key to IMG_Image
img_imagepane_assoc_view _image_key int4 10  √  null
img_imagepanegxd_view _image_key int4 10  √  null
img_image _imageclass_key int4 10 foreign key to VOC_Term where _Vocab_key = 83 (Image Class); 'Expression', 'Phenotypes', 'Molecular'
img_image_view _imageclass_key int4 10  √  null
img_imagepane_assoc_view _imageclass_key int4 10  √  null
gxd_assay _imagepane_key int4 10  √  null foreign key to IMG_ImagePane
gxd_assay_view _imagepane_key int4 10  √  null
gxd_insituresultimage _imagepane_key int4 10 foreign key to IMG_ImagePane
gxd_isresultimage_view _imagepane_key int4 10  √  null
img_imagepane _imagepane_key serial 10  √  nextval('img_imagepane_seq'::regclass) primary key
img_imagepane_assoc _imagepane_key int4 10 foreign key to IMG_ImagePane; specifies the Image Pane
img_imagepane_assoc_view _imagepane_key int4 10  √  null
img_imagepanegxd_view _imagepane_key int4 10  √  null
img_image _imagetype_key int4 10 foreign key to VOC_Term where _Vocab_key = 47 (Image Type)
img_image_view _imagetype_key int4 10  √  null
gxd_index _index_key int4 10 primary key
gxd_index_stages _index_key int4 10 foreign key to GXD_Index
gxd_index_view _index_key int4 10  √  null
gxd_index_stages _indexassay_key int4 10 foreign key to VOC_Term where _Vocab_key = 12 (GXD Index Assay); 'Prot-sxn', 'RNA-sxn', 'Prot-WM', 'RNA-WM', 'Knock in', 'Northern', 'Western', etc.
gxd_htexperiment _initialcuratedby_key int4 10  √  null foreign key to MGI_User; user who first curated the experiment, converting it from its raw status
all_knockout_cache _knockout_key int4 10 primary key
dag_edge _label_key int4 10 foreign key to DAG_Label
dag_label _label_key int4 10 primary key
dag_node _label_key int4 10 foreign key to DAG_Label
dag_node_view _label_key int4 10  √  null
gxd_antibodyprep _label_key int4 10 foreign key to GXD_Label
gxd_antibodyprep_view _label_key int4 10  √  null
gxd_label _label_key int4 10 primary key
gxd_probeprep _label_key int4 10 foreign key to GXD_Label
gxd_probeprep_view _label_key int4 10  √  null
mrk_label _label_key int4 10 primary key
all_label _label_status_key int4 10 1 = current, 2 = old
mrk_label _label_status_key int4 10 1 = current, 2 = old
gxd_htexperiment _lastcuratedby_key int4 10  √  null foreign key to MGI_User; user who last curated the experiment, converting it from its raw status
gxd_htsample_rnaseqcombined _level_key int4 10 foreign key to VOC_Term where _Vocab_key = 144 (RNA-Seq TPM Level)
acc_accession _logicaldb_key int4 10 foreign key to ACC_LogicalDB
acc_actualdb _logicaldb_key int4 10 foreign key to ACC_LogicalDB
acc_logicaldb _logicaldb_key serial 10  √  nextval('acc_logicaldb_seq'::regclass) primary key
acc_logicaldb_view _logicaldb_key int4 10  √  null
acc_view _logicaldb_key int4 10  √  null
all_acc_view _logicaldb_key int4 10  √  null
all_cellline_acc_view _logicaldb_key int4 10  √  null
all_derivation_summary_view _logicaldb_key int4 10  √  null
all_summary_view _logicaldb_key int4 10  √  null
bib_acc_view _logicaldb_key int4 10  √  null
bib_summary_all_view _logicaldb_key int4 10  √  null
gxd_antibody_acc_view _logicaldb_key int4 10  √  null
gxd_antigen_acc_view _logicaldb_key int4 10  √  null
gxd_antigen_summary_view _logicaldb_key int4 10  √  null
gxd_assay_acc_view _logicaldb_key int4 10  √  null
gxd_genotype_acc_view _logicaldb_key int4 10  √  null
gxd_genotype_summary_view _logicaldb_key int4 10  √  null
img_image_acc_view _logicaldb_key int4 10  √  null
img_image_summary_view _logicaldb_key int4 10  √  null
mgi_organism_acc_view _logicaldb_key int4 10  √  null
mgi_organism_summary_view _logicaldb_key int4 10  √  null
mld_acc_view _logicaldb_key int4 10  √  null
mld_summary_view _logicaldb_key int4 10  √  null
mrk_acc_view _logicaldb_key int4 10  √  null
mrk_accnoref_view _logicaldb_key int4 10  √  null
mrk_accref1_view _logicaldb_key int4 10  √  null
mrk_accref2_view _logicaldb_key int4 10  √  null
mrk_accref_view _logicaldb_key int4 10  √  null
mrk_summary_view _logicaldb_key int4 10  √  null
prb_acc_view _logicaldb_key int4 10  √  null
prb_accnoref_view _logicaldb_key int4 10  √  null
prb_accref_view _logicaldb_key int4 10  √  null
prb_accrefnoseq_view _logicaldb_key int4 10  √  null
prb_source_acc_view _logicaldb_key int4 10  √  null
prb_source_summary_view _logicaldb_key int4 10  √  null
prb_strain_acc_view _logicaldb_key int4 10  √  null
prb_strain_summary_view _logicaldb_key int4 10  √  null
prb_tissue_summary_view _logicaldb_key int4 10  √  null
seq_allele_assoc_view _logicaldb_key int4 10  √  null
seq_marker_cache _logicaldb_key int4 10 foreign key to ACC_LogicalDB
seq_sequence_acc_view _logicaldb_key int4 10  √  null
seq_summary_view _logicaldb_key int4 10  √  null
voc_annot_view _logicaldb_key int4 10  √  null
voc_term_acc_view _logicaldb_key int4 10  √  null
voc_term_summary_view _logicaldb_key int4 10  √  null
voc_term_view _logicaldb_key int4 10  √  null
voc_vocab _logicaldb_key int4 10 foreign key to ACC_LogicalDB; identifies the logical DB for the Accession IDs of the Vocabulary Terms
voc_vocab_view _logicaldb_key int4 10  √  null
crs_cross _malestrain_key int4 10 foreign key to PRB_Strain; paternal strain
crs_cross_view _malestrain_key int4 10  √  null
mld_matrix_view _malestrain_key int4 10  √  null
map_coord_feature _map_key int4 10 foreign key to MAP_Coordinate
map_coordinate _map_key int4 10 primary key
seq_coord_cache _map_key int4 10 foreign key to MAP_Collection
map_coordinate _maptype_key int4 10 foreign key to VOC_Term where _Vocab_key = 29 (Map Type)
mrk_event _marker_event_key int4 10 primary key
mrk_history _marker_event_key int4 10 foreign key to MRK_Event
mrk_history_view _marker_event_key int4 10  √  null
mrk_eventreason _marker_eventreason_key int4 10 primary key
mrk_history _marker_eventreason_key int4 10 foreign key to MRK_EventReason
mrk_history_view _marker_eventreason_key int4 10  √  null
all_allele _marker_key int4 10  √  null foreign key to MRK_Marker; foreign key to ALL_Marker_Assoc
all_allele_driver_view _marker_key int4 10  √  null
all_allele_view _marker_key int4 10  √  null
all_knockout_cache _marker_key int4 10 foreign key to MRK_Marker
bib_goxref_view _marker_key int4 10  √  null
crs_matrix _marker_key int4 10  √  null foreign key to MRK_Marker
crs_references _marker_key int4 10 foreign key to MRK_Marker
go_tracking _marker_key int4 10 foreign key to MRK_Marker
go_tracking_view _marker_key int4 10  √  null
gxd_allelegenotype _marker_key int4 10  √  null foreign key to MRK_Marker
gxd_allelepair _marker_key int4 10  √  null foreign key to MRK_Marker
gxd_allelepair_view _marker_key int4 10  √  null
gxd_antibodymarker _marker_key int4 10 foreign key to MRK_Marker
gxd_antibodymarker_view _marker_key int4 10  √  null
gxd_assay _marker_key int4 10 foreign key to MRK_Marker
gxd_assay_view _marker_key int4 10  √  null
gxd_expression _marker_key int4 10 foreign key to MRK_Marker
gxd_htsample_rnaseq _marker_key int4 10 foreign key to MRK_Marker
gxd_htsample_rnaseqcombined _marker_key int4 10 foreign key to MRK_Marker
gxd_index _marker_key int4 10 foreign key to MRK_Marker
gxd_index_view _marker_key int4 10  √  null
mld_concordance _marker_key int4 10  √  null foreign key to MRK_Marker
mld_concordance_view _marker_key int4 10  √  null
mld_expt_marker _marker_key int4 10 foreign key to MRK_Marker
mld_expt_marker_view _marker_key int4 10  √  null
mld_ridata _marker_key int4 10 foreign key to MRK_Marker
mld_ridata_view _marker_key int4 10  √  null
mrk_alias _marker_key int4 10 foreign key to MRK_Marker
mrk_alias_view _marker_key int4 10  √  null
mrk_anchors _marker_key int4 10 foreign key to MRK_Marker
mrk_anchors_view _marker_key int4 10  √  null
mrk_clustermember _marker_key int4 10 foreign key to MRK_Marker
mrk_current _marker_key int4 10 foreign key to MRK_Marker
mrk_current_view _marker_key int4 10  √  null
mrk_do_cache _marker_key int4 10 foreign key to MRK_Marker
mrk_history _marker_key int4 10 foreign key to MRK_Marker
mrk_history_view _marker_key int4 10  √  null
mrk_label _marker_key int4 10 foreign key to MRK_Marker
mrk_location_cache _marker_key int4 10 primary key/foreign key to MRK_Marker
mrk_marker _marker_key serial 10  √  nextval('mrk_marker_seq'::regclass) primary key
mrk_marker_view _marker_key int4 10  √  null
mrk_mcv_cache _marker_key int4 10 foreign key to MRK_Marker
mrk_mouse_view _marker_key int4 10  √  null
mrk_nonmouse_view _marker_key int4 10  √  null
mrk_notes _marker_key int4 10 foreign key to MRK_Marker
mrk_reference _marker_key int4 10 foreign key to MRK_Marker
mrk_reference_view _marker_key int4 10  √  null
mrk_strainmarker _marker_key int4 10  √  null foreign key to MRK_Marker/if null, then no canonical gene
prb_marker _marker_key int4 10 foreign key to MRK_Marker
prb_marker_view _marker_key int4 10  √  null
prb_rflv _marker_key int4 10 foreign key to MRK_Marker
prb_rflv_view _marker_key int4 10  √  null
prb_strain_marker _marker_key int4 10  √  null foreign key to MRK_Marker
prb_strain_marker_view _marker_key int4 10  √  null
pwi_all_allele_view _marker_key int4 10  √  null
pwi_mrk_marker_view _marker_key int4 10  √  null
ri_summary _marker_key int4 10 foreign key to MRK_Marker
seq_marker_cache _marker_key int4 10 foreign key to MRK_Marker
seq_marker_cache_view _marker_key int4 10  √  null
voc_marker_cache _marker_key int4 10 foreign key to MRK_Marker
wks_rosetta _marker_key int4 10  √  null foreign key to MRK_Marker
mld_mc2point _marker_key_1 int4 10 foreign key to MRK_Marker
mld_mc2point_view _marker_key_1 int4 10  √  null
mld_ri2point _marker_key_1 int4 10 foreign key to MRK_Marker
mld_ri2point_view _marker_key_1 int4 10  √  null
mld_statistics _marker_key_1 int4 10 foreign key to MRK_Marker
mld_statistics_view _marker_key_1 int4 10  √  null
mld_mc2point _marker_key_2 int4 10 foreign key to MRK_Marker
mld_mc2point_view _marker_key_2 int4 10  √  null
mld_ri2point _marker_key_2 int4 10 foreign key to MRK_Marker
mld_ri2point_view _marker_key_2 int4 10  √  null
mld_statistics _marker_key_2 int4 10 foreign key to MRK_Marker
mld_statistics_view _marker_key_2 int4 10  √  null
mrk_marker _marker_status_key int4 10 foreign key to MRK_Status
mrk_marker_view _marker_status_key int4 10  √  null
mrk_mouse_view _marker_status_key int4 10  √  null
mrk_nonmouse_view _marker_status_key int4 10  √  null
mrk_status _marker_status_key int4 10 primary key
pwi_mrk_marker_view _marker_status_key int4 10  √  null
mrk_biotypemapping _marker_type_key int4 10 fk to mrk_types
mrk_current_view _marker_type_key int4 10  √  null
mrk_location_cache _marker_type_key int4 10 foreign key to MRK_Types
mrk_marker _marker_type_key int4 10 foreign key to MRK_Types
mrk_marker_view _marker_type_key int4 10  √  null
mrk_mouse_view _marker_type_key int4 10  √  null
mrk_nonmouse_view _marker_type_key int4 10  √  null
mrk_types _marker_type_key int4 10 primary key
pwi_mrk_marker_view _marker_type_key int4 10  √  null
seq_marker_cache _marker_type_key int4 10 foreign key to MRK_Types
all_allele _markerallele_status_key int4 10
all_allele_view _markerallele_status_key int4 10  √  null
pwi_all_allele_view _markerallele_status_key int4 10  √  null
mrk_biotypemapping _mcvterm_key int4 10 fk to voc_term where _vocab_key = 79 (Marker Category aka MCV/FeatureType term)
mrk_mcv_cache _mcvterm_key int4 10 foreign key to VOC_Term where _Vocab_key = 79 (Marker Category); 'gene', 'protein coding gene', 'non-coding RNA gene', etc.
mrk_mcv_count_cache _mcvterm_key int4 10 foreign key to VOC_Term (_Vocab_key = 79)
acc_accession _mgitype_key int4 10 foreign key to ACC_MGIType
acc_mgitype _mgitype_key int4 10 primary key
acc_view _mgitype_key int4 10  √  null
all_acc_view _mgitype_key int4 10  √  null
all_cellline_acc_view _mgitype_key int4 10  √  null
all_derivation_summary_view _mgitype_key int4 10  √  null
all_summary_view _mgitype_key int4 10  √  null
bib_acc_view _mgitype_key int4 10  √  null
bib_summary_all_view _mgitype_key int4 10  √  null
dag_closure _mgitype_key int4 10 foreign key to ACC_MGIType
dag_dag _mgitype_key int4 10 foreign key to ACC_MGIType
gxd_antibody_acc_view _mgitype_key int4 10  √  null
gxd_antigen_acc_view _mgitype_key int4 10  √  null
gxd_antigen_summary_view _mgitype_key int4 10  √  null
gxd_assay_acc_view _mgitype_key int4 10  √  null
gxd_genotype_acc_view _mgitype_key int4 10  √  null
gxd_genotype_summary_view _mgitype_key int4 10  √  null
img_image_acc_view _mgitype_key int4 10  √  null
img_image_summary_view _mgitype_key int4 10  √  null
img_imagepane_assoc _mgitype_key int4 10 foreign key to ACC_MGIType
img_imagepane_assoc_view _mgitype_key int4 10  √  null
map_coord_feature _mgitype_key int4 10 foreign key to ACC_MGIType
map_coordinate _mgitype_key int4 10  √  null foreign key to ACC_MGIType
mgi_note _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_note_allele_view _mgitype_key int4 10  √  null
mgi_note_allelevariant_view _mgitype_key int4 10  √  null
mgi_note_derivation_view _mgitype_key int4 10  √  null
mgi_note_genotype_view _mgitype_key int4 10  √  null
mgi_note_image_view _mgitype_key int4 10  √  null
mgi_note_marker_view _mgitype_key int4 10  √  null
mgi_note_mrkgo_view _mgitype_key int4 10  √  null
mgi_note_probe_view _mgitype_key int4 10  √  null
mgi_note_sequence_view _mgitype_key int4 10  √  null
mgi_note_source_view _mgitype_key int4 10  √  null
mgi_note_strain_view _mgitype_key int4 10  √  null
mgi_note_vocevidence_view _mgitype_key int4 10  √  null
mgi_notetype _mgitype_key int4 10  √  null foreign key to ACC_MGIType
mgi_notetype_alldriver_view _mgitype_key int4 10  √  null
mgi_notetype_allele_view _mgitype_key int4 10  √  null
mgi_notetype_derivation_view _mgitype_key int4 10  √  null
mgi_notetype_genotype_view _mgitype_key int4 10  √  null
mgi_notetype_image_view _mgitype_key int4 10  √  null
mgi_notetype_marker_view _mgitype_key int4 10  √  null
mgi_notetype_mrkgo_view _mgitype_key int4 10  √  null
mgi_notetype_probe_view _mgitype_key int4 10  √  null
mgi_notetype_sequence_view _mgitype_key int4 10  √  null
mgi_notetype_source_view _mgitype_key int4 10  √  null
mgi_notetype_strain_view _mgitype_key int4 10  √  null
mgi_notetype_vocevidence_view _mgitype_key int4 10  √  null
mgi_organism_acc_view _mgitype_key int4 10  √  null
mgi_organism_mgitype _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_organism_mgitype_view _mgitype_key int4 10  √  null
mgi_organism_summary_view _mgitype_key int4 10  √  null
mgi_property _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_propertytype _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_refassoctype _mgitype_key int4 10  √  null foreign key to ACC_MGIType
mgi_reference_allele_view _mgitype_key int4 10  √  null
mgi_reference_allelevariant_view _mgitype_key int4 10  √  null
mgi_reference_antibody_view _mgitype_key int4 10  √  null
mgi_reference_assoc _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_reference_marker_view _mgitype_key int4 10  √  null
mgi_reference_sequence_view _mgitype_key int4 10  √  null
mgi_reference_strain_view _mgitype_key int4 10  √  null
mgi_reftype_allele_view _mgitype_key int4 10  √  null
mgi_reftype_antibody_view _mgitype_key int4 10  √  null
mgi_reftype_marker_view _mgitype_key int4 10  √  null
mgi_reftype_sequence_view _mgitype_key int4 10  √  null
mgi_reftype_strain_view _mgitype_key int4 10  √  null
mgi_set _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_synonym _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_synonym_allele_view _mgitype_key int4 10  √  null
mgi_synonym_goterm_view _mgitype_key int4 10  √  null
mgi_synonym_musmarker_view _mgitype_key int4 10  √  null
mgi_synonym_strain_view _mgitype_key int4 10  √  null
mgi_synonymtype _mgitype_key int4 10  √  null foreign key to ACC_MGIType
mgi_synonymtype_allele_view _mgitype_key int4 10  √  null
mgi_synonymtype_goterm_view _mgitype_key int4 10  √  null
mgi_synonymtype_musmarker_view _mgitype_key int4 10  √  null
mgi_synonymtype_strain_view _mgitype_key int4 10  √  null
mgi_translationstrain_view _mgitype_key int4 10  √  null
mgi_translationtype _mgitype_key int4 10 foreign key to ACC_MGIType
mld_acc_view _mgitype_key int4 10  √  null
mld_summary_view _mgitype_key int4 10  √  null
mrk_acc_view _mgitype_key int4 10  √  null
mrk_accnoref_view _mgitype_key int4 10  √  null
mrk_accref1_view _mgitype_key int4 10  √  null
mrk_accref2_view _mgitype_key int4 10  √  null
mrk_accref_view _mgitype_key int4 10  √  null
mrk_summary_view _mgitype_key int4 10  √  null
prb_acc_view _mgitype_key int4 10  √  null
prb_accnoref_view _mgitype_key int4 10  √  null
prb_accref_view _mgitype_key int4 10  √  null
prb_accrefnoseq_view _mgitype_key int4 10  √  null
prb_source_acc_view _mgitype_key int4 10  √  null
prb_source_summary_view _mgitype_key int4 10  √  null
prb_strain_acc_view _mgitype_key int4 10  √  null
prb_strain_summary_view _mgitype_key int4 10  √  null
prb_tissue_summary_view _mgitype_key int4 10  √  null
seq_allele_assoc_view _mgitype_key int4 10  √  null
seq_sequence_acc_view _mgitype_key int4 10  √  null
seq_summary_view _mgitype_key int4 10  √  null
voc_annot_count_cache _mgitype_key int4 10 foreign key to ACC_MGIType
voc_annot_view _mgitype_key int4 10  √  null
voc_annottype _mgitype_key int4 10 foreign key to ACC_MGIType
voc_term_acc_view _mgitype_key int4 10  √  null
voc_term_summary_view _mgitype_key int4 10  √  null
mgi_relationship_category _mgitype_key_1 int4 10 MGI Type of the First object in the relationship
mgi_relationship_category _mgitype_key_2 int4 10 MGI Type of the Second object in the relationship
all_allele _mode_key int4 10 foreign key to VOC_Term where _Vocab_key = 35 (Allele Inheritance Mode); 'Semidominant', 'Codominant'
all_allele_view _mode_key int4 10  √  null
pwi_all_allele_view _mode_key int4 10  √  null
acc_accession _modifiedby_key int4 10 1001 user who last modified the record
acc_accessionreference _modifiedby_key int4 10 1001 user who last modified the record
acc_actualdb _modifiedby_key int4 10 1001 user who last modified the record
acc_logicaldb _modifiedby_key int4 10 1001 user who last modified the record
acc_logicaldb_view _modifiedby_key int4 10  √  null
acc_mgitype _modifiedby_key int4 10 1001 user who last modified the record
acc_view _modifiedby_key int4 10  √  null
all_acc_view _modifiedby_key int4 10  √  null
all_allele _modifiedby_key int4 10 1001 user who last modified the record
all_allele_cellline _modifiedby_key int4 10 1001 user who last modified the record
all_allele_cellline_view _modifiedby_key int4 10  √  null
all_allele_view _modifiedby_key int4 10  √  null
all_cellline _modifiedby_key int4 10 1001 user who last modified the record
all_cellline_acc_view _modifiedby_key int4 10  √  null
all_cellline_derivation _modifiedby_key int4 10 1001 user who last modified the record
all_cellline_derivation_view _modifiedby_key int4 10  √  null
all_cellline_view _modifiedby_key int4 10  √  null
all_cre_cache _modifiedby_key int4 10 1001 user who last modified the record
all_knockout_cache _modifiedby_key int4 10 1001 user who last modified the record
all_summary_view _modifiedby_key int4 10  √  null
all_variant _modifiedby_key int4 10 1001 user who last modified the record
all_variant_sequence _modifiedby_key int4 10 1001 user who last modified the record
bib_acc_view _modifiedby_key int4 10  √  null
bib_all2_view _modifiedby_key int4 10  √  null
bib_all_view _modifiedby_key int4 10  √  null
bib_refs _modifiedby_key int4 10 1001 user who last modified the record
bib_summary_all_view _modifiedby_key int4 10  √  null
bib_view _modifiedby_key int4 10  √  null
bib_workflow_data _modifiedby_key int4 10 1001 user who last modified the record
bib_workflow_status _modifiedby_key int4 10 1001 user who last modified the record
bib_workflow_tag _modifiedby_key int4 10 1001 user who last modified the record
go_tracking _modifiedby_key int4 10 1001 user who last modified the record
go_tracking_view _modifiedby_key int4 10  √  null
gxd_allelegenotype _modifiedby_key int4 10 1001 user who last modified the record
gxd_allelepair _modifiedby_key int4 10 1001 user who last modified the record
gxd_allelepair_view _modifiedby_key int4 10  √  null
gxd_antibody _modifiedby_key int4 10 1001 user who last modified the record
gxd_antibody_acc_view _modifiedby_key int4 10  √  null
gxd_antibody_view _modifiedby_key int4 10  √  null
gxd_antibodyantigen_view _modifiedby_key int4 10  √  null
gxd_antigen _modifiedby_key int4 10 1001 user who last modified the record
gxd_antigen_acc_view _modifiedby_key int4 10  √  null
gxd_antigen_summary_view _modifiedby_key int4 10  √  null
gxd_antigen_view _modifiedby_key int4 10  √  null
gxd_assay _modifiedby_key int4 10 1001 user who last modified the record
gxd_assay_acc_view _modifiedby_key int4 10  √  null
gxd_assay_view _modifiedby_key int4 10  √  null
gxd_genotype _modifiedby_key int4 10 1001 user who last modified the record
gxd_genotype_acc_view _modifiedby_key int4 10  √  null
gxd_genotype_summary_view _modifiedby_key int4 10  √  null
gxd_genotype_view _modifiedby_key int4 10  √  null
gxd_htexperiment _modifiedby_key int4 10 1001 foreign key to MGI_User; user who last modified the record
gxd_htsample _modifiedby_key int4 10 1001 foreign key to MGI_User; user who last modified the record
gxd_htsample_rnaseq _modifiedby_key int4 10 1001 user who last modified the record
gxd_htsample_rnaseqcombined _modifiedby_key int4 10 1001 user who last modified the record
gxd_htsample_rnaseqset _modifiedby_key int4 10 1001 user who last modified the record
gxd_htsample_rnaseqsetmember _modifiedby_key int4 10 1001 user who last modified the record
gxd_index _modifiedby_key int4 10 1001 user who last modified the record
gxd_index_stages _modifiedby_key int4 10 1001 user who last modified the record
gxd_index_view _modifiedby_key int4 10  √  null
img_image _modifiedby_key int4 10 1001 user who last modified the record
img_image_acc_view _modifiedby_key int4 10  √  null
img_image_summary_view _modifiedby_key int4 10  √  null
img_image_view _modifiedby_key int4 10  √  null
img_imagepane_assoc _modifiedby_key int4 10 1001 user who last modified the record
img_imagepane_assoc_view _modifiedby_key int4 10  √  null
map_coord_collection _modifiedby_key int4 10 1001 user who last modified the record
map_coord_feature _modifiedby_key int4 10 1001 user who last modified the record
map_coordinate _modifiedby_key int4 10 1001 user who last modified the record
mgi_note _modifiedby_key int4 10 1001 user who last modified the record
mgi_note_allele_view _modifiedby_key int4 10  √  null
mgi_note_allelevariant_view _modifiedby_key int4 10  √  null
mgi_note_derivation_view _modifiedby_key int4 10  √  null
mgi_note_genotype_view _modifiedby_key int4 10  √  null
mgi_note_image_view _modifiedby_key int4 10  √  null
mgi_note_marker_view _modifiedby_key int4 10  √  null
mgi_note_mrkgo_view _modifiedby_key int4 10  √  null
mgi_note_probe_view _modifiedby_key int4 10  √  null
mgi_note_sequence_view _modifiedby_key int4 10  √  null
mgi_note_source_view _modifiedby_key int4 10  √  null
mgi_note_strain_view _modifiedby_key int4 10  √  null
mgi_note_vocevidence_view _modifiedby_key int4 10  √  null
mgi_notechunk _modifiedby_key int4 10 1001 user who last modified the record
mgi_notetype _modifiedby_key int4 10 1001 user who last modified the record
mgi_notetype_alldriver_view _modifiedby_key int4 10  √  null
mgi_notetype_allele_view _modifiedby_key int4 10  √  null
mgi_notetype_derivation_view _modifiedby_key int4 10  √  null
mgi_notetype_genotype_view _modifiedby_key int4 10  √  null
mgi_notetype_image_view _modifiedby_key int4 10  √  null
mgi_notetype_marker_view _modifiedby_key int4 10  √  null
mgi_notetype_mrkgo_view _modifiedby_key int4 10  √  null
mgi_notetype_probe_view _modifiedby_key int4 10  √  null
mgi_notetype_sequence_view _modifiedby_key int4 10  √  null
mgi_notetype_source_view _modifiedby_key int4 10  √  null
mgi_notetype_strain_view _modifiedby_key int4 10  √  null
mgi_notetype_vocevidence_view _modifiedby_key int4 10  √  null
mgi_organism _modifiedby_key int4 10 1001 user who last modified the record
mgi_organism_acc_view _modifiedby_key int4 10  √  null
mgi_organism_allele_view _modifiedby_key int4 10  √  null
mgi_organism_antigen_view _modifiedby_key int4 10  √  null
mgi_organism_marker_view _modifiedby_key int4 10  √  null
mgi_organism_mgitype _modifiedby_key int4 10 1001 user who last modified the record
mgi_organism_mgitype_view _modifiedby_key int4 10  √  null
mgi_organism_probe_view _modifiedby_key int4 10  √  null
mgi_organism_view _modifiedby_key int4 10  √  null
mgi_property _modifiedby_key int4 10 1001 user who last modified the record
mgi_propertytype _modifiedby_key int4 10 1001 user who last modified the record
mgi_refassoctype _modifiedby_key int4 10 1001 user who last modified the record
mgi_reference_allele_view _modifiedby_key int4 10  √  null
mgi_reference_allelevariant_view _modifiedby_key int4 10  √  null
mgi_reference_antibody_view _modifiedby_key int4 10  √  null
mgi_reference_assoc _modifiedby_key int4 10 1001 user who last modified the record
mgi_reference_marker_view _modifiedby_key int4 10  √  null
mgi_reference_sequence_view _modifiedby_key int4 10  √  null
mgi_reference_strain_view _modifiedby_key int4 10  √  null
mgi_reftype_allele_view _modifiedby_key int4 10  √  null
mgi_reftype_antibody_view _modifiedby_key int4 10  √  null
mgi_reftype_marker_view _modifiedby_key int4 10  √  null
mgi_reftype_sequence_view _modifiedby_key int4 10  √  null
mgi_reftype_strain_view _modifiedby_key int4 10  √  null
mgi_relationship _modifiedby_key int4 10 1001 user who last modified the record
mgi_relationship_category _modifiedby_key int4 10 1001 user who last modified the record
mgi_relationship_markertss_view _modifiedby_key int4 10  √  null
mgi_relationship_property _modifiedby_key int4 10 1001 user who last modified the record
mgi_roletask _modifiedby_key int4 10 1001 user who last modified the record
mgi_roletask_view _modifiedby_key int4 10  √  null
mgi_set _modifiedby_key int4 10 1001 user who last modified the record
mgi_setmember _modifiedby_key int4 10 1001 user who last modified the record
mgi_setmember_emapa _modifiedby_key int4 10 1001 user who last modified the record
mgi_synonym _modifiedby_key int4 10 1001 user who last modified the record
mgi_synonym_allele_view _modifiedby_key int4 10  √  null
mgi_synonym_goterm_view _modifiedby_key int4 10  √  null
mgi_synonym_musmarker_view _modifiedby_key int4 10  √  null
mgi_synonym_strain_view _modifiedby_key int4 10  √  null
mgi_synonymtype _modifiedby_key int4 10 1001 user who last modified the record
mgi_synonymtype_allele_view _modifiedby_key int4 10  √  null
mgi_synonymtype_goterm_view _modifiedby_key int4 10  √  null
mgi_synonymtype_musmarker_view _modifiedby_key int4 10  √  null
mgi_synonymtype_strain_view _modifiedby_key int4 10  √  null
mgi_translation _modifiedby_key int4 10 1001 user who last modified the record
mgi_translation_view _modifiedby_key int4 10  √  null
mgi_translationstrain_view _modifiedby_key int4 10  √  null
mgi_translationtype _modifiedby_key int4 10 1001 user who last modified the record
mgi_user _modifiedby_key int4 10 1001 user who last modified the record
mgi_user_active_view _modifiedby_key int4 10  √  null
mgi_userrole _modifiedby_key int4 10 1001 user who last modified the record
mgi_userrole_view _modifiedby_key int4 10  √  null
mgi_usertask_view _modifiedby_key int4 10  √  null
mld_acc_view _modifiedby_key int4 10  √  null
mld_summary_view _modifiedby_key int4 10  √  null
mrk_acc_view _modifiedby_key int4 10  √  null
mrk_accnoref_view _modifiedby_key int4 10  √  null
mrk_accref1_view _modifiedby_key int4 10  √  null
mrk_accref2_view _modifiedby_key int4 10  √  null
mrk_accref_view _modifiedby_key int4 10  √  null
mrk_biotypemapping _modifiedby_key int4 10 1001 user who last modified the record
mrk_chromosome _modifiedby_key int4 10 1001 user who last modified the record
mrk_cluster _modifiedby_key int4 10 1001 user who last modified the record
mrk_history _modifiedby_key int4 10 1001 user who last modified the record
mrk_history_view _modifiedby_key int4 10  √  null
mrk_location_cache _modifiedby_key int4 10 1001 user who last modified the record
mrk_marker _modifiedby_key int4 10 1001 user who last modified the record
mrk_marker_view _modifiedby_key int4 10  √  null
mrk_mcv_cache _modifiedby_key int4 10 1001 user who last modified the record
mrk_mcv_count_cache _modifiedby_key int4 10 1001 user who last modified the record
mrk_mouse_view _modifiedby_key int4 10  √  null
mrk_nonmouse_view _modifiedby_key int4 10  √  null
mrk_strainmarker _modifiedby_key int4 10 1001 user who last modified the record
mrk_summary_view _modifiedby_key int4 10  √  null
prb_acc_view _modifiedby_key int4 10  √  null
prb_accnoref_view _modifiedby_key int4 10  √  null
prb_accref_view _modifiedby_key int4 10  √  null
prb_accrefnoseq_view _modifiedby_key int4 10  √  null
prb_alias _modifiedby_key int4 10 1001 user who last modified the record
prb_allele _modifiedby_key int4 10 1001 user who last modified the record
prb_allele_strain _modifiedby_key int4 10 1001 user who last modified the record
prb_marker _modifiedby_key int4 10 1001 user who last modified the record
prb_probe _modifiedby_key int4 10 1001 user who last modified the record
prb_probe_view _modifiedby_key int4 10  √  null
prb_reference _modifiedby_key int4 10 1001 user who last modified the record
prb_reference_view _modifiedby_key int4 10  √  null
prb_rflv _modifiedby_key int4 10 1001 user who last modified the record
prb_rflv_view _modifiedby_key int4 10  √  null
prb_source _modifiedby_key int4 10 1001 user who last modified the record
prb_source_acc_view _modifiedby_key int4 10  √  null
prb_source_view _modifiedby_key int4 10  √  null
prb_strain _modifiedby_key int4 10 1001 user who last modified the record
prb_strain_acc_view _modifiedby_key int4 10  √  null
prb_strain_genotype _modifiedby_key int4 10 1001 user who last modified the record
prb_strain_genotype_view _modifiedby_key int4 10  √  null
prb_strain_marker _modifiedby_key int4 10 1001 user who last modified the record
prb_strain_marker_view _modifiedby_key int4 10  √  null
prb_strain_view _modifiedby_key int4 10  √  null
pwi_all_allele_view _modifiedby_key int4 10  √  null
pwi_bib_refs_view _modifiedby_key int4 10  √  null
pwi_mrk_marker_view _modifiedby_key int4 10  √  null
seq_allele_assoc _modifiedby_key int4 10 1001 user who last modified the record
seq_allele_assoc_view _modifiedby_key int4 10  √  null
seq_coord_cache _modifiedby_key int4 10 1001 user who last modified the record
seq_genemodel _modifiedby_key int4 10 1001 user who last modified the record
seq_genetrap _modifiedby_key int4 10 1001 user who last modified the record
seq_marker_cache _modifiedby_key int4 10 1001 user who last modified the record
seq_probe_cache _modifiedby_key int4 10 1001 user who last modified the record
seq_sequence _modifiedby_key int4 10 1001 user who last modified the record
seq_sequence_acc_view _modifiedby_key int4 10  √  null
seq_sequence_assoc _modifiedby_key int4 10 1001 user who last modified the record
seq_sequence_raw _modifiedby_key int4 10 1001 user who last modified the record
seq_sequence_view _modifiedby_key int4 10  √  null
seq_source_assoc _modifiedby_key int4 10 1001 user who last modified the record
seq_summary_view _modifiedby_key int4 10  √  null
voc_annotheader _modifiedby_key int4 10 1001 user who last modified the record
voc_annotheader_view _modifiedby_key int4 10  √  null
voc_evidence _modifiedby_key int4 10 1001 user who last modified the record
voc_evidence_property _modifiedby_key int4 10 1001 user who last modified the record
voc_evidence_view _modifiedby_key int4 10  √  null
voc_evidenceproperty_view _modifiedby_key int4 10  √  null
voc_term _modifiedby_key int4 10 1001 user who last modified the record
voc_term_acc_view _modifiedby_key int4 10  √  null
voc_term_cellline_view _modifiedby_key int4 10  √  null
voc_term_emapa _modifiedby_key int4 10 1001 user who last modified the record
voc_term_emaps _modifiedby_key int4 10 1001 user who last modified the record
voc_term_mcv_view _modifiedby_key int4 10  √  null
voc_term_repqualifier_view _modifiedby_key int4 10  √  null
voc_term_strainallele_view _modifiedby_key int4 10  √  null
voc_term_strainspecies_view _modifiedby_key int4 10  √  null
voc_term_view _modifiedby_key int4 10  √  null
all_allele_cellline _mutantcellline_key int4 10 foreign key to ALL_CellLine
all_allele_cellline_view _mutantcellline_key int4 10  √  null
gxd_allelepair _mutantcellline_key_1 int4 10  √  null foreign key to ALL_CellLine
gxd_allelepair_view _mutantcellline_key_1 int4 10  √  null
gxd_allelepair _mutantcellline_key_2 int4 10  √  null foreign key to ALL_CellLine
gxd_allelepair_view _mutantcellline_key_2 int4 10  √  null
all_allele_mutation _mutation_key int4 10 foreign key to ALL_Molecular_Mutation
all_allele_mutation_view _mutation_key int4 10  √  null
dag_node _node_key int4 10 primary key
dag_node_view _node_key int4 10  √  null
mgi_note _note_key int4 10 primary key
mgi_note_allele_view _note_key int4 10  √  null
mgi_note_allelevariant_view _note_key int4 10  √  null
mgi_note_derivation_view _note_key int4 10  √  null
mgi_note_genotype_view _note_key int4 10  √  null
mgi_note_image_view _note_key int4 10  √  null
mgi_note_marker_view _note_key int4 10  √  null
mgi_note_mrkgo_view _note_key int4 10  √  null
mgi_note_probe_view _note_key int4 10  √  null
mgi_note_sequence_view _note_key int4 10  √  null
mgi_note_source_view _note_key int4 10  √  null
mgi_note_strain_view _note_key int4 10  √  null
mgi_note_vocevidence_view _note_key int4 10  √  null
mgi_notechunk _note_key int4 10 foreign key to MGI_Note
mgi_note _notetype_key int4 10 foreign key to MGI_NoteType
mgi_note_allele_view _notetype_key int4 10  √  null
mgi_note_allelevariant_view _notetype_key int4 10  √  null
mgi_note_derivation_view _notetype_key int4 10  √  null
mgi_note_genotype_view _notetype_key int4 10  √  null
mgi_note_image_view _notetype_key int4 10  √  null
mgi_note_marker_view _notetype_key int4 10  √  null
mgi_note_mrkgo_view _notetype_key int4 10  √  null
mgi_note_probe_view _notetype_key int4 10  √  null
mgi_note_sequence_view _notetype_key int4 10  √  null
mgi_note_source_view _notetype_key int4 10  √  null
mgi_note_strain_view _notetype_key int4 10  √  null
mgi_note_vocevidence_view _notetype_key int4 10  √  null
mgi_notetype _notetype_key int4 10 primary key
mgi_notetype_alldriver_view _notetype_key int4 10  √  null
mgi_notetype_allele_view _notetype_key int4 10  √  null
mgi_notetype_derivation_view _notetype_key int4 10  √  null
mgi_notetype_genotype_view _notetype_key int4 10  √  null
mgi_notetype_image_view _notetype_key int4 10  √  null
mgi_notetype_marker_view _notetype_key int4 10  √  null
mgi_notetype_mrkgo_view _notetype_key int4 10  √  null
mgi_notetype_probe_view _notetype_key int4 10  √  null
mgi_notetype_sequence_view _notetype_key int4 10  √  null
mgi_notetype_source_view _notetype_key int4 10  √  null
mgi_notetype_strain_view _notetype_key int4 10  √  null
mgi_notetype_vocevidence_view _notetype_key int4 10  √  null
acc_accession _object_key int4 10 foreign key to any object defined in ACC_MGIType
acc_view _object_key int4 10  √  null
all_acc_view _object_key int4 10  √  null
all_allele_subtype_view _object_key int4 10  √  null
all_cellline_acc_view _object_key int4 10  √  null
all_derivation_summary_view _object_key int4 10  √  null
all_summary_view _object_key int4 10  √  null
bib_acc_view _object_key int4 10  √  null
bib_summary_all_view _object_key int4 10  √  null
dag_node _object_key int4 10 foreign key to any object defined in ACC_MGIType
dag_node_view _object_key int4 10  √  null
gxd_antibody_acc_view _object_key int4 10  √  null
gxd_antigen_acc_view _object_key int4 10  √  null
gxd_antigen_summary_view _object_key int4 10  √  null
gxd_assay_acc_view _object_key int4 10  √  null
gxd_genotype_acc_view _object_key int4 10  √  null
gxd_genotype_summary_view _object_key int4 10  √  null
img_image_acc_view _object_key int4 10  √  null
img_image_summary_view _object_key int4 10  √  null
img_imagepane_assoc _object_key int4 10 foreign key to any object defined in ACC_MGIType
img_imagepane_assoc_view _object_key int4 10  √  null
map_coord_feature _object_key int4 10 foreign key to any object defined in ACC_MGIType
map_coordinate _object_key int4 10  √  null foreign key to any object defined in ACC_MGIType
mgi_note _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_note_allele_view _object_key int4 10  √  null
mgi_note_allelevariant_view _object_key int4 10  √  null
mgi_note_derivation_view _object_key int4 10  √  null
mgi_note_genotype_view _object_key int4 10  √  null
mgi_note_image_view _object_key int4 10  √  null
mgi_note_marker_view _object_key int4 10  √  null
mgi_note_mrkgo_view _object_key int4 10  √  null
mgi_note_probe_view _object_key int4 10  √  null
mgi_note_sequence_view _object_key int4 10  √  null
mgi_note_source_view _object_key int4 10  √  null
mgi_note_strain_view _object_key int4 10  √  null
mgi_note_vocevidence_view _object_key int4 10  √  null
mgi_organism_acc_view _object_key int4 10  √  null
mgi_organism_summary_view _object_key int4 10  √  null
mgi_property _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_reference_allele_view _object_key int4 10  √  null
mgi_reference_allelevariant_view _object_key int4 10  √  null
mgi_reference_antibody_view _object_key int4 10  √  null
mgi_reference_assoc _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_reference_marker_view _object_key int4 10  √  null
mgi_reference_sequence_view _object_key int4 10  √  null
mgi_reference_strain_view _object_key int4 10  √  null
mgi_setmember _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_synonym _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_synonym_allele_view _object_key int4 10  √  null
mgi_synonym_goterm_view _object_key int4 10  √  null
mgi_synonym_musmarker_view _object_key int4 10  √  null
mgi_synonym_strain_view _object_key int4 10  √  null
mgi_translation _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_translation_view _object_key int4 10  √  null
mgi_translationstrain_view _object_key int4 10  √  null
mld_acc_view _object_key int4 10  √  null
mld_summary_view _object_key int4 10  √  null
mrk_acc_view _object_key int4 10  √  null
mrk_accnoref_view _object_key int4 10  √  null
mrk_accref1_view _object_key int4 10  √  null
mrk_accref2_view _object_key int4 10  √  null
mrk_accref_view _object_key int4 10  √  null
mrk_summary_view _object_key int4 10  √  null
prb_acc_view _object_key int4 10  √  null
prb_accnoref_view _object_key int4 10  √  null
prb_accref_view _object_key int4 10  √  null
prb_accrefnoseq_view _object_key int4 10  √  null
prb_source_acc_view _object_key int4 10  √  null
prb_source_summary_view _object_key int4 10  √  null
prb_strain_acc_view _object_key int4 10  √  null
prb_strain_needsreview_view _object_key int4 10  √  null
prb_strain_summary_view _object_key int4 10  √  null
prb_tissue_summary_view _object_key int4 10  √  null
seq_allele_assoc_view _object_key int4 10  √  null
seq_sequence_acc_view _object_key int4 10  √  null
seq_summary_view _object_key int4 10  √  null
voc_annot _object_key int4 10 foreign key to any object defined in ACC_MGIType
voc_annot_view _object_key int4 10  √  null
voc_annotheader _object_key int4 10 foreign key to any object defined in ACC_MGIType
voc_annotheader_view _object_key int4 10  √  null
voc_term_acc_view _object_key int4 10  √  null
voc_term_summary_view _object_key int4 10  √  null
mgi_relationship _object_key_1 int4 10 First object in the relationship
mgi_relationship_markertss_view _object_key_1 int4 10  √  null
mgi_relationship _object_key_2 int4 10 Second object in the relationship
mgi_relationship_markertss_view _object_key_2 int4 10  √  null
acc_logicaldb _organism_key int4 10  √  null organism (foreign key to MGI_Organism)
acc_logicaldb_view _organism_key int4 10  √  null
acc_view _organism_key int4 10  √  null
all_allele_driver_view _organism_key int4 10  √  null
gxd_antibody _organism_key int4 10 organism (foreign key to MGI_Organism)
gxd_antibody_view _organism_key int4 10  √  null
gxd_antibodyantigen_view _organism_key int4 10  √  null
gxd_antigen_view _organism_key int4 10  √  null
gxd_htsample _organism_key int4 10 foreign key to MGI_Organism, identifying type of organism for the sample
gxd_htsample_rnaseqset _organism_key int4 10 foreign key to MGI_Organism
mgi_organism _organism_key int4 10 organism (foreign key to MGI_Organism)
mgi_organism_allele_view _organism_key int4 10  √  null
mgi_organism_antigen_view _organism_key int4 10  √  null
mgi_organism_marker_view _organism_key int4 10  √  null
mgi_organism_mgitype _organism_key int4 10 organism (foreign key to MGI_Organism)
mgi_organism_mgitype_view _organism_key int4 10  √  null
mgi_organism_probe_view _organism_key int4 10  √  null
mgi_organism_view _organism_key int4 10  √  null
mgi_synonym_allele_view _organism_key int4 10  √  null
mgi_synonym_goterm_view _organism_key int4 10  √  null
mgi_synonym_musmarker_view _organism_key int4 10  √  null
mgi_synonym_strain_view _organism_key int4 10  √  null
mgi_synonymtype _organism_key int4 10  √  null foreign key to MGI_Organism
mgi_synonymtype_allele_view _organism_key int4 10  √  null
mgi_synonymtype_goterm_view _organism_key int4 10  √  null
mgi_synonymtype_musmarker_view _organism_key int4 10  √  null
mgi_synonymtype_strain_view _organism_key int4 10  √  null
mrk_acc_view _organism_key int4 10  √  null
mrk_chromosome _organism_key int4 10 organism (foreign key to MGI_Organism)
mrk_do_cache _organism_key int4 10 foreign key to MGI_Organism
mrk_label _organism_key int4 10 organism (foreign key to MGI_Organism)
mrk_location_cache _organism_key int4 10 foreign key to MGI_Organism
mrk_marker _organism_key int4 10 foreign key to MGI_Organism
mrk_marker_view _organism_key int4 10  √  null
mrk_mouse_view _organism_key int4 10  √  null
mrk_nonmouse_view _organism_key int4 10  √  null
prb_rflv_view _organism_key int4 10  √  null
prb_source _organism_key int4 10 organism (foreign key to MGI_Organism)
prb_source_view _organism_key int4 10  √  null
pwi_mrk_marker_view _organism_key int4 10  √  null
seq_marker_cache _organism_key int4 10 foreign key to MGI_Organism
seq_sequence _organism_key int4 10 foreign key to MGI_Organism
seq_sequence_view _organism_key int4 10  √  null
mrk_label _orthologorganism_key int4 10  √  null organism of ortholog (foreign key to MGI_Organism)
gxd_allelepair _pairstate_key int4 10 foreign key to VOC_Term where _Vocab_key = 39 (Allele Pair State)
gxd_allelepair_view _pairstate_key int4 10  √  null
dag_edge _parent_key int4 10 foreign key to DAG_Node._Node_key
all_cellline_derivation _parentcellline_key int4 10 foreign key to ALL_CellLine
all_cellline_derivation_view _parentcellline_key int4 10  √  null
gxd_insituresult _pattern_key int4 10 foreign key to GXD_Pattern
gxd_insituresult_view _pattern_key int4 10  √  null
gxd_pattern _pattern_key int4 10 primary key
mrk_biotypemapping _primarymcvterm_key int4 10 fk to voc_term where _vocab_key = 79 (Primary MCV/FeatureType term)
gxd_index _priority_key int4 10 foreign key to VOC_Term where _Vocab_key = 11 (GXD Index Priority); 'High', 'Medium', 'Low'
gxd_index_view _priority_key int4 10  √  null
gxd_probeprep _probe_key int4 10 foreign key to PRB_Probe
gxd_probeprep_view _probe_key int4 10  √  null
mld_contigprobe _probe_key int4 10 foreign key to PRB_Probe
mld_hit _probe_key int4 10 foreign key to PRB_Probe
prb_marker _probe_key int4 10 foreign key to PRB_Probe
prb_marker_view _probe_key int4 10  √  null
prb_notes _probe_key int4 10 foreign key to PRB_Probe
prb_parent_view _probe_key int4 10  √  null
prb_probe _probe_key int4 10 foreign key to PRB_Probe
prb_probe_view _probe_key int4 10  √  null
prb_reference _probe_key int4 10 foreign key to PRB_Probe
prb_reference_view _probe_key int4 10  √  null
seq_probe_cache _probe_key int4 10 foreign key to PRB_Probe
seq_probe_cache_view _probe_key int4 10  √  null
gxd_assay _probeprep_key int4 10  √  null foreign key to GXD_ProbePrep
gxd_assay_view _probeprep_key int4 10  √  null
gxd_probeprep _probeprep_key serial 10  √  nextval('gxd_probeprep_seq'::regclass) primary key
gxd_probeprep_view _probeprep_key int4 10  √  null
mgi_property _property_key int4 10 primary key
mgi_relationship_property _propertyname_key int4 10 The name of the property
mgi_property _propertyterm_key int4 10 foreign key to VOC_Term
voc_evidence_property _propertyterm_key int4 10 foreign key to VOC_Term; examples include: _Vocab_key = 82 (GO Property); 'evidence', 'anatomy', 'cell tyupe', 'text', etc.
voc_evidenceproperty_view _propertyterm_key int4 10  √  null
mgi_property _propertytype_key int4 10 foreign key to MGI_PropertyType
mgi_propertytype _propertytype_key int4 10 primary key
all_allele_subtype_view _qualifier_key int4 10  √  null
all_annot_view _qualifier_key int4 10  √  null
mgi_relationship _qualifier_key int4 10 The term for the relationship qualifier
mgi_relationship_markertss_view _qualifier_key int4 10  √  null
prb_strain_genotype _qualifier_key int4 10 foreign key to VOC_Term where _Vocab_key = 32 (Strain/Genotype Qualifier)
prb_strain_genotype_view _qualifier_key int4 10  √  null
prb_strain_marker _qualifier_key int4 10 foreign key to VOC_Term where _Vocab_key = 31 (Strain Allele Qualifier); 'nomenclature'
prb_strain_marker_view _qualifier_key int4 10  √  null
prb_strain_needsreview_view _qualifier_key int4 10  √  null
seq_allele_assoc _qualifier_key int4 10 foreign key to VOC_Term where _Vocab_key = 69 (Sequence Allele Association Qualifier)
seq_allele_assoc_view _qualifier_key int4 10  √  null
seq_marker_cache _qualifier_key int4 10 foreign key to VOC_Term where _Vocab_key =289 (Representative Sequence Qualifier); qualifies the association between the Marker and the Sequence
seq_sequence_assoc _qualifier_key int4 10 foreign key to VOC_Term where _Vocab_key = 78 (Sequence-Sequence Association Qualifier); 'transcribed from', 'translated from', 'processed from'
voc_annot _qualifier_key int4 10 foreign key to VOC_Term; based on the VOC_AnnotType._AnnotType_key
voc_annot_view _qualifier_key int4 10  √  null
mgi_relationship_category _qualifiervocab_key int4 10 The vocabulary that relationships draw their qualifier terms from
voc_annottype _qualifiervocab_key int4 10 foreign key to VOC_Term; examples include 52:GO Qualifier, 54:MP Qualifier
mgi_refassoctype _refassoctype_key int4 10 primary key
mgi_reference_allele_view _refassoctype_key int4 10  √  null
mgi_reference_allelevariant_view _refassoctype_key int4 10  √  null
mgi_reference_antibody_view _refassoctype_key int4 10  √  null
mgi_reference_assoc _refassoctype_key int4 10 foreign key to MGI_RefAssocType
mgi_reference_marker_view _refassoctype_key int4 10  √  null
mgi_reference_sequence_view _refassoctype_key int4 10  √  null
mgi_reference_strain_view _refassoctype_key int4 10  √  null
mgi_reftype_allele_view _refassoctype_key int4 10  √  null
mgi_reftype_antibody_view _refassoctype_key int4 10  √  null
mgi_reftype_marker_view _refassoctype_key int4 10  √  null
mgi_reftype_sequence_view _refassoctype_key int4 10  √  null
mgi_reftype_strain_view _refassoctype_key int4 10  √  null
prb_accref_view _reference_key int4 10  √  null
prb_accrefnoseq_view _reference_key int4 10  √  null
prb_alias _reference_key int4 10 foreign key to PRB_Reference
prb_ref_notes _reference_key int4 10 foreign key to PRB_Reference
prb_reference _reference_key int4 10 primary key
prb_reference_view _reference_key int4 10  √  null
prb_rflv _reference_key int4 10 foreign key to PRB_Reference
prb_rflv_view _reference_key int4 10  √  null
bib_all2_view _referencetype_key int4 10  √  null
bib_all_view _referencetype_key int4 10  √  null
bib_refs _referencetype_key int4 10 foreign key to VOC_Term where _Vocab_key = 131 (Reference Type)
bib_view _referencetype_key int4 10  √  null
pwi_bib_refs_view _referencetype_key int4 10  √  null
acc_accessionreference _refs_key int4 10 foreign key to BIB_Refs
all_allele _refs_key int4 10  √  null
all_allele_view _refs_key int4 10  √  null
all_cellline_derivation _refs_key int4 10  √  null foreign key to BIB_Refs
all_cellline_derivation_view _refs_key int4 10  √  null
bib_all2_view _refs_key int4 10  √  null
bib_all_view _refs_key int4 10  √  null
bib_associateddata_view _refs_key int4 10  √  null
bib_books _refs_key int4 10 foreign key to BIB_Refs
bib_citation_cache _refs_key int4 10 foreign key to BIB_Refs
bib_goxref_view _refs_key int4 10  √  null
bib_notes _refs_key int4 10 foreign key to BIB_Refs
bib_refs _refs_key serial 10  √  nextval('bib_refs_seq'::regclass) primary key
bib_status_view _refs_key int4 10  √  null
bib_view _refs_key int4 10  √  null
bib_workflow_data _refs_key int4 10 foreign key to BIB_Refs
bib_workflow_status _refs_key int4 10 foreign key to BIB_Refs
bib_workflow_tag _refs_key int4 10 foreign key to BIB_Refs
crs_references _refs_key int4 10 foreign key to BIB_Refs
dag_dag _refs_key int4 10 foreign key to BIB_Refs
gxd_antibodyalias _refs_key int4 10  √  null foreign key to BIB_Refs
gxd_antibodyalias_view _refs_key int4 10  √  null
gxd_antibodyaliasref_view _refs_key int4 10  √  null
gxd_antibodyantigen_view _refs_key int4 10  √  null
gxd_antigen_view _refs_key int4 10  √  null
gxd_assay _refs_key int4 10 foreign key to BIB_Refs
gxd_assay_view _refs_key int4 10  √  null
gxd_expression _refs_key int4 10 foreign key to BIB_Refs
gxd_genotype_dataset_view _refs_key int4 10  √  null
gxd_index _refs_key int4 10 foreign key to BIB_Refs
gxd_index_view _refs_key int4 10  √  null
img_image _refs_key int4 10 foreign key to BIB_Refs
img_image_view _refs_key int4 10  √  null
img_imagepanegxd_view _refs_key int4 10  √  null
mgi_reference_allele_view _refs_key int4 10  √  null
mgi_reference_allelevariant_view _refs_key int4 10  √  null
mgi_reference_antibody_view _refs_key int4 10  √  null
mgi_reference_assoc _refs_key int4 10 foreign key to BIB_Refs
mgi_reference_marker_view _refs_key int4 10  √  null
mgi_reference_sequence_view _refs_key int4 10  √  null
mgi_reference_strain_view _refs_key int4 10  √  null
mgi_relationship _refs_key int4 10 The relationship reference
mgi_relationship_markertss_view _refs_key int4 10  √  null
mgi_synonym _refs_key int4 10  √  null foreign key to BIB_Refs
mgi_synonym_allele_view _refs_key int4 10  √  null
mgi_synonym_goterm_view _refs_key int4 10  √  null
mgi_synonym_musmarker_view _refs_key int4 10  √  null
mgi_synonym_strain_view _refs_key int4 10  √  null
mld_expt_view _refs_key int4 10  √  null
mld_expts _refs_key int4 10 foreign key to BIB_Refs
mld_notes _refs_key int4 10 foreign key to BIB_Refs
mrk_accref1_view _refs_key int4 10  √  null
mrk_accref2_view _refs_key int4 10  √  null
mrk_accref_view _refs_key int4 10  √  null
mrk_do_cache _refs_key int4 10 foreign key to BIB_Refs; reference for DO annotation
mrk_history _refs_key int4 10  √  null foreign key to BIB_Refs
mrk_history_view _refs_key int4 10  √  null
mrk_reference _refs_key int4 10 foreign key to BIB_Refs
mrk_reference_view _refs_key int4 10  √  null
mrk_strainmarker _refs_key int4 10 foreign key to BIB_Refs
prb_marker _refs_key int4 10 foreign key to BIB_Refs
prb_marker_view _refs_key int4 10  √  null
prb_reference _refs_key int4 10 foreign key to BIB_Refs
prb_reference_view _refs_key int4 10  √  null
prb_source _refs_key int4 10  √  null foreign key to BIB_Refs
prb_source_view _refs_key int4 10  √  null
pwi_all_allele_view _refs_key int4 10  √  null
pwi_bib_refs_view _refs_key int4 10  √  null
ri_summary_expt_ref _refs_key int4 10 foreign key to BIB_Refs
seq_allele_assoc _refs_key int4 10 foreign key to BIB_Refs
seq_allele_assoc_view _refs_key int4 10  √  null
seq_allele_view _refs_key int4 10  √  null
seq_marker_cache _refs_key int4 10 foreign key to BIB_Refs
seq_marker_cache_view _refs_key int4 10  √  null
seq_probe_cache _refs_key int4 10 foreign key to BIB_Refs
seq_probe_cache_view _refs_key int4 10  √  null
voc_evidence _refs_key int4 10 foreign key to BIB_Refs
voc_evidence_view _refs_key int4 10  √  null
voc_vocab _refs_key int4 10 foreign key to BIB_Refs
voc_vocab_view _refs_key int4 10  √  null
all_allele_driver_view _relationship_key int4 10  √  null
mgi_relationship _relationship_key serial 10  √  nextval('mgi_relationship_seq'::regclass) Primary key
mgi_relationship_markertss_view _relationship_key int4 10  √  null
mgi_relationship_property _relationship_key int4 10 The relationship this property applies to
mgi_relationship_category _relationshipdag_key int4 10  √  null The DAG which optionally identifies an individual DAG which structures a subset of terms from the vocabulary for use by this category
mgi_relationship_property _relationshipproperty_key int4 10 Primary key
mgi_relationship _relationshipterm_key int4 10 The term identifying the relationship between the two objects
mgi_relationship_markertss_view _relationshipterm_key int4 10  √  null
mgi_relationship_category _relationshipvocab_key int4 10 The vocabulary that relationships draw their relationship terms from
gxd_htsample _relevance_key int4 10 foreign key to VOC_Term, identifies if this sample is relevant for GXD or, if not, why not
gxd_assay _reportergene_key int4 10  √  null foreign key to VOC_Term where _Vocab_key = 14 (GXD Reporter Gene); 'hemagglutinin', 'lacZ', 'GFP', 'Cre', 'FLP', etc.
gxd_assay_view _reportergene_key int4 10  √  null
gxd_insituresult _result_key serial 10  √  nextval('gxd_insituresult_seq'::regclass) primary key
gxd_insituresult_view _result_key int4 10  √  null
gxd_insituresultimage _result_key int4 10 foreign key to GXD_InSituResult
gxd_isresultimage_view _result_key int4 10  √  null
gxd_isresultstructure _result_key int4 10 foreign key to GXD_InSituResult
gxd_isresultstructure_view _result_key int4 10  √  null
gxd_insituresultimage _resultimage_key serial 10  √  nextval('gxd_insituresultimage_seq'::regclass)
gxd_isresultimage_view _resultimage_key int4 10  √  null
gxd_isresultstructure _resultstructure_key serial 10  √  nextval('gxd_isresultstructure_seq'::regclass)
gxd_isresultstructure_view _resultstructure_key int4 10  √  null
seq_genetrap _reversecomp_key int4 10 foreign key to VOC_Term (_Vocab_key = 68). Answers the question is this sequence reverse complemented?
prb_allele _rflv_key int4 10 foreign key to PRB_RFLV
prb_rflv _rflv_key int4 10 primary key
prb_rflv_view _rflv_key int4 10  √  null
mld_ri _riset_key int4 10 foreign key to RI_RISet
mld_ri_view _riset_key int4 10  √  null
ri_riset _riset_key int4 10 primary key
ri_riset_view _riset_key int4 10  √  null
ri_summary _riset_key int4 10 foreign key to RI_RISet
ri_summary _risummary_key int4 10 primary key
ri_summary_expt_ref _risummary_key int4 10 foreign key to RI_Summary
gxd_htsample_rnaseq _rnaseq_key serial 10  √  nextval('gxd_htsample_rnaseq_seq'::regclass) primary key
gxd_htsample_rnaseq _rnaseqcombined_key int4 10 foreign key to GXD_HTSample_RNASeqCombined
gxd_htsample_rnaseqcombined _rnaseqcombined_key serial 10  √  nextval('gxd_htsample_rnaseqcombined_seq'::regclass) primary key
gxd_htsample_rnaseqset _rnaseqset_key serial 10  √  nextval('gxd_htsample_rnaseqset_seq'::regclass) primary key
gxd_htsample_rnaseqsetmember _rnaseqset_key int4 10 foreign key to GXD_HTSample_RNASeq, identifing the set
gxd_htsample_rnaseqsetmember _rnaseqsetmember_key serial 10  √  nextval('gxd_htsample_rnaseqsetmember_seq'::regclass) primary key
mgi_roletask _role_key int4 10 foreign key to VOC_Term where _Vocab_key = 33 (User Role)
mgi_roletask_view _role_key int4 10  √  null
mgi_userrole _role_key int4 10 foreign key to VOC_Term where _Vocab_key = 33 (User Role)
mgi_userrole_view _role_key int4 10  √  null
mgi_usertask_view _role_key int4 10  √  null
mgi_roletask _roletask_key int4 10 primary key
mgi_roletask_view _roletask_key int4 10  √  null
wks_rosetta _rosetta_key int4 10 primary key
gxd_htsample _sample_key int4 10 primary key
gxd_htsample_rnaseq _sample_key int4 10 foreign key to GXD_HTSample
gxd_htsample_rnaseqsetmember _sample_key int4 10 foreign key to GXD_HTSample, identifying the sample member
gxd_antibodyprep _secondary_key int4 10 foreign key to GXD_Antibody
gxd_antibodyprep_view _secondary_key int4 10  √  null
gxd_secondary _secondary_key int4 10 primary key
prb_probe _segmenttype_key int4 10 foreign key to VOC_Term where _Vocab_key = 21 (Sequence Type)
prb_probe_view _segmenttype_key int4 10  √  null
prb_source _segmenttype_key int4 10 foreign key to VOC_Term where _Vocab_key = 10 (Segment Type)
prb_source_view _segmenttype_key int4 10  √  null
gxd_probeprep _sense_key int4 10 foreign key to GXD_ProbeSense
gxd_probeprep_view _sense_key int4 10  √  null
gxd_probesense _sense_key int4 10 primary key
seq_allele_assoc _sequence_key int4 10 foreign key to SEQ_Sequence
seq_allele_assoc_view _sequence_key int4 10  √  null
seq_allele_view _sequence_key int4 10  √  null
seq_coord_cache _sequence_key int4 10 foreign key to SEQ_Sequence
seq_genemodel _sequence_key int4 10 foreign key to SEQ_Sequence
seq_genetrap _sequence_key int4 10 foreign key to SEQ_Sequence
seq_marker_cache _sequence_key int4 10 foreign key to SEQ_Sequence
seq_marker_cache_view _sequence_key int4 10  √  null
seq_probe_cache _sequence_key int4 10 foreign key to SEQ_Sequence
seq_probe_cache_view _sequence_key int4 10  √  null
seq_sequence _sequence_key int4 10 primary key
seq_sequence_raw _sequence_key int4 10 foreign key to SEQ_Sequence
seq_sequence_view _sequence_key int4 10  √  null
seq_source_assoc _sequence_key int4 10 foreign key to SEQ_Sequence
seq_sequence_assoc _sequence_key_1 int4 10 foreign key to SEQ_Sequence
seq_sequence_assoc _sequence_key_2 int4 10 foreign key to SEQ_Sequence
all_variant_sequence _sequence_type_key int4 10 foreign key to VOC_Term, identifies the type of this sequence (_Vocab_key = 21)
seq_allele_view _sequenceprovider_key int4 10  √  null
seq_marker_cache _sequenceprovider_key int4 10 foreign key to VOC_Term where _Vocab_key = 25 (Sequence Provider)
seq_marker_cache_view _sequenceprovider_key int4 10  √  null
seq_sequence _sequenceprovider_key int4 10 foreign key to VOC_Term where _Vocab_key = 25 (Sequence Provider)
seq_sequence_view _sequenceprovider_key int4 10  √  null
seq_sequence _sequencequality_key int4 10 foreign key to VOC_Term where _Vocab_key = 19 (Sequence Quality)
seq_sequence_view _sequencequality_key int4 10  √  null
seq_sequence _sequencestatus_key int4 10 foreign key to VOC_Term where _Vocab_key = 20 (Sequence Status)
seq_sequence_view _sequencestatus_key int4 10  √  null
seq_allele_view _sequencetype_key int4 10  √  null
seq_marker_cache _sequencetype_key int4 10 foreign key to VOC_Term where _Vocab_key = 21 (Sequence Type)
seq_marker_cache_view _sequencetype_key int4 10  √  null
seq_sequence _sequencetype_key int4 10 foreign key to VOC_Term where _Vocab_key = 21 (Sequence Type)
seq_sequence_view _sequencetype_key int4 10  √  null
mgi_set _set_key int4 10 primary key
mgi_setmember _set_key int4 10 foreign key to MGI_Set
mgi_setmember_emapa _setmember_emapa_key int4 10 primary key
mgi_setmember _setmember_key int4 10 primary key
mgi_setmember_emapa _setmember_key int4 10 foreign key to MGI_SetMember
gxd_htsample _sex_key int4 10 foreign key to VOC_Term, identifying sex of the sample
gxd_htsample_rnaseqset _sex_key int4 10 foreign key to VOC_Term
gxd_antibodyantigen_view _source_key int4 10  √  null
gxd_antigen _source_key int4 10 foreign key to PRB_Source
gxd_antigen_view _source_key int4 10  √  null
gxd_htexperiment _source_key int4 10 foreign key to VOC_Term, identifies site from which we downloaded raw data for this experiment
prb_probe _source_key int4 10 foreign key to PRB_Source
prb_probe_view _source_key int4 10  √  null
prb_source _source_key serial 10  √  nextval('prb_source_seq'::regclass) primary key
prb_source_view _source_key int4 10  √  null
prb_sourceref_view _source_key int4 10  √  null
seq_source_assoc _source_key int4 10 foreign key to PRB_Source
all_variant _sourcevariant_key int4 10  √  null null if this is a source (as reported) variant record; foreign key to ALL_Variant to identify the source variant, if this is a curated record
prb_strain _species_key int4 10 foreign key to VOC_Term where _Vocab_key = 26 (Strain Species)
prb_strain_view _species_key int4 10  √  null
gxd_expression _specimen_key int4 10  √  null foreign key to GXD_Specimen
gxd_insituresult _specimen_key int4 10 foreign key to GXD_Specimen
gxd_insituresult_view _specimen_key int4 10  √  null
gxd_isresultimage_view _specimen_key int4 10  √  null
gxd_isresultstructure_view _specimen_key int4 10  √  null
gxd_specimen _specimen_key serial 10  √  nextval('gxd_specimen_seq'::regclass) primary key
gxd_specimen_view _specimen_key int4 10  √  null
all_cre_cache _stage_key int4 10  √  null foreign key to GXD_TheilerStage
gxd_expression _stage_key int4 10 foreign key to GXD_TheilerStage
gxd_gellanestructure _stage_key int4 10 foreign key to GXD_TheilerStage
gxd_gellanestructure_view _stage_key int4 10  √  null
gxd_htsample _stage_key int4 10  √  null foreign key to GXD_TheilerStage, identifying the Theiler Stage of the sample
gxd_htsample_rnaseqset _stage_key int4 10 foreign key to GXD_TheilerStage
gxd_isresultstructure _stage_key int4 10 foreign key to GXD_TheilerStage
gxd_isresultstructure_view _stage_key int4 10  √  null
gxd_theilerstage _stage_key int4 10 primary key
mgi_setmember_emapa _stage_key int4 10 foreign key to GXD_TheilerStage
voc_term_emaps _stage_key int4 10 The theiler stage for this EMAPS term
gxd_index_stages _stageid_key int4 10 foreign key to VOC_Term where _Vocab_key = 13 (GXD Index Stage); '1', '1.5', '2', '2.5'...'19', '19.5'
bib_workflow_status _status_key int4 10 foreign key to VOC_Term where _Vocab_key = 128 (Workflow Status)
all_allele _strain_key int4 10 foreign key to PRB_Strain; the Strain Of Origin; for Transgenes this is the Strain fro which the mutation was made
all_allele_view _strain_key int4 10  √  null
all_cellline _strain_key int4 10 foreign key to PRB_Strain
all_cellline_view _strain_key int4 10  √  null
all_variant _strain_key int4 10 foreign key to PRB_Strain, identifies the strain with this variant
gxd_antibodyantigen_view _strain_key int4 10  √  null
gxd_antigen_view _strain_key int4 10  √  null
gxd_genotype _strain_key int4 10 foreign key to PRB_Strain
gxd_genotype_view _strain_key int4 10  √  null
mld_fish _strain_key int4 10 foreign key to PRB_Strain
mld_fish_view _strain_key int4 10  √  null
mld_insitu _strain_key int4 10 foreign key to PRB_Strain
mld_insitu_view _strain_key int4 10  √  null
mrk_strainmarker _strain_key int4 10 foreign key to PRB_Strain
prb_allele_strain _strain_key int4 10 foreign key to PRB_Strain
prb_rflv_view _strain_key int4 10  √  null
prb_source _strain_key int4 10 foreign key to PRB_Strain
prb_source_view _strain_key int4 10  √  null
prb_strain _strain_key serial 10  √  nextval('prb_strain_seq'::regclass) primary key
prb_strain_attribute_view _strain_key int4 10  √  null
prb_strain_genotype _strain_key int4 10 foreign key to PRB_Strain
prb_strain_genotype_view _strain_key int4 10  √  null
prb_strain_marker _strain_key int4 10 foreign key to PRB_Strain
prb_strain_marker_view _strain_key int4 10  √  null
prb_strain_view _strain_key int4 10  √  null
pwi_all_allele_view _strain_key int4 10  √  null
mld_ri_view _strain_key_1 int4 10  √  null
ri_riset _strain_key_1 int4 10 foreign key to PRB_Strain; 1st member of the cross
ri_riset_view _strain_key_1 int4 10  √  null
mld_ri_view _strain_key_2 int4 10  √  null
ri_riset _strain_key_2 int4 10 foreign key to PRB_Strain; 2nd member of the cross
ri_riset_view _strain_key_2 int4 10  √  null
prb_strain_genotype _straingenotype_key serial 10  √  nextval('prb_strain_genotype_seq'::regclass) primary key
prb_strain_genotype_view _straingenotype_key int4 10  √  null
crs_cross _strainho_key int4 10 foreign key to PRB_Strain; homozygous strain
crs_cross_view _strainho_key int4 10  √  null
mld_matrix_view _strainho_key int4 10  √  null
crs_cross _strainht_key int4 10 foreign key to PRB_Strain; heterozygous strain
crs_cross_view _strainht_key int4 10  √  null
mld_matrix_view _strainht_key int4 10  √  null
mrk_strainmarker _strainmarker_key int4 10 primary key
prb_strain_marker _strainmarker_key serial 10  √  nextval('prb_strain_marker_seq'::regclass) primary key
prb_strain_marker_view _strainmarker_key int4 10  √  null
prb_strain _straintype_key int4 10 foreign key to VOC_Term where _Vocab_key = 55 (Strain Type)
prb_strain_view _straintype_key int4 10  √  null
gxd_gelband _strength_key int4 10 foreign key to GXD_Strength
gxd_gelband_view _strength_key int4 10  √  null
gxd_insituresult _strength_key int4 10 foreign key to GXD_Strength
gxd_insituresult_view _strength_key int4 10  √  null
gxd_strength _strength_key int4 10 primary key
gxd_htexperiment _studytype_key int4 10 foreign key to VOC_Term, identifying whether this experiment is a baseline or differential study
bib_workflow_data _supplemental_key int4 10 foreign key to VOC_Term where_Vocab_key = 130 (Workflow Supplemental Status)
mgi_synonym _synonym_key serial 10  √  nextval('mgi_synonym_seq'::regclass) primary key
mgi_synonym_allele_view _synonym_key int4 10  √  null
mgi_synonym_goterm_view _synonym_key int4 10  √  null
mgi_synonym_musmarker_view _synonym_key int4 10  √  null
mgi_synonym_strain_view _synonym_key int4 10  √  null
mgi_synonym _synonymtype_key int4 10 foreign key to MGI_SynonymType
mgi_synonym_allele_view _synonymtype_key int4 10  √  null
mgi_synonym_goterm_view _synonymtype_key int4 10  √  null
mgi_synonym_musmarker_view _synonymtype_key int4 10  √  null
mgi_synonym_strain_view _synonymtype_key int4 10  √  null
mgi_synonymtype _synonymtype_key int4 10 primary key
mgi_synonymtype_allele_view _synonymtype_key int4 10  √  null
mgi_synonymtype_goterm_view _synonymtype_key int4 10  √  null
mgi_synonymtype_musmarker_view _synonymtype_key int4 10  √  null
mgi_synonymtype_strain_view _synonymtype_key int4 10  √  null
bib_workflow_tag _tag_key int4 10 foreign key to VOC_Term where _Vocab_key = 129 (Workflow Tag)
seq_genetrap _tagmethod_key int4 10 foreign key to VOC_Term (_Vocab_key = 66) The name of the procedure used to produce a sequence tag from a gene trap insertion in a mutant cell line.
mld_hit _target_key int4 10 foreign key to PRB_Probe (Target (YAC))
mgi_roletask _task_key int4 10 foreign key to VOC_Term where _Vocab_key = 34 (User Task)
mgi_roletask_view _task_key int4 10  √  null
all_allele_subtype_view _term_key int4 10  √  null
gxd_htexperimentvariable _term_key int4 10 foreign key to VOC_Term, identifying whether the experiment variable
mrk_do_cache _term_key int4 10 foreign key to VOC_Term where _Vocab_key = 44 (DO)
prb_strain_attribute_view _term_key int4 10  √  null
prb_strain_needsreview_view _term_key int4 10  √  null
voc_allele_cache _term_key int4 10 foreign key to VOC_Term
voc_annot _term_key int4 10 foreign key to VOC_Term; based on the VOC_AnnotType._Vocab_key
voc_annot_count_cache _term_key int4 10 foreign key to VOC_Term
voc_annot_view _term_key int4 10  √  null
voc_annotheader _term_key int4 10 Header Term for the annotation; foreign key to VOC_Term
voc_annotheader_view _term_key int4 10  √  null
voc_go_cache _term_key int4 10 foreign key to VOC_Term
voc_marker_cache _term_key int4 10 foreign key to VOC_Term
voc_term _term_key serial 10  √  nextval('voc_term_seq'::regclass) primary key
voc_term_cellline_view _term_key int4 10  √  null
voc_term_emapa _term_key int4 10 The EMAPA term
voc_term_emaps _term_key int4 10 The EMAPS term
voc_term_mcv_view _term_key int4 10  √  null
voc_term_repqualifier_view _term_key int4 10  √  null
voc_term_strainallele_view _term_key int4 10  √  null
voc_term_strainspecies_view _term_key int4 10  √  null
voc_term_view _term_key int4 10  √  null
img_image _thumbnailimage_key int4 10  √  null foreign key to IMG_Image; if _ImageType_key is full size, then this refers to an IMG_Image object where _ImageType_key is thumbnail; it specifies that thumbnail image counterpart of the full size Image.
img_image_view _thumbnailimage_key int4 10  √  null
gxd_antibodyantigen_view _tissue_key int4 10  √  null
gxd_antigen_view _tissue_key int4 10  √  null
prb_source _tissue_key int4 10 foreign key to PRB_Tissue
prb_source_view _tissue_key int4 10  √  null
prb_tissue _tissue_key serial 10  √  nextval('prb_tissue_seq'::regclass) primary key
mgi_translation _translation_key int4 10 primary key
mgi_translation_view _translation_key int4 10  √  null
mgi_translationstrain_view _translation_key int4 10  √  null
mgi_translation _translationtype_key int4 10 foreign key to MGI_TranslationType
mgi_translation_view _translationtype_key int4 10  √  null
mgi_translationstrain_view _translationtype_key int4 10  √  null
mgi_translationtype _translationtype_key int4 10 primary key
all_allele _transmission_key int4 10 foreign key to VOC_Term where _Vocab_key = 61 (Allele Transmission); 'Germline', 'Cell Line', 'Chimeric'
all_allele_view _transmission_key int4 10  √  null
pwi_all_allele_view _transmission_key int4 10  √  null
map_coordinate _units_key int4 10 foreign key to VOC_Term where _Vocab_key = 30 (Map Units)
mgi_user _user_key int4 10 primary key
mgi_user_active_view _user_key int4 10  √  null
mgi_userrole _user_key int4 10 foreign key to MGI_User
mgi_userrole_view _user_key int4 10  √  null
mgi_usertask_view _user_key int4 10  √  null
mgi_userrole _userrole_key int4 10 primary key
mgi_userrole_view _userrole_key int4 10  √  null
mgi_usertask_view _userrole_key int4 10  √  null
mgi_user _userstatus_key int4 10 foreign key to VOC_Term where _Vocab_key = 22 (User Status)
mgi_user_active_view _userstatus_key int4 10  √  null
mgi_user _usertype_key int4 10 foreign key to VOC_Term where _Vocab_key = 23 (User Type)
mgi_user_active_view _usertype_key int4 10  √  null
all_variant _variant_key serial 10  √  nextval('all_variant_seq'::regclass) primary key, uniquely identifying the record
all_variant_sequence _variant_key int4 10 foreign key to ALL_Variant_Variant, identifying the variant with this sequence
all_variant_sequence _variantsequence_key serial 10  √  nextval('all_variantsequence_seq'::regclass) primary key, uniquely identifying the record
all_allele_cellline_view _vector_key int4 10  √  null
all_cellline_derivation _vector_key int4 10 foreign key to VOC_Term where _Vocab_key = = 72 (Cell Line Vector Name)
all_cellline_derivation_view _vector_key int4 10  √  null
all_cellline_view _vector_key int4 10  √  null
prb_probe _vector_key int4 10 foreign key to VOC_Term where _Vocab_key = 24 (Segment Vector Type)
prb_probe_view _vector_key int4 10  √  null
prb_source _vector_key int4 10 foreign key to VOC_Term where _Vocab_key = 24 (Segment Vector Type)
prb_source_view _vector_key int4 10  √  null
seq_genetrap _vectorend_key int4 10 foreign key to VOC_Term (_Vocab_key = 67)
all_cellline_derivation _vectortype_key int4 10 foreign key to VOC_Term where _Vocab_key = 64 (Cell Line Vector Type)
all_cellline_derivation_view _vectortype_key int4 10  √  null
all_cellline_view _vectortype_key int4 10  √  null
gxd_probeprep _visualization_key int4 10 foreign key to GXD_VisualizationMethod
gxd_probeprep_view _visualization_key int4 10  √  null
gxd_visualizationmethod _visualization_key int4 10 primary key
dag_node_view _vocab_key int4 10  √  null
mgi_propertytype _vocab_key int4 10  √  null foreign key to VOC_Vocab
mgi_translationtype _vocab_key int4 10  √  null foreign key to VOC_Vocab
voc_annot_view _vocab_key int4 10  √  null
voc_annottype _vocab_key int4 10 foreign key to VOC_Vocab
voc_term _vocab_key int4 10 foreign key to VOC_Vocab
voc_term_cellline_view _vocab_key int4 10  √  null
voc_term_mcv_view _vocab_key int4 10  √  null
voc_term_repqualifier_view _vocab_key int4 10  √  null
voc_term_strainallele_view _vocab_key int4 10  √  null
voc_term_strainspecies_view _vocab_key int4 10  √  null
voc_term_view _vocab_key int4 10  √  null
voc_vocab _vocab_key int4 10 primary key
voc_vocab_view _vocab_key int4 10  √  null
voc_vocabdag _vocab_key int4 10 foreign key to VOC_Vocab
voc_vocabdag_view _vocab_key int4 10  √  null
prb_parent_view accnumeric int4 10  √  null
voc_annot_count_cache annotcount int4 10 count of annotations of the given annotType to the given _Term_key
all_allele_cellline_view celllinestrain_key int4 10  √  null
mld_concordance cnn int4 10 -/-; number of Hybrid cells where neither the Concordance Marker/Chromosome nor the linkage Marker is present
mld_concordance_view cnn int4 10  √  null
mld_concordance cnp int4 10 -/+; number of Hybrid cells where the Concordance Marker/Chromosome is not present, but the linkage Marker is present
mld_concordance_view cnp int4 10  √  null
crs_typings colnumber int4 10 column number
mld_concordance cpn int4 10 +/-; number of Hybrid cells where the Concordance Marker/Chromosome is present, but the linkage Marker is not present
mld_concordance_view cpn int4 10  √  null
mld_concordance cpp int4 10 +/+; number of Hybrid cells where both the Concordance Marker/Chromosome and the linkage Marker are present
mld_concordance_view cpp int4 10  √  null
all_allele_cellline_view derivationkey int4 10  √  null
prb_probe derivedfrom int4 10  √  null foreign key to PRB_Probe; parent
prb_probe_view derivedfrom int4 10  √  null
voc_term_emapa endstage int4 10 End Theiler Stage
mrk_history_view event_display bpchar 10  √  null
voc_evidence_view evidenceseqnum int4 10  √  null
seq_genemodel exoncount int4 10  √  null currently not being used
all_cre_cache expressed int4 10  √  null if 1 (true), then this Assay is expressing this Structure, else 0
seq_genetrap goodhitcount int4 10  √  null Number of good blat hits
mld_isregion graincount int4 10 # of grains observed over the region
mld_insitu grainsonchrom int4 10  √  null # of grains hybridizing to correct chromosomal location
mld_insitu_view grainsonchrom int4 10  √  null
mld_insitu grainsotherchrom int4 10  √  null # of grains hybridizing to other chromosomal locations
mld_insitu_view grainsotherchrom int4 10  √  null
bib_associateddata_view has_alleles int4 10  √  null
bib_associateddata_view has_antibodies int4 10  √  null
bib_associateddata_view has_go int4 10  √  null
bib_associateddata_view has_gxdimages int4 10  √  null
bib_associateddata_view has_gxdindex int4 10  √  null
bib_associateddata_view has_gxdresults int4 10  √  null
bib_associateddata_view has_gxdspecimens int4 10  √  null
bib_associateddata_view has_mapping int4 10  √  null
bib_associateddata_view has_markers int4 10  √  null
bib_associateddata_view has_probes int4 10  √  null
bib_associateddata_view has_strain int4 10  √  null
all_cre_cache hasimage int4 10  √  null does this record have an image?
img_imagepane height int4 10  √  null height of image pdf
pwi_report id serial 10  √  nextval('pwi_report_id_seq'::regclass) None
pwi_report_label id serial 10  √  nextval('pwi_report_label_id_seq'::regclass) None
all_allele_view jnum int4 10  √  null
all_cellline_derivation_view jnum int4 10  √  null
bib_all2_view jnum int4 10  √  null
bib_all_view jnum int4 10  √  null
bib_goxref_view jnum int4 10  √  null
bib_view jnum int4 10  √  null
gxd_antibodyaliasref_view jnum int4 10  √  null
gxd_assay_view jnum int4 10  √  null
gxd_index_view jnum int4 10  √  null
img_image_view jnum int4 10  √  null
img_imagepanegxd_view jnum int4 10  √  null
mgi_reference_allele_view jnum int4 10  √  null
mgi_reference_allelevariant_view jnum int4 10  √  null
mgi_reference_antibody_view jnum int4 10  √  null
mgi_reference_marker_view jnum int4 10  √  null
mgi_reference_sequence_view jnum int4 10  √  null
mgi_reference_strain_view jnum int4 10  √  null
mgi_relationship_markertss_view jnum int4 10  √  null
mgi_synonym_allele_view jnum int4 10  √  null
mgi_synonym_goterm_view jnum int4 10  √  null
mgi_synonym_musmarker_view jnum int4 10  √  null
mgi_synonym_strain_view jnum int4 10  √  null
mld_concordance_view jnum int4 10  √  null
mld_expt_marker_view jnum int4 10  √  null
mld_expt_view jnum int4 10  √  null
mld_fish_view jnum int4 10  √  null
mld_hybrid_view jnum int4 10  √  null
mld_insitu_view jnum int4 10  √  null
mld_matrix_view jnum int4 10  √  null
mld_mc2point_view jnum int4 10  √  null
mld_ri2point_view jnum int4 10  √  null
mld_ri_view jnum int4 10  √  null
mld_ridata_view jnum int4 10  √  null
mld_statistics_view jnum int4 10  √  null
mrk_accref1_view jnum int4 10  √  null
mrk_accref2_view jnum int4 10  √  null
mrk_accref_view jnum int4 10  √  null
mrk_reference jnum int4 10 J: accession id of the reference without the prefix; integer (xxxx)
mrk_reference_view jnum int4 10  √  null
prb_marker_view jnum int4 10  √  null
prb_reference_view jnum int4 10  √  null
prb_sourceref_view jnum int4 10  √  null
seq_allele_assoc_view jnum int4 10  √  null
seq_allele_view jnum int4 10  √  null
seq_marker_cache_view jnum int4 10  √  null
seq_probe_cache_view jnum int4 10  √  null
voc_evidence_view jnum int4 10  √  null
voc_vocab_view jnum int4 10  √  null
gxd_gelband_view lanenum int4 10  √  null
map_coordinate length int4 10 map length in specified units (_Units_key)
seq_sequence length int4 10  √  null length of sequence
seq_sequence_view length int4 10  √  null
mrk_mcv_count_cache markercount int4 10 the current number of markers annotated to this term
acc_accessionmax maxnumericpart int4 10 the current maximum numeric value for the accession number series designated by prefixPart
seq_allele_view mgitype varchar 10  √  null
seq_marker_cache_view mgitype varchar 10  √  null
seq_probe_cache_view mgitype varchar 10  √  null
mld_contig minlink int4 10  √  null indicates the minimum number of common hits required to assemble YACs into the Contig.
crs_cross nprogeny int4 10  √  null number of progeny resulting from cross
crs_cross_view nprogeny int4 10  √  null
mld_matrix_view nprogeny int4 10  √  null
gxd_htsample_rnaseqcombined numberofbiologicalreplicates int4 10 the number of biological replicates
seq_sequence numberoforganisms int4 10  √  null for Swiss-Prot, number of non-mouse, non-human, non-rat organisms that are sources of this sequence
seq_sequence_view numberoforganisms int4 10  √  null
acc_accession numericpart int4 10  √  null the trailing numerical portion of accID
acc_view numericpart int4 10  √  null
all_acc_view numericpart int4 10  √  null
all_cellline_acc_view numericpart int4 10  √  null
all_derivation_summary_view numericpart int4 10  √  null
all_summary_view numericpart int4 10  √  null
bib_acc_view numericpart int4 10  √  null
bib_citation_cache numericpart int4 10  √  null the trailing numerical portion of accID
bib_summary_all_view numericpart int4 10  √  null
gxd_antibody_acc_view numericpart int4 10  √  null
gxd_antibody_view numericpart int4 10  √  null
gxd_antibodyantigen_view numericpart int4 10  √  null
gxd_antigen_acc_view numericpart int4 10  √  null
gxd_antigen_summary_view numericpart int4 10  √  null
gxd_antigen_view numericpart int4 10  √  null
gxd_assay_acc_view numericpart int4 10  √  null
gxd_assay_view numericpart int4 10  √  null
gxd_genotype_acc_view numericpart int4 10  √  null
gxd_genotype_summary_view numericpart int4 10  √  null
img_image_acc_view numericpart int4 10  √  null
img_image_summary_view numericpart int4 10  √  null
img_image_view numericpart int4 10  √  null
mgi_organism_acc_view numericpart int4 10  √  null
mgi_organism_summary_view numericpart int4 10  √  null
mld_acc_view numericpart int4 10  √  null
mld_expt_view numericpart int4 10  √  null
mld_summary_view numericpart int4 10  √  null
mrk_acc_view numericpart int4 10  √  null
mrk_accnoref_view numericpart int4 10  √  null
mrk_accref1_view numericpart int4 10  √  null
mrk_accref2_view numericpart int4 10  √  null
mrk_accref_view numericpart int4 10  √  null
mrk_mouse_view numericpart int4 10  √  null
mrk_summary_view numericpart int4 10  √  null
prb_acc_view numericpart int4 10  √  null
prb_accnoref_view numericpart int4 10  √  null
prb_accref_view numericpart int4 10  √  null
prb_accrefnoseq_view numericpart int4 10  √  null
prb_probe_view numericpart int4 10  √  null
prb_source_acc_view numericpart int4 10  √  null
prb_source_summary_view numericpart int4 10  √  null
prb_strain_acc_view numericpart int4 10  √  null
prb_strain_summary_view numericpart int4 10  √  null
prb_tissue_summary_view numericpart int4 10  √  null
seq_allele_assoc_view numericpart int4 10  √  null
seq_sequence_acc_view numericpart int4 10  √  null
seq_summary_view numericpart int4 10  √  null
voc_term_acc_view numericpart int4 10  √  null
voc_term_summary_view numericpart int4 10  √  null
mld_fish nummetaphase int4 10  √  null # of metaphase spreads analyzed in experiment
mld_fish_view nummetaphase int4 10  √  null
mld_insitu nummetaphase int4 10  √  null # of metaphase spreads analyzed in experiment
mld_insitu_view nummetaphase int4 10  √  null
mld_mc2point numparentals int4 10 # of animals exhibiting parental genotype
mld_mc2point_view numparentals int4 10  √  null
mld_mc2point numrecombinants int4 10 # of animals exhibiting recombinant genotype
mld_mc2point_view numrecombinants int4 10  √  null
mld_ri2point numrecombinants int4 10 # of animals exhibiting recombinant genotype
mld_ri2point_view numrecombinants int4 10  √  null
mld_ri2point numtotal int4 10 # of animals typed
mld_ri2point_view numtotal int4 10  √  null
voc_annot_count_cache objectcount int4 10 count of objects of the given _MGIType_key with annotations of a given annotType to the given _Term_key
mld_mcdatalist offspringnmbr int4 10 designates number of offspring detected with haplotype
mrk_do_cache omimcategory3 int4 10 disease mouse model format
all_allele_cellline_view parentcellline_key int4 10  √  null
all_cellline_derivation_view parentcellline_key int4 10  √  null
all_cellline_view parentcellline_key int4 10  √  null
all_cellline_derivation_view parentcelllinestrain_key int4 10  √  null
all_cellline_view parentcelllinestrain_key int4 10  √  null
all_allele_cellline_view parentcelllinetype_key int4 10  √  null
all_cellline_derivation_view parentcelllinetype_key int4 10  √  null
prb_parent_view parentkey int4 10  √  null
prb_parent_view parentnumeric int4 10  √  null
all_label priority int4 10 an integer representing the priority of this record for sorting purposes. the higher the number, the higher the priority.
mrk_label priority int4 10 an integer representing the priority of this record for sorting purposes. the higher the number, the higher the priority.
mld_statistics recomb int4 10 number of mice which recombined for Marker pair
mld_statistics_view recomb int4 10  √  null
pwi_report_label report_id int4 10 None
gxd_gelband_view rownum int4 10  √  null
crs_matrix rownumber int4 10 row number
crs_typings rownumber int4 10 row number
crs_progeny sequencenum int4 10 sequence number for ordering records
dag_edge sequencenum int4 10 sequence number for ordering records
gxd_allelegenotype sequencenum int4 10 sequence number for ordering records
gxd_allelepair sequencenum int4 10 sequence number for ordering records
gxd_allelepair_view sequencenum int4 10  √  null
gxd_assaytype sequencenum int4 10 sequence number for ordering records
gxd_gellane sequencenum int4 10 sequence number for ordering records
gxd_gellane_view sequencenum int4 10  √  null
gxd_gellanestructure_view sequencenum int4 10  √  null
gxd_gelrow sequencenum int4 10 sequence number for ordering records
gxd_gelrow_view sequencenum int4 10  √  null
gxd_insituresult sequencenum int4 10 sequence number for ordering records
gxd_insituresult_view sequencenum int4 10  √  null
gxd_isresultimage_view sequencenum int4 10  √  null
gxd_isresultstructure_view sequencenum int4 10  √  null
gxd_specimen sequencenum int4 10 sequence number for ordering records
gxd_specimen_view sequencenum int4 10  √  null
map_coordinate sequencenum int4 10 orders the Map withing the specified Map Collection
mgi_note_allele_view sequencenum int4 10  √  null
mgi_note_allelevariant_view sequencenum int4 10  √  null
mgi_note_derivation_view sequencenum int4 10  √  null
mgi_note_genotype_view sequencenum int4 10  √  null
mgi_note_image_view sequencenum int4 10  √  null
mgi_note_marker_view sequencenum int4 10  √  null
mgi_note_mrkgo_view sequencenum int4 10  √  null
mgi_note_probe_view sequencenum int4 10  √  null
mgi_note_sequence_view sequencenum int4 10  √  null
mgi_note_source_view sequencenum int4 10  √  null
mgi_note_strain_view sequencenum int4 10  √  null
mgi_note_vocevidence_view sequencenum int4 10  √  null
mgi_notechunk sequencenum int4 10 order of the note segment (for reconstructing the entire note).
mgi_organism_mgitype sequencenum int4 10
mgi_organism_mgitype_view sequencenum int4 10  √  null
mgi_property sequencenum int4 10 sequence number for ordering records
mgi_relationship_property sequencenum int4 10 Order of properties in this relationship
mgi_set sequencenum int4 10 sequence number for ordering records
mgi_setmember sequencenum int4 10 order of the member within the Set
mgi_translation sequencenum int4 10 order of the Translation member
mgi_translation_view sequencenum int4 10  √  null
mgi_translationstrain_view sequencenum int4 10  √  null
mld_concordance sequencenum int4 10 sequence number for ordering records
mld_concordance_view sequencenum int4 10  √  null
mld_contigprobe sequencenum int4 10 sequence number for ordering records
mld_expt_marker sequencenum int4 10 sequence number for ordering records
mld_expt_marker_view sequencenum int4 10  √  null
mld_fish_region sequencenum int4 10 sequence number for ordering records
mld_isregion sequencenum int4 10 sequence number for ordering records
mld_mc2point sequencenum int4 10 sequence number for ordering records
mld_mc2point_view sequencenum int4 10  √  null
mld_mcdatalist sequencenum int4 10 sequence number for ordering records
mld_ri2point sequencenum int4 10 sequence number for ordering records
mld_ri2point_view sequencenum int4 10  √  null
mld_ridata sequencenum int4 10 sequence number for ordering records
mld_ridata_view sequencenum int4 10  √  null
mld_statistics sequencenum int4 10 sequence number for ordering records
mld_statistics_view sequencenum int4 10  √  null
mrk_chromosome sequencenum int4 10 sequence number for ordering records
mrk_clustermember sequencenum int4 10 order of members within this cluster
mrk_history sequencenum int4 10 sequence number of the event
mrk_history_view sequencenum int4 10  √  null
mrk_location_cache sequencenum int4 10 chromosome order
prb_strain_marker_view sequencenum int4 10  √  null
voc_annot_view sequencenum int4 10  √  null
voc_annotheader sequencenum int4 10 order of the Header Term for a specific Object
voc_annotheader_view sequencenum int4 10  √  null
voc_evidence_property sequencenum int4 10 sequnence number of the property within each stanza
voc_evidenceproperty_view sequencenum int4 10  √  null
voc_term sequencenum int4 10  √  null enables us to define an ordered list of Terms for a Vocabulary which contains 0 DAGS. for structured vocabularies, the sequenceNum is null
voc_term_cellline_view sequencenum int4 10  √  null
voc_term_mcv_view sequencenum int4 10  √  null
voc_term_repqualifier_view sequencenum int4 10  √  null
voc_term_strainallele_view sequencenum int4 10  √  null
voc_term_strainspecies_view sequencenum int4 10  √  null
voc_term_view sequencenum int4 10  √  null
gxd_gellanestructure_view stage int4 10  √  null
gxd_isresultstructure_view stage int4 10  √  null
gxd_theilerstage stage int4 10 Theiler Stage (1-28)
voc_evidence_property stanza int4 10 a stanza represents a group of proeprties within the same evidence; group by _AnnotEvidence_key/stranza/sequenceNumber to retreive the ordered set of stanza's for a given annotation/evidence
voc_evidenceproperty_view stanza int4 10  √  null
voc_term_emapa startstage int4 10 Start Theiler Stage
all_allele_view statusnum int4 10  √  null
mld_expt_marker_view tag int4 10  √  null
mld_expt_view tag int4 10  √  null
mld_expts tag int4 10 unique integer value for each experiment type defined for a given reference (CROSS-1, CROSS-2, etc.)
mld_matrix_view tag int4 10  √  null
mld_ri_view tag int4 10  √  null
mld_statistics_view tag int4 10  √  null
mld_statistics total int4 10 total number of mice typed for Marker pair
mld_statistics_view total int4 10  √  null
mld_fish totaldouble int4 10  √  null # of double fluorescent signals indicating presence of marker
mld_fish_region totaldouble int4 10  √  null number of double signals detected in region
mld_fish_view totaldouble int4 10  √  null
mld_insitu totalgrains int4 10  √  null # of grains observed in experiment
mld_insitu_view totalgrains int4 10  √  null
mld_fish totalsingle int4 10  √  null # of single flourescent signals indicating presence of marker
mld_fish_region totalsingle int4 10  √  null number of single signals detected in region
mld_fish_view totalsingle int4 10  √  null
seq_genemodel transcriptcount int4 10  √  null currently not being used.
mrk_biotypemapping usemcvchildren int4 10 0 use feature type/MCV children to determine raw biotype conflicts
img_imagepane width int4 10  √  null width of image pdf
img_imagepane x int4 10  √  null x coordinate of image pdf
gxd_isresultimage_view xdim int4 10  √  null
img_image xdim int4 10  √  null X dimension of JPEG image
img_image_view xdim int4 10  √  null
img_imagepane y int4 10  √  null y coordinate of image pdf
gxd_isresultimage_view ydim int4 10  √  null
img_image ydim int4 10  √  null Y dimensions of JPEG image
img_image_view ydim int4 10  √  null
bib_all2_view year int4 10  √  null
bib_all_view year int4 10  √  null
bib_refs year int4 10  √  null year of publication
bib_view year int4 10  √  null
pwi_bib_refs_view year int4 10  √  null
mrk_location_cache cmoffset float8 17,17  √  null cytogenetic cmOffset
mrk_marker cmoffset float8 17,17  √  null approximate centimorgan (cM) position on chromosome
mrk_marker_view cmoffset float8 17,17  √  null
mrk_mouse_view cmoffset float8 17,17  √  null
mrk_nonmouse_view cmoffset float8 17,17  √  null
pwi_mrk_marker_view cmoffset float8 17,17  √  null
mrk_location_cache endcoordinate float8 17,17  √  null end genome coordinate
mrk_location_cache startcoordinate float8 17,17  √  null start genome coordinate
seq_marker_cache annotation_date timestamp 29,6 now() date of the annotation
seq_probe_cache annotation_date timestamp 29,6 now() date of the annotation
all_allele approval_date timestamp 29,6  √  now() date record was statused as "Approved"
all_allele_view approval_date timestamp 29,6  √  null
pwi_all_allele_view approval_date timestamp 29,6  √  null
voc_annotheader approval_date timestamp 29,6  √  now() date record was approved
voc_annotheader_view approval_date timestamp 29,6  √  null
mrk_cluster cluster_date timestamp 29,6  √  now() Cluster Date
go_tracking completion_date timestamp 29,6  √  now() date GO Tracking was completed
go_tracking_view completion_date timestamp 29,6  √  null
pwi_report created timestamp 29,6 now() None
acc_accession creation_date timestamp 29,6 now() date record was created
acc_accessionmax creation_date timestamp 29,6 now() date record was created
acc_accessionreference creation_date timestamp 29,6 now() date record was created
acc_actualdb creation_date timestamp 29,6 now() date record was created
acc_logicaldb creation_date timestamp 29,6 now() date record was created
acc_logicaldb_view creation_date timestamp 29,6  √  null
acc_mgitype creation_date timestamp 29,6 now() date record was created
acc_view creation_date timestamp 29,6  √  null
all_acc_view creation_date timestamp 29,6  √  null
all_allele creation_date timestamp 29,6 now() date record was created
all_allele_cellline creation_date timestamp 29,6 now() date record was created
all_allele_cellline_view creation_date timestamp 29,6  √  null
all_allele_mutation creation_date timestamp 29,6 now() date record was created
all_allele_mutation_view creation_date timestamp 29,6  √  null
all_allele_subtype_view creation_date timestamp 29,6  √  null
all_allele_view creation_date timestamp 29,6  √  null
all_cellline creation_date timestamp 29,6 now() date record was created
all_cellline_acc_view creation_date timestamp 29,6  √  null
all_cellline_derivation creation_date timestamp 29,6 now() date record was created
all_cellline_derivation_view creation_date timestamp 29,6  √  null
all_cellline_view creation_date timestamp 29,6  √  null
all_cre_cache creation_date timestamp 29,6 now() date record was created
all_derivation_summary_view creation_date timestamp 29,6  √  null
all_knockout_cache creation_date timestamp 29,6 now() date record was created
all_label creation_date timestamp 29,6 now() date record was created
all_summary_view creation_date timestamp 29,6  √  null
all_variant creation_date timestamp 29,6 now() date record was created
all_variant_sequence creation_date timestamp 29,6 now() date record was created
bib_acc_view creation_date timestamp 29,6  √  null
bib_all2_view creation_date timestamp 29,6  √  null
bib_all_view creation_date timestamp 29,6  √  null
bib_books creation_date timestamp 29,6 now() date record was created
bib_goxref_view creation_date timestamp 29,6  √  null
bib_notes creation_date timestamp 29,6 now() date record was created
bib_refs creation_date timestamp 29,6 now() date record was created
bib_summary_all_view creation_date timestamp 29,6  √  null
bib_view creation_date timestamp 29,6  √  null
bib_workflow_data creation_date timestamp 29,6 now() date record was created
bib_workflow_status creation_date timestamp 29,6 now() date record was created
bib_workflow_tag creation_date timestamp 29,6 now() date record was created
crs_cross creation_date timestamp 29,6 now() date record was created
crs_cross_view creation_date timestamp 29,6  √  null
crs_matrix creation_date timestamp 29,6 now() date record was created
crs_progeny creation_date timestamp 29,6 now() date record was created
crs_references creation_date timestamp 29,6 now() date record was created
crs_typings creation_date timestamp 29,6 now() date record was created
dag_closure creation_date timestamp 29,6 now() date record was created
dag_dag creation_date timestamp 29,6 now() date record was created
dag_edge creation_date timestamp 29,6 now() date record was created
dag_label creation_date timestamp 29,6 now() date record was created
dag_node creation_date timestamp 29,6 now() date record was created
dag_node_view creation_date timestamp 29,6  √  null
go_tracking creation_date timestamp 29,6 now() date record was created
go_tracking_view creation_date timestamp 29,6  √  null
gxd_allelegenotype creation_date timestamp 29,6 now() date record was created
gxd_allelepair creation_date timestamp 29,6 now() date record was created
gxd_allelepair_view creation_date timestamp 29,6  √  null
gxd_antibody creation_date timestamp 29,6 now() date record was created
gxd_antibody_acc_view creation_date timestamp 29,6  √  null
gxd_antibody_view creation_date timestamp 29,6  √  null
gxd_antibodyalias creation_date timestamp 29,6 now() date record was created
gxd_antibodyalias_view creation_date timestamp 29,6  √  null
gxd_antibodyaliasref_view creation_date timestamp 29,6  √  null
gxd_antibodyantigen_view creation_date timestamp 29,6  √  null
gxd_antibodyclass creation_date timestamp 29,6 now() date record was created
gxd_antibodymarker creation_date timestamp 29,6 now() date record was created
gxd_antibodyprep creation_date timestamp 29,6 now() date record was created
gxd_antibodyprep_view creation_date timestamp 29,6  √  null
gxd_antibodytype creation_date timestamp 29,6 now() date record was created
gxd_antigen creation_date timestamp 29,6 now() date record was created
gxd_antigen_acc_view creation_date timestamp 29,6  √  null
gxd_antigen_summary_view creation_date timestamp 29,6  √  null
gxd_antigen_view creation_date timestamp 29,6  √  null
gxd_assay creation_date timestamp 29,6 now() date record was created
gxd_assay_acc_view creation_date timestamp 29,6  √  null
gxd_assay_view creation_date timestamp 29,6  √  null
gxd_assaynote creation_date timestamp 29,6 now() date record was created
gxd_assaytype creation_date timestamp 29,6 now() date record was created
gxd_embeddingmethod creation_date timestamp 29,6 now() date record was created
gxd_expression creation_date timestamp 29,6 now() date record was created
gxd_fixationmethod creation_date timestamp 29,6 now() date record was created
gxd_gelband creation_date timestamp 29,6 now() date record was created
gxd_gelband_view creation_date timestamp 29,6  √  null
gxd_gelcontrol creation_date timestamp 29,6 now() date record was created
gxd_gellane creation_date timestamp 29,6 now() date record was created
gxd_gellane_view creation_date timestamp 29,6  √  null
gxd_gellanestructure creation_date timestamp 29,6 now() date record was created
gxd_gellanestructure_view creation_date timestamp 29,6  √  null
gxd_gelrnatype creation_date timestamp 29,6 now() date record was created
gxd_gelrow creation_date timestamp 29,6 now() date record was created
gxd_gelrow_view creation_date timestamp 29,6  √  null
gxd_gelunits creation_date timestamp 29,6 now() date record was created
gxd_genotype creation_date timestamp 29,6 now() date record was created
gxd_genotype_acc_view creation_date timestamp 29,6  √  null
gxd_genotype_summary_view creation_date timestamp 29,6  √  null
gxd_genotype_view creation_date timestamp 29,6  √  null
gxd_htexperiment creation_date timestamp 29,6 now() date record was created
gxd_htsample creation_date timestamp 29,6 now() date record was created
gxd_htsample_rnaseq creation_date timestamp 29,6 now() date record was created
gxd_htsample_rnaseqcombined creation_date timestamp 29,6 now() date record was created
gxd_htsample_rnaseqset creation_date timestamp 29,6 now() date record was created
gxd_htsample_rnaseqsetmember creation_date timestamp 29,6 now() date record was created
gxd_index creation_date timestamp 29,6 now() date record was created
gxd_index_stages creation_date timestamp 29,6 now() date record was created
gxd_index_view creation_date timestamp 29,6  √  null
gxd_insituresult creation_date timestamp 29,6 now() date record was created
gxd_insituresult_view creation_date timestamp 29,6  √  null
gxd_insituresultimage creation_date timestamp 29,6 now() date record was created
gxd_isresultimage_view creation_date timestamp 29,6  √  null
gxd_isresultstructure creation_date timestamp 29,6 now() date record was created
gxd_isresultstructure_view creation_date timestamp 29,6  √  null
gxd_label creation_date timestamp 29,6 now() date record was created
gxd_pattern creation_date timestamp 29,6 now() date record was created
gxd_probeprep creation_date timestamp 29,6 now() date record was created
gxd_probeprep_view creation_date timestamp 29,6  √  null
gxd_probesense creation_date timestamp 29,6 now() date record was created
gxd_secondary creation_date timestamp 29,6 now() date record was created
gxd_specimen creation_date timestamp 29,6 now() date record was created
g