Schema Browser
 Home  | About  | Help  | FAQ  
SchemaSpy Analysis of mgd.mgd - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Sep 26 19:11 EDT 2011
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

mgd.mgd contains 1592 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
acc_accession _accession_key int4 10
acc_accession _createdby_key int4 10
acc_accession _logicaldb_key int4 10
acc_accession _mgitype_key int4 10
acc_accession _modifiedby_key int4 10
acc_accession _object_key int4 10
acc_accession accid varchar 30
acc_accession creation_date timestamp 29,6
acc_accession modification_date timestamp 29,6
acc_accession numericpart int4 10  √  null
acc_accession preferred int2 5  √  null
acc_accession prefixpart varchar 30  √  null
acc_accession private int2 5
acc_accessionmax creation_date timestamp 29,6
acc_accessionmax maxnumericpart int4 10
acc_accessionmax modification_date timestamp 29,6
acc_accessionmax prefixpart varchar 30
acc_accessionreference _accession_key int4 10
acc_accessionreference _createdby_key int4 10
acc_accessionreference _modifiedby_key int4 10
acc_accessionreference _refs_key int4 10
acc_accessionreference creation_date timestamp 29,6
acc_accessionreference modification_date timestamp 29,6
acc_actualdb _actualdb_key int4 10
acc_actualdb _createdby_key int4 10
acc_actualdb _logicaldb_key int4 10
acc_actualdb _modifiedby_key int4 10
acc_actualdb active int2 5
acc_actualdb allowsmultiple int2 5  √  null
acc_actualdb creation_date timestamp 29,6
acc_actualdb delimiter bpchar 8  √  null
acc_actualdb modification_date timestamp 29,6
acc_actualdb name varchar 80
acc_actualdb url varchar 255
acc_logicaldb _createdby_key int4 10
acc_logicaldb _logicaldb_key int4 10
acc_logicaldb _modifiedby_key int4 10
acc_logicaldb _organism_key int4 10  √  null
acc_logicaldb creation_date timestamp 29,6
acc_logicaldb description varchar 255  √  null
acc_logicaldb modification_date timestamp 29,6
acc_logicaldb name varchar 80
acc_mgitype _createdby_key int4 10
acc_mgitype _mgitype_key int4 10
acc_mgitype _modifiedby_key int4 10
acc_mgitype creation_date timestamp 29,6
acc_mgitype dbview varchar 80  √  null
acc_mgitype identitycolumnname varchar 80  √  null
acc_mgitype modification_date timestamp 29,6
acc_mgitype name varchar 80
acc_mgitype primarykeyname varchar 80
acc_mgitype tablename varchar 80
all_allele _allele_key int4 10
all_allele _allele_status_key int4 10
all_allele _allele_type_key int4 10
all_allele _approvedby_key int4 10  √  null
all_allele _createdby_key int4 10
all_allele _marker_key int4 10  √  null
all_allele _mode_key int4 10
all_allele _modifiedby_key int4 10
all_allele _strain_key int4 10
all_allele _transmission_key int4 10
all_allele approval_date timestamp 29,6  √  null
all_allele creation_date timestamp 29,6
all_allele isextinct int2 5  √  null
all_allele ismixed int2 5  √  null
all_allele iswildtype int2 5
all_allele modification_date timestamp 29,6
all_allele name varchar 255
all_allele nomensymbol varchar 50  √  null
all_allele symbol varchar 60
all_allele_cellline _allele_key int4 10
all_allele_cellline _assoc_key int4 10
all_allele_cellline _createdby_key int4 10
all_allele_cellline _modifiedby_key int4 10
all_allele_cellline _mutantcellline_key int4 10
all_allele_cellline creation_date timestamp 29,6
all_allele_cellline modification_date timestamp 29,6
all_allele_mutation _allele_key int4 10
all_allele_mutation _mutation_key int4 10
all_allele_mutation creation_date timestamp 29,6
all_allele_mutation modification_date timestamp 29,6
all_cellline _cellline_key int4 10
all_cellline _cellline_type_key int4 10
all_cellline _createdby_key int4 10
all_cellline _derivation_key int4 10  √  null
all_cellline _modifiedby_key int4 10
all_cellline _strain_key int4 10
all_cellline cellline varchar 255
all_cellline creation_date timestamp 29,6
all_cellline ismutant int2 5
all_cellline modification_date timestamp 29,6
all_cellline_derivation _createdby_key int4 10
all_cellline_derivation _creator_key int4 10
all_cellline_derivation _derivation_key int4 10
all_cellline_derivation _derivationtype_key int4 10
all_cellline_derivation _modifiedby_key int4 10
all_cellline_derivation _parentcellline_key int4 10
all_cellline_derivation _refs_key int4 10  √  null
all_cellline_derivation _vector_key int4 10
all_cellline_derivation _vectortype_key int4 10
all_cellline_derivation creation_date timestamp 29,6
all_cellline_derivation description varchar 255  √  null
all_cellline_derivation modification_date timestamp 29,6
all_cellline_derivation name varchar 255  √  null
all_cre_cache _allele_key int4 10
all_cre_cache _allele_type_key int4 10
all_cre_cache _assay_key int4 10  √  null
all_cre_cache _cache_key int4 10
all_cre_cache _createdby_key int4 10
all_cre_cache _modifiedby_key int4 10
all_cre_cache _structure_key int4 10  √  null
all_cre_cache _system_key int4 10  √  null
all_cre_cache alleletype varchar 255
all_cre_cache creation_date timestamp 29,6
all_cre_cache drivernote varchar 255
all_cre_cache expressed int4 10  √  null
all_cre_cache modification_date timestamp 29,6
all_cre_cache name varchar 255
all_cre_cache structure varchar 255  √  null
all_cre_cache symbol varchar 60
all_cre_cache system varchar 255  √  null
all_knockout_cache _allele_key int4 10  √  null
all_knockout_cache _createdby_key int4 10
all_knockout_cache _knockout_key int4 10
all_knockout_cache _marker_key int4 10
all_knockout_cache _modifiedby_key int4 10
all_knockout_cache companyid varchar 30  √  null
all_knockout_cache creation_date timestamp 29,6
all_knockout_cache holder varchar 30
all_knockout_cache jrsid varchar 30  √  null
all_knockout_cache modification_date timestamp 29,6
all_knockout_cache nihid varchar 30  √  null
all_knockout_cache repository varchar 15
all_label _allele_key int4 10
all_label _label_status_key int4 10
all_label creation_date timestamp 29,6
all_label label varchar 255
all_label labeltype varchar 5
all_label labeltypename varchar 255
all_label modification_date timestamp 29,6
all_label priority int4 10
all_marker_assoc _allele_key int4 10
all_marker_assoc _assoc_key int4 10
all_marker_assoc _createdby_key int4 10
all_marker_assoc _marker_key int4 10
all_marker_assoc _modifiedby_key int4 10
all_marker_assoc _qualifier_key int4 10
all_marker_assoc _refs_key int4 10  √  null
all_marker_assoc _status_key int4 10
all_marker_assoc creation_date timestamp 29,6
all_marker_assoc modification_date timestamp 29,6
bib_books _refs_key int4 10
bib_books book_au varchar 160  √  null
bib_books book_title varchar 200  √  null
bib_books creation_date timestamp 29,6
bib_books modification_date timestamp 29,6
bib_books place varchar 50  √  null
bib_books publisher varchar 50  √  null
bib_books series_ed varchar 50  √  null
bib_citation_cache _refs_key int4 10
bib_citation_cache citation varchar 255
bib_citation_cache isreviewarticle int2 5
bib_citation_cache isreviewarticlestring bpchar 3
bib_citation_cache jnumid varchar 30
bib_citation_cache journal varchar 100  √  null
bib_citation_cache mgiid varchar 30
bib_citation_cache numericpart int4 10
bib_citation_cache pubmedid varchar 30  √  null
bib_citation_cache reviewstatus varchar 40
bib_citation_cache short_citation varchar 255
bib_dataset _createdby_key int4 10
bib_dataset _dataset_key int4 10
bib_dataset _modifiedby_key int4 10
bib_dataset abbreviation varchar 15
bib_dataset creation_date timestamp 29,6
bib_dataset dataset varchar 255
bib_dataset inmgiprocedure varchar 255  √  null
bib_dataset isobsolete int2 5
bib_dataset modification_date timestamp 29,6
bib_dataset sequencenum int4 10
bib_dataset_assoc _assoc_key int4 10
bib_dataset_assoc _createdby_key int4 10
bib_dataset_assoc _dataset_key int4 10
bib_dataset_assoc _modifiedby_key int4 10
bib_dataset_assoc _refs_key int4 10
bib_dataset_assoc creation_date timestamp 29,6
bib_dataset_assoc isneverused int2 5
bib_dataset_assoc modification_date timestamp 29,6
bib_notes _refs_key int4 10
bib_notes creation_date timestamp 29,6
bib_notes modification_date timestamp 29,6
bib_notes note bpchar 255
bib_notes sequencenum int4 10
bib_refs _createdby_key int4 10
bib_refs _modifiedby_key int4 10
bib_refs _primary varchar 60  √  null
bib_refs _refs_key int4 10
bib_refs _reviewstatus_key int4 10
bib_refs abstract text 2147483647  √  null
bib_refs authors varchar 255  √  null
bib_refs authors2 varchar 255  √  null
bib_refs creation_date timestamp 29,6
bib_refs date varchar 30  √  null
bib_refs isreviewarticle int2 5
bib_refs issue varchar 25  √  null
bib_refs journal varchar 100  √  null
bib_refs modification_date timestamp 29,6
bib_refs nlmstatus bpchar 1
bib_refs pgs varchar 30  √  null
bib_refs reftype bpchar 4
bib_refs title varchar 255  √  null
bib_refs title2 varchar 255  √  null
bib_refs vol varchar 20  √  null
bib_refs year int4 10  √  null
bib_reviewstatus _reviewstatus_key int4 10
bib_reviewstatus creation_date timestamp 29,6
bib_reviewstatus modification_date timestamp 29,6
bib_reviewstatus name varchar 40
crs_cross _cross_key int4 10
crs_cross _femalestrain_key int4 10
crs_cross _malestrain_key int4 10
crs_cross _strainho_key int4 10
crs_cross _strainht_key int4 10
crs_cross abbrevho varchar 4  √  null
crs_cross abbrevht varchar 4  √  null
crs_cross allelefromsegparent int2 5
crs_cross creation_date timestamp 29,6
crs_cross displayed int2 5  √  null
crs_cross f1directionknown int2 5  √  null
crs_cross femaleallele1 bpchar 1  √  null
crs_cross femaleallele2 bpchar 1  √  null
crs_cross maleallele1 bpchar 1  √  null
crs_cross maleallele2 bpchar 1  √  null
crs_cross modification_date timestamp 29,6
crs_cross nprogeny int4 10  √  null
crs_cross type varchar 3
crs_cross whosecross varchar 30  √  null
crs_matrix _cross_key int4 10
crs_matrix _marker_key int4 10  √  null
crs_matrix chromosome varchar 8
crs_matrix creation_date timestamp 29,6
crs_matrix modification_date timestamp 29,6
crs_matrix notes varchar 255  √  null
crs_matrix othersymbol varchar 20  √  null
crs_matrix rownumber int4 10
crs_progeny _cross_key int4 10
crs_progeny creation_date timestamp 29,6
crs_progeny modification_date timestamp 29,6
crs_progeny name varchar 40  √  null
crs_progeny notes varchar 255  √  null
crs_progeny sequencenum int4 10
crs_progeny sex bpchar 1
crs_references _cross_key int4 10
crs_references _marker_key int4 10
crs_references _refs_key int4 10
crs_references creation_date timestamp 29,6
crs_references modification_date timestamp 29,6
crs_typings _cross_key int4 10
crs_typings colnumber int4 10
crs_typings creation_date timestamp 29,6
crs_typings data varchar 255  √  null
crs_typings modification_date timestamp 29,6
crs_typings rownumber int4 10
dag_closure _ancestor_key int4 10
dag_closure _ancestorlabel_key int4 10
dag_closure _ancestorobject_key int4 10
dag_closure _dag_key int4 10
dag_closure _descendent_key int4 10
dag_closure _descendentlabel_key int4 10
dag_closure _descendentobject_key int4 10
dag_closure _mgitype_key int4 10
dag_closure creation_date timestamp 29,6
dag_closure modification_date timestamp 29,6
dag_dag _dag_key int4 10
dag_dag _mgitype_key int4 10
dag_dag _refs_key int4 10
dag_dag abbreviation bpchar 5
dag_dag creation_date timestamp 29,6
dag_dag modification_date timestamp 29,6
dag_dag name varchar 255
dag_edge _child_key int4 10
dag_edge _dag_key int4 10
dag_edge _edge_key int4 10
dag_edge _label_key int4 10
dag_edge _parent_key int4 10
dag_edge creation_date timestamp 29,6
dag_edge modification_date timestamp 29,6
dag_edge sequencenum int4 10
dag_label _label_key int4 10
dag_label creation_date timestamp 29,6
dag_label label varchar 255
dag_label modification_date timestamp 29,6
dag_node _dag_key int4 10
dag_node _label_key int4 10
dag_node _node_key int4 10
dag_node _object_key int4 10
dag_node creation_date timestamp 29,6
dag_node modification_date timestamp 29,6
go_tracking _completedby_key int4 10  √  null
go_tracking _createdby_key int4 10
go_tracking _marker_key int4 10
go_tracking _modifiedby_key int4 10
go_tracking completion_date timestamp 29,6  √  null
go_tracking creation_date timestamp 29,6
go_tracking isreferencegene int2 5
go_tracking modification_date timestamp 29,6
gxd_allelegenotype _allele_key int4 10
gxd_allelegenotype _createdby_key int4 10
gxd_allelegenotype _genotype_key int4 10
gxd_allelegenotype _marker_key int4 10  √  null
gxd_allelegenotype _modifiedby_key int4 10
gxd_allelegenotype creation_date timestamp 29,6
gxd_allelegenotype modification_date timestamp 29,6
gxd_allelegenotype sequencenum int4 10
gxd_allelepair _allele_key_1 int4 10
gxd_allelepair _allele_key_2 int4 10  √  null
gxd_allelepair _allelepair_key int4 10
gxd_allelepair _compound_key int4 10
gxd_allelepair _createdby_key int4 10
gxd_allelepair _genotype_key int4 10
gxd_allelepair _marker_key int4 10  √  null
gxd_allelepair _modifiedby_key int4 10
gxd_allelepair _pairstate_key int4 10
gxd_allelepair creation_date timestamp 29,6
gxd_allelepair modification_date timestamp 29,6
gxd_allelepair sequencenum int4 10
gxd_antibody _antibody_key int4 10
gxd_antibody _antibodyclass_key int4 10
gxd_antibody _antibodytype_key int4 10
gxd_antibody _antigen_key int4 10
gxd_antibody _createdby_key int4 10
gxd_antibody _modifiedby_key int4 10
gxd_antibody _organism_key int4 10
gxd_antibody antibodyname varchar 255
gxd_antibody antibodynote varchar 255  √  null
gxd_antibody creation_date timestamp 29,6
gxd_antibody modification_date timestamp 29,6
gxd_antibody recogimmunprecip varchar 15
gxd_antibody recognote varchar 255  √  null
gxd_antibody recogwestern varchar 15
gxd_antibodyalias _antibody_key int4 10
gxd_antibodyalias _antibodyalias_key int4 10
gxd_antibodyalias _refs_key int4 10  √  null
gxd_antibodyalias alias varchar 255
gxd_antibodyalias creation_date timestamp 29,6
gxd_antibodyalias modification_date timestamp 29,6
gxd_antibodyclass _antibodyclass_key int4 10
gxd_antibodyclass class varchar 20
gxd_antibodyclass creation_date timestamp 29,6
gxd_antibodyclass modification_date timestamp 29,6
gxd_antibodymarker _antibody_key int4 10
gxd_antibodymarker _marker_key int4 10
gxd_antibodymarker creation_date timestamp 29,6
gxd_antibodymarker modification_date timestamp 29,6
gxd_antibodyprep _antibody_key int4 10
gxd_antibodyprep _antibodyprep_key int4 10
gxd_antibodyprep _label_key int4 10
gxd_antibodyprep _secondary_key int4 10
gxd_antibodyprep creation_date timestamp 29,6
gxd_antibodyprep modification_date timestamp 29,6
gxd_antibodytype _antibodytype_key int4 10
gxd_antibodytype antibodytype varchar 20
gxd_antibodytype creation_date timestamp 29,6
gxd_antibodytype modification_date timestamp 29,6
gxd_antigen _antigen_key int4 10
gxd_antigen _createdby_key int4 10
gxd_antigen _modifiedby_key int4 10
gxd_antigen _source_key int4 10
gxd_antigen antigenname varchar 255
gxd_antigen antigennote varchar 255  √  null
gxd_antigen creation_date timestamp 29,6
gxd_antigen modification_date timestamp 29,6
gxd_antigen regioncovered varchar 255  √  null
gxd_assay _antibodyprep_key int4 10  √  null
gxd_assay _assay_key int4 10
gxd_assay _assaytype_key int4 10
gxd_assay _createdby_key int4 10
gxd_assay _imagepane_key int4 10  √  null
gxd_assay _marker_key int4 10
gxd_assay _modifiedby_key int4 10
gxd_assay _probeprep_key int4 10  √  null
gxd_assay _refs_key int4 10
gxd_assay _reportergene_key int4 10  √  null
gxd_assay creation_date timestamp 29,6
gxd_assay modification_date timestamp 29,6
gxd_assaynote _assay_key int4 10
gxd_assaynote assaynote bpchar 255
gxd_assaynote creation_date timestamp 29,6
gxd_assaynote modification_date timestamp 29,6
gxd_assaynote sequencenum int4 10
gxd_assaytype _assaytype_key int4 10
gxd_assaytype assaytype varchar 80
gxd_assaytype creation_date timestamp 29,6
gxd_assaytype isgelassay int2 5  √  null
gxd_assaytype isrnaassay int2 5
gxd_assaytype modification_date timestamp 29,6
gxd_embeddingmethod _embedding_key int4 10
gxd_embeddingmethod creation_date timestamp 29,6
gxd_embeddingmethod embeddingmethod varchar 25
gxd_embeddingmethod modification_date timestamp 29,6
gxd_expression _assay_key int4 10
gxd_expression _assaytype_key int4 10
gxd_expression _expression_key int4 10
gxd_expression _genotype_key int4 10
gxd_expression _marker_key int4 10
gxd_expression _refs_key int4 10
gxd_expression _structure_key int4 10
gxd_expression age varchar 50
gxd_expression agemax float8 17,17  √  null
gxd_expression agemin float8 17,17  √  null
gxd_expression creation_date timestamp 29,6
gxd_expression expressed int2 5
gxd_expression hasimage int2 5  √  null
gxd_expression isforgxd int2 5
gxd_expression isrecombinase int2 5
gxd_expression modification_date timestamp 29,6
gxd_fixationmethod _fixation_key int4 10
gxd_fixationmethod creation_date timestamp 29,6
gxd_fixationmethod fixation varchar 25
gxd_fixationmethod modification_date timestamp 29,6
gxd_gelband _gelband_key int4 10
gxd_gelband _gellane_key int4 10
gxd_gelband _gelrow_key int4 10
gxd_gelband _strength_key int4 10
gxd_gelband bandnote varchar 255  √  null
gxd_gelband creation_date timestamp 29,6
gxd_gelband modification_date timestamp 29,6
gxd_gelcontrol _gelcontrol_key int4 10
gxd_gelcontrol creation_date timestamp 29,6
gxd_gelcontrol gellanecontent varchar 255
gxd_gelcontrol modification_date timestamp 29,6
gxd_gellane _assay_key int4 10
gxd_gellane _gelcontrol_key int4 10
gxd_gellane _gellane_key int4 10
gxd_gellane _gelrnatype_key int4 10
gxd_gellane _genotype_key int4 10
gxd_gellane age varchar 50
gxd_gellane agemax float8 17,17  √  null
gxd_gellane agemin float8 17,17  √  null
gxd_gellane agenote varchar 255  √  null
gxd_gellane creation_date timestamp 29,6
gxd_gellane lanelabel varchar 255  √  null
gxd_gellane lanenote varchar 255  √  null
gxd_gellane modification_date timestamp 29,6
gxd_gellane sampleamount varchar 10  √  null
gxd_gellane sequencenum int4 10
gxd_gellane sex varchar 15
gxd_gellanestructure _gellane_key int4 10
gxd_gellanestructure _structure_key int4 10
gxd_gellanestructure creation_date timestamp 29,6
gxd_gellanestructure modification_date timestamp 29,6
gxd_gelrnatype _gelrnatype_key int4 10
gxd_gelrnatype creation_date timestamp 29,6
gxd_gelrnatype modification_date timestamp 29,6
gxd_gelrnatype rnatype varchar 20
gxd_gelrow _assay_key int4 10
gxd_gelrow _gelrow_key int4 10
gxd_gelrow _gelunits_key int4 10
gxd_gelrow creation_date timestamp 29,6
gxd_gelrow modification_date timestamp 29,6
gxd_gelrow rownote varchar 255  √  null
gxd_gelrow sequencenum int4 10
gxd_gelrow size float8 17,17  √  null
gxd_gelunits _gelunits_key int4 10
gxd_gelunits creation_date timestamp 29,6
gxd_gelunits modification_date timestamp 29,6
gxd_gelunits units varchar 15
gxd_genotype _createdby_key int4 10
gxd_genotype _existsas_key int4 10
gxd_genotype _genotype_key int4 10
gxd_genotype _modifiedby_key int4 10
gxd_genotype _strain_key int4 10
gxd_genotype creation_date timestamp 29,6
gxd_genotype isconditional int2 5
gxd_genotype modification_date timestamp 29,6
gxd_genotype note varchar 255  √  null
gxd_index _conditionalmutants_key int4 10
gxd_index _createdby_key int4 10
gxd_index _index_key int4 10
gxd_index _marker_key int4 10
gxd_index _modifiedby_key int4 10
gxd_index _priority_key int4 10
gxd_index _refs_key int4 10
gxd_index comments varchar 255  √  null
gxd_index creation_date timestamp 29,6
gxd_index modification_date timestamp 29,6
gxd_index_stages _createdby_key int4 10
gxd_index_stages _index_key int4 10
gxd_index_stages _indexassay_key int4 10
gxd_index_stages _modifiedby_key int4 10
gxd_index_stages _stageid_key int4 10
gxd_index_stages creation_date timestamp 29,6
gxd_index_stages modification_date timestamp 29,6
gxd_insituresult _pattern_key int4 10
gxd_insituresult _result_key int4 10
gxd_insituresult _specimen_key int4 10
gxd_insituresult _strength_key int4 10
gxd_insituresult creation_date timestamp 29,6
gxd_insituresult modification_date timestamp 29,6
gxd_insituresult resultnote varchar 255  √  null
gxd_insituresult sequencenum int4 10
gxd_insituresultimage _imagepane_key int4 10
gxd_insituresultimage _result_key int4 10
gxd_insituresultimage creation_date timestamp 29,6
gxd_insituresultimage modification_date timestamp 29,6
gxd_isresultstructure _result_key int4 10
gxd_isresultstructure _structure_key int4 10
gxd_isresultstructure creation_date timestamp 29,6
gxd_isresultstructure modification_date timestamp 29,6
gxd_label _label_key int4 10
gxd_label creation_date timestamp 29,6
gxd_label label varchar 80
gxd_label modification_date timestamp 29,6
gxd_pattern _pattern_key int4 10
gxd_pattern creation_date timestamp 29,6
gxd_pattern modification_date timestamp 29,6
gxd_pattern pattern varchar 80
gxd_probeprep _label_key int4 10
gxd_probeprep _probe_key int4 10
gxd_probeprep _probeprep_key int4 10
gxd_probeprep _sense_key int4 10
gxd_probeprep _visualization_key int4 10
gxd_probeprep creation_date timestamp 29,6
gxd_probeprep modification_date timestamp 29,6
gxd_probeprep type varchar 15
gxd_probesense _sense_key int4 10
gxd_probesense creation_date timestamp 29,6
gxd_probesense modification_date timestamp 29,6
gxd_probesense sense varchar 80
gxd_secondary _secondary_key int4 10
gxd_secondary creation_date timestamp 29,6
gxd_secondary modification_date timestamp 29,6
gxd_secondary secondary varchar 80
gxd_specimen _assay_key int4 10
gxd_specimen _embedding_key int4 10
gxd_specimen _fixation_key int4 10
gxd_specimen _genotype_key int4 10
gxd_specimen _specimen_key int4 10
gxd_specimen age varchar 50
gxd_specimen agemax float8 17,17  √  null
gxd_specimen agemin float8 17,17  √  null
gxd_specimen agenote varchar 255  √  null
gxd_specimen creation_date timestamp 29,6
gxd_specimen hybridization varchar 255
gxd_specimen modification_date timestamp 29,6
gxd_specimen sequencenum int4 10
gxd_specimen sex varchar 15
gxd_specimen specimenlabel varchar 255  √  null
gxd_specimen specimennote varchar 255  √  null
gxd_strength _strength_key int4 10
gxd_strength creation_date timestamp 29,6
gxd_strength modification_date timestamp 29,6
gxd_strength strength varchar 15
gxd_structure _parent_key int4 10  √  null
gxd_structure _stage_key int4 10
gxd_structure _structure_key int4 10
gxd_structure _structurename_key int4 10
gxd_structure _system_key int4 10
gxd_structure creation_date timestamp 29,6
gxd_structure edinburghkey int4 10  √  null
gxd_structure inheritsystem int2 5
gxd_structure modification_date timestamp 29,6
gxd_structure printname varchar 255  √  null
gxd_structure printstop int2 5
gxd_structure structurenote varchar 255  √  null
gxd_structure toposort int4 10
gxd_structure treedepth int4 10
gxd_structureclosure _descendent_key int4 10
gxd_structureclosure _structure_key int4 10
gxd_structureclosure creation_date timestamp 29,6
gxd_structureclosure modification_date timestamp 29,6
gxd_structurename _structure_key int4 10
gxd_structurename _structurename_key int4 10
gxd_structurename creation_date timestamp 29,6
gxd_structurename mgiadded int2 5
gxd_structurename modification_date timestamp 29,6
gxd_structurename structure varchar 80
gxd_theilerstage _defaultsystem_key int4 10
gxd_theilerstage _stage_key int4 10
gxd_theilerstage creation_date timestamp 29,6
gxd_theilerstage description varchar 255  √  null
gxd_theilerstage dpcmax float8 17,17
gxd_theilerstage dpcmin float8 17,17
gxd_theilerstage modification_date timestamp 29,6
gxd_theilerstage stage int4 10
gxd_visualizationmethod _visualization_key int4 10
gxd_visualizationmethod creation_date timestamp 29,6
gxd_visualizationmethod modification_date timestamp 29,6
gxd_visualizationmethod visualization varchar 80
hmd_assay _assay_key int4 10
hmd_assay abbrev bpchar 2
hmd_assay assay varchar 80
hmd_assay creation_date timestamp 29,6
hmd_assay modification_date timestamp 29,6
hmd_class _class_key int4 10
hmd_class creation_date timestamp 29,6
hmd_class modification_date timestamp 29,6
hmd_homology _class_key int4 10
hmd_homology _homology_key int4 10
hmd_homology _refs_key int4 10
hmd_homology creation_date timestamp 29,6
hmd_homology modification_date timestamp 29,6
hmd_homology_assay _assay_key int4 10
hmd_homology_assay _homology_key int4 10
hmd_homology_assay creation_date timestamp 29,6
hmd_homology_assay modification_date timestamp 29,6
hmd_homology_marker _homology_key int4 10
hmd_homology_marker _marker_key int4 10
hmd_homology_marker creation_date timestamp 29,6
hmd_homology_marker modification_date timestamp 29,6
hmd_notes _homology_key int4 10
hmd_notes creation_date timestamp 29,6
hmd_notes modification_date timestamp 29,6
hmd_notes notes bpchar 255
hmd_notes sequencenum int4 10
img_cache _assaytype_key int4 10  √  null
img_cache _cache_key int4 10
img_cache _image_key int4 10
img_cache _imageclass_key int4 10
img_cache _imagemgitype_key int4 10
img_cache _imagepane_key int4 10
img_cache _mgitype_key int4 10
img_cache _object_key int4 10
img_cache _refs_key int4 10
img_cache _thumbnailimage_key int4 10
img_cache assaytype varchar 80  √  null
img_cache figurelabel varchar 255
img_cache numericpart int4 10
img_cache panelabel varchar 255  √  null
img_cache sequencenum int4 10
img_cache thumbnailnumericpart int4 10
img_image _createdby_key int4 10
img_image _image_key int4 10
img_image _imageclass_key int4 10
img_image _imagetype_key int4 10
img_image _mgitype_key int4 10
img_image _modifiedby_key int4 10
img_image _refs_key int4 10
img_image _thumbnailimage_key int4 10  √  null
img_image creation_date timestamp 29,6
img_image figurelabel varchar 255
img_image modification_date timestamp 29,6
img_image xdim int4 10  √  null
img_image ydim int4 10  √  null
img_imagepane _image_key int4 10
img_imagepane _imagepane_key int4 10
img_imagepane creation_date timestamp 29,6
img_imagepane modification_date timestamp 29,6
img_imagepane panelabel varchar 255  √  null
img_imagepane_assoc _assoc_key int4 10
img_imagepane_assoc _createdby_key int4 10
img_imagepane_assoc _imagepane_key int4 10
img_imagepane_assoc _mgitype_key int4 10
img_imagepane_assoc _modifiedby_key int4 10
img_imagepane_assoc _object_key int4 10
img_imagepane_assoc creation_date timestamp 29,6
img_imagepane_assoc isprimary int2 5
img_imagepane_assoc modification_date timestamp 29,6
map_coord_collection _collection_key int4 10
map_coord_collection _createdby_key int4 10
map_coord_collection _modifiedby_key int4 10
map_coord_collection abbreviation varchar 255
map_coord_collection creation_date timestamp 29,6
map_coord_collection modification_date timestamp 29,6
map_coord_collection name varchar 255
map_coord_feature _createdby_key int4 10
map_coord_feature _feature_key int4 10
map_coord_feature _map_key int4 10
map_coord_feature _mgitype_key int4 10
map_coord_feature _modifiedby_key int4 10
map_coord_feature _object_key int4 10
map_coord_feature creation_date timestamp 29,6
map_coord_feature endcoordinate float8 17,17
map_coord_feature modification_date timestamp 29,6
map_coord_feature startcoordinate float8 17,17
map_coord_feature strand bpchar 1  √  null
map_coordinate _collection_key int4 10
map_coordinate _createdby_key int4 10
map_coordinate _map_key int4 10
map_coordinate _maptype_key int4 10
map_coordinate _mgitype_key int4 10  √  null
map_coordinate _modifiedby_key int4 10
map_coordinate _object_key int4 10  √  null
map_coordinate _units_key int4 10
map_coordinate abbreviation varchar 255  √  null
map_coordinate creation_date timestamp 29,6
map_coordinate length int4 10
map_coordinate modification_date timestamp 29,6
map_coordinate name varchar 255  √  null
map_coordinate sequencenum int4 10
map_coordinate version varchar 255  √  null
mgi_attributehistory _createdby_key int4 10
mgi_attributehistory _mgitype_key int4 10
mgi_attributehistory _modifiedby_key int4 10
mgi_attributehistory _object_key int4 10
mgi_attributehistory columnname varchar 30
mgi_attributehistory creation_date timestamp 29,6
mgi_attributehistory modification_date timestamp 29,6
mgi_columns column_name varchar 30
mgi_columns creation_date timestamp 29,6
mgi_columns description varchar 255  √  null
mgi_columns example varchar 255  √  null
mgi_columns modification_date timestamp 29,6
mgi_columns table_name varchar 30
mgi_dbinfo creation_date timestamp 29,6
mgi_dbinfo lastdump_date timestamp 29,6
mgi_dbinfo modification_date timestamp 29,6
mgi_dbinfo product_name varchar 30
mgi_dbinfo public_version varchar 30
mgi_dbinfo schema_version varchar 30
mgi_dbinfo snp_data_version varchar 30
mgi_dbinfo snp_schema_version varchar 30
mgi_measurement _statistic_key int4 10
mgi_measurement floatvalue float8 17,17  √  null
mgi_measurement intvalue int4 10  √  null
mgi_measurement islatest int4 10
mgi_measurement timerecorded timestamp 29,6
mgi_note _createdby_key int4 10
mgi_note _mgitype_key int4 10
mgi_note _modifiedby_key int4 10
mgi_note _note_key int4 10
mgi_note _notetype_key int4 10
mgi_note _object_key int4 10
mgi_note creation_date timestamp 29,6
mgi_note modification_date timestamp 29,6
mgi_notechunk _createdby_key int4 10
mgi_notechunk _modifiedby_key int4 10
mgi_notechunk _note_key int4 10
mgi_notechunk creation_date timestamp 29,6
mgi_notechunk modification_date timestamp 29,6
mgi_notechunk note bpchar 255
mgi_notechunk sequencenum int4 10
mgi_notetype _createdby_key int4 10
mgi_notetype _mgitype_key int4 10  √  null
mgi_notetype _modifiedby_key int4 10
mgi_notetype _notetype_key int4 10
mgi_notetype creation_date timestamp 29,6
mgi_notetype modification_date timestamp 29,6
mgi_notetype notetype varchar 255
mgi_notetype private int2 5
mgi_organism _createdby_key int4 10
mgi_organism _modifiedby_key int4 10
mgi_organism _organism_key int4 10
mgi_organism commonname varchar 50
mgi_organism creation_date timestamp 29,6
mgi_organism latinname varchar 50  √  null
mgi_organism modification_date timestamp 29,6
mgi_organism_mgitype _createdby_key int4 10
mgi_organism_mgitype _mgitype_key int4 10
mgi_organism_mgitype _modifiedby_key int4 10
mgi_organism_mgitype _organism_key int4 10
mgi_organism_mgitype creation_date timestamp 29,6
mgi_organism_mgitype modification_date timestamp 29,6
mgi_refassoctype _createdby_key int4 10
mgi_refassoctype _mgitype_key int4 10  √  null
mgi_refassoctype _modifiedby_key int4 10
mgi_refassoctype _refassoctype_key int4 10
mgi_refassoctype allowonlyone int2 5
mgi_refassoctype assoctype varchar 255
mgi_refassoctype creation_date timestamp 29,6
mgi_refassoctype modification_date timestamp 29,6
mgi_reference_assoc _assoc_key int4 10
mgi_reference_assoc _createdby_key int4 10
mgi_reference_assoc _mgitype_key int4 10
mgi_reference_assoc _modifiedby_key int4 10
mgi_reference_assoc _object_key int4 10
mgi_reference_assoc _refassoctype_key int4 10
mgi_reference_assoc _refs_key int4 10
mgi_reference_assoc creation_date timestamp 29,6
mgi_reference_assoc modification_date timestamp 29,6
mgi_roletask _createdby_key int4 10
mgi_roletask _modifiedby_key int4 10
mgi_roletask _role_key int4 10
mgi_roletask _roletask_key int4 10
mgi_roletask _task_key int4 10
mgi_roletask creation_date timestamp 29,6
mgi_roletask modification_date timestamp 29,6
mgi_set _createdby_key int4 10
mgi_set _mgitype_key int4 10
mgi_set _modifiedby_key int4 10
mgi_set _set_key int4 10
mgi_set creation_date timestamp 29,6
mgi_set modification_date timestamp 29,6
mgi_set name varchar 255
mgi_set sequencenum int4 10
mgi_setmember _createdby_key int4 10
mgi_setmember _modifiedby_key int4 10
mgi_setmember _object_key int4 10
mgi_setmember _set_key int4 10
mgi_setmember _setmember_key int4 10
mgi_setmember creation_date timestamp 29,6
mgi_setmember modification_date timestamp 29,6
mgi_setmember sequencenum int4 10
mgi_statistic _statistic_key int4 10
mgi_statistic abbreviation varchar 30
mgi_statistic definition varchar 255  √  null
mgi_statistic hasintvalue int2 5  √  null
mgi_statistic isprivate int2 5
mgi_statistic name varchar 255
mgi_statisticsql _statistic_key int4 10
mgi_statisticsql sequencenum int4 10
mgi_statisticsql sqlchunk varchar 255
mgi_synonym _createdby_key int4 10
mgi_synonym _mgitype_key int4 10
mgi_synonym _modifiedby_key int4 10
mgi_synonym _object_key int4 10
mgi_synonym _refs_key int4 10  √  null
mgi_synonym _synonym_key int4 10
mgi_synonym _synonymtype_key int4 10
mgi_synonym creation_date timestamp 29,6
mgi_synonym modification_date timestamp 29,6
mgi_synonym synonym varchar 255
mgi_synonymtype _createdby_key int4 10
mgi_synonymtype _mgitype_key int4 10  √  null
mgi_synonymtype _modifiedby_key int4 10
mgi_synonymtype _organism_key int4 10  √  null
mgi_synonymtype _synonymtype_key int4 10
mgi_synonymtype allowonlyone int2 5
mgi_synonymtype creation_date timestamp 29,6
mgi_synonymtype definition varchar 255  √  null
mgi_synonymtype modification_date timestamp 29,6
mgi_synonymtype synonymtype varchar 255
mgi_tables _loadedby_key int4 10  √  null
mgi_tables creation_date timestamp 29,6
mgi_tables description text 2147483647  √  null
mgi_tables loaded_date timestamp 29,6  √  null
mgi_tables modification_date timestamp 29,6
mgi_tables table_name varchar 30
mgi_translation _createdby_key int4 10
mgi_translation _modifiedby_key int4 10
mgi_translation _object_key int4 10
mgi_translation _translation_key int4 10
mgi_translation _translationtype_key int4 10
mgi_translation badname varchar 255
mgi_translation creation_date timestamp 29,6
mgi_translation modification_date timestamp 29,6
mgi_translation sequencenum int4 10
mgi_translationtype _createdby_key int4 10
mgi_translationtype _mgitype_key int4 10
mgi_translationtype _modifiedby_key int4 10
mgi_translationtype _translationtype_key int4 10
mgi_translationtype _vocab_key int4 10  √  null
mgi_translationtype compressionchars varchar 50  √  null
mgi_translationtype creation_date timestamp 29,6
mgi_translationtype modification_date timestamp 29,6
mgi_translationtype regularexpression int2 5
mgi_translationtype translationtype varchar 255
mgi_user _createdby_key int4 10
mgi_user _modifiedby_key int4 10
mgi_user _user_key int4 10
mgi_user _userstatus_key int4 10
mgi_user _usertype_key int4 10
mgi_user creation_date timestamp 29,6
mgi_user login varchar 30
mgi_user modification_date timestamp 29,6
mgi_user name varchar 255
mgi_userrole _createdby_key int4 10
mgi_userrole _modifiedby_key int4 10
mgi_userrole _role_key int4 10
mgi_userrole _user_key int4 10
mgi_userrole _userrole_key int4 10
mgi_userrole creation_date timestamp 29,6
mgi_userrole modification_date timestamp 29,6
mgi_vocassociation _association_key int4 10
mgi_vocassociation _associationtype_key int4 10
mgi_vocassociation _createdby_key int4 10
mgi_vocassociation _modifiedby_key int4 10
mgi_vocassociation _term_key_1 int4 10
mgi_vocassociation _term_key_2 int4 10
mgi_vocassociation creation_date timestamp 29,6
mgi_vocassociation modification_date timestamp 29,6
mgi_vocassociation sequencenum int4 10
mgi_vocassociationtype _associationtype_key int4 10
mgi_vocassociationtype _createdby_key int4 10
mgi_vocassociationtype _modifiedby_key int4 10
mgi_vocassociationtype _vocab_key_1 int4 10  √  null
mgi_vocassociationtype _vocab_key_2 int4 10  √  null
mgi_vocassociationtype associationtype varchar 255
mgi_vocassociationtype creation_date timestamp 29,6
mgi_vocassociationtype definition varchar 255  √  null
mgi_vocassociationtype modification_date timestamp 29,6
mlc_marker _marker_key int4 10
mlc_marker _marker_key_2 int4 10
mlc_marker creation_date timestamp 29,6
mlc_marker modification_date timestamp 29,6
mlc_marker tag int4 10
mlc_reference _marker_key int4 10
mlc_reference _refs_key int4 10
mlc_reference creation_date timestamp 29,6
mlc_reference modification_date timestamp 29,6
mlc_reference tag int4 10
mlc_text _marker_key int4 10
mlc_text creation_date timestamp 29,6
mlc_text description text 2147483647  √  null
mlc_text isdeleted int2 5
mlc_text mode varchar 60  √  null
mlc_text modification_date timestamp 29,6
mlc_text userid varchar 30
mld_assay_types _assay_type_key int4 10
mld_assay_types creation_date timestamp 29,6
mld_assay_types description varchar 80
mld_assay_types modification_date timestamp 29,6
mld_concordance _expt_key int4 10
mld_concordance _marker_key int4 10  √  null
mld_concordance chromosome varchar 8  √  null
mld_concordance cnn int4 10
mld_concordance cnp int4 10
mld_concordance cpn int4 10
mld_concordance cpp int4 10
mld_concordance creation_date timestamp 29,6
mld_concordance modification_date timestamp 29,6
mld_concordance sequencenum int4 10
mld_contig _contig_key int4 10
mld_contig _expt_key int4 10
mld_contig creation_date timestamp 29,6
mld_contig maxcm float8 17,17  √  null
mld_contig mincm float8 17,17  √  null
mld_contig minlink int4 10  √  null
mld_contig modification_date timestamp 29,6
mld_contig name varchar 20  √  null
mld_contigprobe _contig_key int4 10
mld_contigprobe _probe_key int4 10
mld_contigprobe creation_date timestamp 29,6
mld_contigprobe modification_date timestamp 29,6
mld_contigprobe sequencenum int4 10
mld_distance _expt_key int4 10
mld_distance _marker_key_1 int4 10
mld_distance _marker_key_2 int4 10
mld_distance creation_date timestamp 29,6
mld_distance endonuclease varchar 20  √  null
mld_distance estdistance varchar 20  √  null
mld_distance minfrag varchar 20  √  null
mld_distance modification_date timestamp 29,6
mld_distance notes varchar 255  √  null
mld_distance realisticdist int2 5  √  null
mld_distance relativearrangecharstr varchar 15  √  null
mld_distance sequencenum int4 10
mld_distance units int2 5
mld_expt_marker _allele_key int4 10  √  null
mld_expt_marker _assay_type_key int4 10
mld_expt_marker _expt_key int4 10
mld_expt_marker _marker_key int4 10
mld_expt_marker creation_date timestamp 29,6
mld_expt_marker description varchar 255  √  null
mld_expt_marker gene varchar 50  √  null
mld_expt_marker matrixdata int2 5
mld_expt_marker modification_date timestamp 29,6
mld_expt_marker sequencenum int4 10
mld_expt_notes _expt_key int4 10
mld_expt_notes creation_date timestamp 29,6
mld_expt_notes modification_date timestamp 29,6
mld_expt_notes note bpchar 255
mld_expt_notes sequencenum int4 10
mld_expts _expt_key int4 10
mld_expts _refs_key int4 10
mld_expts chromosome varchar 8
mld_expts creation_date timestamp 29,6
mld_expts expttype varchar 255
mld_expts modification_date timestamp 29,6
mld_expts tag int4 10
mld_fish _expt_key int4 10
mld_fish _strain_key int4 10
mld_fish band varchar 50  √  null
mld_fish cellorigin varchar 30  √  null
mld_fish creation_date timestamp 29,6
mld_fish karyotype varchar 30  √  null
mld_fish label varchar 50  √  null
mld_fish modification_date timestamp 29,6
mld_fish nummetaphase int4 10  √  null
mld_fish robertsonians varchar 255  √  null
mld_fish totaldouble int4 10  √  null
mld_fish totalsingle int4 10  √  null
mld_fish_region _expt_key int4 10
mld_fish_region creation_date timestamp 29,6
mld_fish_region modification_date timestamp 29,6
mld_fish_region region varchar 10  √  null
mld_fish_region sequencenum int4 10
mld_fish_region totaldouble int4 10  √  null
mld_fish_region totalsingle int4 10  √  null
mld_hit _expt_key int4 10
mld_hit _probe_key int4 10
mld_hit _target_key int4 10
mld_hit creation_date timestamp 29,6
mld_hit modification_date timestamp 29,6
mld_hybrid _expt_key int4 10
mld_hybrid band varchar 50  √  null
mld_hybrid chrsorgenes int2 5
mld_hybrid creation_date timestamp 29,6
mld_hybrid modification_date timestamp 29,6
mld_insitu _expt_key int4 10
mld_insitu _strain_key int4 10
mld_insitu band varchar 50  √  null
mld_insitu cellorigin varchar 30  √  null
mld_insitu creation_date timestamp 29,6
mld_insitu grainsonchrom int4 10  √  null
mld_insitu grainsotherchrom int4 10  √  null
mld_insitu karyotype varchar 30  √  null
mld_insitu modification_date timestamp 29,6
mld_insitu nummetaphase int4 10  √  null
mld_insitu robertsonians varchar 255  √  null
mld_insitu totalgrains int4 10  √  null
mld_isregion _expt_key int4 10
mld_isregion creation_date timestamp 29,6
mld_isregion graincount int4 10
mld_isregion modification_date timestamp 29,6
mld_isregion region varchar 10  √  null
mld_isregion sequencenum int4 10
mld_matrix _cross_key int4 10
mld_matrix _expt_key int4 10
mld_matrix creation_date timestamp 29,6
mld_matrix female varchar 255  √  null
mld_matrix female2 varchar 255  √  null
mld_matrix male varchar 255  √  null
mld_matrix male2 varchar 255  √  null
mld_matrix modification_date timestamp 29,6
mld_mc2point _expt_key int4 10
mld_mc2point _marker_key_1 int4 10
mld_mc2point _marker_key_2 int4 10
mld_mc2point creation_date timestamp 29,6
mld_mc2point modification_date timestamp 29,6
mld_mc2point numparentals int4 10
mld_mc2point numrecombinants int4 10
mld_mc2point sequencenum int4 10
mld_mcdatalist _expt_key int4 10
mld_mcdatalist alleleline varchar 255
mld_mcdatalist creation_date timestamp 29,6
mld_mcdatalist modification_date timestamp 29,6
mld_mcdatalist offspringnmbr int4 10
mld_mcdatalist sequencenum int4 10
mld_notes _refs_key int4 10
mld_notes creation_date timestamp 29,6
mld_notes modification_date timestamp 29,6
mld_notes note bpchar 255
mld_notes sequencenum int4 10
mld_physmap _expt_key int4 10
mld_physmap creation_date timestamp 29,6
mld_physmap definitiveorder int2 5
mld_physmap geneorder varchar 255  √  null
mld_physmap modification_date timestamp 29,6
mld_ri _expt_key int4 10
mld_ri _riset_key int4 10
mld_ri creation_date timestamp 29,6
mld_ri modification_date timestamp 29,6
mld_ri ri_idlist varchar 255
mld_ri2point _expt_key int4 10
mld_ri2point _marker_key_1 int4 10
mld_ri2point _marker_key_2 int4 10
mld_ri2point creation_date timestamp 29,6
mld_ri2point modification_date timestamp 29,6
mld_ri2point numrecombinants int4 10
mld_ri2point numtotal int4 10
mld_ri2point ri_lines varchar 255  √  null
mld_ri2point sequencenum int4 10
mld_ridata _expt_key int4 10
mld_ridata _marker_key int4 10
mld_ridata alleleline varchar 255
mld_ridata creation_date timestamp 29,6
mld_ridata modification_date timestamp 29,6
mld_ridata sequencenum int4 10
mld_statistics _expt_key int4 10
mld_statistics _marker_key_1 int4 10
mld_statistics _marker_key_2 int4 10
mld_statistics creation_date timestamp 29,6
mld_statistics modification_date timestamp 29,6
mld_statistics pcntrecomb float8 17,17
mld_statistics recomb int4 10
mld_statistics sequencenum int4 10
mld_statistics stderr float8 17,17
mld_statistics total int4 10
mrk_alias _alias_key int4 10
mrk_alias _marker_key int4 10
mrk_alias creation_date timestamp 29,6
mrk_alias modification_date timestamp 29,6
mrk_anchors _marker_key int4 10
mrk_anchors chromosome varchar 8
mrk_anchors creation_date timestamp 29,6
mrk_anchors modification_date timestamp 29,6
mrk_chromosome _chromosome_key int4 10
mrk_chromosome _createdby_key int4 10
mrk_chromosome _modifiedby_key int4 10
mrk_chromosome _organism_key int4 10
mrk_chromosome chromosome varchar 8
mrk_chromosome creation_date timestamp 29,6
mrk_chromosome modification_date timestamp 29,6
mrk_chromosome sequencenum int4 10
mrk_class _class_key int4 10
mrk_class creation_date timestamp 29,6
mrk_class modification_date timestamp 29,6
mrk_class name varchar 60
mrk_classes _class_key int4 10
mrk_classes _marker_key int4 10
mrk_classes creation_date timestamp 29,6
mrk_classes modification_date timestamp 29,6
mrk_current _current_key int4 10
mrk_current _marker_key int4 10
mrk_current creation_date timestamp 29,6
mrk_current modification_date timestamp 29,6
mrk_event _marker_event_key int4 10
mrk_event creation_date timestamp 29,6
mrk_event event varchar 255
mrk_event modification_date timestamp 29,6
mrk_eventreason _marker_eventreason_key int4 10
mrk_eventreason creation_date timestamp 29,6
mrk_eventreason eventreason varchar 255
mrk_eventreason modification_date timestamp 29,6
mrk_history _createdby_key int4 10
mrk_history _history_key int4 10
mrk_history _marker_event_key int4 10
mrk_history _marker_eventreason_key int4 10
mrk_history _marker_key int4 10
mrk_history _modifiedby_key int4 10
mrk_history _refs_key int4 10  √  null
mrk_history creation_date timestamp 29,6
mrk_history event_date timestamp 29,6  √  null
mrk_history modification_date timestamp 29,6
mrk_history name varchar 255  √  null
mrk_history sequencenum int4 10
mrk_homology_cache _cache_key int4 10
mrk_homology_cache _class_key int4 10
mrk_homology_cache _homology_key int4 10
mrk_homology_cache _marker_key int4 10
mrk_homology_cache _organism_key int4 10
mrk_homology_cache _refs_key int4 10
mrk_label _label_key int4 10
mrk_label _label_status_key int4 10
mrk_label _marker_key int4 10
mrk_label _organism_key int4 10
mrk_label _orthologorganism_key int4 10  √  null
mrk_label creation_date timestamp 29,6
mrk_label label varchar 255
mrk_label labeltype varchar 5
mrk_label labeltypename varchar 255
mrk_label modification_date timestamp 29,6
mrk_label priority int4 10
mrk_location_cache _cache_key int4 10
mrk_location_cache _createdby_key int4 10
mrk_location_cache _marker_key int4 10
mrk_location_cache _marker_type_key int4 10
mrk_location_cache _modifiedby_key int4 10
mrk_location_cache chromosome varchar 8
mrk_location_cache cmoffset float8 17,17
mrk_location_cache creation_date timestamp 29,6
mrk_location_cache cytogeneticoffset varchar 20  √  null
mrk_location_cache endcoordinate float8 17,17  √  null
mrk_location_cache mapunits varchar 50  √  null
mrk_location_cache modification_date timestamp 29,6
mrk_location_cache provider varchar 255  √  null
mrk_location_cache sequencenum int4 10
mrk_location_cache startcoordinate float8 17,17  √  null
mrk_location_cache strand bpchar 1  √  null
mrk_location_cache version varchar 255  √  null
mrk_marker _createdby_key int4 10
mrk_marker _curationstate_key int4 10
mrk_marker _marker_key int4 10
mrk_marker _marker_status_key int4 10
mrk_marker _marker_type_key int4 10
mrk_marker _modifiedby_key int4 10
mrk_marker _organism_key int4 10
mrk_marker chromosome varchar 8
mrk_marker creation_date timestamp 29,6
mrk_marker cytogeneticoffset varchar 20  √  null
mrk_marker modification_date timestamp 29,6
mrk_marker name varchar 255
mrk_marker symbol varchar 50
mrk_mcv_cache _createdby_key int4 10
mrk_mcv_cache _marker_key int4 10
mrk_mcv_cache _mcvterm_key int4 10
mrk_mcv_cache _modifiedby_key int4 10
mrk_mcv_cache creation_date timestamp 29,6
mrk_mcv_cache directterms varchar 255
mrk_mcv_cache modification_date timestamp 29,6
mrk_mcv_cache qualifier bpchar 1
mrk_mcv_cache term varchar 50
mrk_mcv_count_cache _createdby_key int4 10
mrk_mcv_count_cache _mcvterm_key int4 10
mrk_mcv_count_cache _modifiedby_key int4 10
mrk_mcv_count_cache creation_date timestamp 29,6
mrk_mcv_count_cache markercount int4 10
mrk_mcv_count_cache modification_date timestamp 29,6
mrk_notes _marker_key int4 10
mrk_notes creation_date timestamp 29,6
mrk_notes modification_date timestamp 29,6
mrk_notes note bpchar 255
mrk_notes sequencenum int4 10
mrk_offset _marker_key int4 10
mrk_offset cmoffset float8 17,17
mrk_offset creation_date timestamp 29,6
mrk_offset modification_date timestamp 29,6
mrk_offset source int4 10
mrk_omim_cache _allele_key int4 10  √  null
mrk_omim_cache _cache_key int4 10
mrk_omim_cache _genotype_key int4 10  √  null
mrk_omim_cache _marker_key int4 10  √  null
mrk_omim_cache _marker_type_key int4 10  √  null
mrk_omim_cache _organism_key int4 10
mrk_omim_cache _orthologmarker_key int4 10  √  null
mrk_omim_cache _orthologorganism_key int4 10  √  null
mrk_omim_cache _refs_key int4 10
mrk_omim_cache _term_key int4 10
mrk_omim_cache allelesymbol varchar 60  √  null
mrk_omim_cache creation_date timestamp 29,6
mrk_omim_cache genotypedisplay1 varchar 255  √  null
mrk_omim_cache genotypedisplay2 varchar 100  √  null
mrk_omim_cache genotypefootnote varchar 255  √  null
mrk_omim_cache header varchar 150  √  null
mrk_omim_cache headerfootnote varchar 200  √  null
mrk_omim_cache jnumid varchar 30
mrk_omim_cache markersymbol varchar 50
mrk_omim_cache modification_date timestamp 29,6
mrk_omim_cache omimcategory1 int4 10
mrk_omim_cache omimcategory2 int4 10
mrk_omim_cache omimcategory3 int4 10
mrk_omim_cache orthologsymbol varchar 50  √  null
mrk_omim_cache qualifier varchar 50  √  null
mrk_omim_cache sequencenum int4 10  √  null
mrk_omim_cache strain varchar 255  √  null
mrk_omim_cache term varchar 255
mrk_omim_cache termid varchar 30
mrk_reference _marker_key int4 10
mrk_reference _refs_key int4 10
mrk_reference creation_date timestamp 29,6
mrk_reference jnum int4 10
mrk_reference jnumid varchar 30
mrk_reference mgiid varchar 30
mrk_reference modification_date timestamp 29,6
mrk_reference pubmedid varchar 30  √  null
mrk_status _marker_status_key int4 10
mrk_status creation_date timestamp 29,6
mrk_status modification_date timestamp 29,6
mrk_status status varchar 255
mrk_types _marker_type_key int4 10
mrk_types creation_date timestamp 29,6
mrk_types modification_date timestamp 29,6
mrk_types name varchar 80
prb_alias _alias_key int4 10
prb_alias _createdby_key int4 10
prb_alias _modifiedby_key int4 10
prb_alias _reference_key int4 10
prb_alias alias varchar 30
prb_alias creation_date timestamp 29,6
prb_alias modification_date timestamp 29,6
prb_allele _allele_key int4 10
prb_allele _createdby_key int4 10
prb_allele _modifiedby_key int4 10
prb_allele _rflv_key int4 10
prb_allele allele varchar 30
prb_allele creation_date timestamp 29,6
prb_allele fragments varchar 255
prb_allele modification_date timestamp 29,6
prb_allele_strain _allele_key int4 10
prb_allele_strain _createdby_key int4 10
prb_allele_strain _modifiedby_key int4 10
prb_allele_strain _strain_key int4 10
prb_allele_strain creation_date timestamp 29,6
prb_allele_strain modification_date timestamp 29,6
prb_marker _createdby_key int4 10
prb_marker _marker_key int4 10
prb_marker _modifiedby_key int4 10
prb_marker _probe_key int4 10
prb_marker _refs_key int4 10
prb_marker creation_date timestamp 29,6
prb_marker modification_date timestamp 29,6
prb_marker relationship bpchar 1  √  null
prb_notes _probe_key int4 10
prb_notes creation_date timestamp 29,6
prb_notes modification_date timestamp 29,6
prb_notes note bpchar 255
prb_notes sequencenum int4 10
prb_probe _createdby_key int4 10
prb_probe _modifiedby_key int4 10
prb_probe _probe_key int4 10
prb_probe _segmenttype_key int4 10
prb_probe _source_key int4 10
prb_probe _vector_key int4 10
prb_probe creation_date timestamp 29,6
prb_probe derivedfrom int4 10  √  null
prb_probe insertsite varchar 30  √  null
prb_probe insertsize varchar 30  √  null
prb_probe modification_date timestamp 29,6
prb_probe name varchar 40
prb_probe primer1sequence varchar 80  √  null
prb_probe primer2sequence varchar 80  √  null
prb_probe productsize varchar 40  √  null
prb_probe regioncovered varchar 255  √  null
prb_ref_notes _reference_key int4 10
prb_ref_notes creation_date timestamp 29,6
prb_ref_notes modification_date timestamp 29,6
prb_ref_notes note bpchar 255
prb_ref_notes sequencenum int4 10
prb_reference _createdby_key int4 10
prb_reference _modifiedby_key int4 10
prb_reference _probe_key int4 10
prb_reference _reference_key int4 10
prb_reference _refs_key int4 10
prb_reference creation_date timestamp 29,6
prb_reference hasrmap int2 5
prb_reference hassequence int2 5  √  null
prb_reference modification_date timestamp 29,6
prb_rflv _createdby_key int4 10
prb_rflv _marker_key int4 10
prb_rflv _modifiedby_key int4 10
prb_rflv _reference_key int4 10
prb_rflv _rflv_key int4 10
prb_rflv creation_date timestamp 29,6
prb_rflv endonuclease varchar 15  √  null
prb_rflv modification_date timestamp 29,6
prb_source _cellline_key int4 10
prb_source _createdby_key int4 10
prb_source _gender_key int4 10
prb_source _modifiedby_key int4 10
prb_source _organism_key int4 10
prb_source _refs_key int4 10  √  null
prb_source _segmenttype_key int4 10
prb_source _source_key int4 10
prb_source _strain_key int4 10
prb_source _tissue_key int4 10
prb_source _vector_key int4 10
prb_source age varchar 50
prb_source agemax float8 17,17
prb_source agemin float8 17,17
prb_source creation_date timestamp 29,6
prb_source description varchar 255  √  null
prb_source iscuratoredited int2 5
prb_source modification_date timestamp 29,6
prb_source name varchar 255  √  null
prb_strain _createdby_key int4 10
prb_strain _modifiedby_key int4 10
prb_strain _species_key int4 10
prb_strain _strain_key int4 10
prb_strain _straintype_key int4 10
prb_strain creation_date timestamp 29,6
prb_strain modification_date timestamp 29,6
prb_strain private int2 5  √  null
prb_strain standard int2 5
prb_strain strain varchar 255
prb_strain_genotype _createdby_key int4 10
prb_strain_genotype _genotype_key int4 10
prb_strain_genotype _modifiedby_key int4 10
prb_strain_genotype _qualifier_key int4 10
prb_strain_genotype _strain_key int4 10
prb_strain_genotype _straingenotype_key int4 10
prb_strain_genotype creation_date timestamp 29,6
prb_strain_genotype modification_date timestamp 29,6
prb_strain_marker _allele_key int4 10  √  null
prb_strain_marker _createdby_key int4 10
prb_strain_marker _marker_key int4 10  √  null
prb_strain_marker _modifiedby_key int4 10
prb_strain_marker _qualifier_key int4 10  √  null
prb_strain_marker _strain_key int4 10
prb_strain_marker _strainmarker_key int4 10
prb_strain_marker creation_date timestamp 29,6
prb_strain_marker modification_date timestamp 29,6
prb_tissue _tissue_key int4 10
prb_tissue creation_date timestamp 29,6
prb_tissue modification_date timestamp 29,6
prb_tissue standard int2 5
prb_tissue tissue varchar 80
ri_riset _riset_key int4 10
ri_riset _strain_key_1 int4 10
ri_riset _strain_key_2 int4 10
ri_riset abbrev1 varchar 4
ri_riset abbrev2 varchar 4
ri_riset creation_date timestamp 29,6
ri_riset designation varchar 15
ri_riset modification_date timestamp 29,6
ri_riset ri_idlist varchar 255
ri_summary _marker_key int4 10
ri_summary _riset_key int4 10
ri_summary _risummary_key int4 10
ri_summary creation_date timestamp 29,6
ri_summary modification_date timestamp 29,6
ri_summary summary varchar 255
ri_summary_expt_ref _expt_key int4 10
ri_summary_expt_ref _refs_key int4 10
ri_summary_expt_ref _risummary_key int4 10
ri_summary_expt_ref creation_date timestamp 29,6
ri_summary_expt_ref modification_date timestamp 29,6
seq_allele_assoc _allele_key int4 10
seq_allele_assoc _assoc_key int4 10
seq_allele_assoc _createdby_key int4 10
seq_allele_assoc _modifiedby_key int4 10
seq_allele_assoc _qualifier_key int4 10
seq_allele_assoc _refs_key int4 10
seq_allele_assoc _sequence_key int4 10
seq_allele_assoc creation_date timestamp 29,6
seq_allele_assoc modification_date timestamp 29,6
seq_coord_cache _createdby_key int4 10
seq_coord_cache _map_key int4 10
seq_coord_cache _modifiedby_key int4 10
seq_coord_cache _sequence_key int4 10
seq_coord_cache chromosome varchar 8
seq_coord_cache creation_date timestamp 29,6
seq_coord_cache endcoordinate float8 17,17
seq_coord_cache mapunits varchar 50
seq_coord_cache modification_date timestamp 29,6
seq_coord_cache provider varchar 255
seq_coord_cache startcoordinate float8 17,17
seq_coord_cache strand bpchar 1
seq_coord_cache version varchar 255
seq_description_cache _createdby_key int4 10
seq_description_cache _modifiedby_key int4 10
seq_description_cache _sequence_key int4 10
seq_description_cache creation_date timestamp 29,6
seq_description_cache description varchar 255
seq_description_cache modification_date timestamp 29,6
seq_genemodel _createdby_key int4 10
seq_genemodel _gmmarker_type_key int4 10  √  null
seq_genemodel _modifiedby_key int4 10
seq_genemodel _sequence_key int4 10
seq_genemodel creation_date timestamp 29,6
seq_genemodel exoncount int4 10  √  null
seq_genemodel modification_date timestamp 29,6
seq_genemodel rawbiotype varchar 255  √  null
seq_genemodel transcriptcount int4 10  √  null
seq_genetrap _createdby_key int4 10
seq_genetrap _modifiedby_key int4 10
seq_genetrap _reversecomp_key int4 10
seq_genetrap _sequence_key int4 10
seq_genetrap _tagmethod_key int4 10
seq_genetrap _vectorend_key int4 10
seq_genetrap creation_date timestamp 29,6
seq_genetrap goodhitcount int4 10  √  null
seq_genetrap modification_date timestamp 29,6
seq_genetrap pointcoordinate float8 17,17  √  null
seq_marker_cache _biotypeconflict_key int4 10
seq_marker_cache _cache_key int4 10
seq_marker_cache _createdby_key int4 10
seq_marker_cache _logicaldb_key int4 10
seq_marker_cache _marker_key int4 10
seq_marker_cache _marker_type_key int4 10
seq_marker_cache _modifiedby_key int4 10
seq_marker_cache _organism_key int4 10
seq_marker_cache _qualifier_key int4 10
seq_marker_cache _refs_key int4 10
seq_marker_cache _sequence_key int4 10
seq_marker_cache _sequenceprovider_key int4 10
seq_marker_cache _sequencetype_key int4 10
seq_marker_cache accid varchar 30
seq_marker_cache annotation_date timestamp 29,6
seq_marker_cache creation_date timestamp 29,6
seq_marker_cache modification_date timestamp 29,6
seq_marker_cache rawbiotype varchar 255  √  null
seq_probe_cache _createdby_key int4 10
seq_probe_cache _modifiedby_key int4 10
seq_probe_cache _probe_key int4 10
seq_probe_cache _refs_key int4 10
seq_probe_cache _sequence_key int4 10
seq_probe_cache annotation_date timestamp 29,6
seq_probe_cache creation_date timestamp 29,6
seq_probe_cache modification_date timestamp 29,6
seq_sequence _createdby_key int4 10
seq_sequence _modifiedby_key int4 10
seq_sequence _organism_key int4 10
seq_sequence _sequence_key int4 10
seq_sequence _sequenceprovider_key int4 10
seq_sequence _sequencequality_key int4 10
seq_sequence _sequencestatus_key int4 10
seq_sequence _sequencetype_key int4 10
seq_sequence creation_date timestamp 29,6
seq_sequence description varchar 255  √  null
seq_sequence division bpchar 3  √  null
seq_sequence length int4 10  √  null
seq_sequence modification_date timestamp 29,6
seq_sequence numberoforganisms int4 10  √  null
seq_sequence seqrecord_date timestamp 29,6
seq_sequence sequence_date timestamp 29,6
seq_sequence version varchar 15  √  null
seq_sequence virtual int2 5
seq_sequence_assoc _assoc_key int4 10
seq_sequence_assoc _createdby_key int4 10
seq_sequence_assoc _modifiedby_key int4 10
seq_sequence_assoc _qualifier_key int4 10
seq_sequence_assoc _sequence_key_1 int4 10
seq_sequence_assoc _sequence_key_2 int4 10
seq_sequence_assoc creation_date timestamp 29,6
seq_sequence_assoc modification_date timestamp 29,6
seq_sequence_raw _createdby_key int4 10
seq_sequence_raw _modifiedby_key int4 10
seq_sequence_raw _sequence_key int4 10
seq_sequence_raw creation_date timestamp 29,6
seq_sequence_raw modification_date timestamp 29,6
seq_sequence_raw rawage varchar 100  √  null
seq_sequence_raw rawcellline varchar 100  √  null
seq_sequence_raw rawlibrary varchar 255  √  null
seq_sequence_raw raworganism varchar 255  √  null
seq_sequence_raw rawsex varchar 100  √  null
seq_sequence_raw rawstrain varchar 255  √  null
seq_sequence_raw rawtissue varchar 255  √  null
seq_sequence_raw rawtype varchar 15  √  null
seq_source_assoc _assoc_key int4 10
seq_source_assoc _createdby_key int4 10
seq_source_assoc _modifiedby_key int4 10
seq_source_assoc _sequence_key int4 10
seq_source_assoc _source_key int4 10
seq_source_assoc creation_date timestamp 29,6
seq_source_assoc modification_date timestamp 29,6
voc_allele_cache _allele_key int4 10
voc_allele_cache _term_key int4 10
voc_allele_cache annottype varchar 60
voc_annot _annot_key int4 10
voc_annot _annottype_key int4 10
voc_annot _object_key int4 10
voc_annot _qualifier_key int4 10
voc_annot _term_key int4 10
voc_annot creation_date timestamp 29,6
voc_annot modification_date timestamp 29,6
voc_annot_count_cache _mgitype_key int4 10
voc_annot_count_cache _term_key int4 10
voc_annot_count_cache annotcount int4 10
voc_annot_count_cache annottype varchar 30
voc_annot_count_cache objectcount int4 10
voc_annotheader _annotheader_key int4 10
voc_annotheader _annottype_key int4 10
voc_annotheader _approvedby_key int4 10  √  null
voc_annotheader _createdby_key int4 10
voc_annotheader _modifiedby_key int4 10
voc_annotheader _object_key int4 10
voc_annotheader _term_key int4 10
voc_annotheader approval_date timestamp 29,6  √  null
voc_annotheader creation_date timestamp 29,6
voc_annotheader isnormal int2 5
voc_annotheader modification_date timestamp 29,6
voc_annotheader sequencenum int4 10
voc_annottype _annottype_key int4 10
voc_annottype _evidencevocab_key int4 10
voc_annottype _mgitype_key int4 10
voc_annottype _qualifiervocab_key int4 10
voc_annottype _vocab_key int4 10
voc_annottype creation_date timestamp 29,6
voc_annottype modification_date timestamp 29,6
voc_annottype name varchar 255
voc_evidence _annot_key int4 10
voc_evidence _annotevidence_key int4 10
voc_evidence _createdby_key int4 10
voc_evidence _evidenceterm_key int4 10
voc_evidence _modifiedby_key int4 10
voc_evidence _refs_key int4 10
voc_evidence creation_date timestamp 29,6
voc_evidence inferredfrom varchar 255  √  null
voc_evidence modification_date timestamp 29,6
voc_evidence_property _annotevidence_key int4 10
voc_evidence_property _createdby_key int4 10
voc_evidence_property _evidenceproperty_key int4 10
voc_evidence_property _modifiedby_key int4 10
voc_evidence_property _propertyterm_key int4 10
voc_evidence_property creation_date timestamp 29,6
voc_evidence_property modification_date timestamp 29,6
voc_evidence_property sequencenum int4 10
voc_evidence_property stanza int4 10
voc_evidence_property value varchar 255
voc_go_cache _dag_key int4 10
voc_go_cache _term_key int4 10
voc_go_cache accid varchar 30
voc_go_cache dagabbrev bpchar 5
voc_go_cache term varchar 255
voc_marker_cache _marker_key int4 10
voc_marker_cache _term_key int4 10
voc_marker_cache annottype varchar 30
voc_term _createdby_key int4 10
voc_term _modifiedby_key int4 10
voc_term _term_key int4 10
voc_term _vocab_key int4 10
voc_term abbreviation varchar 255  √  null
voc_term creation_date timestamp 29,6
voc_term isobsolete int2 5
voc_term modification_date timestamp 29,6
voc_term sequencenum int4 10  √  null
voc_term term varchar 255  √  null
voc_text _term_key int4 10
voc_text creation_date timestamp 29,6
voc_text modification_date timestamp 29,6
voc_text note bpchar 255
voc_text sequencenum int4 10
voc_vocab _logicaldb_key int4 10
voc_vocab _refs_key int4 10
voc_vocab _vocab_key int4 10
voc_vocab creation_date timestamp 29,6
voc_vocab isprivate int2 5  √  null
voc_vocab issimple int2 5
voc_vocab modification_date timestamp 29,6
voc_vocab name varchar 255
voc_vocabdag _dag_key int4 10
voc_vocabdag _vocab_key int4 10
voc_vocabdag creation_date timestamp 29,6
voc_vocabdag modification_date timestamp 29,6
wks_rosetta _marker_key int4 10  √  null
wks_rosetta _rosetta_key int4 10
wks_rosetta creation_date timestamp 29,6
wks_rosetta modification_date timestamp 29,6
wks_rosetta wks_markersymbol varchar 50  √  null
wks_rosetta wks_markerurl varchar 100  √  null