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
bib_workflow_data haspdf int2 5 0 does Reference have a PDF?
mrk_biotypemapping usemcvchildren int4 10 0 use feature type/MCV children to determine raw biotype conflicts
bib_workflow_status iscurrent int2 5 1 if 1, then current Status for this Reference/Group
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_mgitype _createdby_key int4 10 1001 user who created the record
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_cellline _createdby_key int4 10 1001 user who created the record
all_cellline_derivation _createdby_key int4 10 1001 user who created the record
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_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_refs _createdby_key int4 10 1001 user who created the record
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
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_antibody _createdby_key int4 10 1001 user who created the record
gxd_antigen _createdby_key int4 10 1001 user who created the record
gxd_assay _createdby_key int4 10 1001 user who created the record
gxd_genotype _createdby_key int4 10 1001 user who created the record
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
img_image _createdby_key int4 10 1001 user who created the record
img_imagepane_assoc _createdby_key int4 10 1001 user who created the record
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_notechunk _createdby_key int4 10 1001 user who created the record
mgi_notetype _createdby_key int4 10 1001 user who created the record
mgi_organism _createdby_key int4 10 1001 user who created the record
mgi_organism_mgitype _createdby_key int4 10 1001 user who created the record
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_assoc _createdby_key int4 10 1001 user who created the record
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_property _createdby_key int4 10 1001 user who created the record
mgi_roletask _createdby_key int4 10 1001 user who created the record
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_synonymtype _createdby_key int4 10 1001 user who created the record
mgi_translation _createdby_key int4 10 1001 user who created the record
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_userrole _createdby_key int4 10 1001 user who created the record
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_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_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_strainmarker _createdby_key int4 10 1001 user who created the record
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_reference _createdby_key int4 10 1001 user who created the record
prb_rflv _createdby_key int4 10 1001 user who created the record
prb_source _createdby_key int4 10 1001 user who created the record
prb_strain _createdby_key int4 10 1001 user who created the record
prb_strain_genotype _createdby_key int4 10 1001 user who created the record
prb_strain_marker _createdby_key int4 10 1001 user who created the record
seq_allele_assoc _createdby_key int4 10 1001 user who created the record
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_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_source_assoc _createdby_key int4 10 1001 user who created the record
voc_annotheader _createdby_key int4 10 1001 user who created the record
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_term _createdby_key int4 10 1001 user who created the record
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
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_mgitype _modifiedby_key int4 10 1001 user who last modified the record
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_cellline _modifiedby_key int4 10 1001 user who last modified the record
all_cellline_derivation _modifiedby_key int4 10 1001 user who last modified the record
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_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_refs _modifiedby_key int4 10 1001 user who last modified the record
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
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_antibody _modifiedby_key int4 10 1001 user who last modified the record
gxd_antigen _modifiedby_key int4 10 1001 user who last modified the record
gxd_assay _modifiedby_key int4 10 1001 user who last modified the record
gxd_genotype _modifiedby_key int4 10 1001 user who last modified the record
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
img_image _modifiedby_key int4 10 1001 user who last modified the record
img_imagepane_assoc _modifiedby_key int4 10 1001 user who last modified the record
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_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_organism _modifiedby_key int4 10 1001 user who last modified the record
mgi_organism_mgitype _modifiedby_key int4 10 1001 user who last modified the record
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_assoc _modifiedby_key int4 10 1001 user who last modified the record
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_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_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_synonymtype _modifiedby_key int4 10 1001 user who last modified the record
mgi_translation _modifiedby_key int4 10 1001 user who last modified the record
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_userrole _modifiedby_key int4 10 1001 user who last modified the record
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_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_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_strainmarker _modifiedby_key int4 10 1001 user who last modified the record
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_reference _modifiedby_key int4 10 1001 user who last modified the record
prb_rflv _modifiedby_key int4 10 1001 user who last modified the record
prb_source _modifiedby_key int4 10 1001 user who last modified the record
prb_strain _modifiedby_key int4 10 1001 user who last modified the record
prb_strain_genotype _modifiedby_key int4 10 1001 user who last modified the record
prb_strain_marker _modifiedby_key int4 10 1001 user who last modified the record
seq_allele_assoc _modifiedby_key int4 10 1001 user who last modified the record
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_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_source_assoc _modifiedby_key int4 10 1001 user who last modified the record
voc_annotheader _modifiedby_key int4 10 1001 user who last modified the record
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_term _modifiedby_key int4 10 1001 user who last modified the record
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
acc_actualdb _actualdb_key serial 10  √  nextval('acc_actualdb_seq'::regclass) primary key
acc_logicaldb _logicaldb_key serial 10  √  nextval('acc_logicaldb_seq'::regclass) primary key
all_allele_cellline _assoc_key serial 10  √  nextval('all_allele_cellline_seq'::regclass) primary key
all_allele_mutation _assoc_key serial 10  √  nextval('all_allele_mutation_seq'::regclass)
all_allele _allele_key serial 10  √  nextval('all_allele_seq'::regclass) primary key
all_cellline_derivation _derivation_key serial 10  √  nextval('all_cellline_derivation_seq'::regclass) primary key
all_cellline _cellline_key serial 10  √  nextval('all_cellline_seq'::regclass) primary key
all_variant _variant_key serial 10  √  nextval('all_variant_seq'::regclass) primary key, uniquely identifying the record
all_variant_sequence _variantsequence_key serial 10  √  nextval('all_variantsequence_seq'::regclass) primary key, uniquely identifying the record
bib_refs _refs_key serial 10  √  nextval('bib_refs_seq'::regclass) primary key
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)
gxd_allelepair _allelepair_key serial 10  √  nextval('gxd_allelepair_seq'::regclass) primary key
gxd_antibody _antibody_key serial 10  √  nextval('gxd_antibody_seq'::regclass) primary key
gxd_antibodyalias _antibodyalias_key serial 10  √  nextval('gxd_antibodyalias_seq'::regclass) 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_antigen _antigen_key serial 10  √  nextval('gxd_antigen_seq'::regclass) primary key
gxd_assay _assay_key serial 10  √  nextval('gxd_assay_seq'::regclass) primary key
gxd_assaynote _assaynote_key serial 10  √  nextval('gxd_assaynote_seq'::regclass)
gxd_gelband _gelband_key serial 10  √  nextval('gxd_gelband_seq'::regclass) primary key
gxd_gellane _gellane_key serial 10  √  nextval('gxd_gellane_seq'::regclass) primary key
gxd_gellanestructure _gellanestructure_key serial 10  √  nextval('gxd_gellanestructure_seq'::regclass)
gxd_gelrow _gelrow_key serial 10  √  nextval('gxd_gelrow_seq'::regclass) primary key
gxd_genotype _genotype_key serial 10  √  nextval('gxd_genotype_seq'::regclass) primary key
gxd_htsample_rnaseq _rnaseq_key serial 10  √  nextval('gxd_htsample_rnaseq_seq'::regclass) primary key
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 _rnaseqsetmember_key serial 10  √  nextval('gxd_htsample_rnaseqsetmember_seq'::regclass) primary key
gxd_insituresult _result_key serial 10  √  nextval('gxd_insituresult_seq'::regclass) primary key
gxd_insituresultimage _resultimage_key serial 10  √  nextval('gxd_insituresultimage_seq'::regclass)
gxd_isresultstructure _resultstructure_key serial 10  √  nextval('gxd_isresultstructure_seq'::regclass)
gxd_probeprep _probeprep_key serial 10  √  nextval('gxd_probeprep_seq'::regclass) primary key
gxd_specimen _specimen_key serial 10  √  nextval('gxd_specimen_seq'::regclass) primary key
img_image _image_key serial 10  √  nextval('img_image_seq'::regclass) primary key
img_imagepane_assoc _assoc_key serial 10  √  nextval('img_imagepane_assoc_seq'::regclass) primary key
img_imagepane _imagepane_key serial 10  √  nextval('img_imagepane_seq'::regclass) primary key
mgi_reference_assoc _assoc_key serial 10  √  nextval('mgi_reference_assoc_seq'::regclass) primary key
mgi_relationship _relationship_key serial 10  √  nextval('mgi_relationship_seq'::regclass) Primary key
mgi_synonym _synonym_key serial 10  √  nextval('mgi_synonym_seq'::regclass) primary key
mrk_history _assoc_key serial 10  √  nextval('mrk_history_seq'::regclass)
mrk_marker _marker_key serial 10  √  nextval('mrk_marker_seq'::regclass) primary key
prb_source _source_key serial 10  √  nextval('prb_source_seq'::regclass) primary key
prb_strain_genotype _straingenotype_key serial 10  √  nextval('prb_strain_genotype_seq'::regclass) primary key
prb_strain_marker _strainmarker_key serial 10  √  nextval('prb_strain_marker_seq'::regclass) primary key
prb_strain _strain_key serial 10  √  nextval('prb_strain_seq'::regclass) primary key
prb_tissue _tissue_key serial 10  √  nextval('prb_tissue_seq'::regclass) primary key
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
seq_source_assoc _assoc_key serial 10  √  nextval('seq_source_assoc_seq'::regclass) 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_annot _annot_key serial 10  √  nextval('voc_annot_seq'::regclass) primary key
voc_evidence_property _evidenceproperty_key serial 10  √  nextval('voc_evidence_property_seq'::regclass) primary key
voc_evidence _annotevidence_key serial 10  √  nextval('voc_evidence_seq'::regclass) primary key
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)
voc_term _term_key serial 10  √  nextval('voc_term_seq'::regclass) primary key
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"
voc_annotheader approval_date timestamp 29,6  √  now() date record was approved
mrk_cluster cluster_date timestamp 29,6  √  now() Cluster Date
go_tracking completion_date timestamp 29,6  √  now() date GO Tracking was completed
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_mgitype creation_date timestamp 29,6 now() date record was created
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_mutation creation_date timestamp 29,6 now() date record was created
all_cellline creation_date timestamp 29,6 now() date record was created
all_cellline_derivation creation_date timestamp 29,6 now() date record was created
all_cre_cache creation_date timestamp 29,6 now() date record was created
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_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_books creation_date timestamp 29,6 now() date record was created
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_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_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
go_tracking creation_date timestamp 29,6 now() date record was created
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_antibody creation_date timestamp 29,6 now() date record was created
gxd_antibodyalias creation_date timestamp 29,6 now() date record was created
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_antibodytype creation_date timestamp 29,6 now() date record was created
gxd_antigen creation_date timestamp 29,6 now() date record was created
gxd_assay creation_date timestamp 29,6 now() date record was created
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_gelcontrol creation_date timestamp 29,6 now() date record was created
gxd_gellane creation_date timestamp 29,6 now() date record was created
gxd_gellanestructure creation_date timestamp 29,6 now() date record was created
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_gelunits creation_date timestamp 29,6 now() date record was created
gxd_genotype creation_date timestamp 29,6 now() date record was created
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_insituresult creation_date timestamp 29,6 now() date record was created
gxd_insituresultimage creation_date timestamp 29,6 now() date record was created
gxd_isresultstructure creation_date timestamp 29,6 now() date record was created
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_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
gxd_strength creation_date timestamp 29,6 now() date record was created
gxd_theilerstage creation_date timestamp 29,6 now() date record was created
gxd_visualizationmethod creation_date timestamp 29,6 now() date record was created
img_image creation_date timestamp 29,6 now() date record was created
img_imagepane creation_date timestamp 29,6 now() date record was created
img_imagepane_assoc creation_date timestamp 29,6 now() date record was created
map_coord_collection creation_date timestamp 29,6 now() date record was created
map_coord_feature creation_date timestamp 29,6 now() date record was created
map_coordinate creation_date timestamp 29,6 now() date record was created
mgi_dbinfo creation_date timestamp 29,6 now() date record was created
mgi_note creation_date timestamp 29,6 now() date record was created
mgi_notechunk creation_date timestamp 29,6 now() date record was created
mgi_notetype creation_date timestamp 29,6 now() date record was created
mgi_organism creation_date timestamp 29,6 now() date record was created
mgi_organism_mgitype creation_date timestamp 29,6 now() date record was created
mgi_property creation_date timestamp 29,6 now() date record was created
mgi_propertytype creation_date timestamp 29,6 now() date record was created
mgi_refassoctype creation_date timestamp 29,6 now() date record was created
mgi_reference_assoc creation_date timestamp 29,6 now() date record was created
mgi_relationship creation_date timestamp 29,6 now() date record was created
mgi_relationship_category creation_date timestamp 29,6 now() date record was created
mgi_relationship_property creation_date timestamp 29,6 now() date record was created
mgi_roletask creation_date timestamp 29,6 now() date record was created
mgi_set creation_date timestamp 29,6 now() date record was created
mgi_setmember creation_date timestamp 29,6 now() date record was created
mgi_setmember_emapa creation_date timestamp 29,6 now() date record was created
mgi_synonym creation_date timestamp 29,6 now() date record was created
mgi_synonymtype creation_date timestamp 29,6 now() date record was created
mgi_translation creation_date timestamp 29,6 now() date record was created
mgi_translationtype creation_date timestamp 29,6 now() date record was created
mgi_user creation_date timestamp 29,6 now() date record was created
mgi_userrole creation_date timestamp 29,6 now() date record was created
mld_assay_types creation_date timestamp 29,6 now() date record was created
mld_concordance creation_date timestamp 29,6 now() date record was created
mld_contig creation_date timestamp 29,6 now() date record was created
mld_contigprobe creation_date timestamp 29,6 now() date record was created
mld_expt_marker creation_date timestamp 29,6 now() date record was created
mld_expt_notes creation_date timestamp 29,6 now() date record was created
mld_expts creation_date timestamp 29,6 now() date record was created
mld_fish creation_date timestamp 29,6 now() date record was created
mld_fish_region creation_date timestamp 29,6 now() date record was created
mld_hit creation_date timestamp 29,6 now() date record was created
mld_hybrid creation_date timestamp 29,6 now() date record was created
mld_insitu creation_date timestamp 29,6 now() date record was created
mld_isregion creation_date timestamp 29,6 now() date record was created
mld_matrix creation_date timestamp 29,6 now() date record was created
mld_mc2point creation_date timestamp 29,6 now() date record was created
mld_mcdatalist creation_date timestamp 29,6 now() date record was created
mld_notes creation_date timestamp 29,6 now() date record was created
mld_ri creation_date timestamp 29,6 now() date record was created
mld_ri2point creation_date timestamp 29,6 now() date record was created
mld_ridata creation_date timestamp 29,6 now() date record was created
mld_statistics creation_date timestamp 29,6 now() date record was created
mrk_alias creation_date timestamp 29,6 now() date record was created
mrk_anchors creation_date timestamp 29,6 now() date record was created
mrk_biotypemapping creation_date timestamp 29,6 now() date record was created
mrk_chromosome creation_date timestamp 29,6 now() date record was created
mrk_cluster creation_date timestamp 29,6 now() date record was created
mrk_current creation_date timestamp 29,6 now() date record was created
mrk_do_cache creation_date timestamp 29,6 now() date record was created
mrk_event creation_date timestamp 29,6 now() date record was created
mrk_eventreason creation_date timestamp 29,6 now() date record was created
mrk_history creation_date timestamp 29,6 now() date record was created
mrk_label creation_date timestamp 29,6 now() date record was created
mrk_location_cache creation_date timestamp 29,6 now() date record was created
mrk_marker creation_date timestamp 29,6 now() date record was created
mrk_mcv_cache creation_date timestamp 29,6 now() date record was created
mrk_mcv_count_cache creation_date timestamp 29,6 now() date record was created
mrk_notes creation_date timestamp 29,6 now() date record was created
mrk_reference creation_date timestamp 29,6 now() date record was created
mrk_status creation_date timestamp 29,6 now() date record was created
mrk_strainmarker creation_date timestamp 29,6 now() date record was created
mrk_types creation_date timestamp 29,6 now() date record was created
prb_alias creation_date timestamp 29,6 now() date record was created
prb_allele creation_date timestamp 29,6 now() date record was created
prb_allele_strain creation_date timestamp 29,6 now() date record was created
prb_marker creation_date timestamp 29,6 now() date record was created
prb_notes creation_date timestamp 29,6 now() date record was created
prb_probe creation_date timestamp 29,6 now() date record was created
prb_ref_notes creation_date timestamp 29,6 now() date record was created
prb_reference creation_date timestamp 29,6 now() date record was created
prb_rflv creation_date timestamp 29,6 now() date record was created
prb_source creation_date timestamp 29,6 now() date record was created
prb_strain creation_date timestamp 29,6 now() date record was created
prb_strain_genotype creation_date timestamp 29,6 now() date record was created
prb_strain_marker creation_date timestamp 29,6 now() date record was created
prb_tissue creation_date timestamp 29,6 now() date record was created
ri_riset creation_date timestamp 29,6 now() date record was created
ri_summary creation_date timestamp 29,6 now() date record was created
ri_summary_expt_ref creation_date timestamp 29,6 now() date record was created
seq_allele_assoc creation_date timestamp 29,6 now() date record was created
seq_coord_cache creation_date timestamp 29,6 now() date record was created
seq_genemodel creation_date timestamp 29,6 now() date record was created
seq_genetrap creation_date timestamp 29,6 now() date record was created
seq_marker_cache creation_date timestamp 29,6 now() date record was created
seq_probe_cache creation_date timestamp 29,6 now() date record was created
seq_sequence creation_date timestamp 29,6 now() date record was created
seq_sequence_assoc creation_date timestamp 29,6 now() date record was created
seq_sequence_raw creation_date timestamp 29,6 now() date record was created
seq_source_assoc creation_date timestamp 29,6 now() date record was created
voc_annot creation_date timestamp 29,6 now() date record was created
voc_annotheader creation_date timestamp 29,6 now() date record was created
voc_annottype creation_date timestamp 29,6 now() date record was created
voc_evidence creation_date timestamp 29,6 now() date record was created
voc_evidence_property creation_date timestamp 29,6 now() date record was created
voc_term creation_date timestamp 29,6 now() date record was created
voc_term_emapa creation_date timestamp 29,6 now() date record was created
voc_term_emaps creation_date timestamp 29,6 now() date record was created
voc_vocab creation_date timestamp 29,6 now() date record was created
voc_vocabdag creation_date timestamp 29,6 now() date record was created
wks_rosetta creation_date timestamp 29,6 now() date record was created
mrk_history event_date timestamp 29,6  √  now() date of the nomenclature event
pwi_report last_run timestamp 29,6  √  now() None
mgi_dbinfo lastdump_date timestamp 29,6 now() date of last database dump
acc_accession modification_date timestamp 29,6 now() date record was last modified
acc_accessionmax modification_date timestamp 29,6 now() date record was last modified
acc_accessionreference modification_date timestamp 29,6 now() date record was last modified
acc_actualdb modification_date timestamp 29,6 now() date record was last modified
acc_logicaldb modification_date timestamp 29,6 now() date record was last modified
acc_mgitype modification_date timestamp 29,6 now() date record was last modified
all_allele modification_date timestamp 29,6 now() date record was last modified
all_allele_cellline modification_date timestamp 29,6 now() date record was last modified
all_allele_mutation modification_date timestamp 29,6 now() date record was last modified
all_cellline modification_date timestamp 29,6 now() date record was last modified
all_cellline_derivation modification_date timestamp 29,6 now() date record was last modified
all_cre_cache modification_date timestamp 29,6 now() date record was last modified
all_knockout_cache modification_date timestamp 29,6 now() date record was last modified
all_label modification_date timestamp 29,6 now() date record was last modified
all_variant modification_date timestamp 29,6 now() date record was last modified
all_variant_sequence modification_date timestamp 29,6 now() date record was last modified
bib_books modification_date timestamp 29,6 now() date record was last modified
bib_notes modification_date timestamp 29,6 now() date record was last modified
bib_refs modification_date timestamp 29,6 now() date record was last modified
bib_workflow_data modification_date timestamp 29,6 now() date record was last modified
bib_workflow_status modification_date timestamp 29,6 now() date record was last modified
bib_workflow_tag modification_date timestamp 29,6 now() date record was last modified
crs_cross modification_date timestamp 29,6 now() date record was last modified
crs_matrix modification_date timestamp 29,6 now() date record was last modified
crs_progeny modification_date timestamp 29,6 now() date record was last modified
crs_references modification_date timestamp 29,6 now() date record was last modified
crs_typings modification_date timestamp 29,6 now() date record was last modified
dag_closure modification_date timestamp 29,6 now() date record was last modified
dag_dag modification_date timestamp 29,6 now() date record was last modified
dag_edge modification_date timestamp 29,6 now() date record was last modified
dag_label modification_date timestamp 29,6 now() date record was last modified
dag_node modification_date timestamp 29,6 now() date record was last modified
go_tracking modification_date timestamp 29,6 now() date record was last modified
gxd_allelegenotype modification_date timestamp 29,6 now() date record was last modified
gxd_allelepair modification_date timestamp 29,6 now() date record was last modified
gxd_antibody modification_date timestamp 29,6 now() date record was last modified
gxd_antibodyalias modification_date timestamp 29,6 now() date record was last modified
gxd_antibodyclass modification_date timestamp 29,6 now() date record was last modified
gxd_antibodymarker modification_date timestamp 29,6 now() date record was last modified
gxd_antibodyprep modification_date timestamp 29,6 now() date record was last modified
gxd_antibodytype modification_date timestamp 29,6 now() date record was last modified
gxd_antigen modification_date timestamp 29,6 now() date record was last modified
gxd_assay modification_date timestamp 29,6 now() date record was last modified
gxd_assaynote modification_date timestamp 29,6 now() date record was last modified
gxd_assaytype modification_date timestamp 29,6 now() date record was last modified
gxd_embeddingmethod modification_date timestamp 29,6 now() date record was last modified
gxd_expression modification_date timestamp 29,6 now() date record was last modified
gxd_fixationmethod modification_date timestamp 29,6 now() date record was last modified
gxd_gelband modification_date timestamp 29,6 now() date record was last modified
gxd_gelcontrol modification_date timestamp 29,6 now() date record was last modified
gxd_gellane modification_date timestamp 29,6 now() date record was last modified
gxd_gellanestructure modification_date timestamp 29,6 now() date record was last modified
gxd_gelrnatype modification_date timestamp 29,6 now() date record was last modified
gxd_gelrow modification_date timestamp 29,6 now() date record was last modified
gxd_gelunits modification_date timestamp 29,6 now() date record was last modified
gxd_genotype modification_date timestamp 29,6 now() date record was last modified
gxd_htexperiment modification_date timestamp 29,6 now() date record was last modified
gxd_htsample modification_date timestamp 29,6 now() date record was last modified
gxd_htsample_rnaseq modification_date timestamp 29,6 now() date record was last modified
gxd_htsample_rnaseqcombined modification_date timestamp 29,6 now() date record was last modified
gxd_htsample_rnaseqset modification_date timestamp 29,6 now() date record was last modified
gxd_htsample_rnaseqsetmember modification_date timestamp 29,6 now() date record was last modified
gxd_index modification_date timestamp 29,6 now() date record was last modified
gxd_index_stages modification_date timestamp 29,6 now() date record was last modified
gxd_insituresult modification_date timestamp 29,6 now() date record was last modified
gxd_insituresultimage modification_date timestamp 29,6 now() date record was last modified
gxd_isresultstructure modification_date timestamp 29,6 now() date record was last modified
gxd_label modification_date timestamp 29,6 now() date record was last modified
gxd_pattern modification_date timestamp 29,6 now() date record was last modified
gxd_probeprep modification_date timestamp 29,6 now() date record was last modified
gxd_probesense modification_date timestamp 29,6 now() date record was last modified
gxd_secondary modification_date timestamp 29,6 now() date record was last modified
gxd_specimen modification_date timestamp 29,6 now() date record was last modified
gxd_strength modification_date timestamp 29,6 now() date record was last modified
gxd_theilerstage modification_date timestamp 29,6 now() date record was last modified
gxd_visualizationmethod modification_date timestamp 29,6 now() date record was last modified
img_image modification_date timestamp 29,6 now() date record was last modified
img_imagepane modification_date timestamp 29,6 now() date record was last modified
img_imagepane_assoc modification_date timestamp 29,6 now() date record was last modified
map_coord_collection modification_date timestamp 29,6 now() date record was last modified
map_coord_feature modification_date timestamp 29,6 now() date record was last modified
map_coordinate modification_date timestamp 29,6 now() date record was last modified
mgi_dbinfo modification_date timestamp 29,6 now() date record was last modified
mgi_note modification_date timestamp 29,6 now() date record was last modified
mgi_notechunk modification_date timestamp 29,6 now() date record was last modified
mgi_notetype modification_date timestamp 29,6 now() date record was last modified
mgi_organism modification_date timestamp 29,6 now() date record was last modified
mgi_organism_mgitype modification_date timestamp 29,6 now() date record was last modified
mgi_property modification_date timestamp 29,6 now() date record was last modified
mgi_propertytype modification_date timestamp 29,6 now() date record was last modified
mgi_refassoctype modification_date timestamp 29,6 now() date record was last modified
mgi_reference_assoc modification_date timestamp 29,6 now() date record was last modified
mgi_relationship modification_date timestamp 29,6 now() date record was last modified
mgi_relationship_category modification_date timestamp 29,6 now() date record was last modified
mgi_relationship_property modification_date timestamp 29,6 now() date record was last modified
mgi_roletask modification_date timestamp 29,6 now() date record was last modified
mgi_set modification_date timestamp 29,6 now() date record was last modified
mgi_setmember modification_date timestamp 29,6 now() date record was last modified
mgi_setmember_emapa modification_date timestamp 29,6 now() date record was last modified
mgi_synonym modification_date timestamp 29,6 now() date record was last modified
mgi_synonymtype modification_date timestamp 29,6 now() date record was last modified
mgi_translation modification_date timestamp 29,6 now() date record was last modified
mgi_translationtype modification_date timestamp 29,6 now() date record was last modified
mgi_user modification_date timestamp 29,6 now() date record was last modified
mgi_userrole modification_date timestamp 29,6 now() date record was last modified
mld_assay_types modification_date timestamp 29,6 now() date record was last modified
mld_concordance modification_date timestamp 29,6 now() date record was last modified
mld_contig modification_date timestamp 29,6 now() date record was last modified
mld_contigprobe modification_date timestamp 29,6 now() date record was last modified
mld_expt_marker modification_date timestamp 29,6 now() date record was last modified
mld_expt_notes modification_date timestamp 29,6 now() date record was last modified
mld_expts modification_date timestamp 29,6 now() date record was last modified
mld_fish modification_date timestamp 29,6 now() date record was last modified
mld_fish_region modification_date timestamp 29,6 now() date record was last modified
mld_hit modification_date timestamp 29,6 now() date record was last modified
mld_hybrid modification_date timestamp 29,6 now() date record was last modified
mld_insitu modification_date timestamp 29,6 now() date record was last modified
mld_isregion modification_date timestamp 29,6 now() date record was last modified
mld_matrix modification_date timestamp 29,6 now() date record was last modified
mld_mc2point modification_date timestamp 29,6 now() date record was last modified
mld_mcdatalist modification_date timestamp 29,6 now() date record was last modified
mld_notes modification_date timestamp 29,6 now() date record was last modified
mld_ri modification_date timestamp 29,6 now() date record was last modified
mld_ri2point modification_date timestamp 29,6 now() date record was last modified
mld_ridata modification_date timestamp 29,6 now() date record was last modified
mld_statistics modification_date timestamp 29,6 now() date record was last modified
mrk_alias modification_date timestamp 29,6 now() date record was last modified
mrk_anchors modification_date timestamp 29,6 now() date record was last modified
mrk_biotypemapping modification_date timestamp 29,6 now() date record was last modified
mrk_chromosome modification_date timestamp 29,6 now() date record was last modified
mrk_cluster modification_date timestamp 29,6 now() date record was last modified
mrk_current modification_date timestamp 29,6 now() date record was last modified
mrk_do_cache modification_date timestamp 29,6 now() date record was last modified
mrk_event modification_date timestamp 29,6 now() date record was last modified
mrk_eventreason modification_date timestamp 29,6 now() date record was last modified
mrk_history modification_date timestamp 29,6 now() date record was last modified
mrk_label modification_date timestamp 29,6 now() date record was last modified
mrk_location_cache modification_date timestamp 29,6 now() date record was last modified
mrk_marker modification_date timestamp 29,6 now() date record was last modified
mrk_mcv_cache modification_date timestamp 29,6 now() date record was last modified
mrk_mcv_count_cache modification_date timestamp 29,6 now() date record was last modified
mrk_notes modification_date timestamp 29,6 now() date record was last modified
mrk_reference modification_date timestamp 29,6 now() date record was last modified
mrk_status modification_date timestamp 29,6 now() date record was last modified
mrk_strainmarker modification_date timestamp 29,6 now() date record was last modified
mrk_types modification_date timestamp 29,6 now() date record was last modified
prb_alias modification_date timestamp 29,6 now() date record was last modified
prb_allele modification_date timestamp 29,6 now() date record was last modified
prb_allele_strain modification_date timestamp 29,6 now() date record was last modified
prb_marker modification_date timestamp 29,6 now() date record was last modified
prb_notes modification_date timestamp 29,6 now() date record was last modified
prb_probe modification_date timestamp 29,6 now() date record was last modified
prb_ref_notes modification_date timestamp 29,6 now() date record was last modified
prb_reference modification_date timestamp 29,6 now() date record was last modified
prb_rflv modification_date timestamp 29,6 now() date record was last modified
prb_source modification_date timestamp 29,6 now() date record was last modified
prb_strain modification_date timestamp 29,6 now() date record was last modified
prb_strain_genotype modification_date timestamp 29,6 now() date record was last modified
prb_strain_marker modification_date timestamp 29,6 now() date record was last modified
prb_tissue modification_date timestamp 29,6 now() date record was last modified
ri_riset modification_date timestamp 29,6 now() date record was last modified
ri_summary modification_date timestamp 29,6 now() date record was last modified
ri_summary_expt_ref modification_date timestamp 29,6 now() date record was last modified
seq_allele_assoc modification_date timestamp 29,6 now() date record was last modified
seq_coord_cache modification_date timestamp 29,6 now() date record was last modified
seq_genemodel modification_date timestamp 29,6 now() date record was last modified
seq_genetrap modification_date timestamp 29,6 now() date record was last modified
seq_marker_cache modification_date timestamp 29,6 now() date record was last modified
seq_probe_cache modification_date timestamp 29,6 now() date record was last modified
seq_sequence modification_date timestamp 29,6 now() date record was last modified
seq_sequence_assoc modification_date timestamp 29,6 now() date record was last modified
seq_sequence_raw modification_date timestamp 29,6 now() date record was last modified
seq_source_assoc modification_date timestamp 29,6 now() date record was last modified
voc_annot modification_date timestamp 29,6 now() date record was last modified
voc_annotheader modification_date timestamp 29,6 now() date record was last modified
voc_annottype modification_date timestamp 29,6 now() date record was last modified
voc_evidence modification_date timestamp 29,6 now() date record was last modified
voc_evidence_property modification_date timestamp 29,6 now() date record was last modified
voc_term modification_date timestamp 29,6 now() date record was last modified
voc_term_emapa modification_date timestamp 29,6 now() date record was last modified
voc_term_emaps modification_date timestamp 29,6 now() date record was last modified
voc_vocab modification_date timestamp 29,6 now() date record was last modified
voc_vocabdag modification_date timestamp 29,6 now() date record was last modified
wks_rosetta modification_date timestamp 29,6 now() date record was last modified
seq_sequence seqrecord_date timestamp 29,6 now() last modification date of the sequence record from the provider
seq_sequence sequence_date timestamp 29,6 now() last modification date of the sequence itself
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
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_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_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_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_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_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_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_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_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_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_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_view _assoc_key int4 10  √  null
all_allele_mutation_view _assoc_key int4 10  √  null
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_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_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_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
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_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_logicaldb_view _createdby_key int4 10  √  null
acc_view _createdby_key int4 10  √  null
all_acc_view _createdby_key int4 10  √  null
all_allele_cellline_view _createdby_key int4 10  √  null
all_allele_view _createdby_key int4 10  √  null
all_cellline_acc_view _createdby_key int4 10  √  null
all_cellline_derivation_view _createdby_key int4 10  √  null
all_cellline_view _createdby_key int4 10  √  null
all_summary_view _createdby_key int4 10  √  null
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_summary_all_view _createdby_key int4 10  √  null
bib_view _createdby_key int4 10  √  null
go_tracking_view _createdby_key int4 10  √  null
gxd_allelepair_view _createdby_key int4 10  √  null
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_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_acc_view _createdby_key int4 10  √  null
gxd_assay_view _createdby_key int4 10  √  null
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_index_view _createdby_key int4 10  √  null
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_view _createdby_key int4 10  √  null
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_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_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_view _createdby_key int4 10  √  null
mgi_organism_probe_view _createdby_key int4 10  √  null
mgi_organism_view _createdby_key int4 10  √  null
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_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_markertss_view _createdby_key int4 10  √  null
mgi_roletask_view _createdby_key int4 10  √  null
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_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_view _createdby_key int4 10  √  null
mgi_translationstrain_view _createdby_key int4 10  √  null
mgi_user_active_view _createdby_key int4 10  √  null
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_history_view _createdby_key int4 10  √  null
mrk_marker_view _createdby_key int4 10  √  null
mrk_mouse_view _createdby_key int4 10  √  null
mrk_nonmouse_view _createdby_key int4 10  √  null
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_probe_view _createdby_key int4 10  √  null
prb_reference_view _createdby_key int4 10  √  null
prb_rflv_view _createdby_key int4 10  √  null
prb_source_acc_view _createdby_key int4 10  √  null
prb_source_view _createdby_key int4 10  √  null
prb_strain_acc_view _createdby_key int4 10  √  null
prb_strain_genotype_view _createdby_key int4 10  √  null
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_view _createdby_key int4 10  √  null
seq_sequence_acc_view _createdby_key int4 10  √  null
seq_sequence_view _createdby_key int4 10  √  null
seq_summary_view _createdby_key int4 10  √  null
voc_annotheader_view _createdby_key int4 10  √  null
voc_evidence_view _createdby_key int4 10  √  null
voc_evidenceproperty_view _createdby_key int4 10  √  null
voc_term_acc_view _createdby_key int4 10  √  null
voc_term_cellline_view _createdby_key int4 10  √  null
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_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_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_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_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_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_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_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_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_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_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_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_logicaldb_view _modifiedby_key int4 10  √  null
acc_view _modifiedby_key int4 10  √  null
all_acc_view _modifiedby_key int4 10  √  null
all_allele_cellline_view _modifiedby_key int4 10  √  null
all_allele_view _modifiedby_key int4 10  √  null
all_cellline_acc_view _modifiedby_key int4 10  √  null
all_cellline_derivation_view _modifiedby_key int4 10  √  null
all_cellline_view _modifiedby_key int4 10  √  null
all_summary_view _modifiedby_key int4 10  √  null
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_summary_all_view _modifiedby_key int4 10  √  null
bib_view _modifiedby_key int4 10  √  null
go_tracking_view _modifiedby_key int4 10  √  null
gxd_allelepair_view _modifiedby_key int4 10  √  null
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_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_acc_view _modifiedby_key int4 10  √  null
gxd_assay_view _modifiedby_key int4 10  √  null
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_index_view _modifiedby_key int4 10  √  null
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_view _modifiedby_key int4 10  √  null
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_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_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_view _modifiedby_key int4 10  √  null
mgi_organism_probe_view _modifiedby_key int4 10  √  null
mgi_organism_view _modifiedby_key int4 10  √  null
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_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_markertss_view _modifiedby_key int4 10  √  null
mgi_roletask_view _modifiedby_key int4 10  √  null
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_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_view _modifiedby_key int4 10  √  null
mgi_translationstrain_view _modifiedby_key int4 10  √  null
mgi_user_active_view _modifiedby_key int4 10  √  null
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_history_view _modifiedby_key int4 10  √  null
mrk_marker_view _modifiedby_key int4 10  √  null
mrk_mouse_view _modifiedby_key int4 10  √  null
mrk_nonmouse_view _modifiedby_key int4 10  √  null
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_probe_view _modifiedby_key int4 10  √  null
prb_reference_view _modifiedby_key int4 10  √  null
prb_rflv_view _modifiedby_key int4 10  √  null
prb_source_acc_view _modifiedby_key int4 10  √  null
prb_source_view _modifiedby_key int4 10  √  null
prb_strain_acc_view _modifiedby_key int4 10  √  null
prb_strain_genotype_view _modifiedby_key int4 10  √  null
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_view _modifiedby_key int4 10  √  null
seq_sequence_acc_view _modifiedby_key int4 10  √  null
seq_sequence_view _modifiedby_key int4 10  √  null
seq_summary_view _modifiedby_key int4 10  √  null
voc_annotheader_view _modifiedby_key int4 10  √  null
voc_evidence_view _modifiedby_key int4 10  √  null
voc_evidenceproperty_view _modifiedby_key int4 10  √  null
voc_term_acc_view _modifiedby_key int4 10  √  null
voc_term_cellline_view _modifiedby_key int4 10  √  null
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
bib_all2_view _primary text 2147483647  √  null
bib_all_view _primary text 2147483647  √  null
bib_refs _primary text 2147483647  √  null primary author; extracted from authors field
bib_view _primary text 2147483647  √  null
mld_concordance_view _primary text 2147483647  √  null
mld_expt_marker_view _primary text 2147483647  √  null
mld_expt_view _primary text 2147483647  √  null
mld_fish_view _primary text 2147483647  √  null
mld_hybrid_view _primary text 2147483647  √  null
mld_insitu_view _primary text 2147483647  √  null
mld_matrix_view _primary text 2147483647  √  null
mld_mc2point_view _primary text 2147483647  √  null
mld_ri2point_view _primary text 2147483647  √  null
mld_ri_view _primary text 2147483647  √  null
mld_ridata_view _primary text 2147483647  √  null
mld_statistics_view _primary text 2147483647  √  null
pwi_bib_refs_view _primary text 2147483647  √  null
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_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_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_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_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_isresultimage_view _resultimage_key int4 10  √  null
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 _rnaseqcombined_key int4 10 foreign key to GXD_HTSample_RNASeqCombined
gxd_htsample_rnaseqsetmember _rnaseqset_key int4 10 foreign key to GXD_HTSample_RNASeq, identifing the set
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_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_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_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_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_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_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_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
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_sequence _variant_key int4 10 foreign key to ALL_Variant_Variant, identifying the variant with this sequence
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
mld_ri_view abbrev1 text 2147483647  √  null
ri_riset abbrev1 text 2147483647 Strain 1 Abbreviation
ri_riset_view abbrev1 text 2147483647  √  null
mld_ri_view abbrev2 text 2147483647  √  null
ri_riset abbrev2 text 2147483647 Strain 2 Abbreviation
ri_riset_view abbrev2 text 2147483647  √  null
crs_cross abbrevho text 2147483647  √  null strain abbreviation for homozygous strain
crs_cross_view abbrevho text 2147483647  √  null
mld_matrix_view abbrevho text 2147483647  √  null
crs_cross abbrevht text 2147483647  √  null strain abbreviation for heterozygous strain
crs_cross_view abbrevht text 2147483647  √  null
mld_matrix_view abbrevht text 2147483647  √  null
dag_dag abbreviation bpchar 5 abbreviated name
map_coord_collection abbreviation text 2147483647 short version of name
map_coordinate abbreviation text 2147483647  √  null short version of name
voc_term abbreviation text 2147483647  √  null abbervated term
voc_term_cellline_view abbreviation text 2147483647  √  null
voc_term_mcv_view abbreviation text 2147483647  √  null
voc_term_repqualifier_view abbreviation text 2147483647  √  null
voc_term_strainallele_view abbreviation text 2147483647  √  null
voc_term_strainspecies_view abbreviation text 2147483647  √  null
voc_term_view abbreviation text 2147483647  √  null
bib_all2_view abstract text 2147483647  √  null
bib_all_view abstract text 2147483647  √  null
bib_refs abstract text 2147483647  √  null NLM (Medline) abstract
bib_view abstract text 2147483647  √  null
pwi_bib_refs_view abstract text 2147483647  √  null
acc_accession accid text 2147483647 the full accession number string
acc_view accid text 2147483647  √  null
all_acc_view accid text 2147483647  √  null
all_cellline_acc_view accid text 2147483647  √  null
all_cre_cache accid text 2147483647 accession id
all_derivation_summary_view accid text 2147483647  √  null
all_summary_view accid text 2147483647  √  null
bib_acc_view accid text 2147483647  √  null
bib_summary_all_view accid text 2147483647  √  null
gxd_antibody_acc_view accid text 2147483647  √  null
gxd_antibodyprep_view accid text 2147483647  √  null
gxd_antigen_acc_view accid text 2147483647  √  null
gxd_antigen_summary_view accid text 2147483647  √  null
gxd_assay_acc_view accid text 2147483647  √  null
gxd_genotype_acc_view accid text 2147483647  √  null
gxd_genotype_summary_view accid text 2147483647  √  null
gxd_probeprep_view accid text 2147483647  √  null
img_image_acc_view accid text 2147483647  √  null
img_image_summary_view accid text 2147483647  √  null
mgi_organism_acc_view accid text 2147483647  √  null
mgi_organism_summary_view accid text 2147483647  √  null
mgi_reference_allele_view accid text 2147483647  √  null
mgi_reference_marker_view accid text 2147483647  √  null
mgi_reference_strain_view accid text 2147483647  √  null
mld_acc_view accid text 2147483647  √  null
mld_expt_marker_view accid text 2147483647  √  null
mld_summary_view accid text 2147483647  √  null
mrk_acc_view accid text 2147483647  √  null
mrk_accnoref_view accid text 2147483647  √  null
mrk_accref1_view accid text 2147483647  √  null
mrk_accref2_view accid text 2147483647  √  null
mrk_accref_view accid text 2147483647  √  null
mrk_nonmouse_view accid text 2147483647  √  null
mrk_summary_view accid text 2147483647  √  null
prb_acc_view accid text 2147483647  √  null
prb_accnoref_view accid text 2147483647  √  null
prb_accref_view accid text 2147483647  √  null
prb_accrefnoseq_view accid text 2147483647  √  null
prb_parent_view accid text 2147483647  √  null
prb_source_acc_view accid text 2147483647  √  null
prb_source_summary_view accid text 2147483647  √  null
prb_strain_acc_view accid text 2147483647  √  null
prb_strain_summary_view accid text 2147483647  √  null
prb_tissue_summary_view accid text 2147483647  √  null
seq_allele_assoc_view accid text 2147483647  √  null
seq_marker_cache accid varchar 30 accession id of the Sequence
seq_sequence_acc_view accid text 2147483647  √  null
seq_summary_view accid text 2147483647  √  null
voc_annot_view accid text 2147483647  √  null
voc_go_cache accid text 2147483647 GO accession id of the Term (GO:xxxxx)
voc_term_acc_view accid text 2147483647  √  null
voc_term_mcv_view accid text 2147483647  √  null
voc_term_summary_view accid text 2147483647  √  null
voc_term_view accid text 2147483647  √  null
prb_parent_view accnumeric int4 10  √  null
prb_parent_view accprefix text 2147483647  √  null
acc_actualdb active int2 5 should the link be constructed? yes (1), no (0)
acc_view actualdb text 2147483647  √  null
all_cre_cache age text 2147483647  √  null age of anatomical structure
gxd_antibodyantigen_view age text 2147483647  √  null
gxd_antigen_view age text 2147483647  √  null
gxd_expression age text 2147483647 age of anatomical structure
gxd_gellane age text 2147483647 age of animal
gxd_gellane_view age text 2147483647  √  null
gxd_htsample age text 2147483647  √  null textual age of the sample
gxd_htsample_rnaseqset age text 2147483647 textual age
gxd_specimen age text 2147483647 age of embryo or animal
gxd_specimen_view age text 2147483647  √  null
prb_source age text 2147483647 age of source
prb_source_view age text 2147483647  √  null
all_cre_cache agemax numeric 131089  √  null maximum age value determined by age field
gxd_expression agemax numeric 131089  √  null maximum age value determined by age field
gxd_gellane agemax numeric 131089  √  null maximum age range determined by age field; system calculated
gxd_gellane_view agemax numeric 131089  √  null
gxd_htsample agemax numeric 131089  √  null
gxd_specimen agemax numeric 131089  √  null maximum age range determined by age field; system calculated
gxd_specimen_view agemax numeric 131089  √  null
prb_source agemax numeric 131089 maximum age range determined by age field; system calculated
prb_source_view agemax numeric 131089  √  null
all_cre_cache agemin numeric 131089  √  null minimum age value determined by age field
gxd_expression agemin numeric 131089  √  null minimum age value determined by age field
gxd_gellane agemin numeric 131089  √  null minimum age range determined by age field; system calculated
gxd_gellane_view agemin numeric 131089  √  null
gxd_htsample agemin numeric 131089  √  null
gxd_specimen agemin numeric 131089  √  null minimum age range determined by age field; system calculated
gxd_specimen_view agemin numeric 131089  √  null
prb_source agemin numeric 131089 minimum age range determined by age field; system calculated
prb_source_view agemin numeric 131089  √  null
gxd_gellane agenote text 2147483647  √  null age notes
gxd_gellane_view agenote text 2147483647  √  null
gxd_specimen agenote text 2147483647  √  null age notes
gxd_specimen_view agenote text 2147483647  √  null
gxd_antibodyalias alias text 2147483647 alias name
gxd_antibodyalias_view alias text 2147483647  √  null
gxd_antibodyaliasref_view alias text 2147483647  √  null
mrk_alias_view alias text 2147483647  √  null
prb_alias alias text 2147483647 alias name
mld_expt_marker_view allele text 2147483647  √  null
prb_allele allele text 2147483647 arbitrary symbol assigned to the RFLV pair/fragment size. no correlation to phenotypic allele symbols.
prb_rflv_view allele text 2147483647  √  null
gxd_allelepair_view allele1 text 2147483647  √  null
gxd_allelepair_view allele2 text 2147483647  √  null
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
seq_allele_view alleleid text 2147483647  √  null
mld_mcdatalist alleleline text 2147483647 haplotypes for marker; order of alleles must correspond with order of Markers in Experiment Marker list (MLD_Expt_Marker)
mld_ridata alleleline text 2147483647 haplotypes for marker; must correspond with listing of animals typed (MLD_RI.RI_IDList)
mld_ridata_view alleleline text 2147483647  √  null
gxd_allelepair_view allelestate text 2147483647  √  null
prb_strain_marker_view allelesymbol text 2147483647  √  null
all_cre_cache alleletype text 2147483647 allele type name (VOC_Term.term) via ALL_Allele._AlleleType_key = VOC_Term._Term_key
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
voc_annot_count_cache annotcount int4 10 count of annotations of the given annotType to the given _Term_key
voc_allele_cache annottype text 2147483647 see table description for details
voc_annot_count_cache annottype text 2147483647 the type of annotation we are considering in this record
voc_annot_view annottype text 2147483647  √  null
voc_marker_cache annottype text 2147483647 see table description for details
gxd_antibody antibodyname text 2147483647 name of Antibody
gxd_antibody_view antibodyname text 2147483647  √  null
gxd_antibodyalias_view antibodyname text 2147483647  √  null
gxd_antibodyaliasref_view antibodyname text 2147483647  √  null
gxd_antibodyantigen_view antibodyname text 2147483647  √  null
gxd_antibodymarker_view antibodyname text 2147483647  √  null
gxd_antibodyprep_view antibodyname text 2147483647  √  null
gxd_antibody antibodynote text 2147483647  √  null note
gxd_antibody_view antibodynote text 2147483647  √  null
gxd_antibody_view antibodyspecies text 2147483647  √  null
gxd_antibody_view antibodytype text 2147483647  √  null
gxd_antibodytype antibodytype text 2147483647 antibody type description
gxd_antibody_view antigenname text 2147483647  √  null
gxd_antibodyantigen_view antigenname text 2147483647  √  null
gxd_antigen antigenname text 2147483647 antigen name
gxd_antigen_view antigenname text 2147483647  √  null
gxd_antibody_view antigennote text 2147483647  √  null
gxd_antibodyantigen_view antigennote text 2147483647  √  null
gxd_antigen antigennote text 2147483647  √  null textual information
gxd_antigen_view antigennote text 2147483647  √  null
bib_status_view ap_status text 2147483647  √  null
all_allele_view approval_date timestamp 29,6  √  null
pwi_all_allele_view approval_date timestamp 29,6  √  null
voc_annotheader_view approval_date timestamp 29,6  √  null
all_allele_view approvedby text 2147483647  √  null
voc_annotheader_view approvedby text 2147483647  √  null
mld_expt_marker_view assay text 2147483647  √  null
gxd_assaynote assaynote text 2147483647 note
gxd_assay_view assaytype text 2147483647  √  null
gxd_assaytype assaytype text 2147483647 assay type description
mgi_refassoctype assoctype text 2147483647 name of this reference association type (ex. "General").
mgi_reference_allele_view assoctype text 2147483647  √  null
mgi_reference_allelevariant_view assoctype text 2147483647  √  null
mgi_reference_antibody_view assoctype text 2147483647  √  null
mgi_reference_marker_view assoctype text 2147483647  √  null
mgi_reference_sequence_view assoctype text 2147483647  √  null
mgi_reference_strain_view assoctype text 2147483647  √  null
mgi_reftype_allele_view assoctype text 2147483647  √  null
mgi_reftype_antibody_view assoctype text 2147483647  √  null
mgi_reftype_marker_view assoctype text 2147483647  √  null
mgi_reftype_sequence_view assoctype text 2147483647  √  null
mgi_reftype_strain_view assoctype text 2147483647  √  null
bib_all2_view authors text 2147483647  √  null
bib_all_view authors text 2147483647  √  null
bib_refs authors text 2147483647  √  null reference authors
bib_view authors text 2147483647  √  null
mld_concordance_view authors text 2147483647  √  null
mld_expt_marker_view authors text 2147483647  √  null
mld_expt_view authors text 2147483647  √  null
mld_fish_view authors text 2147483647  √  null
mld_hybrid_view authors text 2147483647  √  null
mld_insitu_view authors text 2147483647  √  null
mld_matrix_view authors text 2147483647  √  null
mld_mc2point_view authors text 2147483647  √  null
mld_ri2point_view authors text 2147483647  √  null
mld_ri_view authors text 2147483647  √  null
mld_ridata_view authors text 2147483647  √  null
mld_statistics_view authors text 2147483647  √  null
pwi_bib_refs_view authors text 2147483647  √  null
gxd_htsample_rnaseqcombined averagequantilenormalizedtpm numeric 131089 the average quantile normlized TPM
gxd_htsample_rnaseq averagetpm numeric 131089 the average TPM of the sample
mgi_translation badname text 2147483647 bad name to translate
mgi_translation_view badname text 2147483647  √  null
mgi_translationstrain_view badname text 2147483647  √  null
mld_fish band text 2147483647  √  null cytogenetic position on chromosome to which marker is assigned
mld_fish_view band text 2147483647  √  null
mld_hybrid band text 2147483647  √  null region on chromosome to which marker is assigned according to experimental results
mld_hybrid_view band text 2147483647  √  null
mld_insitu band text 2147483647  √  null cytogenetic position on chromosome to which marker is assigned
mld_insitu_view band text 2147483647  √  null
gxd_gelband bandnote text 2147483647  √  null textual information
gxd_gelband_view bandnote text 2147483647  √  null
bib_books book_au text 2147483647  √  null author
bib_books book_title text 2147483647  √  null title
mgi_relationship_markertss_view categoryterm text 2147483647  √  null
all_allele_cellline_view cellline text 2147483647  √  null
all_cellline cellline text 2147483647 ES cell line
all_cellline_view cellline text 2147483647  √  null
prb_source_view cellline text 2147483647  √  null
all_allele_cellline_view celllinestrain text 2147483647  √  null
all_cellline_view celllinestrain text 2147483647  √  null
all_allele_cellline_view celllinestrain_key int4 10  √  null
all_cellline_view celllinetype text 2147483647  √  null
mld_fish cellorigin text 2147483647  √  null cell type from which analyzed metaphase spreads were derived
mld_fish_view cellorigin text 2147483647  √  null
mld_insitu cellorigin text 2147483647  √  null cell type from which analyzed metaphase spreads were derived
mld_insitu_view cellorigin text 2147483647  √  null
crs_matrix chromosome text 2147483647 chromosome on which Marker is located (may disagree with MGD)
gxd_allelepair_view chromosome text 2147483647  √  null
gxd_antibodymarker_view chromosome text 2147483647  √  null
gxd_assay_view chromosome text 2147483647  √  null
mld_concordance chromosome text 2147483647  √  null chromosome value; is NULL if _Marker_key is not NULL
mld_concordance_view chromosome text 2147483647  √  null
mld_expt_marker_view chromosome text 2147483647  √  null
mld_expt_view chromosome text 2147483647  √  null
mld_expts chromosome text 2147483647 chromosome value
mrk_anchors chromosome text 2147483647 marker chromosome
mrk_anchors_view chromosome text 2147483647  √  null
mrk_chromosome chromosome text 2147483647 chromosome value
mrk_current_view chromosome text 2147483647  √  null
mrk_location_cache chromosome text 2147483647 chromosome
mrk_marker chromosome text 2147483647 chromosome
mrk_marker_view chromosome text 2147483647  √  null
mrk_mouse_view chromosome text 2147483647  √  null
mrk_nonmouse_view chromosome text 2147483647  √  null
prb_marker_view chromosome text 2147483647  √  null
prb_rflv_view chromosome text 2147483647  √  null
prb_strain_marker_view chromosome text 2147483647  √  null
pwi_mrk_marker_view chromosome text 2147483647  √  null
seq_coord_cache chromosome text 2147483647 chromosome on which the sequence resides
mld_hybrid chrsorgenes int2 5 does MLD_Concordance table contain Chromosome (0) or Marker (1) values?
mld_hybrid_view chrsorgenes int2 5  √  null
all_allele_view citation text 2147483647  √  null
bib_all2_view citation text 2147483647  √  null
bib_all_view citation text 2147483647  √  null