| SchemaSpy Analysis of mgd.mgd - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on Mon Sep 26 19:11 EDT 2011 |
| ||||||
|
| |||||||
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 |
