pub.mgd contains 4327 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
crs_cross	femaleallele1	bpchar	1	√		null	first allele of maternal strain; used during construction of maternal genotype
crs_cross_view	femaleallele1	bpchar	1	√		null
mld_matrix_view	femaleallele1	bpchar	1	√		null
crs_cross	femaleallele2	bpchar	1	√		null	second allele of maternal strain; used during construction of maternal genotype
crs_cross_view	femaleallele2	bpchar	1	√		null
mld_matrix_view	femaleallele2	bpchar	1	√		null
crs_cross	maleallele1	bpchar	1	√		null	first allele of paternal strain; used during construction of paternal genotype
crs_cross_view	maleallele1	bpchar	1	√		null
mld_matrix_view	maleallele1	bpchar	1	√		null
crs_cross	maleallele2	bpchar	1	√		null	second allele of paternal strain; used during construction of paternal genotype
crs_cross_view	maleallele2	bpchar	1	√		null
mld_matrix_view	maleallele2	bpchar	1	√		null
mrk_mcv_cache	qualifier	bpchar	1				'D' = direct, 'I' = infered
prb_marker	relationship	bpchar	1	√		null	relationship of Probe and Marker (H,E,A,M,P)
prb_marker_view	relationship	bpchar	1	√		null
crs_progeny	sex	bpchar	1				sex of progeny (M, F)
map_coord_feature	strand	bpchar	1	√		null	if '+', the object is on the positive strand, else negative strand
mrk_location_cache	strand	bpchar	1	√		null	strand for genome coordinate
seq_coord_cache	strand	bpchar	1				3' or 5' strand
seq_sequence	division	bpchar	3	√		null	GenBank division
seq_sequence_view	division	bpchar	3	√		null
bib_citation_cache	isreviewarticlestring	bpchar	3				string representation of isReviewArticle
mgi_reference_allele_view	isreviewarticlestring	bpchar	3	√		null
mgi_reference_allelevariant_view	isreviewarticlestring	bpchar	3	√		null
mgi_reference_antibody_view	isreviewarticlestring	bpchar	3	√		null
mgi_reference_marker_view	isreviewarticlestring	bpchar	3	√		null
mgi_reference_sequence_view	isreviewarticlestring	bpchar	3	√		null
mgi_reference_strain_view	isreviewarticlestring	bpchar	3	√		null
dag_dag	abbreviation	bpchar	5				abbreviated name
dag_node_view	dagabbrev	bpchar	5	√		null
voc_go_cache	dagabbrev	bpchar	5				DAG abbreviation name ('C', 'F', 'O', 'P')
voc_vocabdag_view	dagabbrev	bpchar	5	√		null
acc_actualdb	delimiter	bpchar	8	√		null	the delimiter which separates multiple accession numbers; used when construcuting the full URL.
acc_view	delimiter	bpchar	8	√		null
mrk_history_view	event_display	bpchar	10	√		null
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
mrk_location_cache	endcoordinate	float8	17,17	√		null	end genome coordinate
mrk_location_cache	startcoordinate	float8	17,17	√		null	start genome coordinate
acc_actualdb	active	int2	5				should the link be constructed? yes (1), no (0)
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
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
mld_hybrid	chrsorgenes	int2	5				does MLD_Concordance table contain Chromosome (0) or Marker (1) values?
mld_hybrid_view	chrsorgenes	int2	5	√		null
crs_cross	displayed	int2	5				does this cross get displayed in the Cross Lookup list? yes (1), no (0)
crs_cross_view	displayed	int2	5	√		null
mld_matrix_view	displayed	int2	5	√		null
gxd_expression	expressed	int2	5				is Marker expressed in Structure? yes (1), no (0)
crs_cross	f1directionknown	int2	5				is the F1 direction known?
crs_cross_view	f1directionknown	int2	5	√		null
mld_matrix_view	f1directionknown	int2	5	√		null
prb_strain	geneticbackground	int2	5				genetic background/strain prefix
prb_strain_view	geneticbackground	int2	5	√		null
gxd_expression	hasimage	int2	5				if 1 (true), the this Assay contains an Image
bib_workflow_data	haspdf	int2	5			0	does Reference have a PDF?
prb_reference	hasrmap	int2	5				does reference have restriction map information? yes (1), no (0)
prb_reference_view	hasrmap	int2	5	√		null
prb_reference	hassequence	int2	5				is sequence information presented in reference? yes (1), no (0)
prb_reference_view	hassequence	int2	5	√		null
gxd_genotype	isconditional	int2	5				is this a conditional genotype?
gxd_genotype_view	isconditional	int2	5	√		null
prb_source	iscuratoredited	int2	5				has any attribute of this record been modified by a curator?
prb_source_view	iscuratoredited	int2	5	√		null
bib_workflow_status	iscurrent	int2	5			1	if 1, then current Status for this Reference/Group
bib_all2_view	isdiscard	int2	5	√		null
bib_all_view	isdiscard	int2	5	√		null
bib_citation_cache	isdiscard	int2	5
bib_refs	isdiscard	int2	5				is this a discarded reference?
bib_view	isdiscard	int2	5	√		null
pwi_bib_refs_view	isdiscard	int2	5	√		null
all_allele	isextinct	int2	5				if 1 (yes), then the Allele is extinct, else 0
all_allele_view	isextinct	int2	5	√		null
pwi_all_allele_view	isextinct	int2	5	√		null
gxd_expression	isforgxd	int2	5				if 1 (true), then this Assay will appear in GXD counts and queries (in front-end)
gxd_assay_view	isgelassay	int2	5	√		null
gxd_assaytype	isgelassay	int2	5				is assay type a gel assay? yes (1), no (0)
all_allele	ismixed	int2	5				if 1 (yes), then the Allele is mixed (from both male and female mice), else 0
all_allele_view	ismixed	int2	5	√		null
pwi_all_allele_view	ismixed	int2	5	√		null
all_allele_cellline_view	ismutant	int2	5	√		null
all_cellline	ismutant	int2	5				if 1, then this ES Cell line is a Mutant, else Parental
all_cellline_view	ismutant	int2	5	√		null
voc_annotheader	isnormal	int2	5				If all of the qualifiers for a given header term = 'norm' (see VOC_Annot._Qualifier_key) then isNormal = 1 (true), else 0 (false)
voc_annotheader_view	isnormal	int2	5	√		null
voc_term	isobsolete	int2	5	√		null	if 1, the term is obsolete and cannot be used in future annotations
voc_term_cellline_view	isobsolete	int2	5	√		null
voc_term_mcv_view	isobsolete	int2	5	√		null
voc_term_repqualifier_view	isobsolete	int2	5	√		null
voc_term_strainallele_view	isobsolete	int2	5	√		null
voc_term_strainspecies_view	isobsolete	int2	5	√		null
voc_term_view	isobsolete	int2	5	√		null
img_imagepane_assoc	isprimary	int2	5				if = 1, then the association is primary, else secondary
img_imagepane_assoc_view	isprimary	int2	5	√		null
voc_vocab	isprivate	int2	5	√		null	if 1, then the Accession IDs of the Vocabulary Terms are private, else they are public
voc_vocab_view	isprivate	int2	5	√		null
gxd_expression	isrecombinase	int2	5				if 1 (true), then this Assay has a Recombinase Reporter Gene (VOC_Term._Vocab_key = 14)
go_tracking	isreferencegene	int2	5				if 1, then the gene is a reference gene, else 0.
go_tracking_view	isreferencegene	int2	5	√		null
bib_all2_view	isreviewarticle	int2	5	√		null
bib_all_view	isreviewarticle	int2	5	√		null
bib_citation_cache	isreviewarticle	int2	5				is this a review article?
bib_refs	isreviewarticle	int2	5				is this a review article?
bib_view	isreviewarticle	int2	5	√		null
mgi_reference_allele_view	isreviewarticle	int2	5	√		null
mgi_reference_allelevariant_view	isreviewarticle	int2	5	√		null
mgi_reference_antibody_view	isreviewarticle	int2	5	√		null
mgi_reference_marker_view	isreviewarticle	int2	5	√		null
mgi_reference_sequence_view	isreviewarticle	int2	5	√		null
mgi_reference_strain_view	isreviewarticle	int2	5	√		null
mrk_reference_view	isreviewarticle	int2	5	√		null
pwi_bib_refs_view	isreviewarticle	int2	5	√		null
all_variant	isreviewed	int2	5				has this variant been reviewed by a curator (1) or not (0)?
gxd_assay_view	isrnaassay	int2	5	√		null
gxd_assaytype	isrnaassay	int2	5				does assay type detect RNA? yes (1), no (0)
voc_vocab	issimple	int2	5	√		null	if 1, the Vocabulary is a simple vocabulary (no DAG), else the Vocabulary is structured (has 1 or more DAGS)
voc_vocab_view	issimple	int2	5	√		null
all_allele	iswildtype	int2	5				if 1, Allele is a wild type allele, else 0
all_allele_view	iswildtype	int2	5	√		null
pwi_all_allele_view	iswildtype	int2	5	√		null
mld_expt_marker	matrixdata	int2	5				is Marker typed in haplotype data? yes (1), no (0) (MLD_MCDataList)
mld_expt_marker_view	matrixdata	int2	5	√		null
acc_accession	preferred	int2	5				flags accession number as preferred/primary (1) or not preferred/secondary (0). there can only be one preferred accession number for logical database MGI. The default is 1.
acc_view	preferred	int2	5	√		null
all_acc_view	preferred	int2	5	√		null
all_cellline_acc_view	preferred	int2	5	√		null
all_derivation_summary_view	preferred	int2	5	√		null
all_summary_view	preferred	int2	5	√		null
bib_acc_view	preferred	int2	5	√		null
bib_summary_all_view	preferred	int2	5	√		null
gxd_antibody_acc_view	preferred	int2	5	√		null
gxd_antigen_acc_view	preferred	int2	5	√		null
gxd_antigen_summary_view	preferred	int2	5	√		null
gxd_assay_acc_view	preferred	int2	5	√		null
gxd_genotype_acc_view	preferred	int2	5	√		null
gxd_genotype_summary_view	preferred	int2	5	√		null
img_image_acc_view	preferred	int2	5	√		null
img_image_summary_view	preferred	int2	5	√		null
mgi_organism_acc_view	preferred	int2	5	√		null
mgi_organism_summary_view	preferred	int2	5	√		null
mld_acc_view	preferred	int2	5	√		null
mld_summary_view	preferred	int2	5	√		null
mrk_acc_view	preferred	int2	5	√		null
mrk_accnoref_view	preferred	int2	5	√		null
mrk_accref1_view	preferred	int2	5	√		null
mrk_accref2_view	preferred	int2	5	√		null
mrk_accref_view	preferred	int2	5	√		null
mrk_summary_view	preferred	int2	5	√		null
prb_acc_view	preferred	int2	5	√		null
prb_accnoref_view	preferred	int2	5	√		null
prb_accref_view	preferred	int2	5	√		null
prb_accrefnoseq_view	preferred	int2	5	√		null
prb_source_acc_view	preferred	int2	5	√		null
prb_source_summary_view	preferred	int2	5	√		null
prb_strain_acc_view	preferred	int2	5	√		null
prb_strain_summary_view	preferred	int2	5	√		null
prb_tissue_summary_view	preferred	int2	5	√		null
seq_allele_assoc_view	preferred	int2	5	√		null
seq_sequence_acc_view	preferred	int2	5	√		null
seq_summary_view	preferred	int2	5	√		null
voc_term_acc_view	preferred	int2	5	√		null
voc_term_summary_view	preferred	int2	5	√		null
acc_accession	private	int2	5				is this accession number private? yes (1), no (0)
acc_view	private	int2	5	√		null
all_acc_view	private	int2	5	√		null
all_cellline_acc_view	private	int2	5	√		null
all_derivation_summary_view	private	int2	5	√		null
all_summary_view	private	int2	5	√		null
bib_acc_view	private	int2	5	√		null
bib_summary_all_view	private	int2	5	√		null
gxd_antibody_acc_view	private	int2	5	√		null
gxd_antigen_acc_view	private	int2	5	√		null
gxd_antigen_summary_view	private	int2	5	√		null
gxd_assay_acc_view	private	int2	5	√		null
gxd_genotype_acc_view	private	int2	5	√		null
gxd_genotype_summary_view	private	int2	5	√		null
img_image_acc_view	private	int2	5	√		null
img_image_summary_view	private	int2	5	√		null
mgi_notetype	private	int2	5				are notes of this type private?
mgi_notetype_alldriver_view	private	int2	5	√		null
mgi_notetype_allele_view	private	int2	5	√		null
mgi_notetype_derivation_view	private	int2	5	√		null
mgi_notetype_genotype_view	private	int2	5	√		null
mgi_notetype_image_view	private	int2	5	√		null
mgi_notetype_marker_view	private	int2	5	√		null
mgi_notetype_mrkgo_view	private	int2	5	√		null
mgi_notetype_probe_view	private	int2	5	√		null
mgi_notetype_sequence_view	private	int2	5	√		null
mgi_notetype_source_view	private	int2	5	√		null
mgi_notetype_strain_view	private	int2	5	√		null
mgi_notetype_vocevidence_view	private	int2	5	√		null
mgi_organism_acc_view	private	int2	5	√		null
mgi_organism_summary_view	private	int2	5	√		null
mld_acc_view	private	int2	5	√		null
mld_summary_view	private	int2	5	√		null
mrk_acc_view	private	int2	5	√		null
mrk_accnoref_view	private	int2	5	√		null
mrk_accref1_view	private	int2	5	√		null
mrk_accref2_view	private	int2	5	√		null
mrk_accref_view	private	int2	5	√		null
mrk_summary_view	private	int2	5	√		null
prb_acc_view	private	int2	5	√		null
prb_accnoref_view	private	int2	5	√		null
prb_accref_view	private	int2	5	√		null
prb_accrefnoseq_view	private	int2	5	√		null
prb_source_acc_view	private	int2	5	√		null
prb_source_summary_view	private	int2	5	√		null
prb_strain	private	int2	5				if 1, then the Strain record is private (deleted from public copies of the database)
prb_strain_acc_view	private	int2	5	√		null
prb_strain_summary_view	private	int2	5	√		null
prb_strain_view	private	int2	5	√		null
prb_tissue_summary_view	private	int2	5	√		null
seq_sequence_acc_view	private	int2	5	√		null
seq_summary_view	private	int2	5	√		null
voc_term_acc_view	private	int2	5	√		null
voc_term_summary_view	private	int2	5	√		null
mgi_translationstrain_view	regularexpression	int2	5	√		null
mgi_translationtype	regularexpression	int2	5				if true (1), then apply a regular expression algorithm to the lookup of the translation target.
prb_source_view	sstandard	int2	5	√		null
prb_strain	standard	int2	5				if 1, then the strain is official.
prb_strain_view	standard	int2	5	√		null
prb_tissue	standard	int2	5				is the tissue a standard, official tissue? yes (1), no (0)
prb_source_view	tstandard	int2	5	√		null
seq_sequence	virtual	int2	5				is this sequence virtual (consensus)?
seq_sequence_view	virtual	int2	5	√		null
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
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
prb_parent_view	accnumeric	int4	10	√		null
voc_annot_count_cache	annotcount	int4	10				count of annotations of the given annotType to the given _Term_key
all_allele_cellline_view	celllinestrain_key	int4	10	√		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
crs_typings	colnumber	int4	10				column number
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
all_allele_cellline_view	derivationkey	int4	10	√		null
prb_probe	derivedfrom	int4	10	√		null	foreign key to PRB_Probe; parent
prb_probe_view	derivedfrom	int4	10	√		null
voc_term_emapa	endstage	int4	10				End Theiler Stage
voc_evidence_view	evidenceseqnum	int4	10	√		null
seq_genemodel	exoncount	int4	10	√		null	currently not being used
all_cre_cache	expressed	int4	10	√		null	if 1 (true), then this Assay is expressing this Structure, else 0
seq_genetrap	goodhitcount	int4	10	√		null	Number of good blat hits
mld_isregion	graincount	int4	10				# of grains observed over the region
mld_insitu	grainsonchrom	int4	10	√		null	# of grains hybridizing to correct chromosomal location
mld_insitu_view	grainsonchrom	int4	10	√		null
mld_insitu	grainsotherchrom	int4	10	√		null	# of grains hybridizing to other chromosomal locations
mld_insitu_view	grainsotherchrom	int4	10	√		null
bib_associateddata_view	has_alleles	int4	10	√		null
bib_associateddata_view	has_antibodies	int4	10	√		null
bib_associateddata_view	has_go	int4	10	√		null
bib_associateddata_view	has_gxdimages	int4	10	√		null
bib_associateddata_view	has_gxdindex	int4	10	√		null
bib_associateddata_view	has_gxdresults	int4	10	√		null
bib_associateddata_view	has_gxdspecimens	int4	10	√		null
bib_associateddata_view	has_mapping	int4	10	√		null
bib_associateddata_view	has_markers	int4	10	√		null
bib_associateddata_view	has_probes	int4	10	√		null
bib_associateddata_view	has_strain	int4	10	√		null
all_cre_cache	hasimage	int4	10	√		null	does this record have an image?
img_imagepane	height	int4	10	√		null	height of image pdf
all_allele_view	jnum	int4	10	√		null
all_cellline_derivation_view	jnum	int4	10	√		null
bib_all2_view	jnum	int4	10	√		null
bib_all_view	jnum	int4	10	√		null
bib_goxref_view	jnum	int4	10	√		null
bib_view	jnum	int4	10	√		null
gxd_antibodyaliasref_view	jnum	int4	10	√		null
gxd_assay_view	jnum	int4	10	√		null
gxd_index_view	jnum	int4	10	√		null
img_image_view	jnum	int4	10	√		null
img_imagepanegxd_view	jnum	int4	10	√		null
mgi_reference_allele_view	jnum	int4	10	√		null
mgi_reference_allelevariant_view	jnum	int4	10	√		null
mgi_reference_antibody_view	jnum	int4	10	√		null
mgi_reference_marker_view	jnum	int4	10	√		null
mgi_reference_sequence_view	jnum	int4	10	√		null
mgi_reference_strain_view	jnum	int4	10	√		null
mgi_relationship_markertss_view	jnum	int4	10	√		null
mgi_synonym_allele_view	jnum	int4	10	√		null
mgi_synonym_goterm_view	jnum	int4	10	√		null
mgi_synonym_musmarker_view	jnum	int4	10	√		null
mgi_synonym_strain_view	jnum	int4	10	√		null
mld_concordance_view	jnum	int4	10	√		null
mld_expt_marker_view	jnum	int4	10	√		null
mld_expt_view	jnum	int4	10	√		null
mld_fish_view	jnum	int4	10	√		null
mld_hybrid_view	jnum	int4	10	√		null
mld_insitu_view	jnum	int4	10	√		null
mld_matrix_view	jnum	int4	10	√		null
mld_mc2point_view	jnum	int4	10	√		null
mld_ri2point_view	jnum	int4	10	√		null
mld_ri_view	jnum	int4	10	√		null
mld_ridata_view	jnum	int4	10	√		null
mld_statistics_view	jnum	int4	10	√		null
mrk_accref1_view	jnum	int4	10	√		null
mrk_accref2_view	jnum	int4	10	√		null
mrk_accref_view	jnum	int4	10	√		null
mrk_reference	jnum	int4	10				J: accession id of the reference without the prefix; integer (xxxx)
mrk_reference_view	jnum	int4	10	√		null
prb_marker_view	jnum	int4	10	√		null
prb_reference_view	jnum	int4	10	√		null
prb_sourceref_view	jnum	int4	10	√		null
seq_allele_assoc_view	jnum	int4	10	√		null
seq_allele_view	jnum	int4	10	√		null
seq_marker_cache_view	jnum	int4	10	√		null
seq_probe_cache_view	jnum	int4	10	√		null
voc_evidence_view	jnum	int4	10	√		null
voc_vocab_view	jnum	int4	10	√		null
gxd_gelband_view	lanenum	int4	10	√		null
map_coordinate	length	int4	10				map length in specified units (_Units_key)
seq_sequence	length	int4	10	√		null	length of sequence
seq_sequence_view	length	int4	10	√		null
mrk_mcv_count_cache	markercount	int4	10				the current number of markers annotated to this term
acc_accessionmax	maxnumericpart	int4	10				the current maximum numeric value for the accession number series designated by prefixPart
mld_contig	minlink	int4	10	√		null	indicates the minimum number of common hits required to assemble YACs into the Contig.
crs_cross	nprogeny	int4	10	√		null	number of progeny resulting from cross
crs_cross_view	nprogeny	int4	10	√		null
mld_matrix_view	nprogeny	int4	10	√		null
gxd_htsample_rnaseqcombined	numberofbiologicalreplicates	int4	10				the number of biological replicates
seq_sequence	numberoforganisms	int4	10	√		null	for Swiss-Prot, number of non-mouse, non-human, non-rat organisms that are sources of this sequence
seq_sequence_view	numberoforganisms	int4	10	√		null
acc_accession	numericpart	int4	10	√		null	the trailing numerical portion of accID
acc_view	numericpart	int4	10	√		null
all_acc_view	numericpart	int4	10	√		null
all_cellline_acc_view	numericpart	int4	10	√		null
all_derivation_summary_view	numericpart	int4	10	√		null
all_summary_view	numericpart	int4	10	√		null
bib_acc_view	numericpart	int4	10	√		null
bib_citation_cache	numericpart	int4	10	√		null	the trailing numerical portion of accID
bib_summary_all_view	numericpart	int4	10	√		null
gxd_antibody_acc_view	numericpart	int4	10	√		null
gxd_antibody_view	numericpart	int4	10	√		null
gxd_antibodyantigen_view	numericpart	int4	10	√		null
gxd_antigen_acc_view	numericpart	int4	10	√		null
gxd_antigen_summary_view	numericpart	int4	10	√		null
gxd_antigen_view	numericpart	int4	10	√		null
gxd_assay_acc_view	numericpart	int4	10	√		null
gxd_assay_view	numericpart	int4	10	√		null
gxd_genotype_acc_view	numericpart	int4	10	√		null
gxd_genotype_summary_view	numericpart	int4	10	√		null
img_image_acc_view	numericpart	int4	10	√		null
img_image_summary_view	numericpart	int4	10	√		null
img_image_view	numericpart	int4	10	√		null
mgi_organism_acc_view	numericpart	int4	10	√		null
mgi_organism_summary_view	numericpart	int4	10	√		null
mld_acc_view	numericpart	int4	10	√		null
mld_expt_view	numericpart	int4	10	√		null
mld_summary_view	numericpart	int4	10	√		null
mrk_acc_view	numericpart	int4	10	√		null
mrk_accnoref_view	numericpart	int4	10	√		null
mrk_accref1_view	numericpart	int4	10	√		null
mrk_accref2_view	numericpart	int4	10	√		null
mrk_accref_view	numericpart	int4	10	√		null
mrk_mouse_view	numericpart	int4	10	√		null
mrk_summary_view	numericpart	int4	10	√		null
prb_acc_view	numericpart	int4	10	√		null
prb_accnoref_view	numericpart	int4	10	√		null
prb_accref_view	numericpart	int4	10	√		null
prb_accrefnoseq_view	numericpart	int4	10	√		null
prb_probe_view	numericpart	int4	10	√		null
prb_source_acc_view	numericpart	int4	10	√		null
prb_source_summary_view	numericpart	int4	10	√		null
prb_strain_acc_view	numericpart	int4	10	√		null
prb_strain_summary_view	numericpart	int4	10	√		null
prb_tissue_summary_view	numericpart	int4	10	√		null
seq_allele_assoc_view	numericpart	int4	10	√		null
seq_sequence_acc_view	numericpart	int4	10	√		null
seq_summary_view	numericpart	int4	10	√		null
voc_term_acc_view	numericpart	int4	10	√		null
voc_term_summary_view	numericpart	int4	10	√		null
mld_fish	nummetaphase	int4	10	√		null	# of metaphase spreads analyzed in experiment
mld_fish_view	nummetaphase	int4	10	√		null
mld_insitu	nummetaphase	int4	10	√		null	# of metaphase spreads analyzed in experiment
mld_insitu_view	nummetaphase	int4	10	√		null
mld_mc2point	numparentals	int4	10				# of animals exhibiting parental genotype
mld_mc2point_view	numparentals	int4	10	√		null
mld_mc2point	numrecombinants	int4	10				# of animals exhibiting recombinant genotype
mld_mc2point_view	numrecombinants	int4	10	√		null
mld_ri2point	numrecombinants	int4	10				# of animals exhibiting recombinant genotype
mld_ri2point_view	numrecombinants	int4	10	√		null
mld_ri2point	numtotal	int4	10				# of animals typed
mld_ri2point_view	numtotal	int4	10	√		null
voc_annot_count_cache	objectcount	int4	10				count of objects of the given _MGIType_key with annotations of a given annotType to the given _Term_key
mld_mcdatalist	offspringnmbr	int4	10				designates number of offspring detected with haplotype
mrk_do_cache	omimcategory3	int4	10				disease mouse model format
all_allele_cellline_view	parentcellline_key	int4	10	√		null
all_cellline_derivation_view	parentcellline_key	int4	10	√		null
all_cellline_view	parentcellline_key	int4	10	√		null
all_cellline_derivation_view	parentcelllinestrain_key	int4	10	√		null
all_cellline_view	parentcelllinestrain_key	int4	10	√		null
all_allele_cellline_view	parentcelllinetype_key	int4	10	√		null
all_cellline_derivation_view	parentcelllinetype_key	int4	10	√		null
prb_parent_view	parentkey	int4	10	√		null
prb_parent_view	parentnumeric	int4	10	√		null
all_label	priority	int4	10				an integer representing the priority of this record for sorting purposes. the higher the number, the higher the priority.
mrk_label	priority	int4	10				an integer representing the priority of this record for sorting purposes. the higher the number, the higher the priority.
mld_statistics	recomb	int4	10				number of mice which recombined for Marker pair
mld_statistics_view	recomb	int4	10	√		null
pwi_report_label	report_id	int4	10				None
gxd_gelband_view	rownum	int4	10	√		null
crs_matrix	rownumber	int4	10				row number
crs_typings	rownumber	int4	10				row number
crs_progeny	sequencenum	int4	10				sequence number for ordering records
dag_edge	sequencenum	int4	10				sequence number for ordering records
gxd_allelegenotype	sequencenum	int4	10				sequence number for ordering records
gxd_allelepair	sequencenum	int4	10				sequence number for ordering records
gxd_allelepair_view	sequencenum	int4	10	√		null
gxd_assaytype	sequencenum	int4	10				sequence number for ordering records
gxd_gellane	sequencenum	int4	10				sequence number for ordering records
gxd_gellane_view	sequencenum	int4	10	√		null
gxd_gellanestructure_view	sequencenum	int4	10	√		null
gxd_gelrow	sequencenum	int4	10				sequence number for ordering records
gxd_gelrow_view	sequencenum	int4	10	√		null
gxd_insituresult	sequencenum	int4	10				sequence number for ordering records
gxd_insituresult_view	sequencenum	int4	10	√		null
gxd_isresultimage_view	sequencenum	int4	10	√		null
gxd_isresultstructure_view	sequencenum	int4	10	√		null
gxd_specimen	sequencenum	int4	10				sequence number for ordering records
gxd_specimen_view	sequencenum	int4	10	√		null
map_coordinate	sequencenum	int4	10				orders the Map withing the specified Map Collection
mgi_note_allele_view	sequencenum	int4	10	√		null
mgi_note_allelevariant_view	sequencenum	int4	10	√		null
mgi_note_derivation_view	sequencenum	int4	10	√		null
mgi_note_genotype_view	sequencenum	int4	10	√		null
mgi_note_image_view	sequencenum	int4	10	√		null
mgi_note_marker_view	sequencenum	int4	10	√		null
mgi_note_mrkgo_view	sequencenum	int4	10	√		null
mgi_note_probe_view	sequencenum	int4	10	√		null
mgi_note_sequence_view	sequencenum	int4	10	√		null
mgi_note_source_view	sequencenum	int4	10	√		null
mgi_note_strain_view	sequencenum	int4	10	√		null
mgi_note_vocevidence_view	sequencenum	int4	10	√		null
mgi_notechunk	sequencenum	int4	10				order of the note segment (for reconstructing the entire note).
mgi_organism_mgitype	sequencenum	int4	10
mgi_organism_mgitype_view	sequencenum	int4	10	√		null
mgi_property	sequencenum	int4	10				sequence number for ordering records
mgi_relationship_property	sequencenum	int4	10				Order of properties in this relationship
mgi_set	sequencenum	int4	10				sequence number for ordering records
mgi_setmember	sequencenum	int4	10				order of the member within the Set
mgi_translation	sequencenum	int4	10				order of the Translation member
mgi_translation_view	sequencenum	int4	10	√		null
mgi_translationstrain_view	sequencenum	int4	10	√		null
mld_concordance	sequencenum	int4	10				sequence number for ordering records
mld_concordance_view	sequencenum	int4	10	√		null
mld_contigprobe	sequencenum	int4	10				sequence number for ordering records
mld_expt_marker	sequencenum	int4	10				sequence number for ordering records
mld_expt_marker_view	sequencenum	int4	10	√		null
mld_fish_region	sequencenum	int4	10				sequence number for ordering records
mld_isregion	sequencenum	int4	10				sequence number for ordering records
mld_mc2point	sequencenum	int4	10				sequence number for ordering records
mld_mc2point_view	sequencenum	int4	10	√		null
mld_mcdatalist	sequencenum	int4	10				sequence number for ordering records
mld_ri2point	sequencenum	int4	10				sequence number for ordering records
mld_ri2point_view	sequencenum	int4	10	√		null
mld_ridata	sequencenum	int4	10				sequence number for ordering records
mld_ridata_view	sequencenum	int4	10	√		null
mld_statistics	sequencenum	int4	10				sequence number for ordering records
mld_statistics_view	sequencenum	int4	10	√		null
mrk_chromosome	sequencenum	int4	10				sequence number for ordering records
mrk_clustermember	sequencenum	int4	10				order of members within this cluster
mrk_history	sequencenum	int4	10				sequence number of the event
mrk_history_view	sequencenum	int4	10	√		null
mrk_location_cache	sequencenum	int4	10				chromosome order
prb_strain_marker_view	sequencenum	int4	10	√		null
voc_annot_view	sequencenum	int4	10	√		null
voc_annotheader	sequencenum	int4	10				order of the Header Term for a specific Object
voc_annotheader_view	sequencenum	int4	10	√		null
voc_evidence_property	sequencenum	int4	10				sequnence number of the property within each stanza
voc_evidenceproperty_view	sequencenum	int4	10	√		null
voc_term	sequencenum	int4	10	√		null	enables us to define an ordered list of Terms for a Vocabulary which contains 0 DAGS. for structured vocabularies, the sequenceNum is null
voc_term_cellline_view	sequencenum	int4	10	√		null
voc_term_mcv_view	sequencenum	int4	10	√		null
voc_term_repqualifier_view	sequencenum	int4	10	√		null
voc_term_strainallele_view	sequencenum	int4	10	√		null
voc_term_strainspecies_view	sequencenum	int4	10	√		null
voc_term_view	sequencenum	int4	10	√		null
gxd_gellanestructure_view	stage	int4	10	√		null
gxd_isresultstructure_view	stage	int4	10	√		null
gxd_theilerstage	stage	int4	10				Theiler Stage (1-28)
voc_evidence_property	stanza	int4	10				a stanza represents a group of proeprties within the same evidence; group by _AnnotEvidence_key/stranza/sequenceNumber to retreive the ordered set of stanza's for a given annotation/evidence
voc_evidenceproperty_view	stanza	int4	10	√		null
voc_term_emapa	startstage	int4	10				Start Theiler Stage
all_allele_view	statusnum	int4	10	√		null
mld_expt_marker_view	tag	int4	10	√		null
mld_expt_view	tag	int4	10	√		null
mld_expts	tag	int4	10				unique integer value for each experiment type defined for a given reference (CROSS-1, CROSS-2, etc.)
mld_matrix_view	tag	int4	10	√		null
mld_ri_view	tag	int4	10	√		null
mld_statistics_view	tag	int4	10	√		null
mld_statistics	total	int4	10				total number of mice typed for Marker pair
mld_statistics_view	total	int4	10	√		null
mld_fish	totaldouble	int4	10	√		null	# of double fluorescent signals indicating presence of marker
mld_fish_region	totaldouble	int4	10	√		null	number of double signals detected in region
mld_fish_view	totaldouble	int4	10	√		null
mld_insitu	totalgrains	int4	10	√		null	# of grains observed in experiment
mld_insitu_view	totalgrains	int4	10	√		null
mld_fish	totalsingle	int4	10	√		null	# of single flourescent signals indicating presence of marker
mld_fish_region	totalsingle	int4	10	√		null	number of single signals detected in region
mld_fish_view	totalsingle	int4	10	√		null
seq_genemodel	transcriptcount	int4	10	√		null	currently not being used.
mrk_biotypemapping	usemcvchildren	int4	10			0	use feature type/MCV children to determine raw biotype conflicts
img_imagepane	width	int4	10	√		null	width of image pdf
img_imagepane	x	int4	10	√		null	x coordinate of image pdf
gxd_isresultimage_view	xdim	int4	10	√		null
img_image	xdim	int4	10	√		null	X dimension of JPEG image
img_image_view	xdim	int4	10	√		null
img_imagepane	y	int4	10	√		null	y coordinate of image pdf
gxd_isresultimage_view	ydim	int4	10	√		null
img_image	ydim	int4	10	√		null	Y dimensions of JPEG image
img_image_view	ydim	int4	10	√		null
bib_all2_view	year	int4	10	√		null
bib_all_view	year	int4	10	√		null
bib_refs	year	int4	10	√		null	year of publication
bib_view	year	int4	10	√		null
pwi_bib_refs_view	year	int4	10	√		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_htsample_rnaseqcombined	averagequantilenormalizedtpm	numeric	131089				the average quantile normlized TPM
gxd_htsample_rnaseq	averagetpm	numeric	131089				the average TPM of the sample
gxd_theilerstage	dpcmax	numeric	131089				approximate mapping to maximum DPC value
gxd_theilerstage	dpcmin	numeric	131089				approximate mapping to minimum DPC value
all_variant_sequence	endcoordinate	numeric	131089	√		null
map_coord_feature	endcoordinate	numeric	131089				coordinate of the last base pair
seq_coord_cache	endcoordinate	numeric	131089				end BP coordinate
mld_contig	maxcm	numeric	131089	√		null	maximum cM position of markers within the Contig
mld_contig	mincm	numeric	131089	√		null	minimum cM position of markers within the Contig
mld_statistics	pcntrecomb	numeric	131089				percentage of recombination per number of mice
mld_statistics_view	pcntrecomb	numeric	131089	√		null
seq_genetrap	pointcoordinate	numeric	131089	√		null	The single coordinate picked to indicate where the insertion actually happened
gxd_htsample_rnaseq	quantilenormalizedtpm	numeric	131089				the quantile normlized TPM of the sample
gxd_gelrow	size	numeric	131089	√		null	size of band
gxd_gelrow_view	size	numeric	131089	√		null
all_variant_sequence	startcoordinate	numeric	131089	√		null
map_coord_feature	startcoordinate	numeric	131089				coordinate of the first base pair
seq_coord_cache	startcoordinate	numeric	131089				start BP coordinate
mld_statistics	stderr	numeric	131089				standard error of the recombination percentage
mld_statistics_view	stderr	numeric	131089	√		null
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
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
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
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_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	&