SchemaSpy Analysis of pub.mgd - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Mon Sep 28 09:47 EDT 2020 |
| ||||||
|
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 |