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	√