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_actualdb | _actualdb_key | serial | 10 | √ | nextval('acc_actualdb_seq'::regclass) | primary key | |
all_allele | _allele_key | serial | 10 | √ | nextval('all_allele_seq'::regclass) | primary key | |
gxd_allelepair | _allelepair_key | serial | 10 | √ | nextval('gxd_allelepair_seq'::regclass) | primary key | |
voc_annot | _annot_key | serial | 10 | √ | nextval('voc_annot_seq'::regclass) | primary key | |
voc_evidence | _annotevidence_key | serial | 10 | √ | nextval('voc_evidence_seq'::regclass) | primary key | |
gxd_antibody | _antibody_key | serial | 10 | √ | nextval('gxd_antibody_seq'::regclass) | primary key | |
gxd_antibodyalias | _antibodyalias_key | serial | 10 | √ | nextval('gxd_antibodyalias_seq'::regclass) | primary key | |
gxd_antibodymarker | _antibodymarker_key | serial | 10 | √ | nextval('gxd_antibodymarker_seq'::regclass) | ||
gxd_antibodyprep | _antibodyprep_key | serial | 10 | √ | nextval('gxd_antibodyprep_seq'::regclass) | primary key | |
gxd_antigen | _antigen_key | serial | 10 | √ | nextval('gxd_antigen_seq'::regclass) | primary key | |
gxd_assay | _assay_key | serial | 10 | √ | nextval('gxd_assay_seq'::regclass) | primary key | |
gxd_assaynote | _assaynote_key | serial | 10 | √ | nextval('gxd_assaynote_seq'::regclass) | ||
all_allele_cellline | _assoc_key | serial | 10 | √ | nextval('all_allele_cellline_seq'::regclass) | primary key | |
all_allele_mutation | _assoc_key | serial | 10 | √ | nextval('all_allele_mutation_seq'::regclass) | ||
bib_workflow_data | _assoc_key | serial | 10 | √ | nextval('bib_workflow_data_seq'::regclass) | primary key | |
bib_workflow_status | _assoc_key | serial | 10 | √ | nextval('bib_workflow_status_seq'::regclass) | ||
bib_workflow_tag | _assoc_key | serial | 10 | √ | nextval('bib_workflow_tag_seq'::regclass) | ||
img_imagepane_assoc | _assoc_key | serial | 10 | √ | nextval('img_imagepane_assoc_seq'::regclass) | primary key | |
mgi_reference_assoc | _assoc_key | serial | 10 | √ | nextval('mgi_reference_assoc_seq'::regclass) | primary key | |
mrk_history | _assoc_key | serial | 10 | √ | nextval('mrk_history_seq'::regclass) | ||
seq_source_assoc | _assoc_key | serial | 10 | √ | nextval('seq_source_assoc_seq'::regclass) | primary key | |
voc_allele_cache | _cache_key | serial | 10 | √ | nextval('voc_allele_cache_seq'::regclass) | ||
voc_annot_count_cache | _cache_key | serial | 10 | √ | nextval('voc_annot_count_cache_seq'::regclass) | ||
voc_go_cache | _cache_key | serial | 10 | √ | nextval('voc_go_cache_seq'::regclass) | ||
voc_marker_cache | _cache_key | serial | 10 | √ | nextval('voc_marker_cache_seq'::regclass) | ||
all_cellline | _cellline_key | serial | 10 | √ | nextval('all_cellline_seq'::regclass) | primary key | |
all_cellline_derivation | _derivation_key | serial | 10 | √ | nextval('all_cellline_derivation_seq'::regclass) | primary key | |
voc_evidence_property | _evidenceproperty_key | serial | 10 | √ | nextval('voc_evidence_property_seq'::regclass) | primary key | |
gxd_gelband | _gelband_key | serial | 10 | √ | nextval('gxd_gelband_seq'::regclass) | primary key | |
gxd_gellane | _gellane_key | serial | 10 | √ | nextval('gxd_gellane_seq'::regclass) | primary key | |
gxd_gellanestructure | _gellanestructure_key | serial | 10 | √ | nextval('gxd_gellanestructure_seq'::regclass) | ||
gxd_gelrow | _gelrow_key | serial | 10 | √ | nextval('gxd_gelrow_seq'::regclass) | primary key | |
gxd_genotype | _genotype_key | serial | 10 | √ | nextval('gxd_genotype_seq'::regclass) | primary key | |
img_image | _image_key | serial | 10 | √ | nextval('img_image_seq'::regclass) | primary key | |
img_imagepane | _imagepane_key | serial | 10 | √ | nextval('img_imagepane_seq'::regclass) | primary key | |
acc_logicaldb | _logicaldb_key | serial | 10 | √ | nextval('acc_logicaldb_seq'::regclass) | primary key | |
mrk_marker | _marker_key | serial | 10 | √ | nextval('mrk_marker_seq'::regclass) | primary key | |
gxd_probeprep | _probeprep_key | serial | 10 | √ | nextval('gxd_probeprep_seq'::regclass) | primary key | |
bib_refs | _refs_key | serial | 10 | √ | nextval('bib_refs_seq'::regclass) | primary key | |
mgi_relationship | _relationship_key | serial | 10 | √ | nextval('mgi_relationship_seq'::regclass) | Primary key | |
gxd_insituresult | _result_key | serial | 10 | √ | nextval('gxd_insituresult_seq'::regclass) | primary key | |
gxd_insituresultimage | _resultimage_key | serial | 10 | √ | nextval('gxd_insituresultimage_seq'::regclass) | ||
gxd_isresultstructure | _resultstructure_key | serial | 10 | √ | nextval('gxd_isresultstructure_seq'::regclass) | ||
gxd_htsample_rnaseq | _rnaseq_key | serial | 10 | √ | nextval('gxd_htsample_rnaseq_seq'::regclass) | primary key | |
gxd_htsample_rnaseqcombined | _rnaseqcombined_key | serial | 10 | √ | nextval('gxd_htsample_rnaseqcombined_seq'::regclass) | primary key | |
gxd_htsample_rnaseqset | _rnaseqset_key | serial | 10 | √ | nextval('gxd_htsample_rnaseqset_seq'::regclass) | primary key | |
gxd_htsample_rnaseqsetmember | _rnaseqsetmember_key | serial | 10 | √ | nextval('gxd_htsample_rnaseqsetmember_seq'::regclass) | primary key | |
prb_source | _source_key | serial | 10 | √ | nextval('prb_source_seq'::regclass) | primary key | |
gxd_specimen | _specimen_key | serial | 10 | √ | nextval('gxd_specimen_seq'::regclass) | primary key | |
prb_strain | _strain_key | serial | 10 | √ | nextval('prb_strain_seq'::regclass) | primary key | |
prb_strain_genotype | _straingenotype_key | serial | 10 | √ | nextval('prb_strain_genotype_seq'::regclass) | primary key | |
prb_strain_marker | _strainmarker_key | serial | 10 | √ | nextval('prb_strain_marker_seq'::regclass) | primary key | |
mgi_synonym | _synonym_key | serial | 10 | √ | nextval('mgi_synonym_seq'::regclass) | primary key | |
voc_term | _term_key | serial | 10 | √ | nextval('voc_term_seq'::regclass) | primary key | |
prb_tissue | _tissue_key | serial | 10 | √ | nextval('prb_tissue_seq'::regclass) | primary key | |
all_variant | _variant_key | serial | 10 | √ | nextval('all_variant_seq'::regclass) | primary key, uniquely identifying the record | |
all_variant_sequence | _variantsequence_key | serial | 10 | √ | nextval('all_variantsequence_seq'::regclass) | primary key, uniquely identifying the record | |
pwi_report | id | serial | 10 | √ | nextval('pwi_report_id_seq'::regclass) | None | |
pwi_report_label | id | serial | 10 | √ | nextval('pwi_report_label_id_seq'::regclass) | None | |
acc_accession | _accession_key | int4 | 10 | primary key | |||
acc_accessionreference | _accession_key | int4 | 10 | primary key of the Accession number to which the Reference refers | |||
acc_view | _accession_key | int4 | 10 | √ | null | ||
all_acc_view | _accession_key | int4 | 10 | √ | null | ||
all_cellline_acc_view | _accession_key | int4 | 10 | √ | null | ||
all_derivation_summary_view | _accession_key | int4 | 10 | √ | null | ||
all_summary_view | _accession_key | int4 | 10 | √ | null | ||
bib_acc_view | _accession_key | int4 | 10 | √ | null | ||
bib_summary_all_view | _accession_key | int4 | 10 | √ | null | ||
gxd_antibody_acc_view | _accession_key | int4 | 10 | √ | null | ||
gxd_antigen_acc_view | _accession_key | int4 | 10 | √ | null | ||
gxd_antigen_summary_view | _accession_key | int4 | 10 | √ | null | ||
gxd_assay_acc_view | _accession_key | int4 | 10 | √ | null | ||
gxd_genotype_acc_view | _accession_key | int4 | 10 | √ | null | ||
gxd_genotype_summary_view | _accession_key | int4 | 10 | √ | null | ||
img_image_acc_view | _accession_key | int4 | 10 | √ | null | ||
img_image_summary_view | _accession_key | int4 | 10 | √ | null | ||
mgi_organism_acc_view | _accession_key | int4 | 10 | √ | null | ||
mgi_organism_summary_view | _accession_key | int4 | 10 | √ | null | ||
mld_acc_view | _accession_key | int4 | 10 | √ | null | ||
mld_summary_view | _accession_key | int4 | 10 | √ | null | ||
mrk_acc_view | _accession_key | int4 | 10 | √ | null | ||
mrk_accnoref_view | _accession_key | int4 | 10 | √ | null | ||
mrk_accref1_view | _accession_key | int4 | 10 | √ | null | ||
mrk_accref2_view | _accession_key | int4 | 10 | √ | null | ||
mrk_accref_view | _accession_key | int4 | 10 | √ | null | ||
mrk_mouse_view | _accession_key | int4 | 10 | √ | null | ||
mrk_nonmouse_view | _accession_key | int4 | 10 | √ | null | ||
mrk_summary_view | _accession_key | int4 | 10 | √ | null | ||
prb_acc_view | _accession_key | int4 | 10 | √ | null | ||
prb_accnoref_view | _accession_key | int4 | 10 | √ | null | ||
prb_accref_view | _accession_key | int4 | 10 | √ | null | ||
prb_accrefnoseq_view | _accession_key | int4 | 10 | √ | null | ||
prb_source_acc_view | _accession_key | int4 | 10 | √ | null | ||
prb_source_summary_view | _accession_key | int4 | 10 | √ | null | ||
prb_strain_acc_view | _accession_key | int4 | 10 | √ | null | ||
prb_strain_summary_view | _accession_key | int4 | 10 | √ | null | ||
prb_tissue_summary_view | _accession_key | int4 | 10 | √ | null | ||
seq_allele_assoc_view | _accession_key | int4 | 10 | √ | null | ||
seq_sequence_acc_view | _accession_key | int4 | 10 | √ | null | ||
seq_summary_view | _accession_key | int4 | 10 | √ | null | ||
voc_term_acc_view | _accession_key | int4 | 10 | √ | null | ||
voc_term_summary_view | _accession_key | int4 | 10 | √ | null | ||
mrk_alias | _alias_key | int4 | 10 | primary key | |||
mrk_alias_view | _alias_key | int4 | 10 | √ | null | ||
prb_alias | _alias_key | int4 | 10 | primary key | |||
all_allele_cellline | _allele_key | int4 | 10 | foreign key to ALL_Allele | |||
all_allele_cellline_view | _allele_key | int4 | 10 | √ | null | ||
all_allele_driver_view | _allele_key | int4 | 10 | √ | null | ||
all_allele_mutation | _allele_key | int4 | 10 | foreign key to ALL_Allele | |||
all_allele_mutation_view | _allele_key | int4 | 10 | √ | null | ||
all_allele_subtype_view | _allele_key | int4 | 10 | √ | null | ||
all_allele_view | _allele_key | int4 | 10 | √ | null | ||
all_annot_view | _allele_key | int4 | 10 | √ | null | ||
all_cre_cache | _allele_key | int4 | 10 | foreign key to ALL_Allele | |||
all_genotype_view | _allele_key | int4 | 10 | √ | null | ||
all_knockout_cache | _allele_key | int4 | 10 | √ | null | foreign key to ALL_Allele | |
all_label | _allele_key | int4 | 10 | foreign key to ALL_Allele | |||
all_variant | _allele_key | int4 | 10 | foreign key to ALL_Allele, identifies the allele for this variant | |||
gxd_allelegenotype | _allele_key | int4 | 10 | foreign key to ALL_Allele | |||
gxd_assay_allele_view | _allele_key | int4 | 10 | √ | null | ||
mld_expt_marker | _allele_key | int4 | 10 | √ | null | foreign key to ALL_Allele | |
mld_expt_marker_view | _allele_key | int4 | 10 | √ | null | ||
prb_allele | _allele_key | int4 | 10 | foreign key to ALL_Allele | |||
prb_allele_strain | _allele_key | int4 | 10 | foreign key to ALL_Allele | |||
prb_rflv_view | _allele_key | int4 | 10 | √ | null | ||
prb_strain_marker | _allele_key | int4 | 10 | √ | null | foreign key to ALL_Allele | |
prb_strain_marker_view | _allele_key | int4 | 10 | √ | null | ||
pwi_all_allele_view | _allele_key | int4 | 10 | √ | null | ||
seq_allele_assoc | _allele_key | int4 | 10 | foreign key to ALL_Allele | |||
seq_allele_assoc_view | _allele_key | int4 | 10 | √ | null | ||
seq_allele_view | _allele_key | int4 | 10 | √ | null | ||
voc_allele_cache | _allele_key | int4 | 10 | foreign key to ALL_Allele | |||
gxd_allelepair | _allele_key_1 | int4 | 10 | foreign key to ALL_Allele | |||
gxd_allelepair_view | _allele_key_1 | int4 | 10 | √ | null | ||
gxd_allelepair | _allele_key_2 | int4 | 10 | √ | null | foreign key to ALL_Allele | |
gxd_allelepair_view | _allele_key_2 | int4 | 10 | √ | null | ||
all_allele | _allele_status_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 37 (Allele Status); 'In Progress', 'Deleted', 'Reserved', 'Approved', 'Autoload' | |||
all_allele_view | _allele_status_key | int4 | 10 | √ | null | ||
pwi_all_allele_view | _allele_status_key | int4 | 10 | √ | null | ||
all_allele | _allele_type_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 38 (Allele Type); 'Spontaneous', 'Targeted', 'Gene trapped' | |||
all_allele_view | _allele_type_key | int4 | 10 | √ | null | ||
all_cre_cache | _allele_type_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 38 (Allele Type) | |||
pwi_all_allele_view | _allele_type_key | int4 | 10 | √ | null | ||
gxd_allelepair_view | _allelepair_key | int4 | 10 | √ | null | ||
dag_closure | _ancestor_key | int4 | 10 | foreign key to DAG_Node._Node_key | |||
dag_closure | _ancestorlabel_key | int4 | 10 | foreign key to DAG_Label; the label of the Ancestor | |||
dag_closure | _ancestorobject_key | int4 | 10 | the MGI object to which the Ancestor node refers | |||
all_allele_subtype_view | _annot_key | int4 | 10 | √ | null | ||
all_annot_view | _annot_key | int4 | 10 | √ | null | ||
prb_strain_attribute_view | _annot_key | int4 | 10 | √ | null | ||
prb_strain_needsreview_view | _annot_key | int4 | 10 | √ | null | ||
voc_annot_view | _annot_key | int4 | 10 | √ | null | ||
voc_evidence | _annot_key | int4 | 10 | foreign key to VOC_Annot | |||
voc_evidence_view | _annot_key | int4 | 10 | √ | null | ||
voc_evidence_property | _annotevidence_key | int4 | 10 | foreign key to VOC_Evidence | |||
voc_evidence_view | _annotevidence_key | int4 | 10 | √ | null | ||
voc_evidenceproperty_view | _annotevidence_key | int4 | 10 | √ | null | ||
voc_annotheader | _annotheader_key | int4 | 10 | primary key | |||
voc_annotheader_view | _annotheader_key | int4 | 10 | √ | null | ||
all_allele_subtype_view | _annottype_key | int4 | 10 | √ | null | ||
all_annot_view | _annottype_key | int4 | 10 | √ | null | ||
prb_strain_needsreview_view | _annottype_key | int4 | 10 | √ | null | ||
voc_annot | _annottype_key | int4 | 10 | foreign key to VOC_AnnotType; examples include 1000:GO/Marker), 1002:Mammelian Phenotypes/Genotype, 1020:DO/Genotype | |||
voc_annot_view | _annottype_key | int4 | 10 | √ | null | ||
voc_annotheader | _annottype_key | int4 | 10 | foreign key to VOC_AnnotType | |||
voc_annotheader_view | _annottype_key | int4 | 10 | √ | null | ||
voc_annottype | _annottype_key | int4 | 10 | primary key | |||
gxd_antibody_view | _antibody_key | int4 | 10 | √ | null | ||
gxd_antibodyalias | _antibody_key | int4 | 10 | foreign key to GXD_Antibody | |||
gxd_antibodyalias_view | _antibody_key | int4 | 10 | √ | null | ||
gxd_antibodyaliasref_view | _antibody_key | int4 | 10 | √ | null | ||
gxd_antibodyantigen_view | _antibody_key | int4 | 10 | √ | null | ||
gxd_antibodymarker | _antibody_key | int4 | 10 | foreign key to GXD_Antibody | |||
gxd_antibodymarker_view | _antibody_key | int4 | 10 | √ | null | ||
gxd_antibodyprep | _antibody_key | int4 | 10 | foreign key to GXD_Antibody | |||
gxd_antibodyprep_view | _antibody_key | int4 | 10 | √ | null | ||
gxd_antibodyalias_view | _antibodyalias_key | int4 | 10 | √ | null | ||
gxd_antibodyaliasref_view | _antibodyalias_key | int4 | 10 | √ | null | ||
gxd_antibody | _antibodyclass_key | int4 | 10 | foreign key to GXD_AntibodyClass | |||
gxd_antibody_view | _antibodyclass_key | int4 | 10 | √ | null | ||
gxd_antibodyclass | _antibodyclass_key | int4 | 10 | primary key | |||
gxd_antibodyprep_view | _antibodyprep_key | int4 | 10 | √ | null | ||
gxd_assay | _antibodyprep_key | int4 | 10 | √ | null | foreign key to GXD_AntibodyPrep | |
gxd_assay_view | _antibodyprep_key | int4 | 10 | √ | null | ||
gxd_antibody | _antibodytype_key | int4 | 10 | foreign key to GXD_AntibodyType | |||
gxd_antibody_view | _antibodytype_key | int4 | 10 | √ | null | ||
gxd_antibodytype | _antibodytype_key | int4 | 10 | primary key | |||
gxd_antibody | _antigen_key | int4 | 10 | foreign key to GXD_Antigen | |||
gxd_antibody_view | _antigen_key | int4 | 10 | √ | null | ||
gxd_antibodyantigen_view | _antigen_key | int4 | 10 | √ | null | ||
gxd_antigen_view | _antigen_key | int4 | 10 | √ | null | ||
all_allele | _approvedby_key | int4 | 10 | √ | null | user who approved record (foreign key to MGI_User) | |
all_allele_view | _approvedby_key | int4 | 10 | √ | null | ||
pwi_all_allele_view | _approvedby_key | int4 | 10 | √ | null | ||
voc_annotheader | _approvedby_key | int4 | 10 | √ | null | user who approved the record | |
voc_annotheader_view | _approvedby_key | int4 | 10 | √ | null | ||
all_cre_cache | _assay_key | int4 | 10 | √ | null | foreign key to GXD_Assay | |
gxd_antibodyprep_view | _assay_key | int4 | 10 | √ | null | ||
gxd_assay_allele_view | _assay_key | int4 | 10 | √ | null | ||
gxd_assay_view | _assay_key | int4 | 10 | √ | null | ||
gxd_assaynote | _assay_key | int4 | 10 | foreign key to GXD_Assay | |||
gxd_expression | _assay_key | int4 | 10 | foreign key to GXD_Assay | |||
gxd_gelband_view | _assay_key | int4 | 10 | √ | null | ||
gxd_gellane | _assay_key | int4 | 10 | foreign key to GXD_Assay | |||
gxd_gellane_view | _assay_key | int4 | 10 | √ | null | ||
gxd_gellanestructure_view | _assay_key | int4 | 10 | √ | null | ||
gxd_gelrow | _assay_key | int4 | 10 | foreign key to GXD_Assay | |||
gxd_gelrow_view | _assay_key | int4 | 10 | √ | null | ||
gxd_probeprep_view | _assay_key | int4 | 10 | √ | null | ||
gxd_specimen | _assay_key | int4 | 10 | foreign key to GXD_Assay | |||
gxd_specimen_view | _assay_key | int4 | 10 | √ | null | ||
mld_assay_types | _assay_type_key | int4 | 10 | primary key | |||
mld_expt_marker | _assay_type_key | int4 | 10 | foreign key to MLD_Assay_Types | |||
mld_expt_marker_view | _assay_type_key | int4 | 10 | √ | null | ||
gxd_assay | _assaytype_key | int4 | 10 | foreign key to GXD_AssayType | |||
gxd_assay_view | _assaytype_key | int4 | 10 | √ | null | ||
gxd_assaytype | _assaytype_key | int4 | 10 | primary key | |||
gxd_expression | _assaytype_key | int4 | 10 | foreign key to GXD_AssayType | |||
all_allele_cellline_view | _assoc_key | int4 | 10 | √ | null | ||
all_allele_mutation_view | _assoc_key | int4 | 10 | √ | null | ||
img_imagepane_assoc_view | _assoc_key | int4 | 10 | √ | null | ||
mgi_reference_allele_view | _assoc_key | int4 | 10 | √ | null | ||
mgi_reference_allelevariant_view | _assoc_key | int4 | 10 | √ | null | ||
mgi_reference_antibody_view | _assoc_key | int4 | 10 | √ | null | ||
mgi_reference_marker_view | _assoc_key | int4 | 10 | √ | null | ||
mgi_reference_sequence_view | _assoc_key | int4 | 10 | √ | null | ||
mgi_reference_strain_view | _assoc_key | int4 | 10 | √ | null | ||
mrk_history_view | _assoc_key | int4 | 10 | √ | null | ||
seq_allele_assoc | _assoc_key | int4 | 10 | primary key | |||
seq_allele_assoc_view | _assoc_key | int4 | 10 | √ | null | ||
seq_sequence_assoc | _assoc_key | int4 | 10 | primary key | |||
seq_marker_cache | _biotypeconflict_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 76 (BioType Conflict); 'Conflict', 'Not Applicable' | |||
mrk_biotypemapping | _biotypemapping_key | int4 | 10 | primary key | |||
mrk_biotypemapping | _biotypeterm_key | int4 | 10 | fk to voc_term | |||
mrk_biotypemapping | _biotypevocab_key | int4 | 10 | fk to voc_vocab; 1 of 3 provider biotype vocabs (103,104,105) | |||
all_cre_cache | _cache_key | int4 | 10 | primary key | |||
mrk_do_cache | _cache_key | int4 | 10 | primary key | |||
seq_marker_cache | _cache_key | int4 | 10 | primary key | |||
mgi_relationship | _category_key | int4 | 10 | The category, or type, of this relationship | |||
mgi_relationship_category | _category_key | int4 | 10 | Primary key | |||
mgi_relationship_markertss_view | _category_key | int4 | 10 | √ | null | ||
all_cellline_view | _cellline_key | int4 | 10 | √ | null | ||
gxd_antibodyantigen_view | _cellline_key | int4 | 10 | √ | null | ||
gxd_antigen_view | _cellline_key | int4 | 10 | √ | null | ||
prb_source | _cellline_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 18 (Cell Line) | |||
prb_source_view | _cellline_key | int4 | 10 | √ | null | ||
all_cellline | _cellline_type_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 63 (Cell Line Type) | |||
all_cellline_view | _cellline_type_key | int4 | 10 | √ | null | ||
dag_edge | _child_key | int4 | 10 | foreign key to DAG_Node._Node_key | |||
mrk_chromosome | _chromosome_key | int4 | 10 | primary key | |||
mrk_cluster | _cluster_key | int4 | 10 | Primary key | |||
mrk_clustermember | _cluster_key | int4 | 10 | Foreign key to MRK_Cluster | |||
mrk_clustermember | _clustermember_key | int4 | 10 | Primary key | |||
mrk_cluster | _clustersource_key | int4 | 10 | The term for the source or 'provider' of the cluster | |||
mrk_cluster | _clustertype_key | int4 | 10 | The term for the type of cluster | |||
all_allele | _collection_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 92 (Allele Collection); 'KOMP-CSD', 'NorCOMM', 'EUCOMM' |
|||
all_allele_view | _collection_key | int4 | 10 | √ | null | ||
map_coord_collection | _collection_key | int4 | 10 | primary key | |||
map_coordinate | _collection_key | int4 | 10 | foreign key to MAP_Coord_Collection | |||
pwi_all_allele_view | _collection_key | int4 | 10 | √ | null | ||
go_tracking | _completedby_key | int4 | 10 | √ | null | user who completed the record | |
go_tracking_view | _completedby_key | int4 | 10 | √ | null | ||
gxd_allelepair | _compound_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 74 (GXD Conditional Mutants) | |||
gxd_allelepair_view | _compound_key | int4 | 10 | √ | null | ||
gxd_index | _conditionalmutants_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 74 (GXD Conditional Mutants); 'Both tg & KI', 'Induce (minor)', 'Inducile', 'Knocked in', 'Tg (minor amt)', 'Transgenic', 'Not Specified', 'Not Applicable' | |||
gxd_index_view | _conditionalmutants_key | int4 | 10 | √ | null | ||
mld_contig | _contig_key | int4 | 10 | primary key | |||
mld_contigprobe | _contig_key | int4 | 10 | foreign key to MLD_Contig | |||
acc_accession | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
acc_accessionreference | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
acc_actualdb | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
acc_logicaldb | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
acc_logicaldb_view | _createdby_key | int4 | 10 | √ | null | ||
acc_mgitype | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
acc_view | _createdby_key | int4 | 10 | √ | null | ||
all_acc_view | _createdby_key | int4 | 10 | √ | null | ||
all_allele | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
all_allele_cellline | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
all_allele_cellline_view | _createdby_key | int4 | 10 | √ | null | ||
all_allele_view | _createdby_key | int4 | 10 | √ | null | ||
all_cellline | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
all_cellline_acc_view | _createdby_key | int4 | 10 | √ | null | ||
all_cellline_derivation | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
all_cellline_derivation_view | _createdby_key | int4 | 10 | √ | null | ||
all_cellline_view | _createdby_key | int4 | 10 | √ | null | ||
all_cre_cache | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
all_knockout_cache | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
all_summary_view | _createdby_key | int4 | 10 | √ | null | ||
all_variant | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
all_variant_sequence | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
bib_acc_view | _createdby_key | int4 | 10 | √ | null | ||
bib_all2_view | _createdby_key | int4 | 10 | √ | null | ||
bib_all_view | _createdby_key | int4 | 10 | √ | null | ||
bib_refs | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
bib_summary_all_view | _createdby_key | int4 | 10 | √ | null | ||
bib_view | _createdby_key | int4 | 10 | √ | null | ||
bib_workflow_data | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
bib_workflow_status | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
bib_workflow_tag | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
go_tracking | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
go_tracking_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_allelegenotype | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_allelepair | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_allelepair_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_antibody | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_antibody_acc_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_antibody_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_antibodyantigen_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_antigen | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_antigen_acc_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_antigen_summary_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_antigen_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_assay | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_assay_acc_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_assay_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_genotype | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_genotype_acc_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_genotype_summary_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_genotype_view | _createdby_key | int4 | 10 | √ | null | ||
gxd_htexperiment | _createdby_key | int4 | 10 | 1001 | foreign key to MGI_User; user who created the record | ||
gxd_htsample | _createdby_key | int4 | 10 | 1001 | foreign key to MGI_User; user who created the record | ||
gxd_htsample_rnaseq | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_htsample_rnaseqcombined | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_htsample_rnaseqset | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_htsample_rnaseqsetmember | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_index | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_index_stages | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
gxd_index_view | _createdby_key | int4 | 10 | √ | null | ||
img_image | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
img_image_acc_view | _createdby_key | int4 | 10 | √ | null | ||
img_image_summary_view | _createdby_key | int4 | 10 | √ | null | ||
img_image_view | _createdby_key | int4 | 10 | √ | null | ||
img_imagepane_assoc | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
img_imagepane_assoc_view | _createdby_key | int4 | 10 | √ | null | ||
map_coord_collection | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
map_coord_feature | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
map_coordinate | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_note | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_note_allele_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_note_allelevariant_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_note_derivation_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_note_genotype_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_note_image_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_note_marker_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_note_mrkgo_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_note_probe_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_note_sequence_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_note_source_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_note_strain_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_note_vocevidence_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notechunk | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_notetype | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_notetype_alldriver_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notetype_allele_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notetype_derivation_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notetype_genotype_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notetype_image_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notetype_marker_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notetype_mrkgo_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notetype_probe_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notetype_sequence_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notetype_source_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notetype_strain_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_notetype_vocevidence_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_organism | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_organism_acc_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_organism_allele_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_organism_antigen_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_organism_marker_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_organism_mgitype | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_organism_mgitype_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_organism_probe_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_organism_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_property | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_propertytype | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_refassoctype | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_reference_allele_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_reference_allelevariant_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_reference_antibody_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_reference_assoc | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_reference_marker_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_reference_sequence_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_reference_strain_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_reftype_allele_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_reftype_antibody_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_reftype_marker_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_reftype_sequence_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_reftype_strain_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_relationship | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_relationship_category | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_relationship_markertss_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_relationship_property | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_roletask | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_roletask_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_set | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_setmember | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_setmember_emapa | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_synonym | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_synonym_allele_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_synonym_goterm_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_synonym_musmarker_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_synonym_strain_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_synonymtype | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_synonymtype_allele_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_synonymtype_goterm_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_synonymtype_musmarker_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_synonymtype_strain_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_translation | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_translation_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_translationstrain_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_translationtype | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_user | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_user_active_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_userrole | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mgi_userrole_view | _createdby_key | int4 | 10 | √ | null | ||
mgi_usertask_view | _createdby_key | int4 | 10 | √ | null | ||
mld_acc_view | _createdby_key | int4 | 10 | √ | null | ||
mld_summary_view | _createdby_key | int4 | 10 | √ | null | ||
mrk_acc_view | _createdby_key | int4 | 10 | √ | null | ||
mrk_accnoref_view | _createdby_key | int4 | 10 | √ | null | ||
mrk_accref1_view | _createdby_key | int4 | 10 | √ | null | ||
mrk_accref2_view | _createdby_key | int4 | 10 | √ | null | ||
mrk_accref_view | _createdby_key | int4 | 10 | √ | null | ||
mrk_biotypemapping | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mrk_chromosome | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mrk_cluster | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mrk_history | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mrk_history_view | _createdby_key | int4 | 10 | √ | null | ||
mrk_location_cache | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mrk_marker | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mrk_marker_view | _createdby_key | int4 | 10 | √ | null | ||
mrk_mcv_cache | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mrk_mcv_count_cache | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mrk_mouse_view | _createdby_key | int4 | 10 | √ | null | ||
mrk_nonmouse_view | _createdby_key | int4 | 10 | √ | null | ||
mrk_strainmarker | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
mrk_summary_view | _createdby_key | int4 | 10 | √ | null | ||
prb_acc_view | _createdby_key | int4 | 10 | √ | null | ||
prb_accnoref_view | _createdby_key | int4 | 10 | √ | null | ||
prb_accref_view | _createdby_key | int4 | 10 | √ | null | ||
prb_accrefnoseq_view | _createdby_key | int4 | 10 | √ | null | ||
prb_alias | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
prb_allele | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
prb_allele_strain | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
prb_marker | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
prb_probe | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
prb_probe_view | _createdby_key | int4 | 10 | √ | null | ||
prb_reference | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
prb_reference_view | _createdby_key | int4 | 10 | √ | null | ||
prb_rflv | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
prb_rflv_view | _createdby_key | int4 | 10 | √ | null | ||
prb_source | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
prb_source_acc_view | _createdby_key | int4 | 10 | √ | null | ||
prb_source_view | _createdby_key | int4 | 10 | √ | null | ||
prb_strain | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
prb_strain_acc_view | _createdby_key | int4 | 10 | √ | null | ||
prb_strain_genotype | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
prb_strain_genotype_view | _createdby_key | int4 | 10 | √ | null | ||
prb_strain_marker | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
prb_strain_marker_view | _createdby_key | int4 | 10 | √ | null | ||
prb_strain_view | _createdby_key | int4 | 10 | √ | null | ||
pwi_all_allele_view | _createdby_key | int4 | 10 | √ | null | ||
pwi_bib_refs_view | _createdby_key | int4 | 10 | √ | null | ||
pwi_mrk_marker_view | _createdby_key | int4 | 10 | √ | null | ||
seq_allele_assoc | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
seq_allele_assoc_view | _createdby_key | int4 | 10 | √ | null | ||
seq_coord_cache | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
seq_genemodel | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
seq_genetrap | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
seq_marker_cache | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
seq_probe_cache | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
seq_sequence | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
seq_sequence_acc_view | _createdby_key | int4 | 10 | √ | null | ||
seq_sequence_assoc | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
seq_sequence_raw | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
seq_sequence_view | _createdby_key | int4 | 10 | √ | null | ||
seq_source_assoc | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
seq_summary_view | _createdby_key | int4 | 10 | √ | null | ||
voc_annotheader | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
voc_annotheader_view | _createdby_key | int4 | 10 | √ | null | ||
voc_evidence | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
voc_evidence_property | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
voc_evidence_view | _createdby_key | int4 | 10 | √ | null | ||
voc_evidenceproperty_view | _createdby_key | int4 | 10 | √ | null | ||
voc_term | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
voc_term_acc_view | _createdby_key | int4 | 10 | √ | null | ||
voc_term_cellline_view | _createdby_key | int4 | 10 | √ | null | ||
voc_term_emapa | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
voc_term_emaps | _createdby_key | int4 | 10 | 1001 | user who created the record | ||
voc_term_mcv_view | _createdby_key | int4 | 10 | √ | null | ||
voc_term_repqualifier_view | _createdby_key | int4 | 10 | √ | null | ||
voc_term_strainallele_view | _createdby_key | int4 | 10 | √ | null | ||
voc_term_strainspecies_view | _createdby_key | int4 | 10 | √ | null | ||
voc_term_view | _createdby_key | int4 | 10 | √ | null | ||
all_allele_cellline_view | _creator_key | int4 | 10 | √ | null | ||
all_cellline_derivation | _creator_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 62 (Cell Line Creator) | |||
all_cellline_derivation_view | _creator_key | int4 | 10 | √ | null | ||
all_cellline_view | _creator_key | int4 | 10 | √ | null | ||
crs_cross | _cross_key | int4 | 10 | primary key | |||
crs_cross_view | _cross_key | int4 | 10 | √ | null | ||
crs_matrix | _cross_key | int4 | 10 | foreign key to CRS_Cross | |||
crs_progeny | _cross_key | int4 | 10 | foreign key to CRS_Cross | |||
crs_references | _cross_key | int4 | 10 | foreign key to CRS_Cross | |||
crs_typings | _cross_key | int4 | 10 | foreign key to CRS_Cross | |||
mld_matrix | _cross_key | int4 | 10 | foreign key to CRS_Cross | |||
mld_matrix_view | _cross_key | int4 | 10 | √ | null | ||
gxd_htexperiment | _curationstate_key | int4 | 10 | foreign key to VOC_Term, identifying whether curation for this experiment has finished | |||
mrk_current | _current_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_current_view | _current_key | int4 | 10 | √ | null | ||
dag_closure | _dag_key | int4 | 10 | foreign key to DAG_DAG | |||
dag_dag | _dag_key | int4 | 10 | primary key | |||
dag_edge | _dag_key | int4 | 10 | foreign key to DAG_DAG | |||
dag_node | _dag_key | int4 | 10 | foreign key to DAG_DAG | |||
dag_node_view | _dag_key | int4 | 10 | √ | null | ||
voc_go_cache | _dag_key | int4 | 10 | foreign key to DAG_DAG | |||
voc_vocabdag | _dag_key | int4 | 10 | foreign key to DAG_DAG | |||
voc_vocabdag_view | _dag_key | int4 | 10 | √ | null | ||
voc_term_emapa | _defaultparent_key | int4 | 10 | √ | null | An EMAPA term can have multiple parents, this defines the single default. | |
voc_term_emaps | _defaultparent_key | int4 | 10 | √ | null | An EMAPS term can have multiple parents, this defines the single default. | |
all_cellline | _derivation_key | int4 | 10 | √ | null | foreign key to ALL_CellLine_Derivation | |
all_cellline_derivation_view | _derivation_key | int4 | 10 | √ | null | ||
all_cellline_view | _derivation_key | int4 | 10 | √ | null | ||
all_cellline_derivation | _derivationtype_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 38 (Allele Type) | |||
all_cellline_derivation_view | _derivationtype_key | int4 | 10 | √ | null | ||
all_cellline_view | _derivationtype_key | int4 | 10 | √ | null | ||
dag_closure | _descendent_key | int4 | 10 | foreign key to DAG_Node._Node_key | |||
dag_closure | _descendentlabel_key | int4 | 10 | foreign key to DAG_Label; the label of the Descendent | |||
dag_closure | _descendentobject_key | int4 | 10 | the MGI object to which the Descendent node refers | |||
dag_edge | _edge_key | int4 | 10 | primary key | |||
gxd_htsample | _emapa_key | int4 | 10 | √ | null | foreign key to VOC_Term, identifying the EMAPA structure for this sample | |
gxd_htsample_rnaseqset | _emapa_key | int4 | 10 | foreign key to VOC_Term | |||
all_cre_cache | _emapa_term_key | int4 | 10 | √ | null | foreign key to VOC_Term where _Vocab_key = 90 (EMAPA) | |
gxd_expression | _emapa_term_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 90 (EMAPA) | |||
gxd_gellanestructure | _emapa_term_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 90 (EMAPA) | |||
gxd_gellanestructure_view | _emapa_term_key | int4 | 10 | √ | null | ||
gxd_isresultstructure | _emapa_term_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 90 (EMAPA) | |||
gxd_isresultstructure_view | _emapa_term_key | int4 | 10 | √ | null | ||
voc_term_emaps | _emapa_term_key | int4 | 10 | The EMAPA term | |||
gxd_embeddingmethod | _embedding_key | int4 | 10 | primary key | |||
gxd_specimen | _embedding_key | int4 | 10 | foreign key to GXD_EmbeddingMethod | |||
gxd_specimen_view | _embedding_key | int4 | 10 | √ | null | ||
gxd_htexperiment | _evaluatedby_key | int4 | 10 | √ | null | foreign key to MGI_User; user who evaluated this experiment and set its _Relevance_key | |
gxd_htexperiment | _evaluationstate_key | int4 | 10 | foreign key to VOC_Term, identifying whether this experiment has been curated or not | |||
mgi_relationship | _evidence_key | int4 | 10 | The term for the relationship evidence | |||
mgi_relationship_markertss_view | _evidence_key | int4 | 10 | √ | null | ||
voc_evidenceproperty_view | _evidenceproperty_key | int4 | 10 | √ | null | ||
voc_evidence | _evidenceterm_key | int4 | 10 | foreign key to VOC_Term; based on VOC_AnnotType; example _Vocab_key:3:GO Evidence Codes:IDA, IMP, IPI, TAS, etc. | |||
voc_evidence_view | _evidenceterm_key | int4 | 10 | √ | null | ||
mgi_relationship_category | _evidencevocab_key | int4 | 10 | Vocabulary that relationships draw their evidence terms from | |||
voc_annot_view | _evidencevocab_key | int4 | 10 | √ | null | ||
voc_annottype | _evidencevocab_key | int4 | 10 | foreign key to VOC_Term; examples include 3:GO Evidence Codes, 2:Mammalian Phenotype Evidence, 80:MCV Evidence Codes Codes | |||
gxd_genotype | _existsas_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 60 (Genotype Exists As); this genotype exists as 'Mouse Line', 'Cell Line', 'Chimeric', 'Not Specified', 'Not Applicable' | |||
gxd_genotype_view | _existsas_key | int4 | 10 | √ | null | ||
gxd_htexperiment | _experiment_key | int4 | 10 | primary key | |||
gxd_htexperimentvariable | _experiment_key | int4 | 10 | foreign key to GXD_Experiment, identifies the experiment of the variable | |||
gxd_htsample | _experiment_key | int4 | 10 | foreign key to GXD_HTExperiment, identifies the experiment with which this sample is associated | |||
gxd_htsample_rnaseqset | _experiment_key | int4 | 10 | foreign key to GXD_HTExperiment | |||
gxd_htexperiment | _experimenttype_key | int4 | 10 | foreign key to VOC_Term, in identifying the MGI curated value for experiment type | |||
gxd_htexperimentvariable | _experimentvariable_key | int4 | 10 | primary key | |||
gxd_expression | _expression_key | int4 | 10 | primary key | |||
mld_concordance | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_concordance_view | _expt_key | int4 | 10 | √ | null | ||
mld_contig | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_expt_marker | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_expt_marker_view | _expt_key | int4 | 10 | √ | null | ||
mld_expt_notes | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_expt_view | _expt_key | int4 | 10 | √ | null | ||
mld_expts | _expt_key | int4 | 10 | primary key | |||
mld_fish | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_fish_region | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_fish_view | _expt_key | int4 | 10 | √ | null | ||
mld_hit | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_hybrid | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_hybrid_view | _expt_key | int4 | 10 | √ | null | ||
mld_insitu | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_insitu_view | _expt_key | int4 | 10 | √ | null | ||
mld_isregion | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_matrix | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_matrix_view | _expt_key | int4 | 10 | √ | null | ||
mld_mc2point | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_mc2point_view | _expt_key | int4 | 10 | √ | null | ||
mld_mcdatalist | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_ri | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_ri2point | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_ri2point_view | _expt_key | int4 | 10 | √ | null | ||
mld_ri_view | _expt_key | int4 | 10 | √ | null | ||
mld_ridata | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_ridata_view | _expt_key | int4 | 10 | √ | null | ||
mld_statistics | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
mld_statistics_view | _expt_key | int4 | 10 | √ | null | ||
ri_summary_expt_ref | _expt_key | int4 | 10 | foreign key to MLD_Expts | |||
bib_workflow_data | _extractedtext_key | int4 | 10 | foreign key to VOC_Term where_Vocab_key = 142 (Lit Triage Extracted Text Section) | |||
map_coord_feature | _feature_key | int4 | 10 | primary key | |||
crs_cross | _femalestrain_key | int4 | 10 | foreign key to PRB_Strain; maternal strain | |||
crs_cross_view | _femalestrain_key | int4 | 10 | √ | null | ||
mld_matrix_view | _femalestrain_key | int4 | 10 | √ | null | ||
gxd_fixationmethod | _fixation_key | int4 | 10 | primary key | |||
gxd_specimen | _fixation_key | int4 | 10 | foreign key to GXD_FixationMethod | |||
gxd_specimen_view | _fixation_key | int4 | 10 | √ | null | ||
gxd_gelband_view | _gelband_key | int4 | 10 | √ | null | ||
gxd_gelcontrol | _gelcontrol_key | int4 | 10 | primary key | |||
gxd_gellane | _gelcontrol_key | int4 | 10 | foreign key to GXD_GelControl | |||
gxd_gellane_view | _gelcontrol_key | int4 | 10 | √ | null | ||
gxd_expression | _gellane_key | int4 | 10 | √ | null | foreign key to GXD_GelLane | |
gxd_gelband | _gellane_key | int4 | 10 | foreign key to GXD_GelLane | |||
gxd_gelband_view | _gellane_key | int4 | 10 | √ | null | ||
gxd_gellane_view | _gellane_key | int4 | 10 | √ | null | ||
gxd_gellanestructure | _gellane_key | int4 | 10 | foreign key to GXD_GelLane | |||
gxd_gellanestructure_view | _gellane_key | int4 | 10 | √ | null | ||
gxd_gellanestructure_view | _gellanestructure_key | int4 | 10 | √ | null | ||
gxd_gellane | _gelrnatype_key | int4 | 10 | foreign key to GXD_GelRNAType | |||
gxd_gellane_view | _gelrnatype_key | int4 | 10 | √ | null | ||
gxd_gelrnatype | _gelrnatype_key | int4 | 10 | primary key | |||
gxd_gelband | _gelrow_key | int4 | 10 | foreign key to GXD_GelRow | |||
gxd_gelband_view | _gelrow_key | int4 | 10 | √ | null | ||
gxd_gelrow_view | _gelrow_key | int4 | 10 | √ | null | ||
gxd_gelrow | _gelunits_key | int4 | 10 | foreign key to GXD_GelUnits | |||
gxd_gelrow_view | _gelunits_key | int4 | 10 | √ | null | ||
gxd_gelunits | _gelunits_key | int4 | 10 | primary key | |||
gxd_antibodyantigen_view | _gender_key | int4 | 10 | √ | null | ||
gxd_antigen_view | _gender_key | int4 | 10 | √ | null | ||
prb_source | _gender_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 17 (Gender) | |||
prb_source_view | _gender_key | int4 | 10 | √ | null | ||
all_genotype_view | _genotype_key | int4 | 10 | √ | null | ||
gxd_allelegenotype | _genotype_key | int4 | 10 | foreign key to GXD_Genotype | |||
gxd_allelepair | _genotype_key | int4 | 10 | foreign key to GXD_Genotype | |||
gxd_allelepair_view | _genotype_key | int4 | 10 | √ | null | ||
gxd_expression | _genotype_key | int4 | 10 | foreign key to GXD_Genotype | |||
gxd_gellane | _genotype_key | int4 | 10 | foreign key to GXD_Genotype | |||
gxd_gellane_view | _genotype_key | int4 | 10 | √ | null | ||
gxd_genotype_dataset_view | _genotype_key | int4 | 10 | √ | null | ||
gxd_genotype_view | _genotype_key | int4 | 10 | √ | null | ||
gxd_htsample | _genotype_key | int4 | 10 | foreign key to GXD_Genotype, identifying the genotype of the sample | |||
gxd_htsample_rnaseqset | _genotype_key | int4 | 10 | foreign key to GXD_Genotype | |||
gxd_specimen | _genotype_key | int4 | 10 | foreign key to GXD_Genotype | |||
gxd_specimen_view | _genotype_key | int4 | 10 | √ | null | ||
mrk_do_cache | _genotype_key | int4 | 10 | foreign key to GXD_Genotype | |||
prb_strain_genotype | _genotype_key | int4 | 10 | foreign key to GXD_Genotype | |||
prb_strain_genotype_view | _genotype_key | int4 | 10 | √ | null | ||
seq_genemodel | _gmmarker_type_key | int4 | 10 | √ | null | the _Marker_Type_key (foreign key to MRK_Types) corresponding to the 'rawBiotype' attribute. | |
bib_workflow_status | _group_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 127 (Workflow Group) | |||
mgi_user | _group_key | int4 | 10 | √ | null | foreign key to VOC_Term where _Vocab_key = 127 (Workflow Group) | |
mgi_user_active_view | _group_key | int4 | 10 | √ | null | ||
mrk_history | _history_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_history_view | _history_key | int4 | 10 | √ | null | ||
gxd_isresultimage_view | _image_key | int4 | 10 | √ | null | ||
img_image_view | _image_key | int4 | 10 | √ | null | ||
img_imagepane | _image_key | int4 | 10 | foreign key to IMG_Image | |||
img_imagepane_assoc_view | _image_key | int4 | 10 | √ | null | ||
img_imagepanegxd_view | _image_key | int4 | 10 | √ | null | ||
img_image | _imageclass_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 83 (Image Class); 'Expression', 'Phenotypes', 'Molecular' | |||
img_image_view | _imageclass_key | int4 | 10 | √ | null | ||
img_imagepane_assoc_view | _imageclass_key | int4 | 10 | √ | null | ||
gxd_assay | _imagepane_key | int4 | 10 | √ | null | foreign key to IMG_ImagePane | |
gxd_assay_view | _imagepane_key | int4 | 10 | √ | null | ||
gxd_insituresultimage | _imagepane_key | int4 | 10 | foreign key to IMG_ImagePane | |||
gxd_isresultimage_view | _imagepane_key | int4 | 10 | √ | null | ||
img_imagepane_assoc | _imagepane_key | int4 | 10 | foreign key to IMG_ImagePane; specifies the Image Pane | |||
img_imagepane_assoc_view | _imagepane_key | int4 | 10 | √ | null | ||
img_imagepanegxd_view | _imagepane_key | int4 | 10 | √ | null | ||
img_image | _imagetype_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 47 (Image Type) | |||
img_image_view | _imagetype_key | int4 | 10 | √ | null | ||
gxd_index | _index_key | int4 | 10 | primary key | |||
gxd_index_stages | _index_key | int4 | 10 | foreign key to GXD_Index | |||
gxd_index_view | _index_key | int4 | 10 | √ | null | ||
gxd_index_stages | _indexassay_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 12 (GXD Index Assay); 'Prot-sxn', 'RNA-sxn', 'Prot-WM', 'RNA-WM', 'Knock in', 'Northern', 'Western', etc. | |||
gxd_htexperiment | _initialcuratedby_key | int4 | 10 | √ | null | foreign key to MGI_User; user who first curated the experiment, converting it from its raw status | |
all_knockout_cache | _knockout_key | int4 | 10 | primary key | |||
dag_edge | _label_key | int4 | 10 | foreign key to DAG_Label | |||
dag_label | _label_key | int4 | 10 | primary key | |||
dag_node | _label_key | int4 | 10 | foreign key to DAG_Label | |||
dag_node_view | _label_key | int4 | 10 | √ | null | ||
gxd_antibodyprep | _label_key | int4 | 10 | foreign key to GXD_Label | |||
gxd_antibodyprep_view | _label_key | int4 | 10 | √ | null | ||
gxd_label | _label_key | int4 | 10 | primary key | |||
gxd_probeprep | _label_key | int4 | 10 | foreign key to GXD_Label | |||
gxd_probeprep_view | _label_key | int4 | 10 | √ | null | ||
mrk_label | _label_key | int4 | 10 | primary key | |||
all_label | _label_status_key | int4 | 10 | 1 = current, 2 = old | |||
mrk_label | _label_status_key | int4 | 10 | 1 = current, 2 = old | |||
gxd_htexperiment | _lastcuratedby_key | int4 | 10 | √ | null | foreign key to MGI_User; user who last curated the experiment, converting it from its raw status | |
gxd_htsample_rnaseqcombined | _level_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 144 (RNA-Seq TPM Level) | |||
acc_accession | _logicaldb_key | int4 | 10 | foreign key to ACC_LogicalDB | |||
acc_actualdb | _logicaldb_key | int4 | 10 | foreign key to ACC_LogicalDB | |||
acc_logicaldb_view | _logicaldb_key | int4 | 10 | √ | null | ||
acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
all_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
all_cellline_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
all_derivation_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
all_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
bib_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
bib_summary_all_view | _logicaldb_key | int4 | 10 | √ | null | ||
gxd_antibody_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
gxd_antigen_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
gxd_antigen_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
gxd_assay_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
gxd_genotype_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
gxd_genotype_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
img_image_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
img_image_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
mgi_organism_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
mgi_organism_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
mld_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
mld_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
mrk_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
mrk_accnoref_view | _logicaldb_key | int4 | 10 | √ | null | ||
mrk_accref1_view | _logicaldb_key | int4 | 10 | √ | null | ||
mrk_accref2_view | _logicaldb_key | int4 | 10 | √ | null | ||
mrk_accref_view | _logicaldb_key | int4 | 10 | √ | null | ||
mrk_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
prb_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
prb_accnoref_view | _logicaldb_key | int4 | 10 | √ | null | ||
prb_accref_view | _logicaldb_key | int4 | 10 | √ | null | ||
prb_accrefnoseq_view | _logicaldb_key | int4 | 10 | √ | null | ||
prb_source_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
prb_source_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
prb_strain_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
prb_strain_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
prb_tissue_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
seq_allele_assoc_view | _logicaldb_key | int4 | 10 | √ | null | ||
seq_marker_cache | _logicaldb_key | int4 | 10 | foreign key to ACC_LogicalDB | |||
seq_sequence_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
seq_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
voc_annot_view | _logicaldb_key | int4 | 10 | √ | null | ||
voc_term_acc_view | _logicaldb_key | int4 | 10 | √ | null | ||
voc_term_summary_view | _logicaldb_key | int4 | 10 | √ | null | ||
voc_term_view | _logicaldb_key | int4 | 10 | √ | null | ||
voc_vocab | _logicaldb_key | int4 | 10 | foreign key to ACC_LogicalDB; identifies the logical DB for the Accession IDs of the Vocabulary Terms | |||
voc_vocab_view | _logicaldb_key | int4 | 10 | √ | null | ||
crs_cross | _malestrain_key | int4 | 10 | foreign key to PRB_Strain; paternal strain | |||
crs_cross_view | _malestrain_key | int4 | 10 | √ | null | ||
mld_matrix_view | _malestrain_key | int4 | 10 | √ | null | ||
map_coord_feature | _map_key | int4 | 10 | foreign key to MAP_Coordinate | |||
map_coordinate | _map_key | int4 | 10 | primary key | |||
seq_coord_cache | _map_key | int4 | 10 | foreign key to MAP_Collection | |||
map_coordinate | _maptype_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 29 (Map Type) | |||
mrk_event | _marker_event_key | int4 | 10 | primary key | |||
mrk_history | _marker_event_key | int4 | 10 | foreign key to MRK_Event | |||
mrk_history_view | _marker_event_key | int4 | 10 | √ | null | ||
mrk_eventreason | _marker_eventreason_key | int4 | 10 | primary key | |||
mrk_history | _marker_eventreason_key | int4 | 10 | foreign key to MRK_EventReason | |||
mrk_history_view | _marker_eventreason_key | int4 | 10 | √ | null | ||
all_allele | _marker_key | int4 | 10 | √ | null | foreign key to MRK_Marker; foreign key to ALL_Marker_Assoc | |
all_allele_driver_view | _marker_key | int4 | 10 | √ | null | ||
all_allele_view | _marker_key | int4 | 10 | √ | null | ||
all_knockout_cache | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
bib_goxref_view | _marker_key | int4 | 10 | √ | null | ||
crs_matrix | _marker_key | int4 | 10 | √ | null | foreign key to MRK_Marker | |
crs_references | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
go_tracking | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
go_tracking_view | _marker_key | int4 | 10 | √ | null | ||
gxd_allelegenotype | _marker_key | int4 | 10 | √ | null | foreign key to MRK_Marker | |
gxd_allelepair | _marker_key | int4 | 10 | √ | null | foreign key to MRK_Marker | |
gxd_allelepair_view | _marker_key | int4 | 10 | √ | null | ||
gxd_antibodymarker | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
gxd_antibodymarker_view | _marker_key | int4 | 10 | √ | null | ||
gxd_assay | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
gxd_assay_view | _marker_key | int4 | 10 | √ | null | ||
gxd_expression | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
gxd_htsample_rnaseq | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
gxd_htsample_rnaseqcombined | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
gxd_index | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
gxd_index_view | _marker_key | int4 | 10 | √ | null | ||
mld_concordance | _marker_key | int4 | 10 | √ | null | foreign key to MRK_Marker | |
mld_concordance_view | _marker_key | int4 | 10 | √ | null | ||
mld_expt_marker | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mld_expt_marker_view | _marker_key | int4 | 10 | √ | null | ||
mld_ridata | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mld_ridata_view | _marker_key | int4 | 10 | √ | null | ||
mrk_alias | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_alias_view | _marker_key | int4 | 10 | √ | null | ||
mrk_anchors | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_anchors_view | _marker_key | int4 | 10 | √ | null | ||
mrk_clustermember | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_current | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_current_view | _marker_key | int4 | 10 | √ | null | ||
mrk_do_cache | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_history | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_history_view | _marker_key | int4 | 10 | √ | null | ||
mrk_label | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_location_cache | _marker_key | int4 | 10 | primary key/foreign key to MRK_Marker | |||
mrk_marker_view | _marker_key | int4 | 10 | √ | null | ||
mrk_mcv_cache | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_mouse_view | _marker_key | int4 | 10 | √ | null | ||
mrk_nonmouse_view | _marker_key | int4 | 10 | √ | null | ||
mrk_notes | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_reference | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
mrk_reference_view | _marker_key | int4 | 10 | √ | null | ||
mrk_strainmarker | _marker_key | int4 | 10 | √ | null | foreign key to MRK_Marker/if null, then no canonical gene | |
prb_marker | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
prb_marker_view | _marker_key | int4 | 10 | √ | null | ||
prb_rflv | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
prb_rflv_view | _marker_key | int4 | 10 | √ | null | ||
prb_strain_marker | _marker_key | int4 | 10 | √ | null | foreign key to MRK_Marker | |
prb_strain_marker_view | _marker_key | int4 | 10 | √ | null | ||
pwi_all_allele_view | _marker_key | int4 | 10 | √ | null | ||
pwi_mrk_marker_view | _marker_key | int4 | 10 | √ | null | ||
ri_summary | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
seq_marker_cache | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
seq_marker_cache_view | _marker_key | int4 | 10 | √ | null | ||
voc_marker_cache | _marker_key | int4 | 10 | foreign key to MRK_Marker | |||
wks_rosetta | _marker_key | int4 | 10 | √ | null | foreign key to MRK_Marker | |
mld_mc2point | _marker_key_1 | int4 | 10 | foreign key to MRK_Marker | |||
mld_mc2point_view | _marker_key_1 | int4 | 10 | √ | null | ||
mld_ri2point | _marker_key_1 | int4 | 10 | foreign key to MRK_Marker | |||
mld_ri2point_view | _marker_key_1 | int4 | 10 | √ | null | ||
mld_statistics | _marker_key_1 | int4 | 10 | foreign key to MRK_Marker | |||
mld_statistics_view | _marker_key_1 | int4 | 10 | √ | null | ||
mld_mc2point | _marker_key_2 | int4 | 10 | foreign key to MRK_Marker | |||
mld_mc2point_view | _marker_key_2 | int4 | 10 | √ | null | ||
mld_ri2point | _marker_key_2 | int4 | 10 | foreign key to MRK_Marker | |||
mld_ri2point_view | _marker_key_2 | int4 | 10 | √ | null | ||
mld_statistics | _marker_key_2 | int4 | 10 | foreign key to MRK_Marker | |||
mld_statistics_view | _marker_key_2 | int4 | 10 | √ | null | ||
mrk_marker | _marker_status_key | int4 | 10 | foreign key to MRK_Status | |||
mrk_marker_view | _marker_status_key | int4 | 10 | √ | null | ||
mrk_mouse_view | _marker_status_key | int4 | 10 | √ | null | ||
mrk_nonmouse_view | _marker_status_key | int4 | 10 | √ | null | ||
mrk_status | _marker_status_key | int4 | 10 | primary key | |||
pwi_mrk_marker_view | _marker_status_key | int4 | 10 | √ | null | ||
mrk_biotypemapping | _marker_type_key | int4 | 10 | fk to mrk_types | |||
mrk_current_view | _marker_type_key | int4 | 10 | √ | null | ||
mrk_location_cache | _marker_type_key | int4 | 10 | foreign key to MRK_Types | |||
mrk_marker | _marker_type_key | int4 | 10 | foreign key to MRK_Types | |||
mrk_marker_view | _marker_type_key | int4 | 10 | √ | null | ||
mrk_mouse_view | _marker_type_key | int4 | 10 | √ | null | ||
mrk_nonmouse_view | _marker_type_key | int4 | 10 | √ | null | ||
mrk_types | _marker_type_key | int4 | 10 | primary key | |||
pwi_mrk_marker_view | _marker_type_key | int4 | 10 | √ | null | ||
seq_marker_cache | _marker_type_key | int4 | 10 | foreign key to MRK_Types | |||
all_allele | _markerallele_status_key | int4 | 10 | ||||
all_allele_view | _markerallele_status_key | int4 | 10 | √ | null | ||
pwi_all_allele_view | _markerallele_status_key | int4 | 10 | √ | null | ||
mrk_biotypemapping | _mcvterm_key | int4 | 10 | fk to voc_term where _vocab_key = 79 (Marker Category aka MCV/FeatureType term) | |||
mrk_mcv_cache | _mcvterm_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 79 (Marker Category); 'gene', 'protein coding gene', 'non-coding RNA gene', etc. | |||
mrk_mcv_count_cache | _mcvterm_key | int4 | 10 | foreign key to VOC_Term (_Vocab_key = 79) | |||
acc_accession | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
acc_mgitype | _mgitype_key | int4 | 10 | primary key | |||
acc_view | _mgitype_key | int4 | 10 | √ | null | ||
all_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
all_cellline_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
all_derivation_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
all_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
bib_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
bib_summary_all_view | _mgitype_key | int4 | 10 | √ | null | ||
dag_closure | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
dag_dag | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
gxd_antibody_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
gxd_antigen_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
gxd_antigen_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
gxd_assay_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
gxd_genotype_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
gxd_genotype_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
img_image_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
img_image_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
img_imagepane_assoc | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
img_imagepane_assoc_view | _mgitype_key | int4 | 10 | √ | null | ||
map_coord_feature | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
map_coordinate | _mgitype_key | int4 | 10 | √ | null | foreign key to ACC_MGIType | |
mgi_note | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
mgi_note_allele_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_note_allelevariant_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_note_derivation_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_note_genotype_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_note_image_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_note_marker_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_note_mrkgo_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_note_probe_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_note_sequence_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_note_source_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_note_strain_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_note_vocevidence_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype | _mgitype_key | int4 | 10 | √ | null | foreign key to ACC_MGIType | |
mgi_notetype_alldriver_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype_allele_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype_derivation_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype_genotype_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype_image_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype_marker_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype_mrkgo_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype_probe_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype_sequence_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype_source_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype_strain_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_notetype_vocevidence_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_organism_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_organism_mgitype | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
mgi_organism_mgitype_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_organism_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_property | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
mgi_propertytype | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
mgi_refassoctype | _mgitype_key | int4 | 10 | √ | null | foreign key to ACC_MGIType | |
mgi_reference_allele_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_reference_allelevariant_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_reference_antibody_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_reference_assoc | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
mgi_reference_marker_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_reference_sequence_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_reference_strain_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_reftype_allele_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_reftype_antibody_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_reftype_marker_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_reftype_sequence_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_reftype_strain_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_set | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
mgi_synonym | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
mgi_synonym_allele_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_synonym_goterm_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_synonym_musmarker_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_synonym_strain_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_synonymtype | _mgitype_key | int4 | 10 | √ | null | foreign key to ACC_MGIType | |
mgi_synonymtype_allele_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_synonymtype_goterm_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_synonymtype_musmarker_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_synonymtype_strain_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_translationstrain_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_translationtype | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
mld_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
mld_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
mrk_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
mrk_accnoref_view | _mgitype_key | int4 | 10 | √ | null | ||
mrk_accref1_view | _mgitype_key | int4 | 10 | √ | null | ||
mrk_accref2_view | _mgitype_key | int4 | 10 | √ | null | ||
mrk_accref_view | _mgitype_key | int4 | 10 | √ | null | ||
mrk_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
prb_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
prb_accnoref_view | _mgitype_key | int4 | 10 | √ | null | ||
prb_accref_view | _mgitype_key | int4 | 10 | √ | null | ||
prb_accrefnoseq_view | _mgitype_key | int4 | 10 | √ | null | ||
prb_source_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
prb_source_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
prb_strain_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
prb_strain_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
prb_tissue_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
seq_allele_assoc_view | _mgitype_key | int4 | 10 | √ | null | ||
seq_sequence_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
seq_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
voc_annot_count_cache | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
voc_annot_view | _mgitype_key | int4 | 10 | √ | null | ||
voc_annottype | _mgitype_key | int4 | 10 | foreign key to ACC_MGIType | |||
voc_term_acc_view | _mgitype_key | int4 | 10 | √ | null | ||
voc_term_summary_view | _mgitype_key | int4 | 10 | √ | null | ||
mgi_relationship_category | _mgitype_key_1 | int4 | 10 | MGI Type of the First object in the relationship | |||
mgi_relationship_category | _mgitype_key_2 | int4 | 10 | MGI Type of the Second object in the relationship | |||
all_allele | _mode_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 35 (Allele Inheritance Mode); 'Semidominant', 'Codominant' | |||
all_allele_view | _mode_key | int4 | 10 | √ | null | ||
pwi_all_allele_view | _mode_key | int4 | 10 | √ | null | ||
acc_accession | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
acc_accessionreference | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
acc_actualdb | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
acc_logicaldb | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
acc_logicaldb_view | _modifiedby_key | int4 | 10 | √ | null | ||
acc_mgitype | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
all_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
all_allele | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
all_allele_cellline | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
all_allele_cellline_view | _modifiedby_key | int4 | 10 | √ | null | ||
all_allele_view | _modifiedby_key | int4 | 10 | √ | null | ||
all_cellline | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
all_cellline_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
all_cellline_derivation | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
all_cellline_derivation_view | _modifiedby_key | int4 | 10 | √ | null | ||
all_cellline_view | _modifiedby_key | int4 | 10 | √ | null | ||
all_cre_cache | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
all_knockout_cache | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
all_summary_view | _modifiedby_key | int4 | 10 | √ | null | ||
all_variant | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
all_variant_sequence | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
bib_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
bib_all2_view | _modifiedby_key | int4 | 10 | √ | null | ||
bib_all_view | _modifiedby_key | int4 | 10 | √ | null | ||
bib_refs | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
bib_summary_all_view | _modifiedby_key | int4 | 10 | √ | null | ||
bib_view | _modifiedby_key | int4 | 10 | √ | null | ||
bib_workflow_data | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
bib_workflow_status | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
bib_workflow_tag | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
go_tracking | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
go_tracking_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_allelegenotype | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_allelepair | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_allelepair_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_antibody | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_antibody_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_antibody_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_antibodyantigen_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_antigen | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_antigen_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_antigen_summary_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_antigen_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_assay | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_assay_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_assay_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_genotype | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_genotype_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_genotype_summary_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_genotype_view | _modifiedby_key | int4 | 10 | √ | null | ||
gxd_htexperiment | _modifiedby_key | int4 | 10 | 1001 | foreign key to MGI_User; user who last modified the record | ||
gxd_htsample | _modifiedby_key | int4 | 10 | 1001 | foreign key to MGI_User; user who last modified the record | ||
gxd_htsample_rnaseq | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_htsample_rnaseqcombined | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_htsample_rnaseqset | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_htsample_rnaseqsetmember | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_index | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_index_stages | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
gxd_index_view | _modifiedby_key | int4 | 10 | √ | null | ||
img_image | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
img_image_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
img_image_summary_view | _modifiedby_key | int4 | 10 | √ | null | ||
img_image_view | _modifiedby_key | int4 | 10 | √ | null | ||
img_imagepane_assoc | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
img_imagepane_assoc_view | _modifiedby_key | int4 | 10 | √ | null | ||
map_coord_collection | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
map_coord_feature | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
map_coordinate | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_note | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_note_allele_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_note_allelevariant_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_note_derivation_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_note_genotype_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_note_image_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_note_marker_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_note_mrkgo_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_note_probe_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_note_sequence_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_note_source_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_note_strain_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_note_vocevidence_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notechunk | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_notetype | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_notetype_alldriver_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notetype_allele_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notetype_derivation_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notetype_genotype_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notetype_image_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notetype_marker_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notetype_mrkgo_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notetype_probe_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notetype_sequence_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notetype_source_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notetype_strain_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_notetype_vocevidence_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_organism | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_organism_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_organism_allele_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_organism_antigen_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_organism_marker_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_organism_mgitype | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_organism_mgitype_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_organism_probe_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_organism_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_property | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_propertytype | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_refassoctype | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_reference_allele_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_reference_allelevariant_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_reference_antibody_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_reference_assoc | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_reference_marker_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_reference_sequence_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_reference_strain_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_reftype_allele_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_reftype_antibody_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_reftype_marker_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_reftype_sequence_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_reftype_strain_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_relationship | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_relationship_category | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_relationship_markertss_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_relationship_property | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_roletask | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_roletask_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_set | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_setmember | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_setmember_emapa | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_synonym | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_synonym_allele_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_synonym_goterm_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_synonym_musmarker_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_synonym_strain_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_synonymtype | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_synonymtype_allele_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_synonymtype_goterm_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_synonymtype_musmarker_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_synonymtype_strain_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_translation | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_translation_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_translationstrain_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_translationtype | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_user | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_user_active_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_userrole | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mgi_userrole_view | _modifiedby_key | int4 | 10 | √ | null | ||
mgi_usertask_view | _modifiedby_key | int4 | 10 | √ | null | ||
mld_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
mld_summary_view | _modifiedby_key | int4 | 10 | √ | null | ||
mrk_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
mrk_accnoref_view | _modifiedby_key | int4 | 10 | √ | null | ||
mrk_accref1_view | _modifiedby_key | int4 | 10 | √ | null | ||
mrk_accref2_view | _modifiedby_key | int4 | 10 | √ | null | ||
mrk_accref_view | _modifiedby_key | int4 | 10 | √ | null | ||
mrk_biotypemapping | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mrk_chromosome | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mrk_cluster | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mrk_history | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mrk_history_view | _modifiedby_key | int4 | 10 | √ | null | ||
mrk_location_cache | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mrk_marker | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mrk_marker_view | _modifiedby_key | int4 | 10 | √ | null | ||
mrk_mcv_cache | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mrk_mcv_count_cache | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mrk_mouse_view | _modifiedby_key | int4 | 10 | √ | null | ||
mrk_nonmouse_view | _modifiedby_key | int4 | 10 | √ | null | ||
mrk_strainmarker | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
mrk_summary_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_accnoref_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_accref_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_accrefnoseq_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_alias | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
prb_allele | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
prb_allele_strain | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
prb_marker | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
prb_probe | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
prb_probe_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_reference | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
prb_reference_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_rflv | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
prb_rflv_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_source | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
prb_source_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_source_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_strain | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
prb_strain_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_strain_genotype | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
prb_strain_genotype_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_strain_marker | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
prb_strain_marker_view | _modifiedby_key | int4 | 10 | √ | null | ||
prb_strain_view | _modifiedby_key | int4 | 10 | √ | null | ||
pwi_all_allele_view | _modifiedby_key | int4 | 10 | √ | null | ||
pwi_bib_refs_view | _modifiedby_key | int4 | 10 | √ | null | ||
pwi_mrk_marker_view | _modifiedby_key | int4 | 10 | √ | null | ||
seq_allele_assoc | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
seq_allele_assoc_view | _modifiedby_key | int4 | 10 | √ | null | ||
seq_coord_cache | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
seq_genemodel | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
seq_genetrap | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
seq_marker_cache | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
seq_probe_cache | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
seq_sequence | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
seq_sequence_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
seq_sequence_assoc | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
seq_sequence_raw | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
seq_sequence_view | _modifiedby_key | int4 | 10 | √ | null | ||
seq_source_assoc | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
seq_summary_view | _modifiedby_key | int4 | 10 | √ | null | ||
voc_annotheader | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
voc_annotheader_view | _modifiedby_key | int4 | 10 | √ | null | ||
voc_evidence | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
voc_evidence_property | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
voc_evidence_view | _modifiedby_key | int4 | 10 | √ | null | ||
voc_evidenceproperty_view | _modifiedby_key | int4 | 10 | √ | null | ||
voc_term | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
voc_term_acc_view | _modifiedby_key | int4 | 10 | √ | null | ||
voc_term_cellline_view | _modifiedby_key | int4 | 10 | √ | null | ||
voc_term_emapa | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
voc_term_emaps | _modifiedby_key | int4 | 10 | 1001 | user who last modified the record | ||
voc_term_mcv_view | _modifiedby_key | int4 | 10 | √ | null | ||
voc_term_repqualifier_view | _modifiedby_key | int4 | 10 | √ | null | ||
voc_term_strainallele_view | _modifiedby_key | int4 | 10 | √ | null | ||
voc_term_strainspecies_view | _modifiedby_key | int4 | 10 | √ | null | ||
voc_term_view | _modifiedby_key | int4 | 10 | √ | null | ||
all_allele_cellline | _mutantcellline_key | int4 | 10 | foreign key to ALL_CellLine | |||
all_allele_cellline_view | _mutantcellline_key | int4 | 10 | √ | null | ||
gxd_allelepair | _mutantcellline_key_1 | int4 | 10 | √ | null | foreign key to ALL_CellLine | |
gxd_allelepair_view | _mutantcellline_key_1 | int4 | 10 | √ | null | ||
gxd_allelepair | _mutantcellline_key_2 | int4 | 10 | √ | null | foreign key to ALL_CellLine | |
gxd_allelepair_view | _mutantcellline_key_2 | int4 | 10 | √ | null | ||
all_allele_mutation | _mutation_key | int4 | 10 | foreign key to ALL_Molecular_Mutation | |||
all_allele_mutation_view | _mutation_key | int4 | 10 | √ | null | ||
dag_node | _node_key | int4 | 10 | primary key | |||
dag_node_view | _node_key | int4 | 10 | √ | null | ||
mgi_note | _note_key | int4 | 10 | primary key | |||
mgi_note_allele_view | _note_key | int4 | 10 | √ | null | ||
mgi_note_allelevariant_view | _note_key | int4 | 10 | √ | null | ||
mgi_note_derivation_view | _note_key | int4 | 10 | √ | null | ||
mgi_note_genotype_view | _note_key | int4 | 10 | √ | null | ||
mgi_note_image_view | _note_key | int4 | 10 | √ | null | ||
mgi_note_marker_view | _note_key | int4 | 10 | √ | null | ||
mgi_note_mrkgo_view | _note_key | int4 | 10 | √ | null | ||
mgi_note_probe_view | _note_key | int4 | 10 | √ | null | ||
mgi_note_sequence_view | _note_key | int4 | 10 | √ | null | ||
mgi_note_source_view | _note_key | int4 | 10 | √ | null | ||
mgi_note_strain_view | _note_key | int4 | 10 | √ | null | ||
mgi_note_vocevidence_view | _note_key | int4 | 10 | √ | null | ||
mgi_notechunk | _note_key | int4 | 10 | foreign key to MGI_Note | |||
mgi_note | _notetype_key | int4 | 10 | foreign key to MGI_NoteType | |||
mgi_note_allele_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_note_allelevariant_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_note_derivation_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_note_genotype_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_note_image_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_note_marker_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_note_mrkgo_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_note_probe_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_note_sequence_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_note_source_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_note_strain_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_note_vocevidence_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype | _notetype_key | int4 | 10 | primary key | |||
mgi_notetype_alldriver_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype_allele_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype_derivation_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype_genotype_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype_image_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype_marker_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype_mrkgo_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype_probe_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype_sequence_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype_source_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype_strain_view | _notetype_key | int4 | 10 | √ | null | ||
mgi_notetype_vocevidence_view | _notetype_key | int4 | 10 | √ | null | ||
acc_accession | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
acc_view | _object_key | int4 | 10 | √ | null | ||
all_acc_view | _object_key | int4 | 10 | √ | null | ||
all_allele_subtype_view | _object_key | int4 | 10 | √ | null | ||
all_cellline_acc_view | _object_key | int4 | 10 | √ | null | ||
all_derivation_summary_view | _object_key | int4 | 10 | √ | null | ||
all_summary_view | _object_key | int4 | 10 | √ | null | ||
bib_acc_view | _object_key | int4 | 10 | √ | null | ||
bib_summary_all_view | _object_key | int4 | 10 | √ | null | ||
dag_node | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
dag_node_view | _object_key | int4 | 10 | √ | null | ||
gxd_antibody_acc_view | _object_key | int4 | 10 | √ | null | ||
gxd_antigen_acc_view | _object_key | int4 | 10 | √ | null | ||
gxd_antigen_summary_view | _object_key | int4 | 10 | √ | null | ||
gxd_assay_acc_view | _object_key | int4 | 10 | √ | null | ||
gxd_genotype_acc_view | _object_key | int4 | 10 | √ | null | ||
gxd_genotype_summary_view | _object_key | int4 | 10 | √ | null | ||
img_image_acc_view | _object_key | int4 | 10 | √ | null | ||
img_image_summary_view | _object_key | int4 | 10 | √ | null | ||
img_imagepane_assoc | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
img_imagepane_assoc_view | _object_key | int4 | 10 | √ | null | ||
map_coord_feature | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
map_coordinate | _object_key | int4 | 10 | √ | null | foreign key to any object defined in ACC_MGIType | |
mgi_note | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
mgi_note_allele_view | _object_key | int4 | 10 | √ | null | ||
mgi_note_allelevariant_view | _object_key | int4 | 10 | √ | null | ||
mgi_note_derivation_view | _object_key | int4 | 10 | √ | null | ||
mgi_note_genotype_view | _object_key | int4 | 10 | √ | null | ||
mgi_note_image_view | _object_key | int4 | 10 | √ | null | ||
mgi_note_marker_view | _object_key | int4 | 10 | √ | null | ||
mgi_note_mrkgo_view | _object_key | int4 | 10 | √ | null | ||
mgi_note_probe_view | _object_key | int4 | 10 | √ | null | ||
mgi_note_sequence_view | _object_key | int4 | 10 | √ | null | ||
mgi_note_source_view | _object_key | int4 | 10 | √ | null | ||
mgi_note_strain_view | _object_key | int4 | 10 | √ | null | ||
mgi_note_vocevidence_view | _object_key | int4 | 10 | √ | null | ||
mgi_organism_acc_view | _object_key | int4 | 10 | √ | null | ||
mgi_organism_summary_view | _object_key | int4 | 10 | √ | null | ||
mgi_property | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
mgi_reference_allele_view | _object_key | int4 | 10 | √ | null | ||
mgi_reference_allelevariant_view | _object_key | int4 | 10 | √ | null | ||
mgi_reference_antibody_view | _object_key | int4 | 10 | √ | null | ||
mgi_reference_assoc | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
mgi_reference_marker_view | _object_key | int4 | 10 | √ | null | ||
mgi_reference_sequence_view | _object_key | int4 | 10 | √ | null | ||
mgi_reference_strain_view | _object_key | int4 | 10 | √ | null | ||
mgi_setmember | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
mgi_synonym | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
mgi_synonym_allele_view | _object_key | int4 | 10 | √ | null | ||
mgi_synonym_goterm_view | _object_key | int4 | 10 | √ | null | ||
mgi_synonym_musmarker_view | _object_key | int4 | 10 | √ | null | ||
mgi_synonym_strain_view | _object_key | int4 | 10 | √ | null | ||
mgi_translation | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
mgi_translation_view | _object_key | int4 | 10 | √ | null | ||
mgi_translationstrain_view | _object_key | int4 | 10 | √ | null | ||
mld_acc_view | _object_key | int4 | 10 | √ | null | ||
mld_summary_view | _object_key | int4 | 10 | √ | null | ||
mrk_acc_view | _object_key | int4 | 10 | √ | null | ||
mrk_accnoref_view | _object_key | int4 | 10 | √ | null | ||
mrk_accref1_view | _object_key | int4 | 10 | √ | null | ||
mrk_accref2_view | _object_key | int4 | 10 | √ | null | ||
mrk_accref_view | _object_key | int4 | 10 | √ | null | ||
mrk_summary_view | _object_key | int4 | 10 | √ | null | ||
prb_acc_view | _object_key | int4 | 10 | √ | null | ||
prb_accnoref_view | _object_key | int4 | 10 | √ | null | ||
prb_accref_view | _object_key | int4 | 10 | √ | null | ||
prb_accrefnoseq_view | _object_key | int4 | 10 | √ | null | ||
prb_source_acc_view | _object_key | int4 | 10 | √ | null | ||
prb_source_summary_view | _object_key | int4 | 10 | √ | null | ||
prb_strain_acc_view | _object_key | int4 | 10 | √ | null | ||
prb_strain_needsreview_view | _object_key | int4 | 10 | √ | null | ||
prb_strain_summary_view | _object_key | int4 | 10 | √ | null | ||
prb_tissue_summary_view | _object_key | int4 | 10 | √ | null | ||
seq_allele_assoc_view | _object_key | int4 | 10 | √ | null | ||
seq_sequence_acc_view | _object_key | int4 | 10 | √ | null | ||
seq_summary_view | _object_key | int4 | 10 | √ | null | ||
voc_annot | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
voc_annot_view | _object_key | int4 | 10 | √ | null | ||
voc_annotheader | _object_key | int4 | 10 | foreign key to any object defined in ACC_MGIType | |||
voc_annotheader_view | _object_key | int4 | 10 | √ | null | ||
voc_term_acc_view | _object_key | int4 | 10 | √ | null | ||
voc_term_summary_view | _object_key | int4 | 10 | √ | null | ||
mgi_relationship | _object_key_1 | int4 | 10 | First object in the relationship | |||
mgi_relationship_markertss_view | _object_key_1 | int4 | 10 | √ | null | ||
mgi_relationship | _object_key_2 | int4 | 10 | Second object in the relationship | |||
mgi_relationship_markertss_view | _object_key_2 | int4 | 10 | √ | null | ||
acc_logicaldb | _organism_key | int4 | 10 | √ | null | organism (foreign key to MGI_Organism) | |
acc_logicaldb_view | _organism_key | int4 | 10 | √ | null | ||
acc_view | _organism_key | int4 | 10 | √ | null | ||
all_allele_driver_view | _organism_key | int4 | 10 | √ | null | ||
gxd_antibody | _organism_key | int4 | 10 | organism (foreign key to MGI_Organism) | |||
gxd_antibody_view | _organism_key | int4 | 10 | √ | null | ||
gxd_antibodyantigen_view | _organism_key | int4 | 10 | √ | null | ||
gxd_antigen_view | _organism_key | int4 | 10 | √ | null | ||
gxd_htsample | _organism_key | int4 | 10 | foreign key to MGI_Organism, identifying type of organism for the sample | |||
gxd_htsample_rnaseqset | _organism_key | int4 | 10 | foreign key to MGI_Organism | |||
mgi_organism | _organism_key | int4 | 10 | organism (foreign key to MGI_Organism) | |||
mgi_organism_allele_view | _organism_key | int4 | 10 | √ | null | ||
mgi_organism_antigen_view | _organism_key | int4 | 10 | √ | null | ||
mgi_organism_marker_view | _organism_key | int4 | 10 | √ | null | ||
mgi_organism_mgitype | _organism_key | int4 | 10 | organism (foreign key to MGI_Organism) | |||
mgi_organism_mgitype_view | _organism_key | int4 | 10 | √ | null | ||
mgi_organism_probe_view | _organism_key | int4 | 10 | √ | null | ||
mgi_organism_view | _organism_key | int4 | 10 | √ | null | ||
mgi_synonym_allele_view | _organism_key | int4 | 10 | √ | null | ||
mgi_synonym_goterm_view | _organism_key | int4 | 10 | √ | null | ||
mgi_synonym_musmarker_view | _organism_key | int4 | 10 | √ | null | ||
mgi_synonym_strain_view | _organism_key | int4 | 10 | √ | null | ||
mgi_synonymtype | _organism_key | int4 | 10 | √ | null | foreign key to MGI_Organism | |
mgi_synonymtype_allele_view | _organism_key | int4 | 10 | √ | null | ||
mgi_synonymtype_goterm_view | _organism_key | int4 | 10 | √ | null | ||
mgi_synonymtype_musmarker_view | _organism_key | int4 | 10 | √ | null | ||
mgi_synonymtype_strain_view | _organism_key | int4 | 10 | √ | null | ||
mrk_acc_view | _organism_key | int4 | 10 | √ | null | ||
mrk_chromosome | _organism_key | int4 | 10 | organism (foreign key to MGI_Organism) | |||
mrk_do_cache | _organism_key | int4 | 10 | foreign key to MGI_Organism | |||
mrk_label | _organism_key | int4 | 10 | organism (foreign key to MGI_Organism) | |||
mrk_location_cache | _organism_key | int4 | 10 | foreign key to MGI_Organism | |||
mrk_marker | _organism_key | int4 | 10 | foreign key to MGI_Organism | |||
mrk_marker_view | _organism_key | int4 | 10 | √ | null | ||
mrk_mouse_view | _organism_key | int4 | 10 | √ | null | ||
mrk_nonmouse_view | _organism_key | int4 | 10 | √ | null | ||
prb_rflv_view | _organism_key | int4 | 10 | √ | null | ||
prb_source | _organism_key | int4 | 10 | organism (foreign key to MGI_Organism) | |||
prb_source_view | _organism_key | int4 | 10 | √ | null | ||
pwi_mrk_marker_view | _organism_key | int4 | 10 | √ | null | ||
seq_marker_cache | _organism_key | int4 | 10 | foreign key to MGI_Organism | |||
seq_sequence | _organism_key | int4 | 10 | foreign key to MGI_Organism | |||
seq_sequence_view | _organism_key | int4 | 10 | √ | null | ||
mrk_label | _orthologorganism_key | int4 | 10 | √ | null | organism of ortholog (foreign key to MGI_Organism) | |
gxd_allelepair | _pairstate_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 39 (Allele Pair State) | |||
gxd_allelepair_view | _pairstate_key | int4 | 10 | √ | null | ||
dag_edge | _parent_key | int4 | 10 | foreign key to DAG_Node._Node_key | |||
all_cellline_derivation | _parentcellline_key | int4 | 10 | foreign key to ALL_CellLine | |||
all_cellline_derivation_view | _parentcellline_key | int4 | 10 | √ | null | ||
gxd_insituresult | _pattern_key | int4 | 10 | foreign key to GXD_Pattern | |||
gxd_insituresult_view | _pattern_key | int4 | 10 | √ | null | ||
gxd_pattern | _pattern_key | int4 | 10 | primary key | |||
bib_all2_view | _primary | text | 2147483647 | √ | null | ||
bib_all_view | _primary | text | 2147483647 | √ | null | ||
bib_refs | _primary | text | 2147483647 | √ | null | primary author; extracted from authors field | |
bib_view | _primary | text | 2147483647 | √ | null | ||
mld_concordance_view | _primary | text | 2147483647 | √ | null | ||
mld_expt_marker_view | _primary | text | 2147483647 | √ | null | ||
mld_expt_view | _primary | text | 2147483647 | √ | null | ||
mld_fish_view | _primary | text | 2147483647 | √ | null | ||
mld_hybrid_view | _primary | text | 2147483647 | √ | null | ||
mld_insitu_view | _primary | text | 2147483647 | √ | null | ||
mld_matrix_view | _primary | text | 2147483647 | √ | null | ||
mld_mc2point_view | _primary | text | 2147483647 | √ | null | ||
mld_ri2point_view | _primary | text | 2147483647 | √ | null | ||
mld_ri_view | _primary | text | 2147483647 | √ | null | ||
mld_ridata_view | _primary | text | 2147483647 | √ | null | ||
mld_statistics_view | _primary | text | 2147483647 | √ | null | ||
pwi_bib_refs_view | _primary | text | 2147483647 | √ | null | ||
mrk_biotypemapping | _primarymcvterm_key | int4 | 10 | fk to voc_term where _vocab_key = 79 (Primary MCV/FeatureType term) | |||
gxd_index | _priority_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 11 (GXD Index Priority); 'High', 'Medium', 'Low' | |||
gxd_index_view | _priority_key | int4 | 10 | √ | null | ||
gxd_probeprep | _probe_key | int4 | 10 | foreign key to PRB_Probe | |||
gxd_probeprep_view | _probe_key | int4 | 10 | √ | null | ||
mld_contigprobe | _probe_key | int4 | 10 | foreign key to PRB_Probe | |||
mld_hit | _probe_key | int4 | 10 | foreign key to PRB_Probe | |||
prb_marker | _probe_key | int4 | 10 | foreign key to PRB_Probe | |||
prb_marker_view | _probe_key | int4 | 10 | √ | null | ||
prb_notes | _probe_key | int4 | 10 | foreign key to PRB_Probe | |||
prb_parent_view | _probe_key | int4 | 10 | √ | null | ||
prb_probe | _probe_key | int4 | 10 | foreign key to PRB_Probe | |||
prb_probe_view | _probe_key | int4 | 10 | √ | null | ||
prb_reference | _probe_key | int4 | 10 | foreign key to PRB_Probe | |||
prb_reference_view | _probe_key | int4 | 10 | √ | null | ||
seq_probe_cache | _probe_key | int4 | 10 | foreign key to PRB_Probe | |||
seq_probe_cache_view | _probe_key | int4 | 10 | √ | null | ||
gxd_assay | _probeprep_key | int4 | 10 | √ | null | foreign key to GXD_ProbePrep | |
gxd_assay_view | _probeprep_key | int4 | 10 | √ | null | ||
gxd_probeprep_view | _probeprep_key | int4 | 10 | √ | null | ||
mgi_property | _property_key | int4 | 10 | primary key | |||
mgi_relationship_property | _propertyname_key | int4 | 10 | The name of the property | |||
mgi_property | _propertyterm_key | int4 | 10 | foreign key to VOC_Term | |||
voc_evidence_property | _propertyterm_key | int4 | 10 | foreign key to VOC_Term; examples include: _Vocab_key = 82 (GO Property); 'evidence', 'anatomy', 'cell tyupe', 'text', etc. | |||
voc_evidenceproperty_view | _propertyterm_key | int4 | 10 | √ | null | ||
mgi_property | _propertytype_key | int4 | 10 | foreign key to MGI_PropertyType | |||
mgi_propertytype | _propertytype_key | int4 | 10 | primary key | |||
all_allele_subtype_view | _qualifier_key | int4 | 10 | √ | null | ||
all_annot_view | _qualifier_key | int4 | 10 | √ | null | ||
mgi_relationship | _qualifier_key | int4 | 10 | The term for the relationship qualifier | |||
mgi_relationship_markertss_view | _qualifier_key | int4 | 10 | √ | null | ||
prb_strain_genotype | _qualifier_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 32 (Strain/Genotype Qualifier) | |||
prb_strain_genotype_view | _qualifier_key | int4 | 10 | √ | null | ||
prb_strain_marker | _qualifier_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 31 (Strain Allele Qualifier); 'nomenclature' | |||
prb_strain_marker_view | _qualifier_key | int4 | 10 | √ | null | ||
prb_strain_needsreview_view | _qualifier_key | int4 | 10 | √ | null | ||
seq_allele_assoc | _qualifier_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 69 (Sequence Allele Association Qualifier) | |||
seq_allele_assoc_view | _qualifier_key | int4 | 10 | √ | null | ||
seq_marker_cache | _qualifier_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key =289 (Representative Sequence Qualifier); qualifies the association between the Marker and the Sequence | |||
seq_sequence_assoc | _qualifier_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 78 (Sequence-Sequence Association Qualifier); 'transcribed from', 'translated from', 'processed from' | |||
voc_annot | _qualifier_key | int4 | 10 | foreign key to VOC_Term; based on the VOC_AnnotType._AnnotType_key | |||
voc_annot_view | _qualifier_key | int4 | 10 | √ | null | ||
mgi_relationship_category | _qualifiervocab_key | int4 | 10 | The vocabulary that relationships draw their qualifier terms from | |||
voc_annottype | _qualifiervocab_key | int4 | 10 | foreign key to VOC_Term; examples include 52:GO Qualifier, 54:MP Qualifier | |||
mgi_refassoctype | _refassoctype_key | int4 | 10 | primary key | |||
mgi_reference_allele_view | _refassoctype_key | int4 | 10 | √ | null | ||
mgi_reference_allelevariant_view | _refassoctype_key | int4 | 10 | √ | null | ||
mgi_reference_antibody_view | _refassoctype_key | int4 | 10 | √ | null | ||
mgi_reference_assoc | _refassoctype_key | int4 | 10 | foreign key to MGI_RefAssocType | |||
mgi_reference_marker_view | _refassoctype_key | int4 | 10 | √ | null | ||
mgi_reference_sequence_view | _refassoctype_key | int4 | 10 | √ | null | ||
mgi_reference_strain_view | _refassoctype_key | int4 | 10 | √ | null | ||
mgi_reftype_allele_view | _refassoctype_key | int4 | 10 | √ | null | ||
mgi_reftype_antibody_view | _refassoctype_key | int4 | 10 | √ | null | ||
mgi_reftype_marker_view | _refassoctype_key | int4 | 10 | √ | null | ||
mgi_reftype_sequence_view | _refassoctype_key | int4 | 10 | √ | null | ||
mgi_reftype_strain_view | _refassoctype_key | int4 | 10 | √ | null | ||
prb_accref_view | _reference_key | int4 | 10 | √ | null | ||
prb_accrefnoseq_view | _reference_key | int4 | 10 | √ | null | ||
prb_alias | _reference_key | int4 | 10 | foreign key to PRB_Reference | |||
prb_ref_notes | _reference_key | int4 | 10 | foreign key to PRB_Reference | |||
prb_reference | _reference_key | int4 | 10 | primary key | |||
prb_reference_view | _reference_key | int4 | 10 | √ | null | ||
prb_rflv | _reference_key | int4 | 10 | foreign key to PRB_Reference | |||
prb_rflv_view | _reference_key | int4 | 10 | √ | null | ||
bib_all2_view | _referencetype_key | int4 | 10 | √ | null | ||
bib_all_view | _referencetype_key | int4 | 10 | √ | null | ||
bib_refs | _referencetype_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 131 (Reference Type) | |||
bib_view | _referencetype_key | int4 | 10 | √ | null | ||
pwi_bib_refs_view | _referencetype_key | int4 | 10 | √ | null | ||
acc_accessionreference | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
all_allele | _refs_key | int4 | 10 | √ | null | ||
all_allele_view | _refs_key | int4 | 10 | √ | null | ||
all_cellline_derivation | _refs_key | int4 | 10 | √ | null | foreign key to BIB_Refs | |
all_cellline_derivation_view | _refs_key | int4 | 10 | √ | null | ||
bib_all2_view | _refs_key | int4 | 10 | √ | null | ||
bib_all_view | _refs_key | int4 | 10 | √ | null | ||
bib_associateddata_view | _refs_key | int4 | 10 | √ | null | ||
bib_books | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
bib_citation_cache | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
bib_goxref_view | _refs_key | int4 | 10 | √ | null | ||
bib_notes | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
bib_status_view | _refs_key | int4 | 10 | √ | null | ||
bib_view | _refs_key | int4 | 10 | √ | null | ||
bib_workflow_data | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
bib_workflow_status | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
bib_workflow_tag | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
crs_references | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
dag_dag | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
gxd_antibodyalias | _refs_key | int4 | 10 | √ | null | foreign key to BIB_Refs | |
gxd_antibodyalias_view | _refs_key | int4 | 10 | √ | null | ||
gxd_antibodyaliasref_view | _refs_key | int4 | 10 | √ | null | ||
gxd_antibodyantigen_view | _refs_key | int4 | 10 | √ | null | ||
gxd_antigen_view | _refs_key | int4 | 10 | √ | null | ||
gxd_assay | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
gxd_assay_view | _refs_key | int4 | 10 | √ | null | ||
gxd_expression | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
gxd_genotype_dataset_view | _refs_key | int4 | 10 | √ | null | ||
gxd_index | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
gxd_index_view | _refs_key | int4 | 10 | √ | null | ||
img_image | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
img_image_view | _refs_key | int4 | 10 | √ | null | ||
img_imagepanegxd_view | _refs_key | int4 | 10 | √ | null | ||
mgi_reference_allele_view | _refs_key | int4 | 10 | √ | null | ||
mgi_reference_allelevariant_view | _refs_key | int4 | 10 | √ | null | ||
mgi_reference_antibody_view | _refs_key | int4 | 10 | √ | null | ||
mgi_reference_assoc | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
mgi_reference_marker_view | _refs_key | int4 | 10 | √ | null | ||
mgi_reference_sequence_view | _refs_key | int4 | 10 | √ | null | ||
mgi_reference_strain_view | _refs_key | int4 | 10 | √ | null | ||
mgi_relationship | _refs_key | int4 | 10 | The relationship reference | |||
mgi_relationship_markertss_view | _refs_key | int4 | 10 | √ | null | ||
mgi_synonym | _refs_key | int4 | 10 | √ | null | foreign key to BIB_Refs | |
mgi_synonym_allele_view | _refs_key | int4 | 10 | √ | null | ||
mgi_synonym_goterm_view | _refs_key | int4 | 10 | √ | null | ||
mgi_synonym_musmarker_view | _refs_key | int4 | 10 | √ | null | ||
mgi_synonym_strain_view | _refs_key | int4 | 10 | √ | null | ||
mld_expt_view | _refs_key | int4 | 10 | √ | null | ||
mld_expts | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
mld_notes | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
mrk_accref1_view | _refs_key | int4 | 10 | √ | null | ||
mrk_accref2_view | _refs_key | int4 | 10 | √ | null | ||
mrk_accref_view | _refs_key | int4 | 10 | √ | null | ||
mrk_do_cache | _refs_key | int4 | 10 | foreign key to BIB_Refs; reference for DO annotation | |||
mrk_history | _refs_key | int4 | 10 | √ | null | foreign key to BIB_Refs | |
mrk_history_view | _refs_key | int4 | 10 | √ | null | ||
mrk_reference | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
mrk_reference_view | _refs_key | int4 | 10 | √ | null | ||
mrk_strainmarker | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
prb_marker | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
prb_marker_view | _refs_key | int4 | 10 | √ | null | ||
prb_reference | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
prb_reference_view | _refs_key | int4 | 10 | √ | null | ||
prb_source | _refs_key | int4 | 10 | √ | null | foreign key to BIB_Refs | |
prb_source_view | _refs_key | int4 | 10 | √ | null | ||
pwi_all_allele_view | _refs_key | int4 | 10 | √ | null | ||
pwi_bib_refs_view | _refs_key | int4 | 10 | √ | null | ||
ri_summary_expt_ref | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
seq_allele_assoc | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
seq_allele_assoc_view | _refs_key | int4 | 10 | √ | null | ||
seq_allele_view | _refs_key | int4 | 10 | √ | null | ||
seq_marker_cache | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
seq_marker_cache_view | _refs_key | int4 | 10 | √ | null | ||
seq_probe_cache | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
seq_probe_cache_view | _refs_key | int4 | 10 | √ | null | ||
voc_evidence | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
voc_evidence_view | _refs_key | int4 | 10 | √ | null | ||
voc_vocab | _refs_key | int4 | 10 | foreign key to BIB_Refs | |||
voc_vocab_view | _refs_key | int4 | 10 | √ | null | ||
all_allele_driver_view | _relationship_key | int4 | 10 | √ | null | ||
mgi_relationship_markertss_view | _relationship_key | int4 | 10 | √ | null | ||
mgi_relationship_property | _relationship_key | int4 | 10 | The relationship this property applies to | |||
mgi_relationship_category | _relationshipdag_key | int4 | 10 | √ | null | The DAG which optionally identifies an individual DAG which structures a subset of terms from the vocabulary for use by this category | |
mgi_relationship_property | _relationshipproperty_key | int4 | 10 | Primary key | |||
mgi_relationship | _relationshipterm_key | int4 | 10 | The term identifying the relationship between the two objects | |||
mgi_relationship_markertss_view | _relationshipterm_key | int4 | 10 | √ | null | ||
mgi_relationship_category | _relationshipvocab_key | int4 | 10 | The vocabulary that relationships draw their relationship terms from | |||
gxd_htsample | _relevance_key | int4 | 10 | foreign key to VOC_Term, identifies if this sample is relevant for GXD or, if not, why not | |||
gxd_assay | _reportergene_key | int4 | 10 | √ | null | foreign key to VOC_Term where _Vocab_key = 14 (GXD Reporter Gene); 'hemagglutinin', 'lacZ', 'GFP', 'Cre', 'FLP', etc. | |
gxd_assay_view | _reportergene_key | int4 | 10 | √ | null | ||
gxd_insituresult_view | _result_key | int4 | 10 | √ | null | ||
gxd_insituresultimage | _result_key | int4 | 10 | foreign key to GXD_InSituResult | |||
gxd_isresultimage_view | _result_key | int4 | 10 | √ | null | ||
gxd_isresultstructure | _result_key | int4 | 10 | foreign key to GXD_InSituResult | |||
gxd_isresultstructure_view | _result_key | int4 | 10 | √ | null | ||
gxd_isresultimage_view | _resultimage_key | int4 | 10 | √ | null | ||
gxd_isresultstructure_view | _resultstructure_key | int4 | 10 | √ | null | ||
seq_genetrap | _reversecomp_key | int4 | 10 | foreign key to VOC_Term (_Vocab_key = 68). Answers the question is this sequence reverse complemented? | |||
prb_allele | _rflv_key | int4 | 10 | foreign key to PRB_RFLV | |||
prb_rflv | _rflv_key | int4 | 10 | primary key | |||
prb_rflv_view | _rflv_key | int4 | 10 | √ | null | ||
mld_ri | _riset_key | int4 | 10 | foreign key to RI_RISet | |||
mld_ri_view | _riset_key | int4 | 10 | √ | null | ||
ri_riset | _riset_key | int4 | 10 | primary key | |||
ri_riset_view | _riset_key | int4 | 10 | √ | null | ||
ri_summary | _riset_key | int4 | 10 | foreign key to RI_RISet | |||
ri_summary | _risummary_key | int4 | 10 | primary key | |||
ri_summary_expt_ref | _risummary_key | int4 | 10 | foreign key to RI_Summary | |||
gxd_htsample_rnaseq | _rnaseqcombined_key | int4 | 10 | foreign key to GXD_HTSample_RNASeqCombined | |||
gxd_htsample_rnaseqsetmember | _rnaseqset_key | int4 | 10 | foreign key to GXD_HTSample_RNASeq, identifing the set | |||
mgi_roletask | _role_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 33 (User Role) | |||
mgi_roletask_view | _role_key | int4 | 10 | √ | null | ||
mgi_userrole | _role_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 33 (User Role) | |||
mgi_userrole_view | _role_key | int4 | 10 | √ | null | ||
mgi_usertask_view | _role_key | int4 | 10 | √ | null | ||
mgi_roletask | _roletask_key | int4 | 10 | primary key | |||
mgi_roletask_view | _roletask_key | int4 | 10 | √ | null | ||
wks_rosetta | _rosetta_key | int4 | 10 | primary key | |||
gxd_htsample | _sample_key | int4 | 10 | primary key | |||
gxd_htsample_rnaseq | _sample_key | int4 | 10 | foreign key to GXD_HTSample | |||
gxd_htsample_rnaseqsetmember | _sample_key | int4 | 10 | foreign key to GXD_HTSample, identifying the sample member | |||
gxd_antibodyprep | _secondary_key | int4 | 10 | foreign key to GXD_Antibody | |||
gxd_antibodyprep_view | _secondary_key | int4 | 10 | √ | null | ||
gxd_secondary | _secondary_key | int4 | 10 | primary key | |||
prb_probe | _segmenttype_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 21 (Sequence Type) | |||
prb_probe_view | _segmenttype_key | int4 | 10 | √ | null | ||
prb_source | _segmenttype_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 10 (Segment Type) | |||
prb_source_view | _segmenttype_key | int4 | 10 | √ | null | ||
gxd_probeprep | _sense_key | int4 | 10 | foreign key to GXD_ProbeSense | |||
gxd_probeprep_view | _sense_key | int4 | 10 | √ | null | ||
gxd_probesense | _sense_key | int4 | 10 | primary key | |||
seq_allele_assoc | _sequence_key | int4 | 10 | foreign key to SEQ_Sequence | |||
seq_allele_assoc_view | _sequence_key | int4 | 10 | √ | null | ||
seq_allele_view | _sequence_key | int4 | 10 | √ | null | ||
seq_coord_cache | _sequence_key | int4 | 10 | foreign key to SEQ_Sequence | |||
seq_genemodel | _sequence_key | int4 | 10 | foreign key to SEQ_Sequence | |||
seq_genetrap | _sequence_key | int4 | 10 | foreign key to SEQ_Sequence | |||
seq_marker_cache | _sequence_key | int4 | 10 | foreign key to SEQ_Sequence | |||
seq_marker_cache_view | _sequence_key | int4 | 10 | √ | null | ||
seq_probe_cache | _sequence_key | int4 | 10 | foreign key to SEQ_Sequence | |||
seq_probe_cache_view | _sequence_key | int4 | 10 | √ | null | ||
seq_sequence | _sequence_key | int4 | 10 | primary key | |||
seq_sequence_raw | _sequence_key | int4 | 10 | foreign key to SEQ_Sequence | |||
seq_sequence_view | _sequence_key | int4 | 10 | √ | null | ||
seq_source_assoc | _sequence_key | int4 | 10 | foreign key to SEQ_Sequence | |||
seq_sequence_assoc | _sequence_key_1 | int4 | 10 | foreign key to SEQ_Sequence | |||
seq_sequence_assoc | _sequence_key_2 | int4 | 10 | foreign key to SEQ_Sequence | |||
all_variant_sequence | _sequence_type_key | int4 | 10 | foreign key to VOC_Term, identifies the type of this sequence (_Vocab_key = 21) | |||
seq_allele_view | _sequenceprovider_key | int4 | 10 | √ | null | ||
seq_marker_cache | _sequenceprovider_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 25 (Sequence Provider) | |||
seq_marker_cache_view | _sequenceprovider_key | int4 | 10 | √ | null | ||
seq_sequence | _sequenceprovider_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 25 (Sequence Provider) | |||
seq_sequence_view | _sequenceprovider_key | int4 | 10 | √ | null | ||
seq_sequence | _sequencequality_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 19 (Sequence Quality) | |||
seq_sequence_view | _sequencequality_key | int4 | 10 | √ | null | ||
seq_sequence | _sequencestatus_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 20 (Sequence Status) | |||
seq_sequence_view | _sequencestatus_key | int4 | 10 | √ | null | ||
seq_allele_view | _sequencetype_key | int4 | 10 | √ | null | ||
seq_marker_cache | _sequencetype_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 21 (Sequence Type) | |||
seq_marker_cache_view | _sequencetype_key | int4 | 10 | √ | null | ||
seq_sequence | _sequencetype_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 21 (Sequence Type) | |||
seq_sequence_view | _sequencetype_key | int4 | 10 | √ | null | ||
mgi_set | _set_key | int4 | 10 | primary key | |||
mgi_setmember | _set_key | int4 | 10 | foreign key to MGI_Set | |||
mgi_setmember_emapa | _setmember_emapa_key | int4 | 10 | primary key | |||
mgi_setmember | _setmember_key | int4 | 10 | primary key | |||
mgi_setmember_emapa | _setmember_key | int4 | 10 | foreign key to MGI_SetMember | |||
gxd_htsample | _sex_key | int4 | 10 | foreign key to VOC_Term, identifying sex of the sample | |||
gxd_htsample_rnaseqset | _sex_key | int4 | 10 | foreign key to VOC_Term | |||
gxd_antibodyantigen_view | _source_key | int4 | 10 | √ | null | ||
gxd_antigen | _source_key | int4 | 10 | foreign key to PRB_Source | |||
gxd_antigen_view | _source_key | int4 | 10 | √ | null | ||
gxd_htexperiment | _source_key | int4 | 10 | foreign key to VOC_Term, identifies site from which we downloaded raw data for this experiment | |||
prb_probe | _source_key | int4 | 10 | foreign key to PRB_Source | |||
prb_probe_view | _source_key | int4 | 10 | √ | null | ||
prb_source_view | _source_key | int4 | 10 | √ | null | ||
prb_sourceref_view | _source_key | int4 | 10 | √ | null | ||
seq_source_assoc | _source_key | int4 | 10 | foreign key to PRB_Source | |||
all_variant | _sourcevariant_key | int4 | 10 | √ | null | null if this is a source (as reported) variant record; foreign key to ALL_Variant to identify the source variant, if this is a curated record | |
prb_strain | _species_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 26 (Strain Species) | |||
prb_strain_view | _species_key | int4 | 10 | √ | null | ||
gxd_expression | _specimen_key | int4 | 10 | √ | null | foreign key to GXD_Specimen | |
gxd_insituresult | _specimen_key | int4 | 10 | foreign key to GXD_Specimen | |||
gxd_insituresult_view | _specimen_key | int4 | 10 | √ | null | ||
gxd_isresultimage_view | _specimen_key | int4 | 10 | √ | null | ||
gxd_isresultstructure_view | _specimen_key | int4 | 10 | √ | null | ||
gxd_specimen_view | _specimen_key | int4 | 10 | √ | null | ||
all_cre_cache | _stage_key | int4 | 10 | √ | null | foreign key to GXD_TheilerStage | |
gxd_expression | _stage_key | int4 | 10 | foreign key to GXD_TheilerStage | |||
gxd_gellanestructure | _stage_key | int4 | 10 | foreign key to GXD_TheilerStage | |||
gxd_gellanestructure_view | _stage_key | int4 | 10 | √ | null | ||
gxd_htsample | _stage_key | int4 | 10 | √ | null | foreign key to GXD_TheilerStage, identifying the Theiler Stage of the sample | |
gxd_htsample_rnaseqset | _stage_key | int4 | 10 | foreign key to GXD_TheilerStage | |||
gxd_isresultstructure | _stage_key | int4 | 10 | foreign key to GXD_TheilerStage | |||
gxd_isresultstructure_view | _stage_key | int4 | 10 | √ | null | ||
gxd_theilerstage | _stage_key | int4 | 10 | primary key | |||
mgi_setmember_emapa | _stage_key | int4 | 10 | foreign key to GXD_TheilerStage | |||
voc_term_emaps | _stage_key | int4 | 10 | The theiler stage for this EMAPS term | |||
gxd_index_stages | _stageid_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 13 (GXD Index Stage); '1', '1.5', '2', '2.5'...'19', '19.5' | |||
bib_workflow_status | _status_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 128 (Workflow Status) | |||
all_allele | _strain_key | int4 | 10 | foreign key to PRB_Strain; the Strain Of Origin; for Transgenes this is the Strain fro which the mutation was made | |||
all_allele_view | _strain_key | int4 | 10 | √ | null | ||
all_cellline | _strain_key | int4 | 10 | foreign key to PRB_Strain | |||
all_cellline_view | _strain_key | int4 | 10 | √ | null | ||
all_variant | _strain_key | int4 | 10 | foreign key to PRB_Strain, identifies the strain with this variant | |||
gxd_antibodyantigen_view | _strain_key | int4 | 10 | √ | null | ||
gxd_antigen_view | _strain_key | int4 | 10 | √ | null | ||
gxd_genotype | _strain_key | int4 | 10 | foreign key to PRB_Strain | |||
gxd_genotype_view | _strain_key | int4 | 10 | √ | null | ||
mld_fish | _strain_key | int4 | 10 | foreign key to PRB_Strain | |||
mld_fish_view | _strain_key | int4 | 10 | √ | null | ||
mld_insitu | _strain_key | int4 | 10 | foreign key to PRB_Strain | |||
mld_insitu_view | _strain_key | int4 | 10 | √ | null | ||
mrk_strainmarker | _strain_key | int4 | 10 | foreign key to PRB_Strain | |||
prb_allele_strain | _strain_key | int4 | 10 | foreign key to PRB_Strain | |||
prb_rflv_view | _strain_key | int4 | 10 | √ | null | ||
prb_source | _strain_key | int4 | 10 | foreign key to PRB_Strain | |||
prb_source_view | _strain_key | int4 | 10 | √ | null | ||
prb_strain_attribute_view | _strain_key | int4 | 10 | √ | null | ||
prb_strain_genotype | _strain_key | int4 | 10 | foreign key to PRB_Strain | |||
prb_strain_genotype_view | _strain_key | int4 | 10 | √ | null | ||
prb_strain_marker | _strain_key | int4 | 10 | foreign key to PRB_Strain | |||
prb_strain_marker_view | _strain_key | int4 | 10 | √ | null | ||
prb_strain_view | _strain_key | int4 | 10 | √ | null | ||
pwi_all_allele_view | _strain_key | int4 | 10 | √ | null | ||
mld_ri_view | _strain_key_1 | int4 | 10 | √ | null | ||
ri_riset | _strain_key_1 | int4 | 10 | foreign key to PRB_Strain; 1st member of the cross | |||
ri_riset_view | _strain_key_1 | int4 | 10 | √ | null | ||
mld_ri_view | _strain_key_2 | int4 | 10 | √ | null | ||
ri_riset | _strain_key_2 | int4 | 10 | foreign key to PRB_Strain; 2nd member of the cross | |||
ri_riset_view | _strain_key_2 | int4 | 10 | √ | null | ||
prb_strain_genotype_view | _straingenotype_key | int4 | 10 | √ | null | ||
crs_cross | _strainho_key | int4 | 10 | foreign key to PRB_Strain; homozygous strain | |||
crs_cross_view | _strainho_key | int4 | 10 | √ | null | ||
mld_matrix_view | _strainho_key | int4 | 10 | √ | null | ||
crs_cross | _strainht_key | int4 | 10 | foreign key to PRB_Strain; heterozygous strain | |||
crs_cross_view | _strainht_key | int4 | 10 | √ | null | ||
mld_matrix_view | _strainht_key | int4 | 10 | √ | null | ||
mrk_strainmarker | _strainmarker_key | int4 | 10 | primary key | |||
prb_strain_marker_view | _strainmarker_key | int4 | 10 | √ | null | ||
prb_strain | _straintype_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 55 (Strain Type) | |||
prb_strain_view | _straintype_key | int4 | 10 | √ | null | ||
gxd_gelband | _strength_key | int4 | 10 | foreign key to GXD_Strength | |||
gxd_gelband_view | _strength_key | int4 | 10 | √ | null | ||
gxd_insituresult | _strength_key | int4 | 10 | foreign key to GXD_Strength | |||
gxd_insituresult_view | _strength_key | int4 | 10 | √ | null | ||
gxd_strength | _strength_key | int4 | 10 | primary key | |||
gxd_htexperiment | _studytype_key | int4 | 10 | foreign key to VOC_Term, identifying whether this experiment is a baseline or differential study | |||
bib_workflow_data | _supplemental_key | int4 | 10 | foreign key to VOC_Term where_Vocab_key = 130 (Workflow Supplemental Status) | |||
mgi_synonym_allele_view | _synonym_key | int4 | 10 | √ | null | ||
mgi_synonym_goterm_view | _synonym_key | int4 | 10 | √ | null | ||
mgi_synonym_musmarker_view | _synonym_key | int4 | 10 | √ | null | ||
mgi_synonym_strain_view | _synonym_key | int4 | 10 | √ | null | ||
mgi_synonym | _synonymtype_key | int4 | 10 | foreign key to MGI_SynonymType | |||
mgi_synonym_allele_view | _synonymtype_key | int4 | 10 | √ | null | ||
mgi_synonym_goterm_view | _synonymtype_key | int4 | 10 | √ | null | ||
mgi_synonym_musmarker_view | _synonymtype_key | int4 | 10 | √ | null | ||
mgi_synonym_strain_view | _synonymtype_key | int4 | 10 | √ | null | ||
mgi_synonymtype | _synonymtype_key | int4 | 10 | primary key | |||
mgi_synonymtype_allele_view | _synonymtype_key | int4 | 10 | √ | null | ||
mgi_synonymtype_goterm_view | _synonymtype_key | int4 | 10 | √ | null | ||
mgi_synonymtype_musmarker_view | _synonymtype_key | int4 | 10 | √ | null | ||
mgi_synonymtype_strain_view | _synonymtype_key | int4 | 10 | √ | null | ||
bib_workflow_tag | _tag_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 129 (Workflow Tag) | |||
seq_genetrap | _tagmethod_key | int4 | 10 | foreign key to VOC_Term (_Vocab_key = 66) The name of the procedure used to produce a sequence tag from a gene trap insertion in a mutant cell line. | |||
mld_hit | _target_key | int4 | 10 | foreign key to PRB_Probe (Target (YAC)) | |||
mgi_roletask | _task_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 34 (User Task) | |||
mgi_roletask_view | _task_key | int4 | 10 | √ | null | ||
all_allele_subtype_view | _term_key | int4 | 10 | √ | null | ||
gxd_htexperimentvariable | _term_key | int4 | 10 | foreign key to VOC_Term, identifying whether the experiment variable | |||
mrk_do_cache | _term_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 44 (DO) | |||
prb_strain_attribute_view | _term_key | int4 | 10 | √ | null | ||
prb_strain_needsreview_view | _term_key | int4 | 10 | √ | null | ||
voc_allele_cache | _term_key | int4 | 10 | foreign key to VOC_Term | |||
voc_annot | _term_key | int4 | 10 | foreign key to VOC_Term; based on the VOC_AnnotType._Vocab_key | |||
voc_annot_count_cache | _term_key | int4 | 10 | foreign key to VOC_Term | |||
voc_annot_view | _term_key | int4 | 10 | √ | null | ||
voc_annotheader | _term_key | int4 | 10 | Header Term for the annotation; foreign key to VOC_Term | |||
voc_annotheader_view | _term_key | int4 | 10 | √ | null | ||
voc_go_cache | _term_key | int4 | 10 | foreign key to VOC_Term | |||
voc_marker_cache | _term_key | int4 | 10 | foreign key to VOC_Term | |||
voc_term_cellline_view | _term_key | int4 | 10 | √ | null | ||
voc_term_emapa | _term_key | int4 | 10 | The EMAPA term | |||
voc_term_emaps | _term_key | int4 | 10 | The EMAPS term | |||
voc_term_mcv_view | _term_key | int4 | 10 | √ | null | ||
voc_term_repqualifier_view | _term_key | int4 | 10 | √ | null | ||
voc_term_strainallele_view | _term_key | int4 | 10 | √ | null | ||
voc_term_strainspecies_view | _term_key | int4 | 10 | √ | null | ||
voc_term_view | _term_key | int4 | 10 | √ | null | ||
img_image | _thumbnailimage_key | int4 | 10 | √ | null | foreign key to IMG_Image; if _ImageType_key is full size, then this refers to an IMG_Image object where _ImageType_key is thumbnail; it specifies that thumbnail image counterpart of the full size Image. | |
img_image_view | _thumbnailimage_key | int4 | 10 | √ | null | ||
gxd_antibodyantigen_view | _tissue_key | int4 | 10 | √ | null | ||
gxd_antigen_view | _tissue_key | int4 | 10 | √ | null | ||
prb_source | _tissue_key | int4 | 10 | foreign key to PRB_Tissue | |||
prb_source_view | _tissue_key | int4 | 10 | √ | null | ||
mgi_translation | _translation_key | int4 | 10 | primary key | |||
mgi_translation_view | _translation_key | int4 | 10 | √ | null | ||
mgi_translationstrain_view | _translation_key | int4 | 10 | √ | null | ||
mgi_translation | _translationtype_key | int4 | 10 | foreign key to MGI_TranslationType | |||
mgi_translation_view | _translationtype_key | int4 | 10 | √ | null | ||
mgi_translationstrain_view | _translationtype_key | int4 | 10 | √ | null | ||
mgi_translationtype | _translationtype_key | int4 | 10 | primary key | |||
all_allele | _transmission_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 61 (Allele Transmission); 'Germline', 'Cell Line', 'Chimeric' | |||
all_allele_view | _transmission_key | int4 | 10 | √ | null | ||
pwi_all_allele_view | _transmission_key | int4 | 10 | √ | null | ||
map_coordinate | _units_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 30 (Map Units) | |||
mgi_user | _user_key | int4 | 10 | primary key | |||
mgi_user_active_view | _user_key | int4 | 10 | √ | null | ||
mgi_userrole | _user_key | int4 | 10 | foreign key to MGI_User | |||
mgi_userrole_view | _user_key | int4 | 10 | √ | null | ||
mgi_usertask_view | _user_key | int4 | 10 | √ | null | ||
mgi_userrole | _userrole_key | int4 | 10 | primary key | |||
mgi_userrole_view | _userrole_key | int4 | 10 | √ | null | ||
mgi_usertask_view | _userrole_key | int4 | 10 | √ | null | ||
mgi_user | _userstatus_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 22 (User Status) | |||
mgi_user_active_view | _userstatus_key | int4 | 10 | √ | null | ||
mgi_user | _usertype_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 23 (User Type) | |||
mgi_user_active_view | _usertype_key | int4 | 10 | √ | null | ||
all_variant_sequence | _variant_key | int4 | 10 | foreign key to ALL_Variant_Variant, identifying the variant with this sequence | |||
all_allele_cellline_view | _vector_key | int4 | 10 | √ | null | ||
all_cellline_derivation | _vector_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = = 72 (Cell Line Vector Name) | |||
all_cellline_derivation_view | _vector_key | int4 | 10 | √ | null | ||
all_cellline_view | _vector_key | int4 | 10 | √ | null | ||
prb_probe | _vector_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 24 (Segment Vector Type) | |||
prb_probe_view | _vector_key | int4 | 10 | √ | null | ||
prb_source | _vector_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 24 (Segment Vector Type) | |||
prb_source_view | _vector_key | int4 | 10 | √ | null | ||
seq_genetrap | _vectorend_key | int4 | 10 | foreign key to VOC_Term (_Vocab_key = 67) | |||
all_cellline_derivation | _vectortype_key | int4 | 10 | foreign key to VOC_Term where _Vocab_key = 64 (Cell Line Vector Type) | |||
all_cellline_derivation_view | _vectortype_key | int4 | 10 | √ | null | ||
all_cellline_view | _vectortype_key | int4 | 10 | √ | null | ||
gxd_probeprep | _visualization_key | int4 | 10 | foreign key to GXD_VisualizationMethod | |||
gxd_probeprep_view | _visualization_key | int4 | 10 | √ | null | ||
gxd_visualizationmethod | _visualization_key | int4 | 10 | primary key | |||
dag_node_view | _vocab_key | int4 | 10 | √ | null | ||
mgi_propertytype | _vocab_key | int4 | 10 | √ | null | foreign key to VOC_Vocab | |
mgi_translationtype | _vocab_key | int4 | 10 | √ | null | foreign key to VOC_Vocab | |
voc_annot_view | _vocab_key | int4 | 10 | √ | null | ||
voc_annottype | _vocab_key | int4 | 10 | foreign key to VOC_Vocab | |||
voc_term | _vocab_key | int4 | 10 | foreign key to VOC_Vocab | |||
voc_term_cellline_view | _vocab_key | int4 | 10 | √ | null | ||
voc_term_mcv_view | _vocab_key | int4 | 10 | √ | null | ||
voc_term_repqualifier_view | _vocab_key | int4 | 10 | √ | null | ||
voc_term_strainallele_view | _vocab_key | int4 | 10 | √ | null | ||
voc_term_strainspecies_view | _vocab_key | int4 | 10 | √ | null | ||
voc_term_view | _vocab_key | int4 | 10 | √ | null | ||
voc_vocab | _vocab_key | int4 | 10 | primary key | |||
voc_vocab_view | _vocab_key | int4 | 10 | √ | null | ||
voc_vocabdag | _vocab_key | int4 | 10 | foreign key to VOC_Vocab | |||
voc_vocabdag_view | _vocab_key | int4 | 10 | √ | null | ||
mld_ri_view | abbrev1 | text | 2147483647 | √ | null | ||
ri_riset | abbrev1 | text | 2147483647 | Strain 1 Abbreviation | |||
ri_riset_view | abbrev1 | text | 2147483647 | √ | null | ||
mld_ri_view | abbrev2 | text | 2147483647 | √ | null | ||
ri_riset | abbrev2 | text | 2147483647 | Strain 2 Abbreviation | |||
ri_riset_view | abbrev2 | text | 2147483647 | √ | null | ||
crs_cross | abbrevho | text | 2147483647 | √ | null | strain abbreviation for homozygous strain | |
crs_cross_view | abbrevho | text | 2147483647 | √ | null | ||
mld_matrix_view | abbrevho | text | 2147483647 | √ | null | ||
crs_cross | abbrevht | text | 2147483647 | √ | null | strain abbreviation for heterozygous strain | |
crs_cross_view | abbrevht | text | 2147483647 | √ | null | ||
mld_matrix_view | abbrevht | text | 2147483647 | √ | null | ||
dag_dag | abbreviation | bpchar | 5 | abbreviated name | |||
map_coord_collection | abbreviation | text | 2147483647 | short version of name | |||
map_coordinate | abbreviation | text | 2147483647 | √ | null | short version of name | |
voc_term | abbreviation | text | 2147483647 | √ | null | abbervated term | |
voc_term_cellline_view | abbreviation | text | 2147483647 | √ | null | ||
voc_term_mcv_view | abbreviation | text | 2147483647 | √ | null | ||
voc_term_repqualifier_view | abbreviation | text | 2147483647 | √ | null | ||
voc_term_strainallele_view | abbreviation | text | 2147483647 | √ | null | ||
voc_term_strainspecies_view | abbreviation | text | 2147483647 | √ | null | ||
voc_term_view | abbreviation | text | 2147483647 | √ | null | ||
bib_all2_view | abstract | text | 2147483647 | √ | null | ||
bib_all_view | abstract | text | 2147483647 | √ | null | ||
bib_refs | abstract | text | 2147483647 | √ | null | NLM (Medline) abstract | |
bib_view | abstract | text | 2147483647 | √ | null | ||
pwi_bib_refs_view | abstract | text | 2147483647 | √ | null | ||
acc_accession | accid | text | 2147483647 | the full accession number string | |||
acc_view | accid | text | 2147483647 | √ | null | ||
all_acc_view | accid | text | 2147483647 | √ | null | ||
all_cellline_acc_view | accid | text | 2147483647 | √ | null | ||
all_cre_cache | accid | text | 2147483647 | accession id | |||
all_derivation_summary_view | accid | text | 2147483647 | √ | null | ||
all_summary_view | accid | text | 2147483647 | √ | null | ||
bib_acc_view | accid | text | 2147483647 | √ | null | ||
bib_summary_all_view | accid | text | 2147483647 | √ | null | ||
gxd_antibody_acc_view | accid | text | 2147483647 | √ | null | ||
gxd_antibodyprep_view | accid | text | 2147483647 | √ | null | ||
gxd_antigen_acc_view | accid | text | 2147483647 | √ | null | ||
gxd_antigen_summary_view | accid | text | 2147483647 | √ | null | ||
gxd_assay_acc_view | accid | text | 2147483647 | √ | null | ||
gxd_genotype_acc_view | accid | text | 2147483647 | √ | null | ||
gxd_genotype_summary_view | accid | text | 2147483647 | √ | null | ||
gxd_probeprep_view | accid | text | 2147483647 | √ | null | ||
img_image_acc_view | accid | text | 2147483647 | √ | null | ||
img_image_summary_view | accid | text | 2147483647 | √ | null | ||
mgi_organism_acc_view | accid | text | 2147483647 | √ | null | ||
mgi_organism_summary_view | accid | text | 2147483647 | √ | null | ||
mgi_reference_allele_view | accid | text | 2147483647 | √ | null | ||
mgi_reference_marker_view | accid | text | 2147483647 | √ | null | ||
mgi_reference_strain_view | accid | text | 2147483647 | √ | null | ||
mld_acc_view | accid | text | 2147483647 | √ | null | ||
mld_expt_marker_view | accid | text | 2147483647 | √ | null | ||
mld_summary_view | accid | text | 2147483647 | √ | null | ||
mrk_acc_view | accid | text | 2147483647 | √ | null | ||
mrk_accnoref_view | accid | text | 2147483647 | √ | null | ||
mrk_accref1_view | accid | text | 2147483647 | √ | null | ||
mrk_accref2_view | accid | text | 2147483647 | √ | null | ||
mrk_accref_view | accid | text | 2147483647 | √ | null | ||
mrk_nonmouse_view | accid | text | 2147483647 | √ | null | ||
mrk_summary_view | accid | text | 2147483647 | √ | null | ||
prb_acc_view | accid | text | 2147483647 | √ | null | ||
prb_accnoref_view | accid | text | 2147483647 | √ | null | ||
prb_accref_view | accid | text | 2147483647 | √ | null | ||
prb_accrefnoseq_view | accid | text | 2147483647 | √ | null | ||
prb_parent_view | accid | text | 2147483647 | √ | null | ||
prb_source_acc_view | accid | text | 2147483647 | √ | null | ||
prb_source_summary_view | accid | text | 2147483647 | √ | null | ||
prb_strain_acc_view | accid | text | 2147483647 | √ | null | ||
prb_strain_summary_view | accid | text | 2147483647 | √ | null | ||
prb_tissue_summary_view | accid | text | 2147483647 | √ | null | ||
seq_allele_assoc_view | accid | text | 2147483647 | √ | null | ||
seq_marker_cache | accid | varchar | 30 | accession id of the Sequence | |||
seq_sequence_acc_view | accid | text | 2147483647 | √ | null | ||
seq_summary_view | accid | text | 2147483647 | √ | null | ||
voc_annot_view | accid | text | 2147483647 | √ | null | ||
voc_go_cache | accid | text | 2147483647 | GO accession id of the Term (GO:xxxxx) | |||
voc_term_acc_view | accid | text | 2147483647 | √ | null | ||
voc_term_mcv_view | accid | text | 2147483647 | √ | null | ||
voc_term_summary_view | accid | text | 2147483647 | √ | null | ||
voc_term_view | accid | text | 2147483647 | √ | null | ||
prb_parent_view | accnumeric | int4 | 10 | √ | null | ||
prb_parent_view | accprefix | text | 2147483647 | √ | null | ||
acc_actualdb | active | int2 | 5 | should the link be constructed? yes (1), no (0) | |||
acc_view | actualdb | text | 2147483647 | √ | null | ||
all_cre_cache | age | text | 2147483647 | √ | null | age of anatomical structure | |
gxd_antibodyantigen_view | age | text | 2147483647 | √ | null | ||
gxd_antigen_view | age | text | 2147483647 | √ | null | ||
gxd_expression | age | text | 2147483647 | age of anatomical structure | |||
gxd_gellane | age | text | 2147483647 | age of animal | |||
gxd_gellane_view | age | text | 2147483647 | √ | null | ||
gxd_htsample | age | text | 2147483647 | √ | null | textual age of the sample | |
gxd_htsample_rnaseqset | age | text | 2147483647 | textual age | |||
gxd_specimen | age | text | 2147483647 | age of embryo or animal | |||
gxd_specimen_view | age | text | 2147483647 | √ | null | ||
prb_source | age | text | 2147483647 | age of source | |||
prb_source_view | age | text | 2147483647 | √ | null | ||
all_cre_cache | agemax | numeric | 131089 | √ | null | maximum age value determined by age field | |
gxd_expression | agemax | numeric | 131089 | √ | null | maximum age value determined by age field | |
gxd_gellane | agemax | numeric | 131089 | √ | null | maximum age range determined by age field; system calculated | |
gxd_gellane_view | agemax | numeric | 131089 | √ | null | ||
gxd_htsample | agemax | numeric | 131089 | √ | null | ||
gxd_specimen | agemax | numeric | 131089 | √ | null | maximum age range determined by age field; system calculated | |
gxd_specimen_view | agemax | numeric | 131089 | √ | null | ||
prb_source | agemax | numeric | 131089 | maximum age range determined by age field; system calculated | |||
prb_source_view | agemax | numeric | 131089 | √ | null | ||
all_cre_cache | agemin | numeric | 131089 | √ | null | minimum age value determined by age field | |
gxd_expression | agemin | numeric | 131089 | √ | null | minimum age value determined by age field | |
gxd_gellane | agemin | numeric | 131089 | √ | null | minimum age range determined by age field; system calculated | |
gxd_gellane_view | agemin | numeric | 131089 | √ | null | ||
gxd_htsample | agemin | numeric | 131089 | √ | null | ||
gxd_specimen | agemin | numeric | 131089 | √ | null | minimum age range determined by age field; system calculated | |
gxd_specimen_view | agemin | numeric | 131089 | √ | null | ||
prb_source | agemin | numeric | 131089 | minimum age range determined by age field; system calculated | |||
prb_source_view | agemin | numeric | 131089 | √ | null | ||
gxd_gellane | agenote | text | 2147483647 | √ | null | age notes | |
gxd_gellane_view | agenote | text | 2147483647 | √ | null | ||
gxd_specimen | agenote | text | 2147483647 | √ | null | age notes | |
gxd_specimen_view | agenote | text | 2147483647 | √ | null | ||
gxd_antibodyalias | alias | text | 2147483647 | alias name | |||
gxd_antibodyalias_view | alias | text | 2147483647 | √ | null | ||
gxd_antibodyaliasref_view | alias | text | 2147483647 | √ | null | ||
mrk_alias_view | alias | text | 2147483647 | √ | null | ||
prb_alias | alias | text | 2147483647 | alias name | |||
mld_expt_marker_view | allele | text | 2147483647 | √ | null | ||
prb_allele | allele | text | 2147483647 | arbitrary symbol assigned to the RFLV pair/fragment size. no correlation to phenotypic allele symbols. | |||
prb_rflv_view | allele | text | 2147483647 | √ | null | ||
gxd_allelepair_view | allele1 | text | 2147483647 | √ | null | ||
gxd_allelepair_view | allele2 | text | 2147483647 | √ | null | ||
crs_cross | allelefromsegparent | int2 | 5 | is the allele from the segregating parent? | |||
crs_cross_view | allelefromsegparent | int2 | 5 | √ | null | ||
mld_matrix_view | allelefromsegparent | int2 | 5 | √ | null | ||
seq_allele_view | alleleid | text | 2147483647 | √ | null | ||
mld_mcdatalist | alleleline | text | 2147483647 | haplotypes for marker; order of alleles must correspond with order of Markers in Experiment Marker list (MLD_Expt_Marker) | |||
mld_ridata | alleleline | text | 2147483647 | haplotypes for marker; must correspond with listing of animals typed (MLD_RI.RI_IDList) | |||
mld_ridata_view | alleleline | text | 2147483647 | √ | null | ||
gxd_allelepair_view | allelestate | text | 2147483647 | √ | null | ||
prb_strain_marker_view | allelesymbol | text | 2147483647 | √ | null | ||
all_cre_cache | alleletype | text | 2147483647 | allele type name (VOC_Term.term) via ALL_Allele._AlleleType_key = VOC_Term._Term_key | |||
mgi_refassoctype | allowonlyone | int2 | 5 | does this reference type allow only one association? | |||
mgi_reference_allele_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_reference_allelevariant_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_reference_antibody_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_reference_marker_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_reference_sequence_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_reference_strain_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_reftype_allele_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_reftype_antibody_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_reftype_marker_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_reftype_sequence_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_reftype_strain_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_synonym_allele_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_synonym_goterm_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_synonym_musmarker_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_synonym_strain_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_synonymtype | allowonlyone | int2 | 5 | if 1, then there can be at most one Synonym of this type for a given object | |||
mgi_synonymtype_allele_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_synonymtype_goterm_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_synonymtype_musmarker_view | allowonlyone | int2 | 5 | √ | null | ||
mgi_synonymtype_strain_view | allowonlyone | int2 | 5 | √ | null | ||
acc_actualdb | allowsmultiple | int2 | 5 | does the URL support a query using more than one accession number? yes (1), no (0) | |||
acc_view | allowsmultiple | int2 | 5 | √ | null | ||
seq_marker_cache | annotation_date | timestamp | 29,6 | now() | date of the annotation | ||
seq_probe_cache | annotation_date | timestamp | 29,6 | now() | date of the annotation | ||
voc_annot_count_cache | annotcount | int4 | 10 | count of annotations of the given annotType to the given _Term_key | |||
voc_allele_cache | annottype | text | 2147483647 | see table description for details | |||
voc_annot_count_cache | annottype | text | 2147483647 | the type of annotation we are considering in this record | |||
voc_annot_view | annottype | text | 2147483647 | √ | null | ||
voc_marker_cache | annottype | text | 2147483647 | see table description for details | |||
gxd_antibody | antibodyname | text | 2147483647 | name of Antibody | |||
gxd_antibody_view | antibodyname | text | 2147483647 | √ | null | ||
gxd_antibodyalias_view | antibodyname | text | 2147483647 | √ | null | ||
gxd_antibodyaliasref_view | antibodyname | text | 2147483647 | √ | null | ||
gxd_antibodyantigen_view | antibodyname | text | 2147483647 | √ | null | ||
gxd_antibodymarker_view | antibodyname | text | 2147483647 | √ | null | ||
gxd_antibodyprep_view | antibodyname | text | 2147483647 | √ | null | ||
gxd_antibody | antibodynote | text | 2147483647 | √ | null | note | |
gxd_antibody_view | antibodynote | text | 2147483647 | √ | null | ||
gxd_antibody_view | antibodyspecies | text | 2147483647 | √ | null | ||
gxd_antibody_view | antibodytype | text | 2147483647 | √ | null | ||
gxd_antibodytype | antibodytype | text | 2147483647 | antibody type description | |||
gxd_antibody_view | antigenname | text | 2147483647 | √ | null | ||
gxd_antibodyantigen_view | antigenname | text | 2147483647 | √ | null | ||
gxd_antigen | antigenname | text | 2147483647 | antigen name | |||
gxd_antigen_view | antigenname | text | 2147483647 | √ | null | ||
gxd_antibody_view | antigennote | text | 2147483647 | √ | null | ||
gxd_antibodyantigen_view | antigennote | text | 2147483647 | √ | null | ||
gxd_antigen | antigennote | text | 2147483647 | √ | null | textual information | |
gxd_antigen_view | antigennote | text | 2147483647 | √ | null | ||
bib_status_view | ap_status | text | 2147483647 | √ | null | ||
all_allele | 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_assaynote | assaynote | text | 2147483647 | note | |||
gxd_assay_view | assaytype | text | 2147483647 | √ | null | ||
gxd_assaytype | assaytype | text | 2147483647 | assay type description | |||
mgi_refassoctype | assoctype | text | 2147483647 | name of this reference association type (ex. "General"). | |||
mgi_reference_allele_view | assoctype | text | 2147483647 | √ | null | ||
mgi_reference_allelevariant_view | assoctype | text | 2147483647 | √ | null | ||
mgi_reference_antibody_view | assoctype | text | 2147483647 | √ | null | ||
mgi_reference_marker_view | assoctype | text | 2147483647 | √ | null | ||
mgi_reference_sequence_view | assoctype | text | 2147483647 | √ | null | ||
mgi_reference_strain_view | assoctype | text | 2147483647 | √ | null | ||
mgi_reftype_allele_view | assoctype | text | 2147483647 | √ | null | ||
mgi_reftype_antibody_view | assoctype | text | 2147483647 | √ | null | ||
mgi_reftype_marker_view | assoctype | text | 2147483647 | √ | null | ||
mgi_reftype_sequence_view | assoctype | text | 2147483647 | √ | null | ||
mgi_reftype_strain_view | assoctype | text | 2147483647 | √ | null | ||
bib_all2_view | authors | text | 2147483647 | √ | null | ||
bib_all_view | authors | text | 2147483647 | √ | null | ||
bib_refs | authors | text | 2147483647 | √ | null | reference authors | |
bib_view | authors | text | 2147483647 | √ | null | ||
mld_concordance_view | authors | text | 2147483647 | √ | null | ||
mld_expt_marker_view | authors | text | 2147483647 | √ | null | ||
mld_expt_view | authors | text | 2147483647 | √ | null | ||
mld_fish_view | authors | text | 2147483647 | √ | null | ||
mld_hybrid_view | authors | text | 2147483647 | √ | null | ||
mld_insitu_view | authors | text | 2147483647 | √ | null | ||
mld_matrix_view | authors | text | 2147483647 | √ | null | ||
mld_mc2point_view | authors | text | 2147483647 | √ | null | ||
mld_ri2point_view | authors | text | 2147483647 | √ | null | ||
mld_ri_view | authors | text | 2147483647 | √ | null | ||
mld_ridata_view | authors | text | 2147483647 | √ | null | ||
mld_statistics_view | authors | text | 2147483647 | √ | null | ||
pwi_bib_refs_view | authors | text | 2147483647 | √ | null | ||
gxd_htsample_rnaseqcombined | averagequantilenormalizedtpm | numeric | 131089 | the average quantile normlized TPM | |||
gxd_htsample_rnaseq | averagetpm | numeric | 131089 | the average TPM of the sample | |||
mgi_translation | badname | text | 2147483647 | bad name to translate | |||
mgi_translation_view | badname | text | 2147483647 | √ | null | ||
mgi_translationstrain_view | badname | text | 2147483647 | √ | null | ||
mld_fish | band | text | 2147483647 | √ | null | cytogenetic position on chromosome to which marker is assigned | |
mld_fish_view | band | text | 2147483647 | √ | null | ||
mld_hybrid | band | text | 2147483647 | √ | null | region on chromosome to which marker is assigned according to experimental results | |
mld_hybrid_view | band | text | 2147483647 | √ | null | ||
mld_insitu | band | text | 2147483647 | √ | null | cytogenetic position on chromosome to which marker is assigned | |
mld_insitu_view | band | text | 2147483647 | √ | null | ||
gxd_gelband | bandnote | text | 2147483647 | √ | null | textual information | |
gxd_gelband_view | bandnote | text | 2147483647 | √ | null | ||
bib_books | book_au | text | 2147483647 | √ | null | author | |
bib_books | book_title | text | 2147483647 | √ | null | title | |
mgi_relationship_markertss_view | categoryterm | text | 2147483647 | √ | null | ||
all_allele_cellline_view | cellline | text | 2147483647 | √ | null | ||
all_cellline | cellline | text | 2147483647 | ES cell line | |||
all_cellline_view | cellline | text | 2147483647 | √ | null | ||
prb_source_view | cellline | text | 2147483647 | √ | null | ||
all_allele_cellline_view | celllinestrain | text | 2147483647 | √ | null | ||
all_cellline_view | celllinestrain | text | 2147483647 | √ | null | ||
all_allele_cellline_view | celllinestrain_key | int4 | 10 | √ | null | ||
all_cellline_view | celllinetype | text | 2147483647 | √ | null | ||
mld_fish | cellorigin | text | 2147483647 | √ | null | cell type from which analyzed metaphase spreads were derived | |
mld_fish_view | cellorigin | text | 2147483647 | √ | null | ||
mld_insitu | cellorigin | text | 2147483647 | √ | null | cell type from which analyzed metaphase spreads were derived | |
mld_insitu_view | cellorigin | text | 2147483647 | √ | null | ||
crs_matrix | chromosome | text | 2147483647 | chromosome on which Marker is located (may disagree with MGD) | |||
gxd_allelepair_view | chromosome | text | 2147483647 | √ | null | ||
gxd_antibodymarker_view | chromosome | text | 2147483647 | √ | null | ||
gxd_assay_view | chromosome | text | 2147483647 | √ | null | ||
mld_concordance | chromosome | text | 2147483647 | √ | null | chromosome value; is NULL if _Marker_key is not NULL | |
mld_concordance_view | chromosome | text | 2147483647 | √ | null | ||
mld_expt_marker_view | chromosome | text | 2147483647 | √ | null | ||
mld_expt_view | chromosome | text | 2147483647 | √ | null | ||
mld_expts | chromosome | text | 2147483647 | chromosome value | |||
mrk_anchors | chromosome | text | 2147483647 | marker chromosome | |||
mrk_anchors_view | chromosome | text | 2147483647 | √ | null | ||
mrk_chromosome | chromosome | text | 2147483647 | chromosome value | |||
mrk_current_view | chromosome | text | 2147483647 | √ | null | ||
mrk_location_cache | chromosome | text | 2147483647 | chromosome | |||
mrk_marker | chromosome | text | 2147483647 | chromosome | |||
mrk_marker_view | chromosome | text | 2147483647 | √ | null | ||
mrk_mouse_view | chromosome | text | 2147483647 | √ | null | ||
mrk_nonmouse_view | chromosome | text | 2147483647 | √ | null | ||
prb_marker_view | chromosome | text | 2147483647 | √ | null | ||
prb_rflv_view | chromosome | text | 2147483647 | √ | null | ||
prb_strain_marker_view | chromosome | text | 2147483647 | √ | null | ||
pwi_mrk_marker_view | chromosome | text | 2147483647 | √ | null | ||
seq_coord_cache | chromosome | text | 2147483647 | chromosome on which the sequence resides | |||
mld_hybrid | chrsorgenes | int2 | 5 | does MLD_Concordance table contain Chromosome (0) or Marker (1) values? | |||
mld_hybrid_view | chrsorgenes | int2 | 5 | √ | null | ||
all_allele_view | citation | text | 2147483647 | √ | null | ||
bib_all2_view | citation | text | 2147483647 | √ | null | ||
bib_all_view | citation | text | 2147483647 | √ | null | ||
bib_citation_cache | citation | text | 2147483647 | long citation format | |||
bib_view | citation | text | 2147483647 | √ | null | ||
gxd_antibody_view | class | text | 2147483647 | √ | null | ||
gxd_antibodyclass | class | text | 2147483647 | class description | |||
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 | cnn | int4 | 10 | -/-; number of Hybrid cells where neither the Concordance Marker/Chromosome nor the linkage Marker is present | |||
mld_concordance_view | cnn | int4 | 10 | √ | null | ||
mld_concordance | cnp | int4 | 10 | -/+; number of Hybrid cells where the Concordance Marker/Chromosome is not present, but the linkage Marker is present | |||
mld_concordance_view | cnp | int4 | 10 | √ | null | ||
all_allele_view | collection | text | 2147483647 | √ | null | ||
crs_typings | colnumber | int4 | 10 | column number | |||
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 | commonname | text | 2147483647 | common name of organism | |||
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 | cpn | int4 | 10 | +/-; number of Hybrid cells where the Concordance Marker/Chromosome is present, but the linkage Marker is not present | |||
mld_concordance_view | cpn | int4 | 10 | √ | null | ||
mld_concordance | cpp | int4 | 10 | +/+; number of Hybrid cells where both the Concordance Marker/Chromosome and the linkage Marker are present | |||
mld_concordance_view | cpp | int4 | 10 | √ | null | ||
pwi_report | created | timestamp | 29,6 | now() | None | ||
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_accession | creation_date | timestamp | 29,6 | now() | date record was created | ||
acc_accessionmax | creation_date | timestamp | 29,6 | now() | date record was created | ||
acc_accessionreference | creation_date | timestamp | 29,6 | now() | date record was created | ||
acc_actualdb | creation_date | timestamp | 29,6 | now() | date record was created | ||
acc_logicaldb | creation_date | timestamp | 29,6 | now() | date record was created | ||
acc_logicaldb_view | creation_date | timestamp | 29,6 | √ | null | ||
acc_mgitype | creation_date | timestamp | 29,6 | now() | date record was created | ||
acc_view | creation_date | timestamp | 29,6 | √ | null | ||
all_acc_view | creation_date | timestamp | 29,6 | √ | null | ||
all_allele | creation_date | timestamp | 29,6 | now() | date record was created | ||
all_allele_cellline | creation_date | timestamp | 29,6 | now() | date record was created | ||
all_allele_cellline_view | creation_date | timestamp | 29,6 | √ | null | ||
all_allele_mutation | creation_date | timestamp | 29,6 | now() | date record was created | ||
all_allele_mutation_view | creation_date | timestamp | 29,6 | √ | null | ||
all_allele_subtype_view | creation_date | timestamp | 29,6 | √ | null | ||
all_allele_view | creation_date | timestamp | 29,6 | √ | null | ||
all_cellline | creation_date | timestamp | 29,6 | now() | date record was created | ||
all_cellline_acc_view | creation_date | timestamp | 29,6 | √ | null | ||
all_cellline_derivation | creation_date | timestamp | 29,6 | now() | date record was created | ||
all_cellline_derivation_view | creation_date | timestamp | 29,6 | √ | null | ||
all_cellline_view | creation_date | timestamp | 29,6 | √ | null | ||
all_cre_cache | creation_date | timestamp | 29,6 | now() | date record was created | ||
all_derivation_summary_view | creation_date | timestamp | 29,6 | √ | null | ||
all_knockout_cache | creation_date | timestamp | 29,6 | now() | date record was created | ||
all_label | creation_date | timestamp | 29,6 | now() | date record was created | ||
all_summary_view | creation_date | timestamp | 29,6 | √ | null | ||
all_variant | creation_date | timestamp | 29,6 | now() | date record was created | ||
all_variant_sequence | creation_date | timestamp | 29,6 | now() | date record was created | ||
bib_acc_view | creation_date | timestamp | 29,6 | √ | null | ||
bib_all2_view | creation_date | timestamp | 29,6 | √ | null | ||
bib_all_view | creation_date | timestamp | 29,6 | √ | null | ||
bib_books | creation_date | timestamp | 29,6 | now() | date record was created | ||
bib_goxref_view | creation_date | timestamp | 29,6 | √ | null | ||
bib_notes | creation_date | timestamp | 29,6 | now() | date record was created | ||
bib_refs | creation_date | timestamp | 29,6 | now() | date record was created | ||
bib_summary_all_view | creation_date | timestamp | 29,6 | √ | null | ||
bib_view | creation_date | timestamp | 29,6 | √ | null | ||
bib_workflow_data | creation_date | timestamp | 29,6 | now() | date record was created | ||
bib_workflow_status | creation_date | timestamp | 29,6 | now() | date record was created | ||
bib_workflow_tag | creation_date | timestamp | 29,6 | now() | date record was created | ||
crs_cross | creation_date | timestamp | 29,6 | now() | date record was created | ||
crs_cross_view | creation_date | timestamp | 29,6 | √ | null | ||
crs_matrix | creation_date | timestamp | 29,6 | now() | date record was created | ||
crs_progeny | creation_date | timestamp | 29,6 | now() | date record was created | ||
crs_references | creation_date | timestamp | 29,6 | now() | date record was created | ||
crs_typings | creation_date | timestamp | 29,6 | now() | date record was created | ||
dag_closure | creation_date | timestamp | 29,6 | now() | date record was created | ||
dag_dag | creation_date | timestamp | 29,6 | now() | date record was created | ||
dag_edge | creation_date | timestamp | 29,6 | now() | date record was created | ||
dag_label | creation_date | timestamp | 29,6 | now() | date record was created | ||
dag_node | creation_date | timestamp | 29,6 | now() | date record was created | ||
dag_node_view | creation_date | timestamp | 29,6 | √ | null | ||
go_tracking | creation_date | timestamp | 29,6 | now() | date record was created | ||
go_tracking_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_allelegenotype | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_allelepair | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_allelepair_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_antibody | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_antibody_acc_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_antibody_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_antibodyalias | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_antibodyalias_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_antibodyaliasref_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_antibodyantigen_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_antibodyclass | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_antibodymarker | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_antibodyprep | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_antibodyprep_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_antibodytype | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_antigen | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_antigen_acc_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_antigen_summary_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_antigen_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_assay | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_assay_acc_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_assay_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_assaynote | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_assaytype | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_embeddingmethod | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_expression | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_fixationmethod | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_gelband | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_gelband_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_gelcontrol | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_gellane | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_gellane_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_gellanestructure | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_gellanestructure_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_gelrnatype | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_gelrow | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_gelrow_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_gelunits | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_genotype | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_genotype_acc_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_genotype_summary_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_genotype_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_htexperiment | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_htsample | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_htsample_rnaseq | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_htsample_rnaseqcombined | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_htsample_rnaseqset | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_htsample_rnaseqsetmember | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_index | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_index_stages | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_index_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_insituresult | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_insituresult_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_insituresultimage | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_isresultimage_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_isresultstructure | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_isresultstructure_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_label | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_pattern | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_probeprep | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_probeprep_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_probesense | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_secondary | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_specimen | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_specimen_view | creation_date | timestamp | 29,6 | √ | null | ||
gxd_strength | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_theilerstage | creation_date | timestamp | 29,6 | now() | date record was created | ||
gxd_visualizationmethod | creation_date | timestamp | 29,6 | now() | date record was created | ||
img_image | creation_date | timestamp | 29,6 | now() | date record was created | ||
img_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 | creation_date | timestamp | 29,6 | now() | date record was created | ||
img_imagepane_assoc | creation_date | timestamp | 29,6 | now() | date record was created | ||
img_imagepane_assoc_view | creation_date | timestamp | 29,6 | √ | null | ||
map_coord_collection | creation_date | timestamp | 29,6 | now() | date record was created | ||
map_coord_feature | creation_date | timestamp | 29,6 | now() | date record was created | ||
map_coordinate | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_dbinfo | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_note | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_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_notechunk | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_notetype | creation_date | timestamp | 29,6 | now() | date record was created | ||
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 | creation_date | timestamp | 29,6 | now() | date record was created | ||
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 | creation_date | timestamp | 29,6 | now() | date record was created | ||
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_property | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_propertytype | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_refassoctype | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_reference_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_assoc | creation_date | timestamp | 29,6 | now() | date record was created | ||
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 | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_relationship_category | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_relationship_markertss_view | creation_date | timestamp | 29,6 | √ | null | ||
mgi_relationship_property | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_roletask | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_roletask_view | creation_date | timestamp | 29,6 | √ | null | ||
mgi_set | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_setmember | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_setmember_emapa | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_synonym | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_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 | creation_date | timestamp | 29,6 | now() | date record was created | ||
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 | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_translation_view | creation_date | timestamp | 29,6 | √ | null | ||
mgi_translationstrain_view | creation_date | timestamp | 29,6 | √ | null | ||
mgi_translationtype | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_user | creation_date | timestamp | 29,6 | now() | date record was created | ||
mgi_user_active_view | creation_date | timestamp | 29,6 | √ | null | ||
mgi_userrole | creation_date | timestamp | 29,6 | now() | date record was created | ||
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_assay_types | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_concordance | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_concordance_view | creation_date | timestamp | 29,6 | √ | null | ||
mld_contig | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_contigprobe | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_expt_marker | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_expt_marker_view | creation_date | timestamp | 29,6 | √ | null | ||
mld_expt_notes | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_expt_view | creation_date | timestamp | 29,6 | √ | null | ||
mld_expts | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_fish | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_fish_region | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_fish_view | creation_date | timestamp | 29,6 | √ | null | ||
mld_hit | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_hybrid | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_hybrid_view | creation_date | timestamp | 29,6 | √ | null | ||
mld_insitu | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_insitu_view | creation_date | timestamp | 29,6 | √ | null | ||
mld_isregion | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_matrix | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_matrix_view | creation_date | timestamp | 29,6 | √ | null | ||
mld_mc2point | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_mc2point_view | creation_date | timestamp | 29,6 | √ | null | ||
mld_mcdatalist | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_notes | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_ri | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_ri2point | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_ri2point_view | creation_date | timestamp | 29,6 | √ | null | ||
mld_ridata | creation_date | timestamp | 29,6 | now() | date record was created | ||
mld_ridata_view | creation_date | timestamp | 29,6 | √ | null | ||
mld_statistics | creation_date | timestamp | 29,6 | now() | date record was created | ||
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 | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_alias_view | creation_date | timestamp | 29,6 | √ | null | ||
mrk_anchors | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_anchors_view | creation_date | timestamp | 29,6 | √ | null | ||
mrk_biotypemapping | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_chromosome | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_cluster | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_current | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_current_view | creation_date | timestamp | 29,6 | √ | null | ||
mrk_do_cache | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_event | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_eventreason | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_history | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_history_view | creation_date | timestamp | 29,6 | √ | null | ||
mrk_label | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_location_cache | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_marker | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_marker_view | creation_date | timestamp | 29,6 | √ | null | ||
mrk_mcv_cache | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_mcv_count_cache | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_mouse_view | creation_date | timestamp | 29,6 | √ | null | ||
mrk_nonmouse_view | creation_date | timestamp | 29,6 | √ | null | ||
mrk_notes | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_reference | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_reference_view | creation_date | timestamp | 29,6 | √ | null | ||
mrk_status | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_strainmarker | creation_date | timestamp | 29,6 | now() | date record was created | ||
mrk_summary_view | creation_date | timestamp | 29,6 | √ | null | ||
mrk_types | creation_date | timestamp | 29,6 | now() | date record was created | ||
prb_acc_view | creation_date | timestamp | 29,6 | √ | null | ||
prb_accnoref_view | creation_date | timestamp | 29,6 | √ |