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
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_view _alias_key int4 10  √  null
all_allele_cellline_view _allele_key int4 10  √  null
all_allele_driver_view _allele_key int4 10  √  null
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_genotype_view _allele_key int4 10  √  null
all_knockout_cache _allele_key int4 10  √  null 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_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_view _allele_key int4 10  √  null
seq_allele_view _allele_key int4 10  √  null
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_view _allele_status_key int4 10  √  null
pwi_all_allele_view _allele_status_key int4 10  √  null
all_allele_view _allele_type_key int4 10  √  null
pwi_all_allele_view _allele_type_key int4 10  √  null
gxd_allelepair_view _allelepair_key int4 10  √  null
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_view _annot_key int4 10  √  null
voc_evidence_view _annotevidence_key int4 10  √  null
voc_evidenceproperty_view _annotevidence_key int4 10  √  null
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_view _annottype_key int4 10  √  null
voc_annotheader_view _annottype_key int4 10  √  null
gxd_antibody_view _antibody_key int4 10  √  null
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_view _antibody_key int4 10  √  null
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_view _antibodyclass_key int4 10  √  null
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_view _antibodytype_key int4 10  √  null
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_gelband_view _assay_key int4 10  √  null
gxd_gellane_view _assay_key int4 10  √  null
gxd_gellanestructure_view _assay_key int4 10  √  null
gxd_gelrow_view _assay_key int4 10  √  null
gxd_probeprep_view _assay_key int4 10  √  null
gxd_specimen_view _assay_key int4 10  √  null
mld_expt_marker_view _assay_type_key int4 10  √  null
gxd_assay_view _assaytype_key int4 10  √  null
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_view _assoc_key int4 10  √  null
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_view _cellline_key int4 10  √  null
all_cellline_view _cellline_type_key int4 10  √  null
all_allele_view _collection_key int4 10  √  null
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_view _compound_key int4 10  √  null
gxd_index_view _conditionalmutants_key int4 10  √  null
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_view _creator_key int4 10  √  null
all_cellline_view _creator_key int4 10  √  null
crs_cross_view _cross_key int4 10  √  null
mld_matrix_view _cross_key int4 10  √  null
mrk_current_view _current_key int4 10  √  null
dag_node_view _dag_key int4 10  √  null
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_view _derivationtype_key int4 10  √  null
all_cellline_view _derivationtype_key int4 10  √  null
gxd_htsample _emapa_key int4 10  √  null foreign key to VOC_Term, identifying the EMAPA structure for this sample
all_cre_cache _emapa_term_key int4 10  √  null foreign key to VOC_Term where _Vocab_key = 90 (EMAPA)
gxd_gellanestructure_view _emapa_term_key int4 10  √  null
gxd_isresultstructure_view _emapa_term_key int4 10  √  null
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
mgi_relationship_markertss_view _evidence_key int4 10  √  null
voc_evidenceproperty_view _evidenceproperty_key int4 10  √  null
voc_evidence_view _evidenceterm_key int4 10  √  null
voc_annot_view _evidencevocab_key int4 10  √  null
gxd_genotype_view _existsas_key int4 10  √  null
mld_concordance_view _expt_key int4 10  √  null
mld_expt_marker_view _expt_key int4 10  √  null
mld_expt_view _expt_key int4 10  √  null
mld_fish_view _expt_key int4 10  √  null
mld_hybrid_view _expt_key int4 10  √  null
mld_insitu_view _expt_key int4 10  √  null
mld_matrix_view _expt_key int4 10  √  null
mld_mc2point_view _expt_key int4 10  √  null
mld_ri2point_view _expt_key int4 10  √  null
mld_ri_view _expt_key int4 10  √  null
mld_ridata_view _expt_key int4 10  √  null
mld_statistics_view _expt_key int4 10  √  null
crs_cross_view _femalestrain_key int4 10  √  null
mld_matrix_view _femalestrain_key int4 10  √  null
gxd_specimen_view _fixation_key int4 10  √  null
gxd_gelband_view _gelband_key int4 10  √  null
gxd_gellane_view _gelcontrol_key int4 10  √  null
gxd_expression _gellane_key int4 10  √  null foreign key to GXD_GelLane
gxd_gelband_view _gellane_key int4 10  √  null
gxd_gellane_view _gellane_key int4 10  √  null
gxd_gellanestructure_view _gellane_key int4 10  √  null
gxd_gellanestructure_view _gellanestructure_key int4 10  √  null
gxd_gellane_view _gelrnatype_key int4 10  √  null
gxd_gelband_view _gelrow_key int4 10  √  null
gxd_gelrow_view _gelrow_key int4 10  √  null
gxd_gelrow_view _gelunits_key int4 10  √  null
gxd_antibodyantigen_view _gender_key int4 10  √  null
gxd_antigen_view _gender_key int4 10  √  null
prb_source_view _gender_key int4 10  √  null
all_genotype_view _genotype_key int4 10  √  null
gxd_allelepair_view _genotype_key int4 10  √  null
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_specimen_view _genotype_key int4 10  √  null
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.
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_view _history_key int4 10  √  null
gxd_isresultimage_view _image_key int4 10  √  null
img_image_view _image_key int4 10  √  null
img_imagepane_assoc_view _image_key int4 10  √  null
img_imagepanegxd_view _image_key int4 10  √  null
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_isresultimage_view _imagepane_key int4 10  √  null
img_imagepane_assoc_view _imagepane_key int4 10  √  null
img_imagepanegxd_view _imagepane_key int4 10  √  null
img_image_view _imagetype_key int4 10  √  null
gxd_index_view _index_key int4 10  √  null
gxd_htexperiment _initialcuratedby_key int4 10  √  null foreign key to MGI_User; user who first curated the experiment, converting it from its raw status
dag_node_view _label_key int4 10  √  null
gxd_antibodyprep_view _label_key int4 10  √  null
gxd_probeprep_view _label_key int4 10  √  null
gxd_htexperiment _lastcuratedby_key int4 10  √  null foreign key to MGI_User; user who last curated the experiment, converting it from its raw status
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_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_view _logicaldb_key int4 10  √  null
crs_cross_view _malestrain_key int4 10  √  null
mld_matrix_view _malestrain_key int4 10  √  null
mrk_history_view _marker_event_key int4 10  √  null
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
bib_goxref_view _marker_key int4 10  √  null
crs_matrix _marker_key int4 10  √  null 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_view _marker_key int4 10  √  null
gxd_assay_view _marker_key int4 10  √  null
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_view _marker_key int4 10  √  null
mld_ridata_view _marker_key int4 10  √  null
mrk_alias_view _marker_key int4 10  √  null
mrk_anchors_view _marker_key int4 10  √  null
mrk_current_view _marker_key int4 10  √  null
mrk_history_view _marker_key int4 10  √  null
mrk_marker_view _marker_key int4 10  √  null
mrk_mouse_view _marker_key int4 10  √  null
mrk_nonmouse_view _marker_key int4 10  √  null
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_view _marker_key int4 10  √  null
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
seq_marker_cache_view _marker_key int4 10  √  null
wks_rosetta _marker_key int4 10  √  null foreign key to MRK_Marker
mld_mc2point_view _marker_key_1 int4 10  √  null
mld_ri2point_view _marker_key_1 int4 10  √  null
mld_statistics_view _marker_key_1 int4 10  √  null
mld_mc2point_view _marker_key_2 int4 10  √  null
mld_ri2point_view _marker_key_2 int4 10  √  null
mld_statistics_view _marker_key_2 int4 10  √  null
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
pwi_mrk_marker_view _marker_status_key int4 10  √  null
mrk_current_view _marker_type_key int4 10  √  null
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
pwi_mrk_marker_view _marker_type_key int4 10  √  null
all_allele_view _markerallele_status_key int4 10  √  null
pwi_all_allele_view _markerallele_status_key int4 10  √  null
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
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_view _mgitype_key int4 10  √  null
map_coordinate _mgitype_key int4 10  √  null 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_view _mgitype_key int4 10  √  null
mgi_organism_summary_view _mgitype_key int4 10  √  null
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_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_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
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_view _mgitype_key int4 10  √  null
voc_term_acc_view _mgitype_key int4 10  √  null
voc_term_summary_view _mgitype_key int4 10  √  null
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_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_view _mutation_key int4 10  √  null
dag_node_view _node_key int4 10  √  null
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_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_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_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_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_view _object_key int4 10  √  null
map_coordinate _object_key int4 10  √  null 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_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_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_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_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_view _object_key int4 10  √  null
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_markertss_view _object_key_1 int4 10  √  null
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_view _organism_key int4 10  √  null
gxd_antibodyantigen_view _organism_key int4 10  √  null
gxd_antigen_view _organism_key int4 10  √  null
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_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_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_view _organism_key int4 10  √  null
pwi_mrk_marker_view _organism_key int4 10  √  null
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_view _pairstate_key int4 10  √  null
all_cellline_derivation_view _parentcellline_key int4 10  √  null
gxd_insituresult_view _pattern_key int4 10  √  null
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
gxd_index_view _priority_key int4 10  √  null
gxd_probeprep_view _probe_key int4 10  √  null
prb_marker_view _probe_key int4 10  √  null
prb_parent_view _probe_key int4 10  √  null
prb_probe_view _probe_key int4 10  √  null
prb_reference_view _probe_key int4 10  √  null
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
voc_evidenceproperty_view _propertyterm_key int4 10  √  null
all_allele_subtype_view _qualifier_key int4 10  √  null
all_annot_view _qualifier_key int4 10  √  null
mgi_relationship_markertss_view _qualifier_key int4 10  √  null
prb_strain_genotype_view _qualifier_key int4 10  √  null
prb_strain_marker_view _qualifier_key int4 10  √  null
prb_strain_needsreview_view _qualifier_key int4 10  √  null
seq_allele_assoc_view _qualifier_key int4 10  √  null
voc_annot_view _qualifier_key int4 10  √  null
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_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_reference_view _reference_key int4 10  √  null
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_view _referencetype_key int4 10  √  null
pwi_bib_refs_view _referencetype_key int4 10  √  null
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_goxref_view _refs_key int4 10  √  null
bib_status_view _refs_key int4 10  √  null
bib_view _refs_key int4 10  √  null
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_view _refs_key int4 10  √  null
gxd_genotype_dataset_view _refs_key int4 10  √  null
gxd_index_view _refs_key int4 10  √  null
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_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_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
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_history _refs_key int4 10  √  null foreign key to BIB_Refs
mrk_history_view _refs_key int4 10  √  null
mrk_reference_view _refs_key int4 10  √  null
prb_marker_view _refs_key int4 10  √  null
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
seq_allele_assoc_view _refs_key int4 10  √  null
seq_allele_view _refs_key int4 10  √  null
seq_marker_cache_view _refs_key int4 10  √  null
seq_probe_cache_view _refs_key int4 10  √  null
voc_evidence_view _refs_key int4 10  √  null
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_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_markertss_view _relationshipterm_key int4 10  √  null
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_isresultimage_view _result_key int4 10  √  null
gxd_isresultstructure_view _result_key int4 10  √  null
gxd_isresultimage_view _resultimage_key int4 10  √  null
gxd_isresultstructure_view _resultstructure_key int4 10  √  null
prb_rflv_view _rflv_key int4 10  √  null
mld_ri_view _riset_key int4 10  √  null
ri_riset_view _riset_key int4 10  √  null
mgi_roletask_view _role_key int4 10  √  null
mgi_userrole_view _role_key int4 10  √  null
mgi_usertask_view _role_key int4 10  √  null
mgi_roletask_view _roletask_key int4 10  √  null
gxd_antibodyprep_view _secondary_key int4 10  √  null
prb_probe_view _segmenttype_key int4 10  √  null
prb_source_view _segmenttype_key int4 10  √  null
gxd_probeprep_view _sense_key int4 10  √  null
seq_allele_assoc_view _sequence_key int4 10  √  null
seq_allele_view _sequence_key int4 10  √  null
seq_marker_cache_view _sequence_key int4 10  √  null
seq_probe_cache_view _sequence_key int4 10  √  null
seq_sequence_view _sequence_key int4 10  √  null
seq_allele_view _sequenceprovider_key int4 10  √  null
seq_marker_cache_view _sequenceprovider_key int4 10  √  null
seq_sequence_view _sequenceprovider_key int4 10  √  null
seq_sequence_view _sequencequality_key int4 10  √  null
seq_sequence_view _sequencestatus_key int4 10  √  null
seq_allele_view _sequencetype_key int4 10  √  null
seq_marker_cache_view _sequencetype_key int4 10  √  null
seq_sequence_view _sequencetype_key int4 10  √  null
gxd_antibodyantigen_view _source_key int4 10  √  null
gxd_antigen_view _source_key int4 10  √  null
prb_probe_view _source_key int4 10  √  null
prb_source_view _source_key int4 10  √  null
prb_sourceref_view _source_key int4 10  √  null
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_view _species_key int4 10  √  null
gxd_expression _specimen_key int4 10  √  null 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_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_isresultstructure_view _stage_key int4 10  √  null
all_allele_view _strain_key int4 10  √  null
all_cellline_view _strain_key int4 10  √  null
gxd_antibodyantigen_view _strain_key int4 10  √  null
gxd_antigen_view _strain_key int4 10  √  null
gxd_genotype_view _strain_key int4 10  √  null
mld_fish_view _strain_key int4 10  √  null
mld_insitu_view _strain_key int4 10  √  null
prb_rflv_view _strain_key int4 10  √  null
prb_source_view _strain_key int4 10  √  null
prb_strain_attribute_view _strain_key int4 10  √  null
prb_strain_genotype_view _strain_key int4 10  √  null
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_view _strain_key_1 int4 10  √  null
mld_ri_view _strain_key_2 int4 10  √  null
ri_riset_view _strain_key_2 int4 10  √  null
prb_strain_genotype_view _straingenotype_key int4 10  √  null
crs_cross_view _strainho_key int4 10  √  null
mld_matrix_view _strainho_key int4 10  √  null
crs_cross_view _strainht_key int4 10  √  null
mld_matrix_view _strainht_key int4 10  √  null
prb_strain_marker_view _strainmarker_key int4 10  √  null
prb_strain_view _straintype_key int4 10  √  null
gxd_gelband_view _strength_key int4 10  √  null
gxd_insituresult_view _strength_key int4 10  √  null
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_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_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
mgi_roletask_view _task_key int4 10  √  null
all_allele_subtype_view _term_key int4 10  √  null
prb_strain_attribute_view _term_key int4 10  √  null
prb_strain_needsreview_view _term_key int4 10  √  null
voc_annot_view _term_key int4 10  √  null
voc_annotheader_view _term_key int4 10  √  null
voc_term_cellline_view _term_key int4 10  √  null
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_view _tissue_key int4 10  √  null
mgi_translation_view _translation_key int4 10  √  null
mgi_translationstrain_view _translation_key int4 10  √  null
mgi_translation_view _translationtype_key int4 10  √  null
mgi_translationstrain_view _translationtype_key int4 10  √  null
all_allele_view _transmission_key int4 10  √  null
pwi_all_allele_view _transmission_key int4 10  √  null
mgi_user_active_view _user_key int4 10  √  null
mgi_userrole_view _user_key int4 10  √  null
mgi_usertask_view _user_key int4 10  √  null
mgi_userrole_view _userrole_key int4 10  √  null
mgi_usertask_view _userrole_key int4 10  √  null
mgi_user_active_view _userstatus_key int4 10  √  null
mgi_user_active_view _usertype_key int4 10  √  null
all_allele_cellline_view _vector_key int4 10  √  null
all_cellline_derivation_view _vector_key int4 10  √  null
all_cellline_view _vector_key int4 10  √  null
prb_probe_view _vector_key int4 10  √  null
prb_source_view _vector_key int4 10  √  null
all_cellline_derivation_view _vectortype_key int4 10  √  null
all_cellline_view _vectortype_key int4 10  √  null
gxd_probeprep_view _visualization_key int4 10  √  null
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_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_view _vocab_key int4 10  √  null
voc_vocabdag_view _vocab_key int4 10  √  null
mld_ri_view abbrev1 text 2147483647  √  null
ri_riset_view abbrev1 text 2147483647  √  null
mld_ri_view abbrev2 text 2147483647  √  null
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
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_view accid text 2147483647  √  null
all_acc_view accid text 2147483647  √  null
all_cellline_acc_view accid text 2147483647  √  null
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_sequence_acc_view accid text 2147483647  √  null
seq_summary_view accid text 2147483647  √  null
voc_annot_view accid text 2147483647  √  null
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_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_gellane_view age text 2147483647  √  null
gxd_htsample age text 2147483647  √  null textual age of the sample
gxd_specimen_view age text 2147483647  √  null
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_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_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_view alias text 2147483647  √  null
gxd_antibodyaliasref_view alias text 2147483647  √  null
mrk_alias_view alias text 2147483647  √  null
mld_expt_marker_view allele text 2147483647  √  null
prb_rflv_view allele text 2147483647  √  null
gxd_allelepair_view allele1 text 2147483647  √  null
gxd_allelepair_view allele2 text 2147483647  √  null
crs_cross_view allelefromsegparent int2 5  √  null
mld_matrix_view allelefromsegparent int2 5  √  null
seq_allele_view alleleid text 2147483647  √  null
mld_ridata_view alleleline text 2147483647  √  null
gxd_allelepair_view allelestate text 2147483647  √  null
prb_strain_marker_view allelesymbol text 2147483647  √  null
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_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_view allowsmultiple int2 5  √  null
voc_annot_view annottype text 2147483647  √  null
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_antibody_view antigenname text 2147483647  √  null
gxd_antibodyantigen_view antigenname text 2147483647  √  null
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 approval_date timestamp 29,6  √  now() date record was statused as "Approved"
all_allele_view approval_date timestamp 29,6  √  null
pwi_all_allele_view approval_date timestamp 29,6  √  null
voc_annotheader approval_date timestamp 29,6  √  now() date record was approved
voc_annotheader_view approval_date timestamp 29,6  √  null
all_allele_view approvedby text 2147483647  √  null
voc_annotheader_view approvedby text 2147483647  √  null
mld_expt_marker_view assay text 2147483647  √  null
gxd_assay_view assaytype text 2147483647  √  null
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
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_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
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
mrk_anchors_view chromosome text 2147483647  √  null
mrk_current_view chromosome text 2147483647  √  null
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
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
bib_view citation text 2147483647  √  null
gxd_antibody_view class text 2147483647  √  null
mrk_cluster cluster_date timestamp 29,6  √  now() Cluster Date
mrk_cluster clusterid text 2147483647  √  null Cluster Accession ID
mrk_location_cache cmoffset float8 17,17  √  null cytogenetic cmOffset
mrk_marker cmoffset float8 17,17  √  null approximate centimorgan (cM) position on chromosome
mrk_marker_view cmoffset float8 17,17  √  null
mrk_mouse_view cmoffset float8 17,17  √  null
mrk_nonmouse_view cmoffset float8 17,17  √  null
pwi_mrk_marker_view cmoffset float8 17,17  √  null
mld_concordance_view cnn int4 10  √  null
mld_concordance_view cnp int4 10  √  null
all_allele_view collection text 2147483647  √  null
gxd_index comments text 2147483647  √  null textual information
gxd_index_view comments text 2147483647  √  null
all_allele_driver_view commonname text 2147483647  √  null
mgi_organism_allele_view commonname text 2147483647  √  null
mgi_organism_antigen_view commonname text 2147483647  √  null
mgi_organism_marker_view commonname text 2147483647  √  null
mgi_organism_mgitype_view commonname text 2147483647  √  null
mgi_organism_probe_view commonname text 2147483647  √  null
mgi_organism_view commonname text 2147483647  √  null
mrk_marker_view commonname text 2147483647  √  null
mrk_mouse_view commonname text 2147483647  √  null
all_knockout_cache companyid text 2147483647  √  null the company ID of the knockout (the Deltagen or Lexicon ID)
go_tracking_view completedby text 2147483647  √  null
go_tracking completion_date timestamp 29,6  √  now() date GO Tracking was completed
go_tracking_view completion_date timestamp 29,6  √  null
gxd_allelepair_view compound text 2147483647  √  null
mgi_translationstrain_view compressionchars text 2147483647  √  null
mgi_translationtype compressionchars text 2147483647  √  null list of characters to remove from a translation target before translation is applied.
mld_concordance_view cpn int4 10  √  null
mld_concordance_view cpp int4 10  √  null
all_allele_cellline_view createdby text 2147483647  √  null
all_allele_view createdby text 2147483647  √  null
all_cellline_derivation_view createdby text 2147483647  √  null
all_cellline_view createdby text 2147483647  √  null
bib_all2_view createdby text 2147483647  √  null
bib_view createdby text 2147483647  √  null
gxd_antibody_view createdby text 2147483647  √  null
gxd_antibodyantigen_view createdby text 2147483647  √  null
gxd_antigen_view createdby text 2147483647  √  null
gxd_assay_view createdby text 2147483647  √  null
gxd_genotype_view createdby text 2147483647  √  null
gxd_index_view createdby text 2147483647  √  null
img_image_view createdby text 2147483647  √  null
mgi_note_allele_view createdby text 2147483647  √  null
mgi_note_allelevariant_view createdby text 2147483647  √  null
mgi_note_derivation_view createdby text 2147483647  √  null
mgi_note_genotype_view createdby text 2147483647  √  null
mgi_note_image_view createdby text 2147483647  √  null
mgi_note_marker_view createdby text 2147483647  √  null
mgi_note_mrkgo_view createdby text 2147483647  √  null
mgi_note_probe_view createdby text 2147483647  √  null
mgi_note_sequence_view createdby text 2147483647  √  null
mgi_note_source_view createdby text 2147483647  √  null
mgi_note_strain_view createdby text 2147483647  √  null
mgi_note_vocevidence_view createdby text 2147483647  √  null
mgi_organism_view createdby text 2147483647  √  null
mgi_reference_marker_view createdby text 2147483647  √  null
mgi_relationship_markertss_view createdby text 2147483647  √  null
mgi_synonym_musmarker_view createdby text 2147483647  √  null
mgi_translation_view createdby text 2147483647  √  null
mgi_user_active_view createdby text 2147483647  √  null
mgi_userrole_view createdby text 2147483647  √  null
mgi_usertask_view createdby text 2147483647  √  null
mrk_accref1_view createdby text 2147483647  √  null
mrk_accref2_view createdby text 2147483647  √  null
mrk_accref_view createdby text 2147483647  √  null
mrk_history_view createdby text 2147483647  √  null
mrk_marker_view createdby text 2147483647  √  null
prb_probe_view createdby text 2147483647  √  null
prb_reference_view createdby text 2147483647  √  null
prb_source_view createdby text 2147483647  √  null
prb_strain_view createdby text 2147483647  √  null
seq_allele_assoc_view createdby text 2147483647  √  null
seq_sequence_view createdby text 2147483647  √  null
voc_evidence_view createdby text 2147483647  √  null
voc_evidenceproperty_view createdby text 2147483647  √  null
acc_logicaldb_view creation_date timestamp 29,6  √  null
acc_view creation_date timestamp 29,6  √  null
all_acc_view creation_date timestamp 29,6  √  null
all_allele_cellline_view creation_date timestamp 29,6  √  null
all_allele_mutation_view creation_date timestamp 29,6  √  null
all_allele_subtype_view creation_date timestamp 29,6  √  null
all_allele_view creation_date timestamp 29,6  √  null
all_cellline_acc_view creation_date timestamp 29,6  √  null
all_cellline_derivation_view creation_date timestamp 29,6  √  null
all_cellline_view creation_date timestamp 29,6  √  null
all_derivation_summary_view creation_date timestamp 29,6  √  null
all_summary_view creation_date timestamp 29,6  √  null
bib_acc_view creation_date timestamp 29,6  √  null
bib_all2_view creation_date timestamp 29,6  √  null
bib_all_view creation_date timestamp 29,6  √  null
bib_goxref_view creation_date timestamp 29,6  √  null
bib_summary_all_view creation_date timestamp 29,6  √  null
bib_view creation_date timestamp 29,6  √  null
crs_cross_view creation_date timestamp 29,6  √  null
dag_node_view creation_date timestamp 29,6  √  null
go_tracking_view creation_date timestamp 29,6  √  null
gxd_allelepair_view creation_date timestamp 29,6  √  null
gxd_antibody_acc_view creation_date timestamp 29,6  √  null
gxd_antibody_view creation_date timestamp 29,6  √  null
gxd_antibodyalias_view creation_date timestamp 29,6  √  null
gxd_antibodyaliasref_view creation_date timestamp 29,6  √  null
gxd_antibodyantigen_view creation_date timestamp 29,6  √  null
gxd_antibodyprep_view creation_date timestamp 29,6  √  null
gxd_antigen_acc_view creation_date timestamp 29,6  √  null
gxd_antigen_summary_view creation_date timestamp 29,6  √  null
gxd_antigen_view creation_date timestamp 29,6  √  null
gxd_assay_acc_view creation_date timestamp 29,6  √  null
gxd_assay_view creation_date timestamp 29,6  √  null
gxd_gelband_view creation_date timestamp 29,6  √  null
gxd_gellane_view creation_date timestamp 29,6  √  null
gxd_gellanestructure_view creation_date timestamp 29,6  √  null
gxd_gelrow_view creation_date timestamp 29,6  √  null
gxd_genotype_acc_view creation_date timestamp 29,6  √  null
gxd_genotype_summary_view creation_date timestamp 29,6  √  null
gxd_genotype_view creation_date timestamp 29,6  √  null
gxd_index_view creation_date timestamp 29,6  √  null
gxd_insituresult_view creation_date timestamp 29,6  √  null
gxd_isresultimage_view creation_date timestamp 29,6  √  null
gxd_isresultstructure_view creation_date timestamp 29,6  √  null
gxd_probeprep_view creation_date timestamp 29,6  √  null
gxd_specimen_view creation_date timestamp 29,6  √  null
img_image_acc_view creation_date timestamp 29,6  √  null
img_image_summary_view creation_date timestamp 29,6  √  null
img_image_view creation_date timestamp 29,6  √  null
img_imagepane_assoc_view creation_date timestamp 29,6  √  null
mgi_note_allele_view creation_date timestamp 29,6  √  null
mgi_note_allelevariant_view creation_date timestamp 29,6  √  null
mgi_note_derivation_view creation_date timestamp 29,6  √  null
mgi_note_genotype_view creation_date timestamp 29,6  √  null
mgi_note_image_view creation_date timestamp 29,6  √  null
mgi_note_marker_view creation_date timestamp 29,6  √  null
mgi_note_mrkgo_view creation_date timestamp 29,6  √  null
mgi_note_probe_view creation_date timestamp 29,6  √  null
mgi_note_sequence_view creation_date timestamp 29,6  √  null
mgi_note_source_view creation_date timestamp 29,6  √  null
mgi_note_strain_view creation_date timestamp 29,6  √  null
mgi_note_vocevidence_view creation_date timestamp 29,6  √  null
mgi_notetype_alldriver_view creation_date timestamp 29,6  √  null
mgi_notetype_allele_view creation_date timestamp 29,6  √  null
mgi_notetype_derivation_view creation_date timestamp 29,6  √  null
mgi_notetype_genotype_view creation_date timestamp 29,6  √  null
mgi_notetype_image_view creation_date timestamp 29,6  √  null
mgi_notetype_marker_view creation_date timestamp 29,6  √  null
mgi_notetype_mrkgo_view creation_date timestamp 29,6  √  null
mgi_notetype_probe_view creation_date timestamp 29,6  √  null
mgi_notetype_sequence_view creation_date timestamp 29,6  √  null
mgi_notetype_source_view creation_date timestamp 29,6  √  null
mgi_notetype_strain_view creation_date timestamp 29,6  √  null
mgi_notetype_vocevidence_view creation_date timestamp 29,6  √  null
mgi_organism_acc_view creation_date timestamp 29,6  √  null
mgi_organism_allele_view creation_date timestamp 29,6  √  null
mgi_organism_antigen_view creation_date timestamp 29,6  √  null
mgi_organism_marker_view creation_date timestamp 29,6  √  null
mgi_organism_mgitype_view creation_date timestamp 29,6  √  null
mgi_organism_probe_view creation_date timestamp 29,6  √  null
mgi_organism_summary_view creation_date timestamp 29,6  √  null
mgi_organism_view creation_date timestamp 29,6  √  null
mgi_reference_allele_view creation_date timestamp 29,6  √  null
mgi_reference_allelevariant_view creation_date timestamp 29,6  √  null
mgi_reference_antibody_view creation_date timestamp 29,6  √  null
mgi_reference_marker_view creation_date timestamp 29,6  √  null
mgi_reference_sequence_view creation_date timestamp 29,6  √  null
mgi_reference_strain_view creation_date timestamp 29,6  √  null
mgi_reftype_allele_view creation_date timestamp 29,6  √  null
mgi_reftype_antibody_view creation_date timestamp 29,6  √  null
mgi_reftype_marker_view creation_date timestamp 29,6  √  null
mgi_reftype_sequence_view creation_date timestamp 29,6  √  null
mgi_reftype_strain_view creation_date timestamp 29,6  √  null
mgi_relationship_markertss_view creation_date timestamp 29,6  √  null
mgi_roletask_view creation_date timestamp 29,6  √  null
mgi_synonym_allele_view creation_date timestamp 29,6  √  null
mgi_synonym_goterm_view creation_date timestamp 29,6  √  null
mgi_synonym_musmarker_view creation_date timestamp 29,6  √  null
mgi_synonym_strain_view creation_date timestamp 29,6  √  null
mgi_synonymtype_allele_view creation_date timestamp 29,6  √  null
mgi_synonymtype_goterm_view creation_date timestamp 29,6  √  null
mgi_synonymtype_musmarker_view creation_date timestamp 29,6  √  null
mgi_synonymtype_strain_view creation_date timestamp 29,6  √  null
mgi_translation_view creation_date timestamp 29,6  √  null
mgi_translationstrain_view creation_date timestamp 29,6  √  null
mgi_user_active_view creation_date timestamp 29,6  √  null
mgi_userrole_view creation_date timestamp 29,6  √  null
mgi_usertask_view creation_date timestamp 29,6  √  null
mld_acc_view creation_date timestamp 29,6  √  null
mld_concordance_view creation_date timestamp 29,6  √  null
mld_expt_marker_view creation_date timestamp 29,6  √  null
mld_expt_view creation_date timestamp 29,6  √  null
mld_fish_view creation_date timestamp 29,6  √  null
mld_hybrid_view creation_date timestamp 29,6  √  null
mld_insitu_view creation_date timestamp 29,6  √  null
mld_matrix_view creation_date timestamp 29,6  √  null
mld_mc2point_view creation_date timestamp 29,6  √  null
mld_ri2point_view creation_date timestamp 29,6  √  null
mld_ridata_view creation_date timestamp 29,6  √  null
mld_statistics_view creation_date timestamp 29,6  √  null
mld_summary_view creation_date timestamp 29,6  √  null
mrk_acc_view creation_date timestamp 29,6  √  null
mrk_accnoref_view creation_date timestamp 29,6  √  null
mrk_accref1_view creation_date timestamp 29,6  √  null
mrk_accref2_view creation_date timestamp 29,6  √  null
mrk_accref_view creation_date timestamp 29,6  √  null
mrk_alias_view creation_date timestamp 29,6  √  null
mrk_anchors_view creation_date timestamp 29,6  √  null
mrk_current_view creation_date timestamp 29,6  √  null
mrk_history_view creation_date timestamp 29,6  √  null
mrk_marker_view creation_date timestamp 29,6  √  null
mrk_mouse_view creation_date timestamp 29,6  √  null
mrk_nonmouse_view creation_date timestamp 29,6  √  null
mrk_reference_view creation_date timestamp 29,6  √  null
mrk_summary_view creation_date timestamp 29,6  √  null
prb_acc_view creation_date timestamp 29,6  √  null
prb_accnoref_view creation_date timestamp 29,6  √  null
prb_accref_view creation_date timestamp 29,6  √  null
prb_accrefnoseq_view creation_date timestamp 29,6  √  null
prb_probe_view creation_date timestamp 29,6  √  null
prb_reference_view creation_date timestamp 29,6  √  null
prb_rflv_view creation_date timestamp 29,6  √  null
prb_source_acc_view creation_date timestamp 29,6  √  null
prb_source_summary_view creation_date timestamp 29,6  √  null
prb_source_view creation_date timestamp 29,6  √  null
prb_strain_acc_view creation_date timestamp 29,6  √  null
prb_strain_genotype_view creation_date timestamp 29,6  √  null
prb_strain_marker_view creation_date timestamp 29,6  √  null
prb_strain_needsreview_view creation_date timestamp 29,6  √  null
prb_strain_summary_view creation_date timestamp 29,6  √  null
prb_strain_view creation_date timestamp 29,6  √  null
prb_tissue_summary_view creation_date timestamp 29,6  √  null
pwi_all_allele_view creation_date timestamp 29,6  √  null
pwi_bib_refs_view creation_date timestamp 29,6  √  null
pwi_mrk_marker_view creation_date timestamp 29,6  √  null
ri_riset_view creation_date timestamp 29,6  √  null
seq_allele_assoc_view creation_date timestamp 29,6  √  null
seq_sequence_acc_view creation_date timestamp 29,6  √  null
seq_sequence_view creation_date timestamp 29,6  √  null
seq_summary_view creation_date timestamp 29,6  √  null
voc_annot_view creation_date timestamp 29,6  √  null
voc_annotheader_view creation_date timestamp 29,6  √  null
voc_evidence_view creation_date timestamp 29,6  √  null
voc_evidenceproperty_view creation_date timestamp 29,6  √  null
voc_term_acc_view creation_date timestamp 29,6  √  null
voc_term_cellline_view creation_date timestamp 29,6  √  null
voc_term_mcv_view creation_date timestamp 29,6  √  null
voc_term_repqualifier_view creation_date timestamp 29,6  √  null
voc_term_strainallele_view creation_date timestamp 29,6  √  null
voc_term_strainspecies_view creation_date timestamp 29,6  √  null
voc_term_summary_view creation_date timestamp 29,6  √  null
voc_term_view creation_date timestamp 29,6  √  null
voc_vocab_view creation_date timestamp 29,6  √  null
voc_vocabdag_view creation_date timestamp 29,6  √  null
all_allele_cellline_view creator text 2147483647  √  null
all_cellline_derivation_view creator text 2147483647  √  null
all_cellline_view creator text 2147483647  √  null
all_cre_cache cresystemlabel text 2147483647  √  null Cre System Label
mrk_current_view current_symbol text 2147483647  √  null
mrk_location_cache cytogeneticoffset text 2147483647  √  null cytogenetic cmOffset
mrk_marker cytogeneticoffset text 2147483647  √  null cytogenetic band
mrk_marker_view cytogeneticoffset text 2147483647  √  null
mrk_mouse_view cytogeneticoffset text 2147483647  √  null
mrk_nonmouse_view cytogeneticoffset text 2147483647  √  null
pwi_mrk_marker_view cytogeneticoffset text 2147483647  √  null
dag_node_view dag text 2147483647  √  null
voc_vocabdag_view dag text 2147483647  √  null
dag_node_view dagabbrev bpchar 5  √  null
voc_vocabdag_view dagabbrev bpchar 5  √  null
crs_typings data text 2147483647  √  null haplotype data
bib_all2_view date text 2147483647  √  null
bib_all_view date text 2147483647  √  null
bib_refs date text 2147483647  √  null reference date
bib_view date text 2147483647  √  null
pwi_bib_refs_view date text 2147483647  √  null
acc_mgitype dbview text 2147483647  √  null table summary view
mgi_synonymtype definition text 2147483647  √  null defintion of the synonym type
mgi_synonymtype_allele_view definition text 2147483647  √  null
mgi_synonymtype_goterm_view definition text 2147483647  √  null
mgi_synonymtype_musmarker_view definition text 2147483647  √  null
mgi_synonymtype_strain_view definition text 2147483647  √  null
acc_actualdb delimiter bpchar 8  √  null the delimiter which separates multiple accession numbers; used when construcuting the full URL.
acc_view delimiter bpchar 8  √  null
all_allele_cellline_view derivationkey int4 10  √  null
all_allele_cellline_view derivationname text 2147483647  √  null
all_cellline_view derivationname text 2147483647  √  null
prb_probe derivedfrom int4 10  √  null foreign key to PRB_Probe; parent
prb_probe_view derivedfrom int4 10  √  null
acc_logicaldb description text 2147483647  √  null brief description of the logical entity
acc_logicaldb_view description text 2147483647  √  null
acc_view description text 2147483647  √  null
all_cellline_derivation description text 2147483647  √  null longer name
all_cellline_derivation_view description text 2147483647  √  null
all_derivation_summary_view description text 2147483647  √  null
all_summary_view description text 2147483647  √  null
all_variant description text 2147483647  √  null text description of this variant
bib_summary_all_view description text 2147483647  √  null
gxd_antibody_acc_view description text 2147483647  √  null
gxd_antibodyantigen_view description text 2147483647  √  null
gxd_antigen_acc_view description text 2147483647  √  null
gxd_antigen_summary_view description text 2147483647  √  null
gxd_antigen_view description text 2147483647  √  null
gxd_genotype_acc_view description text 2147483647  √  null
gxd_genotype_summary_view description text 2147483647  √  null
gxd_htexperiment description text 2147483647  √  null textual description
gxd_theilerstage description text 2147483647  √  null description of the anatomical developments
img_image_summary_view description text 2147483647  √  null
mgi_organism_summary_view description text 2147483647  √  null
mld_expt_marker description text 2147483647  √  null description of probes used, etc.
mld_expt_marker_view description text 2147483647  √  null
mld_summary_view description text 2147483647  √  null
mrk_accnoref_view description text 2147483647  √  null
mrk_summary_view description text 2147483647  √  null
prb_accnoref_view description text 2147483647  √  null
prb_source description text 2147483647  √  null description of library source
prb_source_summary_view description text 2147483647  √  null
prb_source_view description text 2147483647  √  null
prb_strain_genotype_view description text 2147483647  √  null
prb_strain_summary_view description text 2147483647  √  null
prb_tissue_summary_view description text 2147483647  √  null
pwi_report description text 2147483647  √  null None
seq_sequence description text 2147483647  √  null description
seq_sequence_view description text 2147483647  √  null
seq_summary_view description text 2147483647  √  null
voc_term_summary_view description text 2147483647  √  null
mld_ri_view designation text 2147483647  √  null
ri_riset_view designation text 2147483647  √  null
crs_cross_view display text 2147483647  √  null
crs_cross_view displayed int2 5  √  null
mld_matrix_view displayed int2 5  √  null
gxd_gellanestructure_view displayit text 2147483647  √  null
gxd_genotype_view displayit text 2147483647  √  null
gxd_isresultstructure_view displayit text 2147483647  √  null
seq_sequence division bpchar 3  √  null GenBank division
seq_sequence_view division bpchar 3  √  null
bib_citation_cache doiid text 2147483647  √  null DOI (digital object identifier) accession ID
all_cre_cache emapaterm text 2147483647  √  null term from VOC_Term where _Vocab_key = 90
gxd_specimen_view embeddingmethod text 2147483647  √  null
all_variant_sequence endcoordinate numeric 131089  √  null
mrk_location_cache endcoordinate float8 17,17  √  null end genome coordinate
prb_rflv endonuclease text 2147483647  √  null endonuclease (An enzyme that cleaves its nucleic acid substrate at internal sites in the nucleotide sequence)
prb_rflv_view endonuclease text 2147483647  √  null
gxd_htexperiment evaluated_date timestamp 29,6  √  null
mrk_history_view event text 2147483647  √  null
mrk_history event_date timestamp 29,6  √  now() date of the nomenclature event
mrk_history_view event_date timestamp 29,6  √  null
mrk_history_view event_display bpchar 10  √  null
mrk_history_view eventreason text 2147483647  √  null
voc_evidence_view evidencecode text 2147483647  √  null
voc_evidence_view evidenceseqnum int4 10  √  null
mgi_relationship_markertss_view evidenceterm text 2147483647  √  null
gxd_genotype_view existsas text 2147483647  √  null
seq_genemodel exoncount int4 10  √  null currently not being used
all_cre_cache expressed int4 10  √  null if 1 (true), then this Assay is expressing this Structure, else 0
mld_expt_view exptlabel text 2147483647  √  null
mld_expt_marker_view expttype text 2147483647  √  null
mld_expt_view expttype text 2147483647  √  null
mld_statistics_view expttype text 2147483647  √  null
bib_workflow_data extractedtext text 2147483647  √  null PDF data that is saved as text per specific section
crs_cross_view f1directionknown int2 5  √  null
mld_matrix_view f1directionknown int2 5  √  null
mld_matrix female text 2147483647  √  null genotype of mother
mld_matrix_view female text 2147483647  √  null
mld_matrix female2 text 2147483647  √  null genotype of mother; overflow
mld_matrix_view female2 text 2147483647  √  null
crs_cross femaleallele1 bpchar 1  √  null first allele of maternal strain; used during construction of maternal genotype
crs_cross_view femaleallele1 bpchar 1  √  null
mld_matrix_view femaleallele1 bpchar 1  √  null
crs_cross femaleallele2 bpchar 1  √  null second allele of maternal strain; used during construction of maternal genotype
crs_cross_view femaleallele2 bpchar 1  √  null
mld_matrix_view femaleallele2 bpchar 1  √  null
crs_cross_view femalestrain text 2147483647  √  null
mld_matrix_view femalestrain text 2147483647  √  null
gxd_isresultimage_view figurelabel text 2147483647  √  null
img_image_view figurelabel text 2147483647  √  null
img_imagepane_assoc_view figurelabel text 2147483647  √  null
gxd_isresultimage_view figurepanelabel text 2147483647  √  null
gxd_specimen_view fixation text 2147483647  √  null
prb_rflv_view fragments text 2147483647  √  null
gxd_gellane_view gellanecontent text 2147483647  √  null
prb_source_view gender text 2147483647  √  null
mld_expt_marker gene text 2147483647  √  null original marker symbol; marker symbol used when record was inserted; OBSOLETE/REMOVE FROM SCHEMA
mld_expt_marker_view gene text 2147483647  √  null
prb_strain_view geneticbackground int2 5  √  null
mrk_location_cache genomicchromosome text 2147483647  √  null chromosome
mrk_do_cache genotypefootnote text 2147483647  √  null genotype footnote for WI
bib_status_view go_status text 2147483647  √  null
seq_genetrap goodhitcount int4 10  √  null Number of good blat hits
mgi_translationstrain_view goodname text 2147483647  √  null
mld_insitu grainsonchrom int4 10  √  null # of grains hybridizing to correct chromosomal location
mld_insitu_view grainsonchrom int4 10  √  null
mld_insitu grainsotherchrom int4 10  √  null # of grains hybridizing to other chromosomal locations
mld_insitu_view grainsotherchrom int4 10  √  null
bib_status_view gxd_status text 2147483647  √  null
bib_associateddata_view has_alleles int4 10  √  null
bib_associateddata_view has_antibodies int4 10  √  null
bib_associateddata_view has_go int4 10  √  null
bib_associateddata_view has_gxdimages int4 10  √  null
bib_associateddata_view has_gxdindex int4 10  √  null
bib_associateddata_view has_gxdresults int4 10  √  null
bib_associateddata_view has_gxdspecimens int4 10  √  null
bib_associateddata_view has_mapping int4 10  √  null
bib_associateddata_view has_markers int4 10  √  null
bib_associateddata_view has_probes int4 10  √  null
bib_associateddata_view has_strain int4 10  √  null
all_cre_cache hasimage int4 10  √  null does this record have an image?
prb_reference_view hasrmap int2 5  √  null
prb_reference_view hassequence int2 5  √  null
mrk_do_cache headerfootnote text 2147483647  √  null genotype header footnote for WI
img_imagepane height int4 10  √  null height of image pdf
mrk_history_view history text 2147483647  √  null
mrk_history_view historyname text 2147483647  √  null
gxd_specimen_view hybridization text 2147483647  √  null
acc_mgitype identitycolumnname text 2147483647  √  null name of the primary key column of tableName
img_image_view imageclass text 2147483647  √  null
img_image_view imagetype text 2147483647  √  null
voc_evidence inferredfrom text 2147483647  √  null supporting acc id for the evidence
voc_evidence_view inferredfrom text 2147483647  √  null
gxd_htexperiment initial_curated_date timestamp 29,6  √  null date record was first curated
prb_probe insertsite text 2147483647  √  null site of probe on the vector
prb_probe_view insertsite text 2147483647  √  null
prb_probe insertsize text 2147483647  √  null size of probe
prb_probe_view insertsize text 2147483647  √  null
gxd_genotype_view isconditional int2 5  √  null
prb_source_view iscuratoredited int2 5  √  null
bib_all2_view isdiscard int2 5  √  null
bib_all_view isdiscard int2 5  √  null
bib_view isdiscard int2 5  √  null
pwi_bib_refs_view isdiscard int2 5  √  null
all_allele_view isextinct int2 5  √  null
pwi_all_allele_view isextinct int2 5  √  null
gxd_assay_view isgelassay int2 5  √  null
all_allele_view ismixed int2 5  √  null
pwi_all_allele_view ismixed int2 5  √  null
all_allele_cellline_view ismutant int2 5  √  null
all_cellline_view ismutant int2 5  √  null
voc_annotheader_view isnormal int2 5  √  null
voc_term isobsolete int2 5  √  null if 1, the term is obsolete and cannot be used in future annotations
voc_term_cellline_view isobsolete int2 5  √  null
voc_term_mcv_view isobsolete int2 5  √  null
voc_term_repqualifier_view isobsolete int2 5  √  null
voc_term_strainallele_view isobsolete int2 5  √  null
voc_term_strainspecies_view isobsolete int2 5  √  null
voc_term_view isobsolete int2 5  √  null
img_imagepane_assoc_view isprimary int2 5  √  null
voc_vocab isprivate int2 5  √  null if 1, then the Accession IDs of the Vocabulary Terms are private, else they are public
voc_vocab_view isprivate int2 5  √  null
go_tracking_view isreferencegene int2 5  √  null
bib_all2_view isreviewarticle int2 5  √  null
bib_all_view isreviewarticle int2 5  √  null
bib_view isreviewarticle int2 5  √  null
mgi_reference_allele_view isreviewarticle int2 5  √  null
mgi_reference_allelevariant_view isreviewarticle int2 5  √  null
mgi_reference_antibody_view isreviewarticle int2 5  √  null
mgi_reference_marker_view isreviewarticle int2 5  √  null
mgi_reference_sequence_view isreviewarticle int2 5  √  null
mgi_reference_strain_view isreviewarticle int2 5  √  null
mrk_reference_view isreviewarticle int2 5  √  null
pwi_bib_refs_view isreviewarticle int2 5  √  null
mgi_reference_allele_view isreviewarticlestring bpchar 3  √  null
mgi_reference_allelevariant_view isreviewarticlestring bpchar 3  √  null
mgi_reference_antibody_view isreviewarticlestring bpchar 3  √  null
mgi_reference_marker_view isreviewarticlestring bpchar 3  √  null
mgi_reference_sequence_view isreviewarticlestring bpchar 3  √  null
mgi_reference_strain_view isreviewarticlestring bpchar 3  √  null
gxd_assay_view isrnaassay int2 5  √  null
voc_vocab issimple int2 5  √  null if 1, the Vocabulary is a simple vocabulary (no DAG), else the Vocabulary is structured (has 1 or more DAGS)
voc_vocab_view issimple int2 5  √  null
bib_all2_view issue text 2147483647  √  null
bib_all_view issue text 2147483647  √  null
bib_refs issue text 2147483647  √  null reference issue
bib_view issue text 2147483647  √  null
pwi_bib_refs_view issue text 2147483647  √  null
all_allele_view iswildtype int2 5  √  null
pwi_all_allele_view iswildtype int2 5  √  null
all_allele_view jnum int4 10  √  null
all_cellline_derivation_view jnum int4 10  √  null
bib_all2_view jnum int4 10  √  null
bib_all_view jnum int4 10  √  null
bib_goxref_view jnum int4 10  √  null
bib_view jnum int4 10  √  null
gxd_antibodyaliasref_view jnum int4 10  √  null
gxd_assay_view jnum int4 10  √  null
gxd_index_view jnum int4 10  √  null
img_image_view jnum int4 10  √  null
img_imagepanegxd_view jnum int4 10  √  null
mgi_reference_allele_view jnum int4 10  √  null
mgi_reference_allelevariant_view jnum int4 10  √  null
mgi_reference_antibody_view jnum int4 10  √  null
mgi_reference_marker_view jnum int4 10  √  null
mgi_reference_sequence_view jnum int4 10  √  null
mgi_reference_strain_view jnum int4 10  √  null
mgi_relationship_markertss_view jnum int4 10  √  null
mgi_synonym_allele_view jnum int4 10  √  null
mgi_synonym_goterm_view jnum int4 10  √  null
mgi_synonym_musmarker_view jnum int4 10  √  null
mgi_synonym_strain_view jnum int4 10  √  null
mld_concordance_view jnum int4 10  √  null
mld_expt_marker_view jnum int4 10  √  null
mld_expt_view jnum int4 10  √  null
mld_fish_view jnum int4 10  √  null
mld_hybrid_view jnum int4 10  √  null
mld_insitu_view jnum int4 10  √  null
mld_matrix_view jnum int4 10  √  null
mld_mc2point_view jnum int4 10  √  null
mld_ri2point_view jnum int4 10  √  null
mld_ri_view jnum int4 10  √  null
mld_ridata_view jnum int4 10  √  null
mld_statistics_view jnum int4 10  √  null
mrk_accref1_view jnum int4 10  √  null
mrk_accref2_view jnum int4 10  √  null
mrk_accref_view jnum int4 10  √  null
mrk_reference_view jnum int4 10  √  null
prb_marker_view jnum int4 10  √  null
prb_reference_view jnum int4 10  √  null
prb_sourceref_view jnum int4 10  √  null
seq_allele_assoc_view jnum int4 10  √  null
seq_allele_view jnum int4 10  √  null
seq_marker_cache_view jnum int4 10  √  null
seq_probe_cache_view jnum int4 10  √  null
voc_evidence_view jnum int4 10  √  null
voc_vocab_view jnum int4 10  √  null
all_allele_view jnumid text 2147483647  √  null
all_cellline_derivation_view jnumid text 2147483647  √  null
bib_all2_view jnumid text 2147483647  √  null
bib_all_view jnumid text 2147483647  √  null
bib_citation_cache jnumid text 2147483647  √  null J: accession id
bib_goxref_view jnumid text 2147483647  √  null
bib_view jnumid text 2147483647  √  null
gxd_antibodyaliasref_view jnumid text 2147483647  √  null
gxd_assay_view jnumid text 2147483647  √  null
gxd_index_view jnumid text 2147483647  √  null
img_image_view jnumid text 2147483647  √  null
img_imagepanegxd_view jnumid text 2147483647  √  null
mgi_reference_allele_view jnumid text 2147483647  √  null
mgi_reference_allelevariant_view jnumid text 2147483647  √  null
mgi_reference_antibody_view jnumid text 2147483647  √  null
mgi_reference_marker_view jnumid text 2147483647  √  null
mgi_reference_sequence_view jnumid text 2147483647  √  null
mgi_reference_strain_view jnumid text 2147483647  √  null
mgi_relationship_markertss_view jnumid text 2147483647  √  null
mgi_synonym_allele_view jnumid text 2147483647  √  null
mgi_synonym_goterm_view jnumid text 2147483647  √  null
mgi_synonym_musmarker_view jnumid text 2147483647  √  null
mgi_synonym_strain_view jnumid text 2147483647  √  null
mld_concordance_view jnumid text 2147483647  √  null
mld_expt_marker_view jnumid text 2147483647  √  null
mld_expt_view jnumid text 2147483647  √  null
mld_fish_view jnumid text 2147483647  √  null
mld_hybrid_view jnumid text 2147483647  √  null
mld_insitu_view jnumid text 2147483647  √  null
mld_matrix_view jnumid text 2147483647  √  null
mld_mc2point_view jnumid text 2147483647  √  null
mld_ri2point_view jnumid text 2147483647  √  null
mld_ri_view jnumid text 2147483647  √  null
mld_ridata_view jnumid text 2147483647  √  null
mld_statistics_view jnumid text 2147483647  √  null
mrk_accref1_view jnumid text 2147483647  √  null
mrk_accref2_view jnumid text 2147483647  √  null
mrk_accref_view jnumid text 2147483647  √  null
mrk_history_view jnumid text 2147483647  √  null
mrk_reference_view jnumid text 2147483647  √  null
prb_reference_view jnumid text 2147483647  √  null
prb_sourceref_view jnumid text 2147483647  √  null
pwi_bib_refs_view jnumid text 2147483647  √  null
seq_allele_assoc_view jnumid text 2147483647  √  null
seq_allele_view jnumid text 2147483647  √  null
seq_marker_cache_view jnumid text 2147483647  √  null
seq_probe_cache_view jnumid text 2147483647  √  null
voc_evidence_view jnumid text 2147483647  √  null
voc_vocab_view jnumid text 2147483647  √  null
bib_all2_view journal text 2147483647  √  null
bib_all_view journal text 2147483647  √  null
bib_citation_cache journal text 2147483647  √  null reference journal
bib_refs journal text 2147483647  √  null reference journal
bib_view journal text 2147483647  √  null
pwi_bib_refs_view journal text 2147483647  √  null
all_knockout_cache jrsid text 2147483647  √  null the Jax Registry ID (JRS) of the knockout
mld_fish karyotype text 2147483647  √  null method used to identify chromosome bands
mld_fish_view karyotype text 2147483647  √  null
mld_insitu karyotype text 2147483647  √  null method used to identify chromosome bands
mld_insitu_view karyotype text 2147483647  √  null
gxd_antibodyprep_view label text 2147483647  √  null
gxd_probeprep_view label text 2147483647  √  null
mgi_setmember label text 2147483647  √  null label of the member (optional)
mld_fish label text 2147483647  √  null type of fluorescence on probe
mld_fish_view label text 2147483647  √  null
gxd_gellane lanelabel text 2147483647  √  null lane label to describe lane contents
gxd_gellane_view lanelabel text 2147483647  √  null
gxd_gellane lanenote text 2147483647  √  null notes for entire lane
gxd_gellane_view lanenote text 2147483647  √  null
gxd_gelband_view lanenum int4 10  √  null
gxd_htexperiment last_curated_date timestamp 29,6  √  null date record was last curated
pwi_report last_run timestamp 29,6  √  now() None
pwi_report last_run_duration text 2147483647  √  null None
gxd_htexperiment lastupdate_date timestamp 29,6  √  null date the experiment was last updated at source
mgi_organism latinname text 2147483647  √  null latin name of organism
mgi_organism_allele_view latinname text 2147483647  √  null
mgi_organism_antigen_view latinname text 2147483647  √  null
mgi_organism_marker_view latinname text 2147483647  √  null
mgi_organism_mgitype_view latinname text 2147483647  √  null
mgi_organism_probe_view latinname text 2147483647  √  null
mgi_organism_view latinname text 2147483647  √  null
mrk_marker_view latinname text 2147483647  √  null
mrk_mouse_view latinname text 2147483647  √  null
seq_sequence length int4 10  √  null length of sequence
seq_sequence_view length int4 10  √  null
gxd_antibodyantigen_view library text 2147483647  √  null
gxd_antigen_view library text 2147483647  √  null
bib_workflow_data linksupplemental text 2147483647  √  null not used/can be removed
acc_view logicaldb text 2147483647  √  null
all_acc_view logicaldb text 2147483647  √  null
all_cellline_acc_view logicaldb text 2147483647  √  null
bib_acc_view logicaldb text 2147483647  √  null
gxd_antibody_acc_view logicaldb text 2147483647  √  null
gxd_antigen_acc_view logicaldb text 2147483647  √  null
gxd_assay_acc_view logicaldb text 2147483647  √  null
gxd_genotype_acc_view logicaldb text 2147483647  √  null
gxd_genotype_summary_view logicaldb text 2147483647  √  null
img_image_acc_view logicaldb text 2147483647  √  null
mgi_organism_acc_view logicaldb text 2147483647  √  null
mld_acc_view logicaldb text 2147483647  √  null
mrk_acc_view logicaldb text 2147483647  √  null
mrk_accnoref_view logicaldb text 2147483647  √  null
mrk_accref1_view logicaldb text 2147483647  √  null
mrk_accref2_view logicaldb text 2147483647  √  null
mrk_accref_view logicaldb text 2147483647  √  null
mrk_nonmouse_view logicaldb text 2147483647  √  null
prb_acc_view logicaldb text 2147483647  √  null
prb_accnoref_view logicaldb text 2147483647  √  null
prb_accref_view logicaldb text 2147483647  √  null
prb_accrefnoseq_view logicaldb text 2147483647  √  null
prb_source_acc_view logicaldb text 2147483647  √  null
prb_strain_acc_view logicaldb text 2147483647  √  null
seq_allele_assoc_view logicaldb text 2147483647  √  null
seq_sequence_acc_view logicaldb text 2147483647  √  null
voc_term_acc_view logicaldb text 2147483647  √  null
voc_vocab_view logicaldb text 2147483647  √  null
mgi_user_active_view login text 2147483647  √  null
mgi_userrole_view login text 2147483647  √  null
mgi_usertask_view login text 2147483647  √  null
mld_matrix male text 2147483647  √  null genotype of father
mld_matrix_view male text 2147483647  √  null
mld_matrix male2 text 2147483647  √  null genotype of father; overflow
mld_matrix_view male2 text 2147483647  √  null
crs_cross maleallele1 bpchar 1  √  null first allele of paternal strain; used during construction of paternal genotype
crs_cross_view maleallele1 bpchar 1  √  null
mld_matrix_view maleallele1 bpchar 1  √  null
crs_cross maleallele2 bpchar 1  √  null second allele of paternal strain; used during construction of paternal genotype
crs_cross_view maleallele2 bpchar 1  √  null
mld_matrix_view maleallele2 bpchar 1  √  null
crs_cross_view malestrain text 2147483647  √  null
mld_matrix_view malestrain text 2147483647  √  null
mrk_location_cache mapunits text 2147483647  √  null units of genome coordinates
mgi_relationship_markertss_view marker1 text 2147483647  √  null
mgi_relationship_markertss_view marker2 text 2147483647  √  null
all_allele_view markerallele_status text 2147483647  √  null
seq_marker_cache_view markerid text 2147483647  √  null
mrk_history_view markername text 2147483647  √  null
all_allele_view markersymbol text 2147483647  √  null
mgi_reference_allele_view markersymbol text 2147483647  √  null
mrk_marker_view markertype text 2147483647  √  null
mrk_mouse_view markertype text 2147483647  √  null
mld_expt_marker_view matrixdata int2 5  √  null
mld_contig maxcm numeric 131089  √  null maximum cM position of markers within the Contig
all_derivation_summary_view mgiid text 2147483647  √  null
all_summary_view mgiid text 2147483647  √  null
bib_summary_all_view mgiid text 2147483647  √  null
gxd_antibody_view mgiid text 2147483647  √  null
gxd_antibodyantigen_view mgiid text 2147483647  √  null
gxd_antigen_summary_view mgiid text 2147483647  √  null
gxd_antigen_view mgiid text 2147483647  √  null
gxd_assay_view mgiid text 2147483647  √  null
gxd_gellane_view mgiid text 2147483647  √  null
gxd_genotype_summary_view mgiid text 2147483647  √  null
gxd_genotype_view mgiid text 2147483647  √  null
gxd_specimen_view mgiid text 2147483647  √  null
img_image_summary_view mgiid text 2147483647  √  null
img_image_view mgiid text 2147483647  √  null
img_imagepane_assoc_view mgiid text 2147483647  √  null
mgi_organism_summary_view mgiid text 2147483647  √  null
mld_expt_view mgiid text 2147483647  √  null
mld_summary_view mgiid text 2147483647  √  null
mrk_mouse_view mgiid text 2147483647  √  null
mrk_reference_view mgiid text 2147483647  √  null
mrk_summary_view mgiid text 2147483647  √  null
prb_probe_view mgiid text 2147483647  √  null
prb_source_summary_view mgiid text 2147483647  √  null
prb_strain_genotype_view mgiid text 2147483647  √  null
prb_strain_summary_view mgiid text 2147483647  √  null
prb_tissue_summary_view mgiid text 2147483647  √  null
pwi_all_allele_view mgiid text 2147483647  √  null
pwi_mrk_marker_view mgiid text 2147483647  √  null
seq_summary_view mgiid text 2147483647  √  null
voc_term_summary_view mgiid text 2147483647  √  null
acc_view mgitype text 2147483647  √  null
mgi_note_allele_view mgitype text 2147483647  √  null
mgi_note_allelevariant_view mgitype text 2147483647  √  null
mgi_note_derivation_view mgitype text 2147483647  √  null
mgi_note_genotype_view mgitype text 2147483647  √  null
mgi_note_image_view mgitype text 2147483647  √  null
mgi_note_marker_view mgitype text 2147483647  √  null
mgi_note_mrkgo_view mgitype text 2147483647  √  null
mgi_note_probe_view mgitype text 2147483647  √  null
mgi_note_sequence_view mgitype text 2147483647  √  null
mgi_note_source_view mgitype text 2147483647  √  null
mgi_note_strain_view mgitype text 2147483647  √  null
mgi_note_vocevidence_view mgitype text 2147483647  √  null
mrk_accnoref_view mgitype text 2147483647  √  null
mrk_accref1_view mgitype text 2147483647  √  null
mrk_accref2_view mgitype text 2147483647  √  null
mrk_accref_view mgitype text 2147483647  √  null
prb_accnoref_view mgitype text 2147483647  √  null
prb_accref_view mgitype text 2147483647  √  null
prb_accrefnoseq_view mgitype text 2147483647  √  null
seq_allele_view mgitype varchar 10  √  null
seq_marker_cache_view mgitype varchar 10  √  null
seq_probe_cache_view mgitype varchar 10  √  null
mld_contig mincm numeric 131089  √  null minimum cM position of markers within the Contig
mld_contig minlink int4 10  √  null indicates the minimum number of common hits required to assemble YACs into the Contig.
acc_logicaldb_view modification_date timestamp 29,6  √  null
acc_view modification_date timestamp 29,6  √  null
all_acc_view modification_date timestamp 29,6  √  null
all_allele_cellline_view modification_date timestamp 29,6  √  null
all_allele_mutation_view modification_date timestamp 29,6  √  null
all_allele_subtype_view modification_date timestamp 29,6  √  null
all_allele_view modification_date timestamp 29,6  √  null
all_cellline_acc_view modification_date timestamp 29,6  √  null
all_cellline_derivation_view modification_date timestamp 29,6  √  null
all_cellline_view modification_date timestamp 29,6  √  null
all_derivation_summary_view modification_date timestamp 29,6  √  null
all_summary_view modification_date timestamp 29,6  √  null
bib_acc_view modification_date timestamp 29,6  √  null
bib_all2_view modification_date timestamp 29,6  √  null
bib_all_view modification_date timestamp 29,6  √  null
bib_summary_all_view modification_date timestamp 29,6  √  null
bib_view modification_date timestamp 29,6  √  null
crs_cross_view modification_date timestamp 29,6  √  null
dag_node_view modification_date timestamp 29,6  √  null
go_tracking_view modification_date timestamp 29,6  √  null
gxd_allelepair_view modification_date timestamp 29,6  √  null
gxd_antibody_acc_view modification_date timestamp 29,6  √  null
gxd_antibody_view modification_date timestamp 29,6  √  null
gxd_antibodyalias_view modification_date timestamp 29,6  √  null
gxd_antibodyaliasref_view modification_date timestamp 29,6  √  null
gxd_antibodyantigen_view modification_date timestamp 29,6  √  null
gxd_antibodyprep_view modification_date timestamp 29,6  √  null
gxd_antigen_acc_view modification_date timestamp 29,6  √  null
gxd_antigen_summary_view modification_date timestamp 29,6  √  null
gxd_antigen_view modification_date timestamp 29,6  √  null
gxd_assay_acc_view modification_date timestamp 29,6  √  null
gxd_assay_view modification_date timestamp 29,6  √  null
gxd_gelband_view modification_date timestamp 29,6  √  null
gxd_gellane_view modification_date timestamp 29,6  √  null
gxd_gellanestructure_view modification_date timestamp 29,6  √  null
gxd_gelrow_view modification_date timestamp 29,6  √  null
gxd_genotype_acc_view modification_date timestamp 29,6  √  null
gxd_genotype_summary_view modification_date timestamp 29,6  √  null
gxd_genotype_view modification_date timestamp 29,6  √  null
gxd_index_view modification_date timestamp 29,6  √  null
gxd_insituresult_view modification_date timestamp 29,6  √  null
gxd_isresultimage_view modification_date timestamp 29,6  √  null
gxd_isresultstructure_view modification_date timestamp 29,6  √  null
gxd_probeprep_view modification_date timestamp 29,6  √  null
gxd_specimen_view modification_date timestamp 29,6  √  null
img_image_acc_view modification_date timestamp 29,6  √  null
img_image_summary_view modification_date timestamp 29,6  √  null
img_image_view modification_date timestamp 29,6  √  null
img_imagepane_assoc_view modification_date timestamp 29,6  √  null
mgi_note_allele_view modification_date timestamp 29,6  √  null
mgi_note_allelevariant_view modification_date timestamp 29,6  √  null
mgi_note_derivation_view modification_date timestamp 29,6  √  null
mgi_note_genotype_view modification_date timestamp 29,6  √  null
mgi_note_image_view modification_date timestamp 29,6  √  null
mgi_note_marker_view modification_date timestamp 29,6  √  null
mgi_note_mrkgo_view modification_date timestamp 29,6  √  null
mgi_note_probe_view modification_date timestamp 29,6  √  null
mgi_note_sequence_view modification_date timestamp 29,6  √  null
mgi_note_source_view modification_date timestamp 29,6  √  null
mgi_note_strain_view modification_date timestamp 29,6  √  null
mgi_note_vocevidence_view modification_date timestamp 29,6  √  null
mgi_notetype_alldriver_view modification_date timestamp 29,6  √  null
mgi_notetype_allele_view modification_date timestamp 29,6  √  null
mgi_notetype_derivation_view modification_date timestamp 29,6  √  null
mgi_notetype_genotype_view modification_date timestamp 29,6  √  null
mgi_notetype_image_view modification_date timestamp 29,6  √  null
mgi_notetype_marker_view modification_date timestamp 29,6  √  null
mgi_notetype_mrkgo_view modification_date timestamp 29,6  √  null
mgi_notetype_probe_view modification_date timestamp 29,6  √  null
mgi_notetype_sequence_view modification_date timestamp 29,6  √  null
mgi_notetype_source_view modification_date timestamp 29,6  √  null
mgi_notetype_strain_view modification_date timestamp 29,6  √  null
mgi_notetype_vocevidence_view modification_date timestamp 29,6  √  null
mgi_organism_acc_view modification_date timestamp 29,6  √  null
mgi_organism_allele_view modification_date timestamp 29,6  √  null
mgi_organism_antigen_view modification_date timestamp 29,6  √  null
mgi_organism_marker_view modification_date timestamp 29,6  √  null
mgi_organism_mgitype_view modification_date timestamp 29,6  √  null
mgi_organism_probe_view modification_date timestamp 29,6  √  null
mgi_organism_summary_view modification_date timestamp 29,6  √  null
mgi_organism_view modification_date timestamp 29,6  √  null
mgi_reference_allele_view modification_date timestamp 29,6  √  null
mgi_reference_allelevariant_view modification_date timestamp 29,6  √  null
mgi_reference_antibody_view modification_date timestamp 29,6  √  null
mgi_reference_marker_view modification_date timestamp 29,6  √  null
mgi_reference_sequence_view modification_date timestamp 29,6  √  null
mgi_reference_strain_view modification_date timestamp 29,6  √  null
mgi_reftype_allele_view modification_date timestamp 29,6  √  null
mgi_reftype_antibody_view modification_date timestamp 29,6  √  null
mgi_reftype_marker_view modification_date timestamp 29,6  √  null
mgi_reftype_sequence_view modification_date timestamp 29,6  √  null
mgi_reftype_strain_view modification_date timestamp 29,6  √  null
mgi_relationship_markertss_view modification_date timestamp 29,6  √  null
mgi_roletask_view modification_date timestamp 29,6  √  null
mgi_synonym_allele_view modification_date timestamp 29,6  √  null
mgi_synonym_goterm_view modification_date timestamp 29,6  √  null
mgi_synonym_musmarker_view modification_date timestamp 29,6  √  null
mgi_synonym_strain_view modification_date timestamp 29,6  √  null
mgi_synonymtype_allele_view modification_date timestamp 29,6  √  null
mgi_synonymtype_goterm_view modification_date timestamp 29,6  √  null
mgi_synonymtype_musmarker_view modification_date timestamp 29,6  √  null
mgi_synonymtype_strain_view modification_date timestamp 29,6  √  null
mgi_translation_view modification_date timestamp 29,6  √  null
mgi_translationstrain_view modification_date timestamp 29,6  √  null
mgi_user_active_view modification_date timestamp 29,6  √  null
mgi_userrole_view modification_date timestamp 29,6  √  null
mgi_usertask_view modification_date timestamp 29,6  √  null
mld_acc_view modification_date timestamp 29,6  √  null
mld_concordance_view modification_date timestamp 29,6  √  null
mld_expt_marker_view modification_date timestamp 29,6  √  null
mld_expt_view modification_date timestamp 29,6  √  null
mld_fish_view modification_date timestamp 29,6  √  null
mld_hybrid_view modification_date timestamp 29,6  √  null
mld_insitu_view modification_date timestamp 29,6  √  null
mld_matrix_view modification_date timestamp 29,6  √  null
mld_mc2point_view modification_date timestamp 29,6  √  null
mld_ri2point_view modification_date timestamp 29,6  √  null
mld_ridata_view modification_date timestamp 29,6  √  null
mld_statistics_view modification_date timestamp 29,6  √  null
mld_summary_view modification_date timestamp 29,6  √  null
mrk_acc_view modification_date timestamp 29,6  √  null
mrk_accnoref_view modification_date timestamp 29,6  √  null
mrk_accref1_view modification_date timestamp 29,6  √  null
mrk_accref2_view modification_date timestamp 29,6  √  null
mrk_accref_view modification_date timestamp 29,6  √  null
mrk_alias_view modification_date timestamp 29,6  √  null
mrk_anchors_view modification_date timestamp 29,6  √  null
mrk_current_view modification_date timestamp 29,6  √  null
mrk_history_view modification_date timestamp 29,6  √  null
mrk_marker_view modification_date timestamp 29,6  √  null
mrk_mouse_view modification_date timestamp 29,6  √  null
mrk_nonmouse_view modification_date timestamp 29,6  √  null
mrk_reference_view modification_date timestamp 29,6  √  null
mrk_summary_view modification_date timestamp 29,6  √  null
prb_acc_view modification_date timestamp 29,6  √  null
prb_accnoref_view modification_date timestamp 29,6  √  null
prb_accref_view modification_date timestamp 29,6  √  null
prb_accrefnoseq_view modification_date timestamp 29,6  √  null
prb_marker_view modification_date timestamp 29,6  √  null
prb_probe_view modification_date timestamp 29,6  √  null
prb_reference_view modification_date timestamp 29,6  √  null
prb_rflv_view modification_date timestamp 29,6  √  null
prb_source_acc_view modification_date timestamp 29,6  √  null
prb_source_summary_view modification_date timestamp 29,6  √  null
prb_source_view modification_date timestamp 29,6  √  null
prb_strain_acc_view modification_date timestamp 29,6  √  null
prb_strain_genotype_view modification_date timestamp 29,6  √  null
prb_strain_marker_view modification_date timestamp 29,6  √  null
prb_strain_needsreview_view modification_date timestamp 29,6  √  null
prb_strain_summary_view modification_date timestamp 29,6  √  null
prb_strain_view modification_date timestamp 29,6  √  null
prb_tissue_summary_view modification_date timestamp 29,6  √  null
pwi_all_allele_view modification_date timestamp 29,6  √  null
pwi_bib_refs_view modification_date timestamp 29,6  √  null
pwi_mrk_marker_view modification_date timestamp 29,6  √  null
ri_riset_view modification_date timestamp 29,6  √  null
seq_allele_assoc_view modification_date timestamp 29,6  √  null
seq_sequence_acc_view modification_date timestamp 29,6  √  null
seq_sequence_view modification_date timestamp 29,6  √  null
seq_summary_view modification_date timestamp 29,6  √  null
voc_annot_view modification_date timestamp 29,6  √  null
voc_annotheader_view modification_date timestamp 29,6  √  null
voc_evidence_view modification_date timestamp 29,6  √  null
voc_evidenceproperty_view modification_date timestamp 29,6  √  null
voc_term_acc_view modification_date timestamp 29,6  √  null
voc_term_cellline_view modification_date timestamp 29,6  √  null
voc_term_mcv_view modification_date timestamp 29,6  √  null
voc_term_repqualifier_view modification_date timestamp 29,6  √  null
voc_term_strainallele_view modification_date timestamp 29,6  √  null
voc_term_strainspecies_view modification_date timestamp 29,6  √  null
voc_term_summary_view modification_date timestamp 29,6  √  null
voc_term_view modification_date timestamp 29,6  √  null
voc_vocab_view modification_date timestamp 29,6  √  null
voc_vocabdag_view modification_date timestamp 29,6  √  null
img_image_view modifiedb text 2147483647  √  null
all_allele_cellline_view modifiedby text 2147483647  √  null
all_allele_view modifiedby text 2147483647  √  null
all_cellline_derivation_view modifiedby text 2147483647  √  null
all_cellline_view modifiedby text 2147483647  √  null
bib_all2_view modifiedby text 2147483647  √  null
bib_view modifiedby text 2147483647  √  null
gxd_antibody_view modifiedby text 2147483647  √  null
gxd_antibodyantigen_view modifiedby text 2147483647  √  null
gxd_antigen_view modifiedby text 2147483647  √  null
gxd_assay_view modifiedby text 2147483647  √  null
gxd_genotype_view modifiedby text 2147483647  √  null
gxd_index_view modifiedby text 2147483647  √  null
mgi_note_allele_view modifiedby text 2147483647  √  null
mgi_note_allelevariant_view modifiedby text 2147483647  √  null
mgi_note_derivation_view modifiedby text 2147483647  √  null
mgi_note_genotype_view modifiedby text 2147483647  √  null
mgi_note_image_view modifiedby text 2147483647  √  null
mgi_note_marker_view modifiedby text 2147483647  √  null
mgi_note_mrkgo_view modifiedby text 2147483647  √  null
mgi_note_probe_view modifiedby text 2147483647  √  null
mgi_note_sequence_view modifiedby text 2147483647  √  null
mgi_note_source_view modifiedby text 2147483647  √  null
mgi_note_strain_view modifiedby text 2147483647  √  null
mgi_note_vocevidence_view modifiedby text 2147483647  √  null
mgi_organism_view modifiedby text 2147483647  √  null
mgi_reference_marker_view modifiedby text 2147483647  √  null
mgi_reference_strain_view modifiedby text 2147483647  √  null
mgi_relationship_markertss_view modifiedby text 2147483647  √  null
mgi_synonym_allele_view modifiedby text 2147483647  √  null
mgi_synonym_goterm_view modifiedby text 2147483647  √  null
mgi_synonym_musmarker_view modifiedby text 2147483647  √  null
mgi_synonym_strain_view modifiedby text 2147483647  √  null
mgi_translation_view modifiedby text 2147483647  √  null
mgi_user_active_view modifiedby text 2147483647  √  null
mgi_userrole_view modifiedby text 2147483647  √  null
mgi_usertask_view modifiedby text 2147483647  √  null
mrk_accref1_view modifiedby text 2147483647  √  null
mrk_accref2_view modifiedby text 2147483647  √  null
mrk_accref_view modifiedby text 2147483647  √  null
mrk_history_view modifiedby text 2147483647  √  null
mrk_marker_view modifiedby text 2147483647  √  null
prb_marker_view modifiedby text 2147483647  √  null
prb_probe_view modifiedby text 2147483647  √  null
prb_reference_view modifiedby text 2147483647  √  null
prb_source_view modifiedby text 2147483647  √  null
prb_strain_genotype_view modifiedby text 2147483647  √  null
prb_strain_view modifiedby text 2147483647  √  null
seq_allele_assoc_view modifiedby text 2147483647  √  null
seq_sequence_view modifiedby text 2147483647  √  null
voc_evidence_view modifiedby text 2147483647  √  null
voc_evidenceproperty_view modifiedby text 2147483647  √  null
all_allele_mutation_view mutation text 2147483647  √  null
acc_logicaldb_view name text 2147483647  √  null
all_allele_view name text 2147483647  √  null
all_cellline_derivation name text 2147483647  √  null Cell Line Library Name
all_cellline_derivation_view name text 2147483647  √  null
crs_progeny name text 2147483647  √  null progeny name
gxd_assay_view name text 2147483647  √  null
gxd_htexperiment name text 2147483647  √  null name/title of the experiment
gxd_htsample name text 2147483647  √  null name/title of the sample
map_coordinate name text 2147483647  √  null public Map label which is printed in the WI or on reports
mgi_user_active_view name text 2147483647  √  null
mld_contig name text 2147483647  √  null name of Contig
mrk_history name text 2147483647  √  null name of the symbol
mrk_history_view name text 2147483647  √  null
mrk_marker_view name text 2147483647  √  null
mrk_mouse_view name text 2147483647  √  null
mrk_nonmouse_view name text 2147483647  √  null
prb_marker_view name text 2147483647  √  null
prb_parent_view name text 2147483647  √  null
prb_probe_view name text 2147483647  √  null
prb_source name text 2147483647  √  null source name
prb_source_view name text 2147483647  √  null
pwi_all_allele_view name text 2147483647  √  null
pwi_mrk_marker_view name text 2147483647  √  null
seq_probe_cache_view name text 2147483647  √  null
voc_term_cellline_view name text 2147483647  √  null
voc_term_mcv_view name text 2147483647  √  null
voc_term_repqualifier_view name text 2147483647  √  null
voc_term_strainallele_view name text 2147483647  √  null
voc_term_strainspecies_view name text 2147483647  √  null
voc_vocab_view name text 2147483647  √  null
all_knockout_cache nihid text 2147483647  √  null the NIH ID of the knockout
gxd_genotype note text 2147483647  √  null note
gxd_genotype_view note text 2147483647  √  null
gxd_htsample_rnaseqset note text 2147483647  √  null sample note from MGI_Note/MGI_NoteChunk where _NoteType_key = 1048
mgi_note_allele_view note text 2147483647  √  null
mgi_note_allelevariant_view note text 2147483647  √  null
mgi_note_derivation_view note text 2147483647  √  null
mgi_note_genotype_view note text 2147483647  √  null
mgi_note_image_view note text 2147483647  √  null
mgi_note_marker_view note text 2147483647  √  null
mgi_note_mrkgo_view note text 2147483647  √  null
mgi_note_probe_view note text 2147483647  √  null
mgi_note_sequence_view note text 2147483647  √  null
mgi_note_source_view note text 2147483647  √  null
mgi_note_strain_view note text 2147483647  √  null
mgi_note_vocevidence_view note text 2147483647  √  null
voc_term note text 2147483647  √  null textual information/description
voc_term_cellline_view note text 2147483647  √  null
voc_term_mcv_view note text 2147483647  √  null
voc_term_repqualifier_view note text 2147483647  √  null
voc_term_strainallele_view note text 2147483647  √  null
voc_term_strainspecies_view note text 2147483647  √  null
voc_term_view note text 2147483647  √  null
crs_matrix notes text 2147483647  √  null notes
crs_progeny notes text 2147483647  √  null textual information
mgi_note_allele_view notetype text 2147483647  √  null
mgi_note_allelevariant_view notetype text 2147483647  √  null
mgi_note_derivation_view notetype text 2147483647  √  null
mgi_note_genotype_view notetype text 2147483647  √  null
mgi_note_image_view notetype text 2147483647  √  null
mgi_note_marker_view notetype text 2147483647  √  null
mgi_note_mrkgo_view notetype text 2147483647  √  null
mgi_note_probe_view notetype text 2147483647  √  null
mgi_note_sequence_view notetype text 2147483647  √  null
mgi_note_source_view notetype text 2147483647  √  null
mgi_note_strain_view notetype text 2147483647  √  null
mgi_note_vocevidence_view notetype text 2147483647  √  null
mgi_notetype_alldriver_view notetype text 2147483647  √  null
mgi_notetype_allele_view notetype text 2147483647  √  null
mgi_notetype_derivation_view notetype text 2147483647  √  null
mgi_notetype_genotype_view notetype text 2147483647  √  null
mgi_notetype_image_view notetype text 2147483647  √  null
mgi_notetype_marker_view notetype text 2147483647  √  null
mgi_notetype_mrkgo_view notetype text 2147483647  √  null
mgi_notetype_probe_view notetype text 2147483647  √  null
mgi_notetype_sequence_view notetype text 2147483647  √  null
mgi_notetype_source_view notetype text 2147483647  √  null
mgi_notetype_strain_view notetype text 2147483647  √  null
mgi_notetype_vocevidence_view notetype text 2147483647  √  null
crs_cross nprogeny int4 10  √  null number of progeny resulting from cross
crs_cross_view nprogeny int4 10  √  null
mld_matrix_view nprogeny int4 10  √  null
seq_sequence numberoforganisms int4 10  √  null for Swiss-Prot, number of non-mouse, non-human, non-rat organisms that are sources of this sequence
seq_sequence_view numberoforganisms int4 10  √  null
acc_accession numericpart int4 10  √  null the trailing numerical portion of accID
acc_view numericpart int4 10  √  null
all_acc_view numericpart int4 10  √  null
all_cellline_acc_view numericpart int4 10  √  null
all_derivation_summary_view numericpart int4 10  √  null
all_summary_view numericpart int4 10  √  null
bib_acc_view numericpart int4 10  √  null
bib_citation_cache numericpart int4 10  √  null the trailing numerical portion of accID
bib_summary_all_view numericpart int4 10  √  null
gxd_antibody_acc_view numericpart int4 10  √  null
gxd_antibody_view numericpart int4 10  √  null
gxd_antibodyantigen_view numericpart int4 10  √  null
gxd_antigen_acc_view numericpart int4 10  √  null
gxd_antigen_summary_view numericpart int4 10  √  null
gxd_antigen_view numericpart int4 10  √  null
gxd_assay_acc_view numericpart int4 10  √  null
gxd_assay_view numericpart int4 10  √  null
gxd_genotype_acc_view numericpart int4 10  √  null
gxd_genotype_summary_view numericpart int4 10  √  null
img_image_acc_view numericpart int4 10  √  null
img_image_summary_view numericpart int4 10  √  null
img_image_view numericpart int4 10  √  null
mgi_organism_acc_view numericpart int4 10  √  null
mgi_organism_summary_view numericpart int4 10  √  null
mld_acc_view numericpart int4 10  √  null
mld_expt_view numericpart int4 10  √  null
mld_summary_view numericpart int4 10  √  null
mrk_acc_view numericpart int4 10  √  null
mrk_accnoref_view numericpart int4 10  √  null
mrk_accref1_view numericpart int4 10  √  null
mrk_accref2_view numericpart int4 10  √  null
mrk_accref_view numericpart int4 10  √  null
mrk_mouse_view numericpart int4 10  √  null
mrk_summary_view numericpart int4 10  √  null
prb_acc_view numericpart int4 10  √  null
prb_accnoref_view numericpart int4 10  √  null
prb_accref_view numericpart int4 10  √  null
prb_accrefnoseq_view numericpart int4 10  √  null
prb_probe_view numericpart int4 10  √  null
prb_source_acc_view numericpart int4 10  √  null
prb_source_summary_view numericpart int4 10  √  null
prb_strain_acc_view numericpart int4 10  √  null
prb_strain_summary_view numericpart int4 10  √  null
prb_tissue_summary_view numericpart int4 10  √  null
seq_allele_assoc_view numericpart int4 10  √  null
seq_sequence_acc_view numericpart int4 10  √  null
seq_summary_view numericpart int4 10  √  null
voc_term_acc_view numericpart int4 10  √  null
voc_term_summary_view numericpart int4 10  √  null
mld_fish nummetaphase int4 10  √  null # of metaphase spreads analyzed in experiment
mld_fish_view nummetaphase int4 10  √  null
mld_insitu nummetaphase int4 10  √  null # of metaphase spreads analyzed in experiment
mld_insitu_view nummetaphase int4 10  √  null
mld_mc2point_view numparentals int4 10  √  null
mld_mc2point_view numrecombinants int4 10  √  null
mld_ri2point_view numrecombinants int4 10  √  null
mld_ri2point_view numtotal int4 10  √  null
voc_term_view obsoletestate text 2147483647  √  null
mgi_user orcid text 2147483647  √  null ORC ids (see orcid.org)
mgi_user_active_view orcid text 2147483647  √  null
acc_logicaldb_view organism text 2147483647  √  null
mgi_organism_allele_view organism text 2147483647  √  null
mgi_organism_marker_view organism text 2147483647  √  null
mrk_marker_view organism text 2147483647  √  null
mrk_mouse_view organism text 2147483647  √  null
prb_source_view organism text 2147483647  √  null
mld_ri_view origin text 2147483647  √  null
ri_riset_view origin text 2147483647  √  null
crs_matrix othersymbol text 2147483647  √  null symbol if not in MGD (and therefore _Marker_key is null)
gxd_isresultimage_view panelabel text 2147483647  √  null
img_imagepane panelabel text 2147483647  √  null pane label
img_imagepanegxd_view panelabel text 2147483647  √  null
all_allele_cellline_view parentcellline text 2147483647  √  null
all_cellline_derivation_view parentcellline text 2147483647  √  null
all_cellline_view parentcellline text 2147483647  √  null
all_allele_cellline_view parentcellline_key int4 10  √  null
all_cellline_derivation_view parentcellline_key int4 10  √  null
all_cellline_view parentcellline_key int4 10  √  null
all_cellline_derivation_view parentcelllinestrain text 2147483647  √  null
all_cellline_view parentcelllinestrain text 2147483647  √  null
all_cellline_derivation_view parentcelllinestrain_key int4 10  √  null
all_cellline_view parentcelllinestrain_key int4 10  √  null
all_cellline_derivation_view parentcelllinetype text 2147483647  √  null
all_allele_cellline_view parentcelllinetype_key int4 10  √  null
all_cellline_derivation_view parentcelllinetype_key int4 10  √  null
prb_parent_view parentclone text 2147483647  √  null
prb_probe_view parentclone text 2147483647  √  null
prb_parent_view parentid text 2147483647  √  null
prb_parent_view parentkey int4 10  √  null
prb_parent_view parentnumeric int4 10  √  null
prb_parent_view parentprefix text 2147483647  √  null
gxd_insituresult_view pattern text 2147483647  √  null
mld_statistics_view pcntrecomb numeric 131089  √  null
bib_all2_view pgs text 2147483647  √  null
bib_all_view pgs text 2147483647  √  null
bib_refs pgs text 2147483647  √  null page range of reference
bib_view pgs text 2147483647  √  null
pwi_bib_refs_view pgs text 2147483647  √  null
img_imagepane_assoc_view pixid text 2147483647  √  null
bib_books place text 2147483647  √  null publisher location
seq_genetrap pointcoordinate numeric 131089  √  null The single coordinate picked to indicate where the insertion actually happened
acc_view preferred int2 5  √  null
all_acc_view preferred int2 5  √  null
all_cellline_acc_view preferred int2 5  √  null
all_derivation_summary_view preferred int2 5  √  null
all_summary_view preferred int2 5  √  null
bib_acc_view preferred int2 5  √  null
bib_summary_all_view preferred int2 5  √  null
gxd_antibody_acc_view preferred int2 5  √  null
gxd_antigen_acc_view preferred