SchemaSpy Analysis of pub.mgd - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Mon Sep 28 09:47 EDT 2020 |
| ||||||
|
pub.mgd contains 4327 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
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 | & |