Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
SchemaSpy Analysis of pub.mgd - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Sep 11 06:12 EDT 2023
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

pub.mgd contains 3404 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
acc_accession _accession_key int4 10 primary key
acc_accession _createdby_key int4 10 1001 user who created the record
acc_accession _logicaldb_key int4 10 foreign key to ACC_LogicalDB
acc_accession _mgitype_key int4 10 foreign key to ACC_MGIType
acc_accession _modifiedby_key int4 10 1001 user who last modified the record
acc_accession _object_key int4 10 foreign key to any object defined in ACC_MGIType
acc_accession accid text 2147483647 the full accession number string
acc_accession creation_date timestamp 29,6 now() date record was created
acc_accession modification_date timestamp 29,6 now() date record was last modified
acc_accession numericpart int4 10  √  null the trailing numerical portion of accID
acc_accession preferred int2 5 flags accession number as preferred/primary (1) or not preferred/secondary (0). there can only be one preferred accession number for logical database MGI. The default is 1.
acc_accession prefixpart text 2147483647  √  null the leading non-numerical portion of accID
acc_accession private int2 5 is this accession number private? yes (1), no (0)
acc_accessionmax creation_date timestamp 29,6 now() date record was created
acc_accessionmax maxnumericpart int4 10 the current maximum numeric value for the accession number series designated by prefixPart
acc_accessionmax modification_date timestamp 29,6 now() date record was last modified
acc_accessionmax prefixpart text 2147483647 primary key; the leading non-numerical portion of an MGI accID ("MGI:" or "J:")
acc_accessionreference _accession_key int4 10 primary key of the Accession number to which the Reference refers
acc_accessionreference _createdby_key int4 10 1001 user who created the record
acc_accessionreference _modifiedby_key int4 10 1001 user who last modified the record
acc_accessionreference _refs_key int4 10 foreign key to BIB_Refs
acc_accessionreference creation_date timestamp 29,6 now() date record was created
acc_accessionreference modification_date timestamp 29,6 now() date record was last modified
acc_actualdb _actualdb_key serial 10  √  nextval('acc_actualdb_seq'::regclass) primary key
acc_actualdb _createdby_key int4 10 1001 user who created the record
acc_actualdb _logicaldb_key int4 10 foreign key to ACC_LogicalDB
acc_actualdb _modifiedby_key int4 10 1001 user who last modified the record
acc_actualdb active int2 5 should the link be constructed? yes (1), no (0)
acc_actualdb allowsmultiple int2 5 does the URL support a query using more than one accession number? yes (1), no (0)
acc_actualdb creation_date timestamp 29,6 now() date record was created
acc_actualdb delimiter bpchar 8  √  null the delimiter which separates multiple accession numbers; used when construcuting the full URL.
acc_actualdb modification_date timestamp 29,6 now() date record was last modified
acc_actualdb name text 2147483647 name of the actual database; the HTML label that appears in the WI
acc_actualdb url text 2147483647 template of the URL; includes place holder string of '@@@@'. during construction of the full URL, the '@@@@' will be replaced by the appropriate term (accession number, symbol, etc.)
acc_logicaldb _createdby_key int4 10 1001 user who created the record
acc_logicaldb _logicaldb_key serial 10  √  nextval('acc_logicaldb_seq'::regclass) primary key
acc_logicaldb _modifiedby_key int4 10 1001 user who last modified the record
acc_logicaldb _organism_key int4 10  √  null organism (foreign key to MGI_Organism)
acc_logicaldb creation_date timestamp 29,6 now() date record was created
acc_logicaldb description text 2147483647  √  null brief description of the logical entity
acc_logicaldb modification_date timestamp 29,6 now() date record was last modified
acc_logicaldb name text 2147483647 name of the logical entity
acc_mgitype _createdby_key int4 10 1001 user who created the record
acc_mgitype _mgitype_key int4 10 primary key
acc_mgitype _modifiedby_key int4 10 1001 user who last modified the record
acc_mgitype creation_date timestamp 29,6 now() date record was created
acc_mgitype dbview text 2147483647  √  null table summary view
acc_mgitype identitycolumnname text 2147483647  √  null name of the primary key column of tableName
acc_mgitype modification_date timestamp 29,6 now() date record was last modified
acc_mgitype name text 2147483647 name of the accessionable object type
acc_mgitype primarykeyname text 2147483647 primary key name for the accessionable object type
acc_mgitype tablename text 2147483647 master/primary table for the accessionable object type
acc_view _accession_key int4 10  √  null
acc_view _createdby_key int4 10  √  null
acc_view _logicaldb_key int4 10  √  null
acc_view _mgitype_key int4 10  √  null
acc_view _modifiedby_key int4 10  √  null
acc_view _object_key int4 10  √  null
acc_view _organism_key int4 10  √  null
acc_view accid text 2147483647  √  null
acc_view actualdb text 2147483647  √  null
acc_view allowsmultiple int2 5  √  null
acc_view creation_date timestamp 29,6  √  null
acc_view delimiter bpchar 8  √  null
acc_view description text 2147483647  √  null
acc_view logicaldb text 2147483647  √  null
acc_view mgitype text 2147483647  √  null
acc_view modification_date timestamp 29,6  √  null
acc_view numericpart int4 10  √  null
acc_view preferred int2 5  √  null
acc_view prefixpart text 2147483647  √  null
acc_view private int2 5  √  null
acc_view url text 2147483647  √  null
all_acc_view _accession_key int4 10  √  null
all_acc_view _createdby_key int4 10  √  null
all_acc_view _logicaldb_key int4 10  √  null
all_acc_view _mgitype_key int4 10  √  null
all_acc_view _modifiedby_key int4 10  √  null
all_acc_view _object_key int4 10  √  null
all_acc_view accid text 2147483647  √  null
all_acc_view creation_date timestamp 29,6  √  null
all_acc_view logicaldb text 2147483647  √  null
all_acc_view modification_date timestamp 29,6  √  null
all_acc_view numericpart int4 10  √  null
all_acc_view preferred int2 5  √  null
all_acc_view prefixpart text 2147483647  √  null
all_acc_view private int2 5  √  null
all_allele _allele_key serial 10  √  nextval('all_allele_seq'::regclass) primary key
all_allele _allele_status_key int4 10 foreign key to VOC_Term where _Vocab_key = 37 (Allele Status); 'In Progress', 'Deleted', 'Reserved', 'Approved', 'Autoload'
all_allele _allele_type_key int4 10 foreign key to VOC_Term where _Vocab_key = 38 (Allele Type); 'Spontaneous', 'Targeted', 'Gene trapped'
all_allele _approvedby_key int4 10  √  null user who approved record (foreign key to MGI_User)
all_allele _collection_key int4 10 foreign key to VOC_Term where _Vocab_key = 92
(Allele Collection); 'KOMP-CSD', 'NorCOMM', 'EUCOMM'
all_allele _createdby_key int4 10 1001 user who created the record
all_allele _marker_key int4 10  √  null foreign key to MRK_Marker; foreign key to ALL_Marker_Assoc
all_allele _markerallele_status_key int4 10
all_allele _mode_key int4 10 foreign key to VOC_Term where _Vocab_key = 35 (Allele Inheritance Mode); 'Semidominant', 'Codominant'
all_allele _modifiedby_key int4 10 1001 user who last modified the record
all_allele _refs_key int4 10  √  null
all_allele _strain_key int4 10 foreign key to PRB_Strain; the Strain Of Origin; for Transgenes this is the Strain fro which the mutation was made
all_allele _transmission_key int4 10 foreign key to VOC_Term where _Vocab_key = 61 (Allele Transmission); 'Germline', 'Cell Line', 'Chimeric'
all_allele approval_date timestamp 29,6  √  now() date record was statused as "Approved"
all_allele creation_date timestamp 29,6 now() date record was created
all_allele isextinct int2 5 if 1 (yes), then the Allele is extinct, else 0
all_allele ismixed int2 5 if 1 (yes), then the Allele is mixed (from both male and female mice), else 0
all_allele iswildtype int2 5 if 1, Allele is a wild type allele, else 0
all_allele modification_date timestamp 29,6 now() date record was last modified
all_allele name text 2147483647 Allele Name
all_allele symbol text 2147483647 Allele Symbol; includes the Marker symbol
all_allele_cellline _allele_key int4 10 foreign key to ALL_Allele
all_allele_cellline _assoc_key serial 10  √  nextval('all_allele_cellline_seq'::regclass) primary key
all_allele_cellline _createdby_key int4 10 1001 user who created the record
all_allele_cellline _modifiedby_key int4 10 1001 user who last modified the record
all_allele_cellline _mutantcellline_key int4 10 foreign key to ALL_CellLine
all_allele_cellline creation_date timestamp 29,6 now() date record was created
all_allele_cellline modification_date timestamp 29,6 now() date record was last modified
all_allele_cellline_view _allele_key int4 10  √  null
all_allele_cellline_view _assoc_key int4 10  √  null
all_allele_cellline_view _createdby_key int4 10  √  null
all_allele_cellline_view _creator_key int4 10  √  null
all_allele_cellline_view _modifiedby_key int4 10  √  null
all_allele_cellline_view _mutantcellline_key int4 10  √  null
all_allele_cellline_view _vector_key int4 10  √  null
all_allele_cellline_view cellline text 2147483647  √  null
all_allele_cellline_view celllinestrain text 2147483647  √  null
all_allele_cellline_view celllinestrain_key int4 10  √  null
all_allele_cellline_view createdby text 2147483647  √  null
all_allele_cellline_view creation_date timestamp 29,6  √  null
all_allele_cellline_view creator text 2147483647  √  null
all_allele_cellline_view derivationkey int4 10  √  null
all_allele_cellline_view derivationname text 2147483647  √  null
all_allele_cellline_view ismutant int2 5  √  null
all_allele_cellline_view modification_date timestamp 29,6  √  null
all_allele_cellline_view modifiedby text 2147483647  √  null
all_allele_cellline_view parentcellline text 2147483647  √  null
all_allele_cellline_view parentcellline_key int4 10  √  null
all_allele_cellline_view parentcelllinetype_key int4 10  √  null
all_allele_cellline_view symbol text 2147483647  √  null
all_allele_cellline_view vector text 2147483647  √  null
all_allele_driver_view _allele_key int4 10  √  null
all_allele_driver_view _marker_key int4 10  √  null
all_allele_driver_view _organism_key int4 10  √  null
all_allele_driver_view _relationship_key int4 10  √  null
all_allele_driver_view commonname text 2147483647  √  null
all_allele_driver_view symbol text 2147483647  √  null
all_allele_mutation _allele_key int4 10 foreign key to ALL_Allele
all_allele_mutation _assoc_key serial 10  √  nextval('all_allele_mutation_seq'::regclass)
all_allele_mutation _mutation_key int4 10 foreign key to ALL_Molecular_Mutation
all_allele_mutation creation_date timestamp 29,6 now() date record was created
all_allele_mutation modification_date timestamp 29,6 now() date record was last modified
all_allele_mutation_view _allele_key int4 10  √  null
all_allele_mutation_view _assoc_key int4 10  √  null
all_allele_mutation_view _mutation_key int4 10  √  null
all_allele_mutation_view creation_date timestamp 29,6  √  null
all_allele_mutation_view modification_date timestamp 29,6  √  null
all_allele_mutation_view mutation text 2147483647  √  null
all_allele_subtype_view _allele_key int4 10  √  null
all_allele_subtype_view _annot_key int4 10  √  null
all_allele_subtype_view _annottype_key int4 10  √  null
all_allele_subtype_view _object_key int4 10  √  null
all_allele_subtype_view _qualifier_key int4 10  √  null
all_allele_subtype_view _term_key int4 10  √  null
all_allele_subtype_view creation_date timestamp 29,6  √  null
all_allele_subtype_view modification_date timestamp 29,6  √  null
all_allele_subtype_view term text 2147483647  √  null
all_allele_view _allele_key int4 10  √  null
all_allele_view _allele_status_key int4 10  √  null
all_allele_view _allele_type_key int4 10  √  null
all_allele_view _approvedby_key int4 10  √  null
all_allele_view _collection_key int4 10  √  null
all_allele_view _createdby_key int4 10  √  null
all_allele_view _marker_key int4 10  √  null
all_allele_view _markerallele_status_key int4 10  √  null
all_allele_view _mode_key int4 10  √  null
all_allele_view _modifiedby_key int4 10  √  null
all_allele_view _refs_key int4 10  √  null
all_allele_view _strain_key int4 10  √  null
all_allele_view _transmission_key int4 10  √  null
all_allele_view approval_date timestamp 29,6  √  null
all_allele_view approvedby text 2147483647  √  null
all_allele_view citation text 2147483647  √  null
all_allele_view collection text 2147483647  √  null
all_allele_view createdby text 2147483647  √  null
all_allele_view creation_date timestamp 29,6  √  null
all_allele_view isextinct int2 5  √  null
all_allele_view ismixed int2 5  √  null
all_allele_view iswildtype int2 5  √  null
all_allele_view jnum int4 10  √  null
all_allele_view jnumid text 2147483647  √  null
all_allele_view markerallele_status text 2147483647  √  null
all_allele_view markersymbol text 2147483647  √  null
all_allele_view modification_date timestamp 29,6  √  null
all_allele_view modifiedby text 2147483647  √  null
all_allele_view name text 2147483647  √  null
all_allele_view short_citation text 2147483647  √  null
all_allele_view statusnum int4 10  √  null
all_allele_view strain text 2147483647  √  null
all_allele_view symbol text 2147483647  √  null
all_allele_view term text 2147483647  √  null
all_annot_view _allele_key int4 10  √  null
all_annot_view _annot_key int4 10  √  null
all_annot_view _annottype_key int4 10  √  null
all_annot_view _qualifier_key int4 10  √  null
all_cellline _cellline_key serial 10  √  nextval('all_cellline_seq'::regclass) primary key
all_cellline _cellline_type_key int4 10 foreign key to VOC_Term where _Vocab_key = 63 (Cell Line Type)
all_cellline _createdby_key int4 10 1001 user who created the record
all_cellline _derivation_key int4 10  √  null foreign key to ALL_CellLine_Derivation
all_cellline _modifiedby_key int4 10 1001 user who last modified the record
all_cellline _strain_key int4 10 foreign key to PRB_Strain
all_cellline cellline text 2147483647 ES cell line
all_cellline creation_date timestamp 29,6 now() date record was created
all_cellline ismutant int2 5 if 1, then this ES Cell line is a Mutant, else Parental
all_cellline modification_date timestamp 29,6 now() date record was last modified
all_cellline_acc_view _accession_key int4 10  √  null
all_cellline_acc_view _createdby_key int4 10  √  null
all_cellline_acc_view _logicaldb_key int4 10  √  null
all_cellline_acc_view _mgitype_key int4 10  √  null
all_cellline_acc_view _modifiedby_key int4 10  √  null
all_cellline_acc_view _object_key int4 10  √  null
all_cellline_acc_view accid text 2147483647  √  null
all_cellline_acc_view creation_date timestamp 29,6  √  null
all_cellline_acc_view logicaldb text 2147483647  √  null
all_cellline_acc_view modification_date timestamp 29,6  √  null
all_cellline_acc_view numericpart int4 10  √  null
all_cellline_acc_view preferred int2 5  √  null
all_cellline_acc_view prefixpart text 2147483647  √  null
all_cellline_acc_view private int2 5  √  null
all_cellline_derivation _createdby_key int4 10 1001 user who created the record
all_cellline_derivation _creator_key int4 10 foreign key to VOC_Term where _Vocab_key = 62 (Cell Line Creator)
all_cellline_derivation _derivation_key serial 10  √  nextval('all_cellline_derivation_seq'::regclass) primary key
all_cellline_derivation _derivationtype_key int4 10 foreign key to VOC_Term where _Vocab_key = 38 (Allele Type)
all_cellline_derivation _modifiedby_key int4 10 1001 user who last modified the record
all_cellline_derivation _parentcellline_key int4 10 foreign key to ALL_CellLine
all_cellline_derivation _refs_key int4 10  √  null foreign key to BIB_Refs
all_cellline_derivation _vector_key int4 10 foreign key to VOC_Term where _Vocab_key = = 72 (Cell Line Vector Name)
all_cellline_derivation _vectortype_key int4 10 foreign key to VOC_Term where _Vocab_key = 64 (Cell Line Vector Type)
all_cellline_derivation creation_date timestamp 29,6 now() date record was created
all_cellline_derivation description text 2147483647  √  null longer name
all_cellline_derivation modification_date timestamp 29,6 now() date record was last modified
all_cellline_derivation name text 2147483647  √  null Cell Line Library Name
all_cellline_derivation_view _createdby_key int4 10  √  null
all_cellline_derivation_view _creator_key int4 10  √  null
all_cellline_derivation_view _derivation_key int4 10  √  null
all_cellline_derivation_view _derivationtype_key int4 10  √  null
all_cellline_derivation_view _modifiedby_key int4 10  √  null
all_cellline_derivation_view _parentcellline_key int4 10  √  null
all_cellline_derivation_view _refs_key int4 10  √  null
all_cellline_derivation_view _vector_key int4 10  √  null
all_cellline_derivation_view _vectortype_key int4 10  √  null
all_cellline_derivation_view createdby text 2147483647  √  null
all_cellline_derivation_view creation_date timestamp 29,6  √  null
all_cellline_derivation_view creator text 2147483647  √  null
all_cellline_derivation_view description text 2147483647  √  null
all_cellline_derivation_view jnum int4 10  √  null
all_cellline_derivation_view jnumid text 2147483647  √  null
all_cellline_derivation_view modification_date timestamp 29,6  √  null
all_cellline_derivation_view modifiedby text 2147483647  √  null
all_cellline_derivation_view name text 2147483647  √  null
all_cellline_derivation_view parentcellline text 2147483647  √  null
all_cellline_derivation_view parentcellline_key int4 10  √  null
all_cellline_derivation_view parentcelllinestrain text 2147483647  √  null
all_cellline_derivation_view parentcelllinestrain_key int4 10  √  null
all_cellline_derivation_view parentcelllinetype text 2147483647  √  null
all_cellline_derivation_view parentcelllinetype_key int4 10  √  null
all_cellline_derivation_view short_citation text 2147483647  √  null
all_cellline_derivation_view vector text 2147483647  √  null
all_cellline_derivation_view vectortype text 2147483647  √  null
all_cellline_view _cellline_key int4 10  √  null
all_cellline_view _cellline_type_key int4 10  √  null
all_cellline_view _createdby_key int4 10  √  null
all_cellline_view _creator_key int4 10  √  null
all_cellline_view _derivation_key int4 10  √  null
all_cellline_view _derivationtype_key int4 10  √  null
all_cellline_view _modifiedby_key int4 10  √  null
all_cellline_view _strain_key int4 10  √  null
all_cellline_view _vector_key int4 10  √  null
all_cellline_view _vectortype_key int4 10  √  null
all_cellline_view cellline text 2147483647  √  null
all_cellline_view celllinestrain text 2147483647  √  null
all_cellline_view celllinetype text 2147483647  √  null
all_cellline_view createdby text 2147483647  √  null
all_cellline_view creation_date timestamp 29,6  √  null
all_cellline_view creator text 2147483647  √  null
all_cellline_view derivationname text 2147483647  √  null
all_cellline_view ismutant int2 5  √  null
all_cellline_view modification_date timestamp 29,6  √  null
all_cellline_view modifiedby text 2147483647  √  null
all_cellline_view parentcellline text 2147483647  √  null
all_cellline_view parentcellline_key int4 10  √  null
all_cellline_view parentcelllinestrain text 2147483647  √  null
all_cellline_view parentcelllinestrain_key int4 10  √  null
all_cellline_view vector text 2147483647  √  null
all_cellline_view vectortype text 2147483647  √  null
all_cre_cache _allele_key int4 10 foreign key to ALL_Allele
all_cre_cache _allele_type_key int4 10 foreign key to VOC_Term where _Vocab_key = 38 (Allele Type)
all_cre_cache _assay_key int4 10  √  null foreign key to GXD_Assay
all_cre_cache _cache_key int4 10 primary key
all_cre_cache _celltype_term_key int4 10  √  null foreign key to VOC_Term where _Vocab_key = 102 (Cell Ontology)
all_cre_cache _createdby_key int4 10 1001 user who created the record
all_cre_cache _emapa_term_key int4 10  √  null foreign key to VOC_Term where _Vocab_key = 90 (EMAPA)
all_cre_cache _modifiedby_key int4 10 1001 user who last modified the record
all_cre_cache _stage_key int4 10  √  null foreign key to GXD_TheilerStage
all_cre_cache accid text 2147483647 accession id
all_cre_cache age text 2147483647  √  null age of anatomical structure
all_cre_cache agemax numeric 131089  √  null maximum age value determined by age field
all_cre_cache agemin numeric 131089  √  null minimum age value determined by age field
all_cre_cache alleletype text 2147483647 allele type name (VOC_Term.term) via ALL_Allele._AlleleType_key = VOC_Term._Term_key
all_cre_cache creation_date timestamp 29,6 now() date record was created
all_cre_cache cresystemlabel text 2147483647  √  null Cre System Label
all_cre_cache drivernote text 2147483647 MGI_Relationship._Object_key_2 (marker) where _Category_key = 1006
all_cre_cache emapaterm text 2147483647  √  null term from VOC_Term where _Vocab_key = 90
all_cre_cache expressed int4 10  √  null if 1 (true), then this Assay is expressing this Structure, else 0
all_cre_cache hasimage int4 10  √  null does this record have an image?
all_cre_cache modification_date timestamp 29,6 now() date record was last modified
all_cre_cache name text 2147483647 Allele name
all_cre_cache strength text 2147483647  √  null
all_cre_cache symbol text 2147483647 Allele symbol
all_genotype_view _allele_key int4 10  √  null
all_genotype_view _genotype_key int4 10  √  null
all_knockout_cache _allele_key int4 10  √  null foreign key to ALL_Allele
all_knockout_cache _createdby_key int4 10 1001 user who created the record
all_knockout_cache _knockout_key int4 10 primary key
all_knockout_cache _marker_key int4 10 foreign key to MRK_Marker
all_knockout_cache _modifiedby_key int4 10 1001 user who last modified the record
all_knockout_cache companyid text 2147483647  √  null the company ID of the knockout (the Deltagen or Lexicon ID)
all_knockout_cache creation_date timestamp 29,6 now() date record was created
all_knockout_cache holder text 2147483647 the holder of the knockout (Deltagen or Lexicon)
all_knockout_cache jrsid text 2147483647  √  null the Jax Registry ID (JRS) of the knockout
all_knockout_cache modification_date timestamp 29,6 now() date record was last modified
all_knockout_cache nihid text 2147483647  √  null the NIH ID of the knockout
all_knockout_cache repository text 2147483647 the repository from which this knockout is available (JAX or MMRRC)
all_label _allele_key int4 10 foreign key to ALL_Allele
all_label _label_status_key int4 10 1 = current, 2 = old
all_label creation_date timestamp 29,6 now() date record was created
all_label label text 2147483647 label type (N, S, Y)
all_label labeltype text 2147483647 specifies if label is current symbol, current name, allele symbol, allele name, etc.
all_label labeltypename text 2147483647 label (name, symbol, synonym)
all_label modification_date timestamp 29,6 now() date record was last modified
all_label priority int4 10 an integer representing the priority of this record for sorting purposes. the higher the number, the higher the priority.
all_summary_view _accession_key int4 10  √  null
all_summary_view _createdby_key int4 10  √  null
all_summary_view _logicaldb_key int4 10  √  null
all_summary_view _mgitype_key int4 10  √  null
all_summary_view _modifiedby_key int4 10  √  null
all_summary_view _object_key int4 10  √  null
all_summary_view accid text 2147483647  √  null
all_summary_view creation_date timestamp 29,6  √  null
all_summary_view description text 2147483647  √  null
all_summary_view mgiid text 2147483647  √  null
all_summary_view modification_date timestamp 29,6  √  null
all_summary_view numericpart int4 10  √  null
all_summary_view preferred int2 5  √  null
all_summary_view prefixpart text 2147483647  √  null
all_summary_view private int2 5  √  null
all_summary_view short_description text 2147483647  √  null
all_summary_view subtype text 2147483647  √  null
all_summarybymarker_view _allele_key int4 10  √  null
all_summarybymarker_view accid text 2147483647  √  null
all_summarybymarker_view allelestatus text 2147483647  √  null
all_summarybymarker_view diseaseannots text 2147483647  √  null
all_summarybymarker_view mpannots text 2147483647  √  null
all_summarybymarker_view symbol text 2147483647  √  null
all_summarybymarker_view transmission text 2147483647  √  null
all_summarybyreference_view _allele_key int4 10  √  null
all_summarybyreference_view accid text 2147483647  √  null
all_summarybyreference_view allelestatus text 2147483647  √  null
all_summarybyreference_view alleletype text 2147483647  √  null
all_summarybyreference_view diseaseannots text 2147483647  √  null
all_summarybyreference_view jnumid text 2147483647  √  null
all_summarybyreference_view mpannots text 2147483647  √  null
all_summarybyreference_view symbol text 2147483647  √  null
all_summarybyreference_view transmission text 2147483647  √  null
all_variant _allele_key int4 10 foreign key to ALL_Allele, identifies the allele for this variant
all_variant _createdby_key int4 10 1001 user who created the record
all_variant _modifiedby_key int4 10 1001 user who last modified the record
all_variant _sourcevariant_key int4 10  √  null null if this is a source (as reported) variant record; foreign key to ALL_Variant to identify the source variant, if this is a curated record
all_variant _strain_key int4 10 foreign key to PRB_Strain, identifies the strain with this variant
all_variant _variant_key serial 10  √  nextval('all_variant_seq'::regclass) primary key, uniquely identifying the record
all_variant creation_date timestamp 29,6 now() date record was created
all_variant description text 2147483647  √  null text description of this variant
all_variant isreviewed int2 5 has this variant been reviewed by a curator (1) or not (0)?
all_variant modification_date timestamp 29,6 now() date record was last modified
all_variant_sequence _createdby_key int4 10 1001 user who created the record
all_variant_sequence _modifiedby_key int4 10 1001 user who last modified the record
all_variant_sequence _sequence_type_key int4 10 foreign key to VOC_Term, identifies the type of this sequence (_Vocab_key = 21)
all_variant_sequence _variant_key int4 10 foreign key to ALL_Variant_Variant, identifying the variant with this sequence
all_variant_sequence _variantsequence_key serial 10  √  nextval('all_variantsequence_seq'::regclass) primary key, uniquely identifying the record
all_variant_sequence creation_date timestamp 29,6 now() date record was created
all_variant_sequence endcoordinate numeric 131089  √  null
all_variant_sequence modification_date timestamp 29,6 now() date record was last modified
all_variant_sequence referencesequence text 2147483647  √  null text string identifying the reference (non-variant) version of this sequence
all_variant_sequence startcoordinate numeric 131089  √  null
all_variant_sequence variantsequence text 2147483647  √  null text string identifying the variant version of this sequence
all_variant_sequence version text 2147483647  √  null
bib_acc_view _accession_key int4 10  √  null
bib_acc_view _createdby_key int4 10  √  null
bib_acc_view _logicaldb_key int4 10  √  null
bib_acc_view _mgitype_key int4 10  √  null
bib_acc_view _modifiedby_key int4 10  √  null
bib_acc_view _object_key int4 10  √  null
bib_acc_view accid text 2147483647  √  null
bib_acc_view creation_date timestamp 29,6  √  null
bib_acc_view logicaldb text 2147483647  √  null
bib_acc_view modification_date timestamp 29,6  √  null
bib_acc_view numericpart int4 10  √  null
bib_acc_view preferred int2 5  √  null
bib_acc_view prefixpart text 2147483647  √  null
bib_acc_view private int2 5  √  null
bib_all_view _createdby_key int4 10  √  null
bib_all_view _modifiedby_key int4 10  √  null
bib_all_view _primary text 2147483647  √  null
bib_all_view _referencetype_key int4 10  √  null
bib_all_view _refs_key int4 10  √  null
bib_all_view abstract text 2147483647  √  null
bib_all_view authors text 2147483647  √  null
bib_all_view citation text 2147483647  √  null
bib_all_view creation_date timestamp 29,6  √  null
bib_all_view date text 2147483647  √  null
bib_all_view isreviewarticle int2 5  √  null
bib_all_view issue text 2147483647  √  null
bib_all_view jnum int4 10  √  null
bib_all_view jnumid text 2147483647  √  null
bib_all_view journal text 2147483647  √  null
bib_all_view modification_date timestamp 29,6  √  null
bib_all_view pgs text 2147483647  √  null
bib_all_view referencetype text 2147483647  √  null
bib_all_view short_citation text 2147483647  √  null
bib_all_view title text 2147483647  √  null
bib_all_view vol text 2147483647  √  null
bib_all_view year int4 10  √  null
bib_associateddata_view _refs_key int4 10  √  null
bib_associateddata_view has_alleles int4 10  √  null
bib_associateddata_view has_antibodies int4 10  √  null
bib_associateddata_view has_genotype int4 10  √  null
bib_associateddata_view has_go int4 10  √  null
bib_associateddata_view has_gxdimages int4 10  √  null
bib_associateddata_view has_gxdindex int4 10  √  null
bib_associateddata_view has_gxdresults int4 10  √  null
bib_associateddata_view has_gxdspecimens int4 10  √  null
bib_associateddata_view has_mapping int4 10  √  null
bib_associateddata_view has_markers int4 10  √  null
bib_associateddata_view has_probes int4 10  √  null
bib_associateddata_view has_strain int4 10  √  null
bib_books _refs_key int4 10 foreign key to BIB_Refs
bib_books book_au text 2147483647  √  null author
bib_books book_title text 2147483647  √  null title
bib_books creation_date timestamp 29,6 now() date record was created
bib_books modification_date timestamp 29,6 now() date record was last modified
bib_books place text 2147483647  √  null publisher location
bib_books publisher text 2147483647  √  null publisher name
bib_books series_ed text 2147483647  √  null edition/series
bib_citation_cache _refs_key int4 10 foreign key to BIB_Refs
bib_citation_cache _relevance_key int4 10 foreign key to VOC_Term._Vocab_key = 149
bib_citation_cache citation text 2147483647 long citation format
bib_citation_cache doiid text 2147483647  √  null DOI (digital object identifier) accession ID
bib_citation_cache isreviewarticle int2 5 is this a review article?
bib_citation_cache isreviewarticlestring bpchar 3 string representation of isReviewArticle
bib_citation_cache jnumid text 2147483647  √  null J: accession id
bib_citation_cache journal text 2147483647  √  null reference journal
bib_citation_cache mgiid text 2147483647 MGI accession id
bib_citation_cache numericpart int4 10  √  null the trailing numerical portion of accID
bib_citation_cache pubmedid text 2147483647  √  null pubmed accession ID
bib_citation_cache referencetype text 2147483647 term of foreign key to VOC_Term._Vocab_key = 131
bib_citation_cache relevanceterm text 2147483647 term of foreign key to VOC_Term._Vocab_key = 149
bib_citation_cache short_citation text 2147483647 short citation format
bib_goxref_view _marker_key int4 10  √  null
bib_goxref_view _refs_key int4 10  √  null
bib_goxref_view creation_date timestamp 29,6  √  null
bib_goxref_view jnum int4 10  √  null
bib_goxref_view jnumid text 2147483647  √  null
bib_goxref_view short_citation text 2147483647  √  null
bib_goxref_view title text 2147483647  √  null
bib_notes _refs_key int4 10 foreign key to BIB_Refs
bib_notes creation_date timestamp 29,6 now() date record was created
bib_notes modification_date timestamp 29,6 now() date record was last modified
bib_notes note text 2147483647 note
bib_refs _createdby_key int4 10 1001 user who created the record
bib_refs _modifiedby_key int4 10 1001 user who last modified the record
bib_refs _primary text 2147483647  √  null primary author; extracted from authors field
bib_refs _referencetype_key int4 10 foreign key to VOC_Term where _Vocab_key = 131 (Reference Type)
bib_refs _refs_key serial 10  √  nextval('bib_refs_seq'::regclass) primary key
bib_refs abstract text 2147483647  √  null NLM (Medline) abstract
bib_refs authors text 2147483647  √  null reference authors
bib_refs creation_date timestamp 29,6 now() date record was created
bib_refs date text 2147483647  √  null reference date
bib_refs isreviewarticle int2 5 is this a review article?
bib_refs issue text 2147483647  √  null reference issue
bib_refs journal text 2147483647  √  null reference journal
bib_refs modification_date timestamp 29,6 now() date record was last modified
bib_refs pgs text 2147483647  √  null page range of reference
bib_refs title text 2147483647  √  null reference title
bib_refs vol text 2147483647  √  null reference volume number
bib_refs year int4 10  √  null year of publication
bib_status_view _refs_key int4 10  √  null
bib_status_view ap_status text 2147483647  √  null
bib_status_view go_status text 2147483647  √  null
bib_status_view gxd_status text 2147483647  √  null
bib_status_view pro_status text 2147483647  √  null
bib_status_view qtl_status text 2147483647  √  null
bib_status_view tumor_status text 2147483647  √  null
bib_summary_view _refs_key int4 10  √  null
bib_summary_view _relevance_key int4 10  √  null
bib_summary_view abstract text 2147483647  √  null
bib_summary_view authors text 2147483647  √  null
bib_summary_view citation text 2147483647  √  null
bib_summary_view doiid text 2147483647  √  null
bib_summary_view has_alleles int4 10  √  null
bib_summary_view has_antibodies int4 10  √  null
bib_summary_view has_genotype int4 10  √  null
bib_summary_view has_gxdassays int4 10  √  null
bib_summary_view has_gxdimages int4 10  √  null
bib_summary_view has_gxdindex int4 10  √  null
bib_summary_view has_gxdresults int4 10  √  null
bib_summary_view has_gxdspecimens int4 10  √  null
bib_summary_view has_mapping int4 10  √  null
bib_summary_view has_markers int4 10  √  null
bib_summary_view has_probes int4 10  √  null
bib_summary_view isreviewarticle int2 5  √  null
bib_summary_view isreviewarticlestring bpchar 3  √  null
bib_summary_view jnumid text 2147483647  √  null
bib_summary_view journal text 2147483647  √  null
bib_summary_view mgiid text 2147483647  √  null
bib_summary_view numericpart int4 10  √  null
bib_summary_view pubmedid text 2147483647  √  null
bib_summary_view referencetype text 2147483647  √  null
bib_summary_view relevanceterm text 2147483647  √  null
bib_summary_view short_citation text 2147483647  √  null
bib_summary_view title text 2147483647  √  null
bib_summary_view vol text 2147483647  √  null
bib_summary_view year int4 10  √  null
bib_view _createdby_key int4 10  √  null
bib_view _modifiedby_key int4 10  √  null
bib_view _primary text 2147483647  √  null
bib_view _referencetype_key int4 10  √  null
bib_view _refs_key int4 10  √  null
bib_view abstract text 2147483647  √  null
bib_view authors text 2147483647  √  null
bib_view citation text 2147483647  √  null
bib_view createdby text 2147483647  √  null
bib_view creation_date timestamp 29,6  √  null
bib_view date text 2147483647  √  null
bib_view isreviewarticle int2 5  √  null
bib_view issue text 2147483647  √  null
bib_view jnum int4 10  √  null
bib_view jnumid text 2147483647  √  null
bib_view journal text 2147483647  √  null
bib_view modification_date timestamp 29,6  √  null
bib_view modifiedby text 2147483647  √  null
bib_view pgs text 2147483647  √  null
bib_view referencetype text 2147483647  √  null
bib_view short_citation text 2147483647  √  null
bib_view title text 2147483647  √  null
bib_view vol text 2147483647  √  null
bib_view year int4 10  √  null
bib_workflow_data _assoc_key serial 10  √  nextval('bib_workflow_data_seq'::regclass) primary key
bib_workflow_data _createdby_key int4 10 1001 user who created the record
bib_workflow_data _extractedtext_key int4 10 foreign key to VOC_Term where_Vocab_key = 142 (Lit Triage Extracted Text Section)
bib_workflow_data _modifiedby_key int4 10 1001 user who last modified the record
bib_workflow_data _refs_key int4 10 foreign key to BIB_Refs
bib_workflow_data _supplemental_key int4 10 foreign key to VOC_Term where_Vocab_key = 130 (Workflow Supplemental Status)
bib_workflow_data creation_date timestamp 29,6 now() date record was created
bib_workflow_data extractedtext text 2147483647  √  null PDF data that is saved as text per specific section
bib_workflow_data haspdf int2 5 0 does Reference have a PDF?
bib_workflow_data linksupplemental text 2147483647  √  null not used/can be removed
bib_workflow_data modification_date timestamp 29,6 now() date record was last modified
bib_workflow_relevance _assoc_key serial 10  √  nextval('bib_workflow_relevance_seq'::regclass) primary key
bib_workflow_relevance _createdby_key int4 10 1001 user who created the record
bib_workflow_relevance _modifiedby_key int4 10 1001 user who last modified the record
bib_workflow_relevance _refs_key int4 10 foreign key to BIB_Refs
bib_workflow_relevance _relevance_key int4 10 foreign key to VOC_Term where _Vocab_key = 149 (Workflow Relevance)
bib_workflow_relevance confidence float8 17,17  √  null confidence values of the predicted relevance classifier
bib_workflow_relevance creation_date timestamp 29,6 now() date record was created
bib_workflow_relevance iscurrent int2 5 1 if 1, then current Relevance for this Reference
bib_workflow_relevance modification_date timestamp 29,6 now() date record was last modified
bib_workflow_relevance version text 2147483647  √  null version of relevance classifier
bib_workflow_status _assoc_key serial 10  √  nextval('bib_workflow_status_seq'::regclass)
bib_workflow_status _createdby_key int4 10 1001 user who created the record
bib_workflow_status _group_key int4 10 foreign key to VOC_Term where _Vocab_key = 127 (Workflow Group)
bib_workflow_status _modifiedby_key int4 10 1001 user who last modified the record
bib_workflow_status _refs_key int4 10 foreign key to BIB_Refs
bib_workflow_status _status_key int4 10 foreign key to VOC_Term where _Vocab_key = 128 (Workflow Status)
bib_workflow_status creation_date timestamp 29,6 now() date record was created
bib_workflow_status iscurrent int2 5 1 if 1, then current Status for this Reference/Group
bib_workflow_status modification_date timestamp 29,6 now() date record was last modified
bib_workflow_tag _assoc_key serial 10  √  nextval('bib_workflow_tag_seq'::regclass)
bib_workflow_tag _createdby_key int4 10 1001 user who created the record
bib_workflow_tag _modifiedby_key int4 10 1001 user who last modified the record
bib_workflow_tag _refs_key int4 10 foreign key to BIB_Refs
bib_workflow_tag _tag_key int4 10 foreign key to VOC_Term where _Vocab_key = 129 (Workflow Tag)
bib_workflow_tag creation_date timestamp 29,6 now() date record was created
bib_workflow_tag modification_date timestamp 29,6 now() date record was last modified
crs_cross _cross_key int4 10 primary key
crs_cross _femalestrain_key int4 10 foreign key to PRB_Strain; maternal strain
crs_cross _malestrain_key int4 10 foreign key to PRB_Strain; paternal strain
crs_cross _strainho_key int4 10 foreign key to PRB_Strain; homozygous strain
crs_cross _strainht_key int4 10 foreign key to PRB_Strain; heterozygous strain
crs_cross abbrevho text 2147483647  √  null strain abbreviation for homozygous strain
crs_cross abbrevht text 2147483647  √  null strain abbreviation for heterozygous strain
crs_cross allelefromsegparent int2 5 is the allele from the segregating parent?
crs_cross creation_date timestamp 29,6 now() date record was created
crs_cross displayed int2 5 does this cross get displayed in the Cross Lookup list? yes (1), no (0)
crs_cross f1directionknown int2 5 is the F1 direction known?
crs_cross femaleallele1 bpchar 1  √  null first allele of maternal strain; used during construction of maternal genotype
crs_cross femaleallele2 bpchar 1  √  null second allele of maternal strain; used during construction of maternal genotype
crs_cross maleallele1 bpchar 1  √  null first allele of paternal strain; used during construction of paternal genotype
crs_cross maleallele2 bpchar 1  √  null second allele of paternal strain; used during construction of paternal genotype
crs_cross modification_date timestamp 29,6 now() date record was last modified
crs_cross nprogeny int4 10  √  null number of progeny resulting from cross
crs_cross type text 2147483647 type of cross
crs_cross whosecross text 2147483647  √  null if non-null, then name of cross. if null, then this is a one-time only anonymous cross.
crs_matrix _cross_key int4 10 foreign key to CRS_Cross
crs_matrix _marker_key int4 10  √  null foreign key to MRK_Marker
crs_matrix chromosome text 2147483647 chromosome on which Marker is located (may disagree with MGD)
crs_matrix creation_date timestamp 29,6 now() date record was created
crs_matrix modification_date timestamp 29,6 now() date record was last modified
crs_matrix notes text 2147483647  √  null notes
crs_matrix othersymbol text 2147483647  √  null symbol if not in MGD (and therefore _Marker_key is null)
crs_matrix rownumber int4 10 row number
crs_progeny _cross_key int4 10 foreign key to CRS_Cross
crs_progeny creation_date timestamp 29,6 now() date record was created
crs_progeny modification_date timestamp 29,6 now() date record was last modified
crs_progeny name text 2147483647  √  null progeny name
crs_progeny notes text 2147483647  √  null textual information
crs_progeny sequencenum int4 10 sequence number for ordering records
crs_progeny sex bpchar 1 sex of progeny (M, F)
crs_references _cross_key int4 10 foreign key to CRS_Cross
crs_references _marker_key int4 10 foreign key to MRK_Marker
crs_references _refs_key int4 10 foreign key to BIB_Refs
crs_references creation_date timestamp 29,6 now() date record was created
crs_references modification_date timestamp 29,6 now() date record was last modified
crs_typings _cross_key int4 10 foreign key to CRS_Cross
crs_typings colnumber int4 10 column number
crs_typings creation_date timestamp 29,6 now() date record was created
crs_typings data text 2147483647  √  null haplotype data
crs_typings modification_date timestamp 29,6 now() date record was last modified
crs_typings rownumber int4 10 row number
dag_closure _ancestor_key int4 10 foreign key to DAG_Node._Node_key
dag_closure _ancestorlabel_key int4 10 foreign key to DAG_Label; the label of the Ancestor
dag_closure _ancestorobject_key int4 10 the MGI object to which the Ancestor node refers
dag_closure _dag_key int4 10 foreign key to DAG_DAG
dag_closure _descendent_key int4 10 foreign key to DAG_Node._Node_key
dag_closure _descendentlabel_key int4 10 foreign key to DAG_Label; the label of the Descendent
dag_closure _descendentobject_key int4 10 the MGI object to which the Descendent node refers
dag_closure _mgitype_key int4 10 foreign key to ACC_MGIType
dag_closure creation_date timestamp 29,6 now() date record was created
dag_closure modification_date timestamp 29,6 now() date record was last modified
dag_dag _dag_key int4 10 primary key
dag_dag _mgitype_key int4 10 foreign key to ACC_MGIType
dag_dag _refs_key int4 10 foreign key to BIB_Refs
dag_dag abbreviation bpchar 5 abbreviated name
dag_dag creation_date timestamp 29,6 now() date record was created
dag_dag modification_date timestamp 29,6 now() date record was last modified
dag_dag name text 2147483647 name of the DAG
dag_edge _child_key int4 10 foreign key to DAG_Node._Node_key
dag_edge _dag_key int4 10 foreign key to DAG_DAG
dag_edge _edge_key int4 10 primary key
dag_edge _label_key int4 10 foreign key to DAG_Label
dag_edge _parent_key int4 10 foreign key to DAG_Node._Node_key
dag_edge creation_date timestamp 29,6 now() date record was created
dag_edge modification_date timestamp 29,6 now() date record was last modified
dag_edge sequencenum int4 10 sequence number for ordering records
dag_label _label_key int4 10 primary key
dag_label creation_date timestamp 29,6 now() date record was created
dag_label label text 2147483647 the label
dag_label modification_date timestamp 29,6 now() date record was last modified
dag_node _dag_key int4 10 foreign key to DAG_DAG
dag_node _label_key int4 10 foreign key to DAG_Label
dag_node _node_key int4 10 primary key
dag_node _object_key int4 10 foreign key to any object defined in ACC_MGIType
dag_node creation_date timestamp 29,6 now() date record was created
dag_node modification_date timestamp 29,6 now() date record was last modified
dag_node_view _dag_key int4 10  √  null
dag_node_view _label_key int4 10  √  null
dag_node_view _node_key int4 10  √  null
dag_node_view _object_key int4 10  √  null
dag_node_view _vocab_key int4 10  √  null
dag_node_view creation_date timestamp 29,6  √  null
dag_node_view dag text 2147483647  √  null
dag_node_view dagabbrev bpchar 5  √  null
dag_node_view modification_date timestamp 29,6  √  null
go_tracking _completedby_key int4 10  √  null user who completed the record
go_tracking _createdby_key int4 10 1001 user who created the record
go_tracking _marker_key int4 10 foreign key to MRK_Marker
go_tracking _modifiedby_key int4 10 1001 user who last modified the record
go_tracking completion_date timestamp 29,6  √  now() date GO Tracking was completed
go_tracking creation_date timestamp 29,6 now() date record was created
go_tracking isreferencegene int2 5 if 1, then the gene is a reference gene, else 0.
go_tracking modification_date timestamp 29,6 now() date record was last modified
gxd_allelegenotype _allele_key int4 10 foreign key to ALL_Allele
gxd_allelegenotype _createdby_key int4 10 1001 user who created the record
gxd_allelegenotype _genotype_key int4 10 foreign key to GXD_Genotype
gxd_allelegenotype _marker_key int4 10  √  null foreign key to MRK_Marker
gxd_allelegenotype _modifiedby_key int4 10 1001 user who last modified the record
gxd_allelegenotype creation_date timestamp 29,6 now() date record was created
gxd_allelegenotype modification_date timestamp 29,6 now() date record was last modified
gxd_allelegenotype sequencenum int4 10 sequence number for ordering records
gxd_allelepair _allele_key_1 int4 10 foreign key to ALL_Allele
gxd_allelepair _allele_key_2 int4 10  √  null foreign key to ALL_Allele
gxd_allelepair _allelepair_key serial 10  √  nextval('gxd_allelepair_seq'::regclass) primary key
gxd_allelepair _compound_key int4 10 foreign key to VOC_Term where _Vocab_key = 74 (GXD Conditional Mutants)
gxd_allelepair _createdby_key int4 10 1001 user who created the record
gxd_allelepair _genotype_key int4 10 foreign key to GXD_Genotype
gxd_allelepair _marker_key int4 10  √  null foreign key to MRK_Marker
gxd_allelepair _modifiedby_key int4 10 1001 user who last modified the record
gxd_allelepair _mutantcellline_key_1 int4 10  √  null foreign key to ALL_CellLine
gxd_allelepair _mutantcellline_key_2 int4 10  √  null foreign key to ALL_CellLine
gxd_allelepair _pairstate_key int4 10 foreign key to VOC_Term where _Vocab_key = 39 (Allele Pair State)
gxd_allelepair creation_date timestamp 29,6 now() date record was created
gxd_allelepair modification_date timestamp 29,6 now() date record was last modified
gxd_allelepair sequencenum int4 10 sequence number for ordering records
gxd_allelepair_view _allele_key_1 int4 10  √  null
gxd_allelepair_view _allele_key_2 int4 10  √  null
gxd_allelepair_view _allelepair_key int4 10  √  null
gxd_allelepair_view _compound_key int4 10  √  null
gxd_allelepair_view _createdby_key int4 10  √  null
gxd_allelepair_view _genotype_key int4 10  √  null
gxd_allelepair_view _marker_key int4 10  √  null
gxd_allelepair_view _modifiedby_key int4 10  √  null
gxd_allelepair_view _mutantcellline_key_1 int4 10  √  null
gxd_allelepair_view _mutantcellline_key_2 int4 10  √  null
gxd_allelepair_view _pairstate_key int4 10  √  null
gxd_allelepair_view allele1 text 2147483647  √  null
gxd_allelepair_view allele2 text 2147483647  √  null
gxd_allelepair_view allelestate text 2147483647  √  null
gxd_allelepair_view chromosome text 2147483647  √  null
gxd_allelepair_view compound text 2147483647  √  null
gxd_allelepair_view creation_date timestamp 29,6  √  null
gxd_allelepair_view modification_date timestamp 29,6  √  null
gxd_allelepair_view sequencenum int4 10  √  null
gxd_allelepair_view symbol text 2147483647  √  null
gxd_antibody _antibody_key serial 10  √  nextval('gxd_antibody_seq'::regclass) primary key
gxd_antibody _antibodyclass_key int4 10 foreign key to GXD_AntibodyClass
gxd_antibody _antibodytype_key int4 10 foreign key to GXD_AntibodyType
gxd_antibody _antigen_key int4 10 foreign key to GXD_Antigen
gxd_antibody _createdby_key int4 10 1001 user who created the record
gxd_antibody _modifiedby_key int4 10 1001 user who last modified the record
gxd_antibody _organism_key int4 10 organism (foreign key to MGI_Organism)
gxd_antibody antibodyname text 2147483647 name of Antibody
gxd_antibody antibodynote text 2147483647  √  null note
gxd_antibody creation_date timestamp 29,6 now() date record was created
gxd_antibody modification_date timestamp 29,6 now() date record was last modified
gxd_antibody_acc_view _accession_key int4 10  √  null
gxd_antibody_acc_view _createdby_key int4 10  √  null
gxd_antibody_acc_view _logicaldb_key int4 10  √  null
gxd_antibody_acc_view _mgitype_key int4 10  √  null
gxd_antibody_acc_view _modifiedby_key int4 10  √  null
gxd_antibody_acc_view _object_key int4 10  √  null
gxd_antibody_acc_view accid text 2147483647  √  null
gxd_antibody_acc_view creation_date timestamp 29,6  √  null
gxd_antibody_acc_view description text 2147483647  √  null
gxd_antibody_acc_view logicaldb text 2147483647  √  null
gxd_antibody_acc_view modification_date timestamp 29,6  √  null
gxd_antibody_acc_view numericpart int4 10  √  null
gxd_antibody_acc_view preferred int2 5  √  null
gxd_antibody_acc_view prefixpart text 2147483647  √  null
gxd_antibody_acc_view private int2 5  √  null
gxd_antibody_view _antibody_key int4 10  √  null
gxd_antibody_view _antibodyclass_key int4 10  √  null
gxd_antibody_view _antibodytype_key int4 10  √  null
gxd_antibody_view _antigen_key int4 10  √  null
gxd_antibody_view _createdby_key int4 10  √  null
gxd_antibody_view _modifiedby_key int4 10  √  null
gxd_antibody_view _organism_key int4 10  √  null
gxd_antibody_view antibodyname text 2147483647  √  null
gxd_antibody_view antibodynote text 2147483647  √  null
gxd_antibody_view antibodyspecies text 2147483647  √  null
gxd_antibody_view antibodytype text 2147483647  √  null
gxd_antibody_view antigenname text 2147483647  √  null
gxd_antibody_view antigennote text 2147483647  √  null
gxd_antibody_view class text 2147483647  √  null
gxd_antibody_view createdby text 2147483647  √  null
gxd_antibody_view creation_date timestamp 29,6  √  null
gxd_antibody_view mgiid text 2147483647  √  null
gxd_antibody_view modification_date timestamp 29,6  √  null
gxd_antibody_view modifiedby text 2147483647  √  null
gxd_antibody_view numericpart int4 10  √  null
gxd_antibody_view prefixpart text 2147483647  √  null
gxd_antibody_view regioncovered text 2147483647  √  null
gxd_antibodyalias _antibody_key int4 10 foreign key to GXD_Antibody
gxd_antibodyalias _antibodyalias_key serial 10  √  nextval('gxd_antibodyalias_seq'::regclass) primary key
gxd_antibodyalias _refs_key int4 10  √  null foreign key to BIB_Refs
gxd_antibodyalias alias text 2147483647 alias name
gxd_antibodyalias creation_date timestamp 29,6 now() date record was created
gxd_antibodyalias modification_date timestamp 29,6 now() date record was last modified
gxd_antibodyalias_view _antibody_key int4 10  √  null
gxd_antibodyalias_view _antibodyalias_key int4 10  √  null
gxd_antibodyalias_view _refs_key int4 10  √  null
gxd_antibodyalias_view alias text 2147483647  √  null
gxd_antibodyalias_view antibodyname text 2147483647  √  null
gxd_antibodyalias_view creation_date timestamp 29,6  √  null
gxd_antibodyalias_view modification_date timestamp 29,6  √  null
gxd_antibodyaliasref_view _antibody_key int4 10  √  null
gxd_antibodyaliasref_view _antibodyalias_key int4 10  √  null
gxd_antibodyaliasref_view _refs_key int4 10  √  null
gxd_antibodyaliasref_view alias text 2147483647  √  null
gxd_antibodyaliasref_view antibodyname text 2147483647  √  null
gxd_antibodyaliasref_view creation_date timestamp 29,6  √  null
gxd_antibodyaliasref_view jnum int4 10  √  null
gxd_antibodyaliasref_view jnumid text 2147483647  √  null
gxd_antibodyaliasref_view modification_date timestamp 29,6  √  null
gxd_antibodyaliasref_view short_citation text 2147483647  √  null
gxd_antibodyantigen_view _antibody_key int4 10  √  null
gxd_antibodyantigen_view _antigen_key int4 10  √  null
gxd_antibodyantigen_view _cellline_key int4 10  √  null
gxd_antibodyantigen_view _createdby_key int4 10  √  null
gxd_antibodyantigen_view _gender_key int4 10  √  null
gxd_antibodyantigen_view _modifiedby_key int4 10  √  null
gxd_antibodyantigen_view _organism_key int4 10  √  null
gxd_antibodyantigen_view _refs_key int4 10  √  null
gxd_antibodyantigen_view _source_key int4 10  √  null
gxd_antibodyantigen_view _strain_key int4 10  √  null
gxd_antibodyantigen_view _tissue_key int4 10  √  null
gxd_antibodyantigen_view age text 2147483647  √  null
gxd_antibodyantigen_view antibodyname text 2147483647  √  null
gxd_antibodyantigen_view antigenname text 2147483647  √  null
gxd_antibodyantigen_view antigennote text 2147483647  √  null
gxd_antibodyantigen_view createdby text 2147483647  √  null
gxd_antibodyantigen_view creation_date timestamp 29,6  √  null
gxd_antibodyantigen_view description text 2147483647  √  null
gxd_antibodyantigen_view library text 2147483647  √  null
gxd_antibodyantigen_view mgiid text 2147483647  √  null
gxd_antibodyantigen_view modification_date timestamp 29,6  √  null
gxd_antibodyantigen_view modifiedby text 2147483647  √  null
gxd_antibodyantigen_view numericpart int4 10  √  null
gxd_antibodyantigen_view prefixpart text 2147483647  √  null
gxd_antibodyantigen_view regioncovered text 2147483647  √  null
gxd_antibodymarker _antibody_key int4 10 foreign key to GXD_Antibody
gxd_antibodymarker _antibodymarker_key serial 10  √  nextval('gxd_antibodymarker_seq'::regclass)
gxd_antibodymarker _marker_key int4 10 foreign key to MRK_Marker
gxd_antibodymarker creation_date timestamp 29,6 now() date record was created
gxd_antibodymarker modification_date timestamp 29,6 now() date record was last modified
gxd_antibodymarker_view _antibody_key int4 10  √  null
gxd_antibodymarker_view _marker_key int4 10  √  null
gxd_antibodymarker_view antibodyname text 2147483647  √  null
gxd_antibodymarker_view chromosome text 2147483647  √  null
gxd_antibodymarker_view symbol text 2147483647  √  null
gxd_antibodyprep _antibody_key int4 10 foreign key to GXD_Antibody
gxd_antibodyprep _antibodyprep_key serial 10  √  nextval('gxd_antibodyprep_seq'::regclass) primary key
gxd_antibodyprep _label_key int4 10 foreign key to GXD_Label
gxd_antibodyprep _secondary_key int4 10 foreign key to GXD_Antibody
gxd_antibodyprep creation_date timestamp 29,6 now() date record was created
gxd_antibodyprep modification_date timestamp 29,6 now() date record was last modified
gxd_antibodyprep_view _antibody_key int4 10  √  null
gxd_antibodyprep_view _antibodyprep_key int4 10  √  null
gxd_antibodyprep_view _assay_key int4 10  √  null
gxd_antibodyprep_view _label_key int4 10  √  null
gxd_antibodyprep_view _secondary_key int4 10  √  null
gxd_antibodyprep_view accid text 2147483647  √  null
gxd_antibodyprep_view antibodyname text 2147483647  √  null
gxd_antibodyprep_view creation_date timestamp 29,6  √  null
gxd_antibodyprep_view label text 2147483647  √  null
gxd_antibodyprep_view modification_date timestamp 29,6  √  null
gxd_antibodyprep_view secondary text 2147483647  √  null
gxd_antigen _antigen_key serial 10  √  nextval('gxd_antigen_seq'::regclass) primary key
gxd_antigen _createdby_key int4 10 1001 user who created the record
gxd_antigen _modifiedby_key int4 10 1001 user who last modified the record
gxd_antigen _source_key int4 10 foreign key to PRB_Source
gxd_antigen antigenname text 2147483647 antigen name
gxd_antigen antigennote text 2147483647  √  null textual information
gxd_antigen creation_date timestamp 29,6 now() date record was created
gxd_antigen modification_date timestamp 29,6 now() date record was last modified
gxd_antigen regioncovered text 2147483647  √  null region covered by antigen
gxd_antigen_acc_view _accession_key int4 10  √  null
gxd_antigen_acc_view _createdby_key int4 10  √  null
gxd_antigen_acc_view _logicaldb_key int4 10  √  null
gxd_antigen_acc_view _mgitype_key int4 10  √  null
gxd_antigen_acc_view _modifiedby_key int4 10  √  null
gxd_antigen_acc_view _object_key int4 10  √  null
gxd_antigen_acc_view accid text 2147483647  √  null
gxd_antigen_acc_view creation_date timestamp 29,6  √  null
gxd_antigen_acc_view description text 2147483647  √  null
gxd_antigen_acc_view logicaldb text 2147483647  √  null
gxd_antigen_acc_view modification_date timestamp 29,6  √  null
gxd_antigen_acc_view numericpart int4 10  √  null
gxd_antigen_acc_view preferred int2 5  √  null
gxd_antigen_acc_view prefixpart text 2147483647  √  null
gxd_antigen_acc_view private int2 5  √  null
gxd_antigen_summary_view _accession_key int4 10  √  null
gxd_antigen_summary_view _createdby_key int4 10  √  null
gxd_antigen_summary_view _logicaldb_key int4 10  √  null
gxd_antigen_summary_view _mgitype_key int4 10  √  null
gxd_antigen_summary_view _modifiedby_key int4 10  √  null
gxd_antigen_summary_view _object_key int4 10  √  null
gxd_antigen_summary_view accid text 2147483647  √  null
gxd_antigen_summary_view creation_date timestamp 29,6  √  null
gxd_antigen_summary_view description text 2147483647  √  null
gxd_antigen_summary_view mgiid text 2147483647  √  null
gxd_antigen_summary_view modification_date timestamp 29,6  √  null
gxd_antigen_summary_view numericpart int4 10  √  null
gxd_antigen_summary_view preferred int2 5  √  null
gxd_antigen_summary_view prefixpart text 2147483647  √  null
gxd_antigen_summary_view private int2 5  √  null
gxd_antigen_summary_view short_description text 2147483647  √  null
gxd_antigen_summary_view subtype text 2147483647  √  null
gxd_antigen_view _antigen_key int4 10  √  null
gxd_antigen_view _cellline_key int4 10  √  null
gxd_antigen_view _createdby_key int4 10  √  null
gxd_antigen_view _gender_key int4 10  √  null
gxd_antigen_view _modifiedby_key int4 10  √  null
gxd_antigen_view _organism_key int4 10  √  null
gxd_antigen_view _refs_key int4 10  √  null
gxd_antigen_view _source_key int4 10  √  null
gxd_antigen_view _strain_key int4 10  √  null
gxd_antigen_view _tissue_key int4 10  √  null
gxd_antigen_view age text 2147483647  √  null
gxd_antigen_view antigenname text 2147483647  √  null
gxd_antigen_view antigennote text 2147483647  √  null
gxd_antigen_view createdby text 2147483647  √  null
gxd_antigen_view creation_date timestamp 29,6  √  null
gxd_antigen_view description text 2147483647  √  null
gxd_antigen_view library text 2147483647  √  null
gxd_antigen_view mgiid text 2147483647  √  null
gxd_antigen_view modification_date timestamp 29,6  √  null
gxd_antigen_view modifiedby text 2147483647  √  null
gxd_antigen_view numericpart int4 10  √  null
gxd_antigen_view prefixpart text 2147483647  √  null
gxd_antigen_view regioncovered text 2147483647  √  null
gxd_assay _antibodyprep_key int4 10  √  null foreign key to GXD_AntibodyPrep
gxd_assay _assay_key serial 10  √  nextval('gxd_assay_seq'::regclass) primary key
gxd_assay _assaytype_key int4 10 foreign key to GXD_AssayType
gxd_assay _createdby_key int4 10 1001 user who created the record
gxd_assay _imagepane_key int4 10  √  null foreign key to IMG_ImagePane
gxd_assay _marker_key int4 10 foreign key to MRK_Marker
gxd_assay _modifiedby_key int4 10 1001 user who last modified the record
gxd_assay _probeprep_key int4 10  √  null foreign key to GXD_ProbePrep
gxd_assay _refs_key int4 10 foreign key to BIB_Refs
gxd_assay _reportergene_key int4 10  √  null foreign key to VOC_Term where _Vocab_key = 14 (GXD Reporter Gene); 'hemagglutinin', 'lacZ', 'GFP', 'Cre', 'FLP', etc.
gxd_assay creation_date timestamp 29,6 now() date record was created
gxd_assay modification_date timestamp 29,6 now() date record was last modified
gxd_assay_acc_view _accession_key int4 10  √  null
gxd_assay_acc_view _createdby_key int4 10  √  null
gxd_assay_acc_view _logicaldb_key int4 10  √  null
gxd_assay_acc_view _mgitype_key int4 10  √  null
gxd_assay_acc_view _modifiedby_key int4 10  √  null
gxd_assay_acc_view _object_key int4 10  √  null
gxd_assay_acc_view accid text 2147483647  √  null
gxd_assay_acc_view creation_date timestamp 29,6  √  null
gxd_assay_acc_view logicaldb text 2147483647  √  null
gxd_assay_acc_view modification_date timestamp 29,6  √  null
gxd_assay_acc_view numericpart int4 10  √  null
gxd_assay_acc_view preferred int2 5  √  null
gxd_assay_acc_view prefixpart text 2147483647  √  null
gxd_assay_acc_view private int2 5  √  null
gxd_assay_allele_view _allele_key int4 10  √  null
gxd_assay_allele_view _assay_key int4 10  √  null
gxd_assay_dltemplate_view _assay_key int4 10  √  null
gxd_assay_dltemplate_view _marker_key int4 10  √  null
gxd_assay_dltemplate_view _specimen_key int4 10  √  null
gxd_assay_dltemplate_view accid text 2147483647  √  null
gxd_assay_dltemplate_view at1 int4 10  √  null
gxd_assay_dltemplate_view at2 int4 10  √  null
gxd_assay_dltemplate_view sequencenum int4 10  √  null
gxd_assay_dltemplate_view specimenlabel text 2147483647  √  null
gxd_assay_dltemplate_view symbol text 2147483647  √  null
gxd_assay_view _antibodyprep_key int4 10  √  null
gxd_assay_view _assay_key int4 10  √  null
gxd_assay_view _assaytype_key int4 10  √  null
gxd_assay_view _createdby_key int4 10  √  null
gxd_assay_view _imagepane_key int4 10  √  null
gxd_assay_view _marker_key int4 10  √  null
gxd_assay_view _modifiedby_key int4 10  √  null
gxd_assay_view _probeprep_key int4 10  √  null
gxd_assay_view _refs_key int4 10  √  null
gxd_assay_view _reportergene_key int4 10  √  null
gxd_assay_view assaytype text 2147483647  √  null
gxd_assay_view chromosome text 2147483647  √  null
gxd_assay_view createdby text 2147483647  √  null
gxd_assay_view creation_date timestamp 29,6  √  null
gxd_assay_view isgelassay int2 5  √  null
gxd_assay_view isrnaassay int2 5  √  null
gxd_assay_view jnum int4 10  √  null
gxd_assay_view jnumid text 2147483647  √  null
gxd_assay_view mgiid text 2147483647  √  null
gxd_assay_view modification_date timestamp 29,6  √  null
gxd_assay_view modifiedby text 2147483647  √  null
gxd_assay_view name text 2147483647  √  null
gxd_assay_view numericpart int4 10  √  null
gxd_assay_view prefixpart text 2147483647  √  null
gxd_assay_view short_citation text 2147483647  √  null
gxd_assay_view symbol text 2147483647  √  null
gxd_assaynote _assay_key int4 10 foreign key to GXD_Assay
gxd_assaynote _assaynote_key serial 10  √  nextval('gxd_assaynote_seq'::regclass)
gxd_assaynote assaynote text 2147483647 note
gxd_assaynote creation_date timestamp 29,6 now() date record was created
gxd_assaynote modification_date timestamp 29,6 now() date record was last modified
gxd_assaytype _assaytype_key serial 10  √  nextval('gxd_assaytype_seq'::regclass) primary key
gxd_assaytype assaytype text 2147483647 assay type description
gxd_assaytype creation_date timestamp 29,6 now() date record was created
gxd_assaytype isgelassay int2 5 is assay type a gel assay? yes (1), no (0)
gxd_assaytype isrnaassay int2 5 does assay type detect RNA? yes (1), no (0)
gxd_assaytype modification_date timestamp 29,6 now() date record was last modified
gxd_assaytype sequencenum int4 10 sequence number for ordering records
gxd_expression _assay_key int4 10 foreign key to GXD_Assay
gxd_expression _assaytype_key int4 10 foreign key to GXD_AssayType
gxd_expression _celltype_term_key int4 10  √  null foreign key to VOC_Term where _Vocab_key = 102 (Cell Ontology)
gxd_expression _emapa_term_key int4 10 foreign key to VOC_Term where _Vocab_key = 90 (EMAPA)
gxd_expression _expression_key int4 10 primary key
gxd_expression _gellane_key int4 10  √  null foreign key to GXD_GelLane
gxd_expression _genotype_key int4 10 foreign key to GXD_Genotype
gxd_expression _marker_key int4 10 foreign key to MRK_Marker
gxd_expression _refs_key int4 10 foreign key to BIB_Refs
gxd_expression _specimen_key int4 10  √  null foreign key to GXD_Specimen
gxd_expression _stage_key int4 10 foreign key to GXD_TheilerStage
gxd_expression age text 2147483647 age of anatomical structure
gxd_expression agemax numeric 131089  √  null maximum age value determined by age field
gxd_expression agemin numeric 131089  √  null minimum age value determined by age field
gxd_expression creation_date timestamp 29,6 now() date record was created
gxd_expression expressed int2 5 is Marker expressed in Structure? yes (1), no (0)
gxd_expression hasimage int2 5 if 1 (true), the this Assay contains an Image
gxd_expression isforgxd int2 5 if 1 (true), then this Assay will appear in GXD counts and queries (in front-end)
gxd_expression isrecombinase int2 5 if 1 (true), then this Assay has a Recombinase Reporter Gene (VOC_Term._Vocab_key = 14)
gxd_expression modification_date timestamp 29,6 now() date record was last modified
gxd_expression resultnote text 2147483647  √  null result notes
gxd_expression strength text 2147483647  √  null strength
gxd_gelband _gelband_key serial 10  √  nextval('gxd_gelband_seq'::regclass) primary key
gxd_gelband _gellane_key int4 10 foreign key to GXD_GelLane
gxd_gelband _gelrow_key int4 10 foreign key to GXD_GelRow
gxd_gelband _strength_key int4 10 foreign key to VOC_Term
gxd_gelband bandnote text 2147483647  √  null textual information
gxd_gelband creation_date timestamp 29,6 now() date record was created
gxd_gelband modification_date timestamp 29,6 now() date record was last modified
gxd_gelband_view _assay_key int4 10  √  null
gxd_gelband_view _gelband_key int4 10  √  null
gxd_gelband_view _gellane_key int4 10  √  null
gxd_gelband_view _gelrow_key int4 10  √  null
gxd_gelband_view _strength_key int4 10  √  null
gxd_gelband_view bandnote text 2147483647  √  null
gxd_gelband_view creation_date timestamp 29,6  √  null
gxd_gelband_view lanenum int4 10  √  null
gxd_gelband_view modification_date timestamp 29,6  √  null
gxd_gelband_view rownum int4 10  √  null
gxd_gelband_view strength text 2147483647  √  null
gxd_gellane _assay_key int4 10 foreign key to GXD_Assay
gxd_gellane _gelcontrol_key int4 10 foreign key to GXD_GelControl
gxd_gellane _gellane_key serial 10  √  nextval('gxd_gellane_seq'::regclass) primary key
gxd_gellane _gelrnatype_key int4 10 foreign key to GXD_GelRNAType
gxd_gellane _genotype_key int4 10 foreign key to GXD_Genotype
gxd_gellane age text 2147483647 age of animal
gxd_gellane agemax numeric 131089  √  null maximum age range determined by age field; system calculated
gxd_gellane agemin numeric 131089  √  null minimum age range determined by age field; system calculated
gxd_gellane agenote text 2147483647  √  null age notes
gxd_gellane creation_date timestamp 29,6 now() date record was created
gxd_gellane lanelabel text 2147483647  √  null lane label to describe lane contents
gxd_gellane lanenote text 2147483647  √  null notes for entire lane
gxd_gellane modification_date timestamp 29,6 now() date record was last modified
gxd_gellane sampleamount text 2147483647  √  null amount of source material for RNA gels
gxd_gellane sequencenum int4 10 sequence number for ordering records
gxd_gellane sex text 2147483647 sex of animal (Female, Male, Pooled)
gxd_gellane_view _assay_key int4 10  √  null
gxd_gellane_view _gelcontrol_key int4 10  √  null
gxd_gellane_view _gellane_key int4 10  √  null
gxd_gellane_view _gelrnatype_key int4 10  √  null
gxd_gellane_view _genotype_key int4 10  √  null
gxd_gellane_view age text 2147483647  √  null
gxd_gellane_view agemax numeric 131089  √  null
gxd_gellane_view agemin numeric 131089  √  null
gxd_gellane_view agenote text 2147483647  √  null
gxd_gellane_view creation_date timestamp 29,6  √  null
gxd_gellane_view gellanecontent text 2147483647  √  null
gxd_gellane_view lanelabel text 2147483647  √  null
gxd_gellane_view lanenote text 2147483647  √  null
gxd_gellane_view mgiid text 2147483647  √  null
gxd_gellane_view modification_date timestamp 29,6  √  null
gxd_gellane_view rnatype text 2147483647  √  null
gxd_gellane_view sampleamount text 2147483647  √  null
gxd_gellane_view sequencenum int4 10  √  null
gxd_gellane_view sex text 2147483647  √  null
gxd_gellane_view strain text 2147483647  √  null
gxd_gellanestructure _emapa_term_key int4 10 foreign key to VOC_Term where _Vocab_key = 90 (EMAPA)
gxd_gellanestructure _gellane_key int4 10 foreign key to GXD_GelLane
gxd_gellanestructure _gellanestructure_key serial 10  √  nextval('gxd_gellanestructure_seq'::regclass)
gxd_gellanestructure _stage_key int4 10 foreign key to GXD_TheilerStage
gxd_gellanestructure creation_date timestamp 29,6 now() date record was created
gxd_gellanestructure modification_date timestamp 29,6 now() date record was last modified
gxd_gellanestructure_view _assay_key int4 10  √  null
gxd_gellanestructure_view _emapa_term_key int4 10  √  null
gxd_gellanestructure_view _gellane_key int4 10  √  null
gxd_gellanestructure_view _gellanestructure_key int4 10  √  null
gxd_gellanestructure_view _stage_key int4 10  √  null
gxd_gellanestructure_view creation_date timestamp 29,6  √  null
gxd_gellanestructure_view displayit text 2147483647  √  null
gxd_gellanestructure_view modification_date timestamp 29,6  √  null
gxd_gellanestructure_view sequencenum int4 10  √  null
gxd_gellanestructure_view stage int4 10  √  null
gxd_gellanestructure_view term text 2147483647  √  null
gxd_gelrow _assay_key int4 10 foreign key to GXD_Assay
gxd_gelrow _gelrow_key serial 10  √  nextval('gxd_gelrow_seq'::regclass) primary key
gxd_gelrow _gelunits_key int4 10 foreign key to GXD_GelUnits
gxd_gelrow creation_date timestamp 29,6 now() date record was created
gxd_gelrow modification_date timestamp 29,6 now() date record was last modified
gxd_gelrow rownote text 2147483647  √  null textual information
gxd_gelrow sequencenum int4 10 sequence number for ordering records
gxd_gelrow size numeric 131089  √  null size of band
gxd_gelrow_view _assay_key int4 10  √  null
gxd_gelrow_view _gelrow_key int4 10  √  null
gxd_gelrow_view _gelunits_key int4 10  √  null
gxd_gelrow_view creation_date timestamp 29,6  √  null
gxd_gelrow_view modification_date timestamp 29,6  √  null
gxd_gelrow_view rownote text 2147483647  √  null
gxd_gelrow_view sequencenum int4 10  √  null
gxd_gelrow_view size numeric 131089  √  null
gxd_gelrow_view size_str text 2147483647  √  null
gxd_gelrow_view units text 2147483647  √  null
gxd_genotype _createdby_key int4 10 1001 user who created the record
gxd_genotype _existsas_key int4 10 foreign key to VOC_Term where _Vocab_key = 60 (Genotype Exists As); this genotype exists as 'Mouse Line', 'Cell Line', 'Chimeric', 'Not Specified', 'Not Applicable'
gxd_genotype _genotype_key serial 10  √  nextval('gxd_genotype_seq'::regclass) primary key
gxd_genotype _modifiedby_key int4 10 1001 user who last modified the record
gxd_genotype _strain_key int4 10 foreign key to PRB_Strain
gxd_genotype creation_date timestamp 29,6 now() date record was created
gxd_genotype isconditional int2 5 is this a conditional genotype?
gxd_genotype modification_date timestamp 29,6 now() date record was last modified
gxd_genotype note text 2147483647  √  null note
gxd_genotype_acc_view _accession_key int4 10  √  null
gxd_genotype_acc_view _createdby_key int4 10  √  null
gxd_genotype_acc_view _logicaldb_key int4 10  √  null
gxd_genotype_acc_view _mgitype_key int4 10  √  null
gxd_genotype_acc_view _modifiedby_key int4 10  √  null
gxd_genotype_acc_view _object_key int4 10  √  null
gxd_genotype_acc_view accid text 2147483647  √  null
gxd_genotype_acc_view creation_date timestamp 29,6  √  null
gxd_genotype_acc_view description text 2147483647  √  null
gxd_genotype_acc_view logicaldb text 2147483647  √  null
gxd_genotype_acc_view modification_date timestamp 29,6  √  null
gxd_genotype_acc_view numericpart int4 10  √  null
gxd_genotype_acc_view preferred int2 5  √  null
gxd_genotype_acc_view prefixpart text 2147483647  √  null
gxd_genotype_acc_view private int2 5  √  null
gxd_genotype_dataset_view _genotype_key int4 10  √  null
gxd_genotype_dataset_view _refs_key int4 10  √  null
gxd_genotype_dataset_view strain text 2147483647  √  null
gxd_genotype_summary_view _accession_key int4 10  √  null
gxd_genotype_summary_view _createdby_key int4 10  √  null
gxd_genotype_summary_view _logicaldb_key int4 10  √  null
gxd_genotype_summary_view _mgitype_key int4 10  √  null
gxd_genotype_summary_view _modifiedby_key int4 10  √  null
gxd_genotype_summary_view _object_key int4 10  √  null
gxd_genotype_summary_view accid text 2147483647  √  null
gxd_genotype_summary_view creation_date timestamp 29,6  √  null
gxd_genotype_summary_view description text 2147483647  √  null
gxd_genotype_summary_view logicaldb text 2147483647  √  null
gxd_genotype_summary_view mgiid text 2147483647  √  null
gxd_genotype_summary_view modification_date timestamp 29,6  √  null
gxd_genotype_summary_view numericpart int4 10  √  null
gxd_genotype_summary_view preferred int2 5  √  null
gxd_genotype_summary_view prefixpart text 2147483647  √  null
gxd_genotype_summary_view private int2 5  √  null
gxd_genotype_summary_view short_description text 2147483647  √  null
gxd_genotype_summary_view subtype text 2147483647  √  null
gxd_genotype_view _createdby_key int4 10  √  null
gxd_genotype_view _existsas_key int4 10  √  null
gxd_genotype_view _genotype_key int4 10  √  null
gxd_genotype_view _modifiedby_key int4 10  √  null
gxd_genotype_view _strain_key int4 10  √  null
gxd_genotype_view createdby text 2147483647  √  null
gxd_genotype_view creation_date timestamp 29,6  √  null
gxd_genotype_view displayit text 2147483647  √  null
gxd_genotype_view existsas text 2147483647  √  null
gxd_genotype_view isconditional int2 5  √  null
gxd_genotype_view mgiid text 2147483647  √  null
gxd_genotype_view modification_date timestamp 29,6  √  null
gxd_genotype_view modifiedby text 2147483647  √  null
gxd_genotype_view note text 2147483647  √  null
gxd_genotype_view strain text 2147483647  √  null
gxd_genotypeannotheader_view annotkey int4 10  √  null
gxd_genotypeannotheader_view headersequencenum int4 10  √  null
gxd_genotypeannotheader_view headerterm text 2147483647  √  null
gxd_genotypeannotheader_view headertermkey int4 10  √  null
gxd_genotypeannotheader_view term text 2147483647  √  null
gxd_genotypeannotheader_view termkey int4 10  √  null
gxd_genotypeannotheader_view termsequencenum int4 10  √  null
gxd_htexperiment _createdby_key int4 10 1001 foreign key to MGI_User; user who created the record
gxd_htexperiment _curationstate_key int4 10 foreign key to VOC_Term, identifying whether curation for this experiment has finished
gxd_htexperiment _evaluatedby_key int4 10  √  null foreign key to MGI_User; user who evaluated this experiment and set its _Relevance_key
gxd_htexperiment _evaluationstate_key int4 10 foreign key to VOC_Term, identifying whether this experiment has been curated or not
gxd_htexperiment _experiment_key serial 10  √  nextval('gxd_htexperiment_seq'::regclass) primary key
gxd_htexperiment _experimenttype_key int4 10 foreign key to VOC_Term, in identifying the MGI curated value for experiment type
gxd_htexperiment _initialcuratedby_key int4 10  √  null foreign key to MGI_User; user who first curated the experiment, converting it from its raw status
gxd_htexperiment _lastcuratedby_key int4 10  √  null foreign key to MGI_User; user who last curated the experiment, converting it from its raw status
gxd_htexperiment _modifiedby_key int4 10 1001 foreign key to MGI_User; user who last modified the record
gxd_htexperiment _source_key int4 10 foreign key to VOC_Term, identifies site from which we downloaded raw data for this experiment
gxd_htexperiment _studytype_key int4 10 foreign key to VOC_Term, identifying whether this experiment is a baseline or differential study
gxd_htexperiment confidence numeric 131089 0.0 The relevance classifier’s confidence in its prediction
gxd_htexperiment creation_date timestamp 29,6 now() date record was created
gxd_htexperiment description text 2147483647  √  null textual description
gxd_htexperiment evaluated_date timestamp 29,6  √  null
gxd_htexperiment initial_curated_date timestamp 29,6  √  null date record was first curated
gxd_htexperiment last_curated_date timestamp 29,6  √  null date record was last curated
gxd_htexperiment lastupdate_date timestamp 29,6  √  null date the experiment was last updated at source
gxd_htexperiment modification_date timestamp 29,6 now() date record was last modified
gxd_htexperiment name text 2147483647  √  null name/title of the experiment
gxd_htexperiment release_date timestamp 29,6  √  null date the experiment was first uploaded to source
gxd_htexperimentvariable _experiment_key int4 10 foreign key to GXD_Experiment, identifies the experiment of the variable
gxd_htexperimentvariable _experimentvariable_key serial 10  √  nextval('gxd_htexperimentvariable_seq'::regclass) primary key
gxd_htexperimentvariable _term_key int4 10 foreign key to VOC_Term, identifying whether the experiment variable
gxd_htrawsample _createdby_key int4 10 1001 foreign key to MGI_User, user who created the record
gxd_htrawsample _experiment_key int4 10 foreign key to GXD_HTExperiment
gxd_htrawsample _modifiedby_key int4 10 1001 foreign key to MGI_User, user who last modified the record
gxd_htrawsample _rawsample_key serial 10  √  nextval('gxd_htrawsample_seq'::regclass) primary key
gxd_htrawsample accid text 2147483647  √  null raw sample accession ID
gxd_htrawsample creation_date timestamp 29,6 now() date record was created
gxd_htrawsample modification_date timestamp 29,6 now() date record was last modified
gxd_htsample _celltype_term_key int4 10  √  null foreign key to VOC_Term where _Vocab_key = 102 (Cell Ontology)
gxd_htsample _createdby_key int4 10 1001 foreign key to MGI_User; user who created the record
gxd_htsample _emapa_key int4 10  √  null foreign key to VOC_Term, identifying the EMAPA structure for this sample
gxd_htsample _experiment_key int4 10 foreign key to GXD_HTExperiment, identifies the experiment with which this sample is associated
gxd_htsample _genotype_key int4 10 foreign key to GXD_Genotype, identifying the genotype of the sample
gxd_htsample _modifiedby_key int4 10 1001 foreign key to MGI_User; user who last modified the record
gxd_htsample _organism_key int4 10 foreign key to MGI_Organism, identifying type of organism for the sample
gxd_htsample _relevance_key int4 10 foreign key to VOC_Term, identifies if this sample is relevant for GXD or, if not, why not
gxd_htsample _sample_key serial 10  √  nextval('gxd_htsample_seq'::regclass) primary key
gxd_htsample _sex_key int4 10 foreign key to VOC_Term, identifying sex of the sample
gxd_htsample _stage_key int4 10  √  null foreign key to GXD_TheilerStage, identifying the Theiler Stage of the sample
gxd_htsample age text 2147483647  √  null textual age of the sample
gxd_htsample agemax numeric 131089  √  null
gxd_htsample agemin numeric 131089  √  null
gxd_htsample creation_date timestamp 29,6 now() date record was created
gxd_htsample modification_date timestamp 29,6 now() date record was last modified
gxd_htsample name text 2147483647  √  null name/title of the sample
gxd_htsample_rnaseq _createdby_key int4 10 1001 user who created the record
gxd_htsample_rnaseq _marker_key int4 10 foreign key to MRK_Marker
gxd_htsample_rnaseq _modifiedby_key int4 10 1001 user who last modified the record
gxd_htsample_rnaseq _rnaseq_key serial 10  √  nextval('gxd_htsample_rnaseq_seq'::regclass) primary key
gxd_htsample_rnaseq _rnaseqcombined_key int4 10 foreign key to GXD_HTSample_RNASeqCombined
gxd_htsample_rnaseq _sample_key int4 10 foreign key to GXD_HTSample
gxd_htsample_rnaseq averagetpm numeric 131089 the average TPM of the sample
gxd_htsample_rnaseq creation_date timestamp 29,6 now() date record was created
gxd_htsample_rnaseq modification_date timestamp 29,6 now() date record was last modified
gxd_htsample_rnaseq quantilenormalizedtpm numeric 131089 the quantile normlized TPM of the sample
gxd_htsample_rnaseqcombined _createdby_key int4 10 1001 user who created the record
gxd_htsample_rnaseqcombined _level_key int4 10 foreign key to VOC_Term where _Vocab_key = 144 (RNA-Seq TPM Level)
gxd_htsample_rnaseqcombined _marker_key int4 10 foreign key to MRK_Marker
gxd_htsample_rnaseqcombined _modifiedby_key int4 10 1001 user who last modified the record
gxd_htsample_rnaseqcombined _rnaseqcombined_key serial 10  √  nextval('gxd_htsample_rnaseqcombined_seq'::regclass) primary key
gxd_htsample_rnaseqcombined averagequantilenormalizedtpm numeric 131089 the average quantile normlized TPM
gxd_htsample_rnaseqcombined creation_date timestamp 29,6 now() date record was created
gxd_htsample_rnaseqcombined modification_date timestamp 29,6 now() date record was last modified
gxd_htsample_rnaseqcombined numberofbiologicalreplicates int4 10 the number of biological replicates
gxd_htsample_rnaseqset _createdby_key int4 10 1001 user who created the record
gxd_htsample_rnaseqset _emapa_key int4 10 foreign key to VOC_Term
gxd_htsample_rnaseqset _experiment_key int4 10 foreign key to GXD_HTExperiment
gxd_htsample_rnaseqset _genotype_key int4 10 foreign key to GXD_Genotype
gxd_htsample_rnaseqset _modifiedby_key int4 10 1001 user who last modified the record
gxd_htsample_rnaseqset _organism_key int4 10 foreign key to MGI_Organism
gxd_htsample_rnaseqset _rnaseqset_key serial 10  √  nextval('gxd_htsample_rnaseqset_seq'::regclass) primary key
gxd_htsample_rnaseqset _sex_key int4 10 foreign key to VOC_Term
gxd_htsample_rnaseqset _stage_key int4 10 foreign key to GXD_TheilerStage
gxd_htsample_rnaseqset age text 2147483647 textual age
gxd_htsample_rnaseqset creation_date timestamp 29,6 now() date record was created
gxd_htsample_rnaseqset modification_date timestamp 29,6 now() date record was last modified
gxd_htsample_rnaseqset note text 2147483647  √  null sample note from MGI_Note where _NoteType_key = 1048
gxd_htsample_rnaseqset_cache _assoc_key serial 10  √  nextval('gxd_htsample_rnaseqset_cache_seq'::regclass) primary key
gxd_htsample_rnaseqset_cache _createdby_key int4 10 1001
gxd_htsample_rnaseqset_cache _modifiedby_key int4 10 1001
gxd_htsample_rnaseqset_cache _rnaseqcombined_key int4 10 foreign key to GXD_HTSample_RNASeqCombined
gxd_htsample_rnaseqset_cache _rnaseqset_key int4 10 foreign key to GXD_HTSample_RNASeqSet
gxd_htsample_rnaseqset_cache creation_date timestamp 29,6 now()
gxd_htsample_rnaseqset_cache modification_date timestamp 29,6 now()
gxd_htsample_rnaseqsetmember _createdby_key int4 10 1001 user who created the record
gxd_htsample_rnaseqsetmember _modifiedby_key int4 10 1001 user who last modified the record
gxd_htsample_rnaseqsetmember _rnaseqset_key int4 10 foreign key to GXD_HTSample_RNASeq, identifing the set
gxd_htsample_rnaseqsetmember _rnaseqsetmember_key serial 10  √  nextval('gxd_htsample_rnaseqsetmember_seq'::regclass) primary key
gxd_htsample_rnaseqsetmember _sample_key int4 10 foreign key to GXD_HTSample, identifying the sample member
gxd_htsample_rnaseqsetmember creation_date timestamp 29,6 now() date record was created
gxd_htsample_rnaseqsetmember modification_date timestamp 29,6 now() date record was last modified
gxd_index _conditionalmutants_key int4 10 foreign key to VOC_Term where _Vocab_key = 74 (GXD Conditional Mutants); 'Both tg & KI', 'Induce (minor)', 'Inducile', 'Knocked in', 'Tg (minor amt)', 'Transgenic', 'Not Specified', 'Not Applicable'
gxd_index _createdby_key int4 10 1001 user who created the record
gxd_index _index_key serial 10  √  nextval('gxd_index_seq'::regclass) primary key
gxd_index _marker_key int4 10 foreign key to MRK_Marker
gxd_index _modifiedby_key int4 10 1001 user who last modified the record
gxd_index _priority_key int4 10 foreign key to VOC_Term where _Vocab_key = 11 (GXD Index Priority); 'High', 'Medium', 'Low'
gxd_index _refs_key int4 10 foreign key to BIB_Refs
gxd_index comments text 2147483647  √  null textual information
gxd_index creation_date timestamp 29,6 now() date record was created
gxd_index modification_date timestamp 29,6 now() date record was last modified
gxd_index_stages _createdby_key int4 10 1001 user who created the record
gxd_index_stages _index_key int4 10 foreign key to GXD_Index
gxd_index_stages _indexassay_key int4 10 foreign key to VOC_Term where _Vocab_key = 12 (GXD Index Assay); 'Prot-sxn', 'RNA-sxn', 'Prot-WM', 'RNA-WM', 'Knock in', 'Northern', 'Western', etc.
gxd_index_stages _indexstage_key serial 10  √  nextval('gxd_indexstage_seq'::regclass)
gxd_index_stages _modifiedby_key int4 10 1001 user who last modified the record
gxd_index_stages _stageid_key int4 10 foreign key to VOC_Term where _Vocab_key = 13 (GXD Index Stage); '1', '1.5', '2', '2.5'...'19', '19.5'
gxd_index_stages creation_date timestamp 29,6 now() date record was created
gxd_index_stages modification_date timestamp 29,6 now() date record was last modified
gxd_index_summaryby_view _index_key int4 10  √  null
gxd_index_summaryby_view _indexassay_key int4 10  √  null
gxd_index_summaryby_view _marker_key int4 10  √  null
gxd_index_summaryby_view age text 2147483647  √  null
gxd_index_summaryby_view comments text 2147483647  √  null
gxd_index_summaryby_view conditional text 2147483647  √  null
gxd_index_summaryby_view indexassay text 2147483647  √  null
gxd_index_summaryby_view isfullcoded int4 10  √  null
gxd_index_summaryby_view jnumid text 2147483647  √  null
gxd_index_summaryby_view markerid text 2147483647  √  null
gxd_index_summaryby_view markerstatus text 2147483647  √  null
gxd_index_summaryby_view markertype text 2147483647  √  null
gxd_index_summaryby_view name text 2147483647  √  null
gxd_index_summaryby_view priority text 2147483647  √  null
gxd_index_summaryby_view sequencenum int4 10  √  null
gxd_index_summaryby_view short_citation text 2147483647  √  null
gxd_index_summaryby_view symbol text 2147483647  √  null
gxd_index_view _conditionalmutants_key int4 10  √  null
gxd_index_view _createdby_key int4 10  √  null
gxd_index_view _index_key int4 10  √  null
gxd_index_view _marker_key int4 10  √  null
gxd_index_view _modifiedby_key int4 10  √  null
gxd_index_view _priority_key int4 10  √  null
gxd_index_view _refs_key int4 10  √  null
gxd_index_view comments text 2147483647  √  null
gxd_index_view createdby text 2147483647  √  null
gxd_index_view creation_date timestamp 29,6  √  null
gxd_index_view jnum int4 10  √  null
gxd_index_view jnumid text 2147483647  √  null
gxd_index_view modification_date timestamp 29,6  √  null
gxd_index_view modifiedby text 2147483647  √  null
gxd_index_view short_citation text 2147483647  √  null
gxd_index_view symbol text 2147483647  √  null
gxd_insituresult _pattern_key int4 10 foreign key to VOC_Term
gxd_insituresult _result_key serial 10  √  nextval('gxd_insituresult_seq'::regclass) primary key
gxd_insituresult _specimen_key int4 10 foreign key to GXD_Specimen
gxd_insituresult _strength_key int4 10 foreign key to VOC_Term
gxd_insituresult creation_date timestamp 29,6 now() date record was created
gxd_insituresult modification_date timestamp 29,6 now() date record was last modified
gxd_insituresult resultnote text 2147483647  √  null textual information
gxd_insituresult sequencenum int4 10 sequence number for ordering records
gxd_insituresult_view _pattern_key int4 10  √  null
gxd_insituresult_view _result_key int4 10  √  null
gxd_insituresult_view _specimen_key int4 10  √  null
gxd_insituresult_view _strength_key int4 10  √  null
gxd_insituresult_view creation_date timestamp 29,6  √  null
gxd_insituresult_view modification_date timestamp 29,6  √  null
gxd_insituresult_view pattern text 2147483647  √  null
gxd_insituresult_view resultnote text 2147483647  √  null
gxd_insituresult_view sequencenum int4 10  √  null
gxd_insituresult_view strength text 2147483647  √  null
gxd_insituresultimage _imagepane_key int4 10 foreign key to IMG_ImagePane
gxd_insituresultimage _result_key int4 10 foreign key to GXD_InSituResult
gxd_insituresultimage _resultimage_key serial 10  √  nextval('gxd_insituresultimage_seq'::regclass)
gxd_insituresultimage creation_date timestamp 29,6 now() date record was created
gxd_insituresultimage modification_date timestamp 29,6 now() date record was last modified
gxd_isresultcelltype _celltype_term_key int4 10 foreign key to VOC_Term where _Vocab_key = 102 (Cell Ontology)
gxd_isresultcelltype _result_key int4 10 foreign key to GXD_InSituResult
gxd_isresultcelltype _resultcelltype_key serial 10  √  nextval('gxd_isresultcelltype_seq'::regclass)
gxd_isresultcelltype creation_date timestamp 29,6 now() date record was created
gxd_isresultcelltype modification_date timestamp 29,6 now() date record was last modified
gxd_isresultcelltype_view _assay_key int4 10  √  null
gxd_isresultcelltype_view _celltype_term_key int4 10  √  null
gxd_isresultcelltype_view _result_key int4 10  √  null
gxd_isresultcelltype_view _resultcelltype_key int4 10  √  null
gxd_isresultcelltype_view _specimen_key int4 10  √  null
gxd_isresultcelltype_view creation_date timestamp 29,6  √  null
gxd_isresultcelltype_view displayit text 2147483647  √  null
gxd_isresultcelltype_view modification_date timestamp 29,6  √  null
gxd_isresultcelltype_view sequencenum int4 10  √  null
gxd_isresultcelltype_view term text 2147483647  √  null
gxd_isresultimage_view _image_key int4 10  √  null
gxd_isresultimage_view _imagepane_key int4 10  √  null
gxd_isresultimage_view _result_key int4 10  √  null
gxd_isresultimage_view _resultimage_key int4 10  √  null
gxd_isresultimage_view _specimen_key int4 10  √  null
gxd_isresultimage_view accid text 2147483647  √  null
gxd_isresultimage_view creation_date timestamp 29,6  √  null
gxd_isresultimage_view figurelabel text 2147483647  √  null
gxd_isresultimage_view figurepanelabel text 2147483647  √  null
gxd_isresultimage_view height int4 10  √  null
gxd_isresultimage_view modification_date timestamp 29,6  √  null
gxd_isresultimage_view panelabel text 2147483647  √  null
gxd_isresultimage_view pixid int4 10  √  null
gxd_isresultimage_view sequencenum int4 10  √  null
gxd_isresultimage_view width int4 10  √  null
gxd_isresultimage_view x int4 10  √  null
gxd_isresultimage_view xdim int4 10  √  null
gxd_isresultimage_view y int4 10  √  null
gxd_isresultimage_view ydim int4 10  √  null
gxd_isresultstructure _emapa_term_key int4 10 foreign key to VOC_Term where _Vocab_key = 90 (EMAPA)
gxd_isresultstructure _result_key int4 10 foreign key to GXD_InSituResult
gxd_isresultstructure _resultstructure_key serial 10  √  nextval('gxd_isresultstructure_seq'::regclass)
gxd_isresultstructure _stage_key int4 10 foreign key to GXD_TheilerStage
gxd_isresultstructure creation_date timestamp 29,6 now() date record was created
gxd_isresultstructure modification_date timestamp 29,6 now() date record was last modified
gxd_isresultstructure_view _emapa_term_key int4 10  √  null
gxd_isresultstructure_view _result_key int4 10  √  null
gxd_isresultstructure_view _resultstructure_key int4 10  √  null
gxd_isresultstructure_view _specimen_key int4 10  √  null
gxd_isresultstructure_view _stage_key int4 10  √  null
gxd_isresultstructure_view creation_date timestamp 29,6  √  null
gxd_isresultstructure_view displayit text 2147483647  √  null
gxd_isresultstructure_view modification_date timestamp 29,6  √  null
gxd_isresultstructure_view sequencenum int4 10  √  null
gxd_isresultstructure_view stage int4 10  √  null
gxd_isresultstructure_view term text 2147483647  √  null
gxd_probeprep _label_key int4 10 foreign key to GXD_Label
gxd_probeprep _probe_key int4 10 foreign key to PRB_Probe
gxd_probeprep _probeprep_key serial 10  √  nextval('gxd_probeprep_seq'::regclass) primary key
gxd_probeprep _sense_key int4 10 foreign key to GXD_ProbeSense
gxd_probeprep _visualization_key int4 10 foreign key to GXD_VisualizationMethod
gxd_probeprep creation_date timestamp 29,6 now() date record was created
gxd_probeprep modification_date timestamp 29,6 now() date record was last modified
gxd_probeprep type text 2147483647 final type of probe segment (DNA, RNA, Not Specified)
gxd_probeprep_view _assay_key int4 10  √  null
gxd_probeprep_view _label_key int4 10  √  null
gxd_probeprep_view _probe_key int4 10  √  null
gxd_probeprep_view _probeprep_key int4 10  √  null
gxd_probeprep_view _sense_key int4 10  √  null
gxd_probeprep_view _visualization_key int4 10  √  null
gxd_probeprep_view accid text 2147483647  √  null
gxd_probeprep_view creation_date timestamp 29,6  √  null
gxd_probeprep_view label text 2147483647  √  null
gxd_probeprep_view modification_date timestamp 29,6  √  null
gxd_probeprep_view probename text 2147483647  √  null
gxd_probeprep_view sense text 2147483647  √  null
gxd_probeprep_view type text 2147483647  √  null
gxd_probeprep_view visualization text 2147483647  √  null
gxd_specimen _assay_key int4 10 foreign key to GXD_Assay
gxd_specimen _embedding_key int4 10 foreign key to GXD_EmbeddingMethod
gxd_specimen _fixation_key int4 10 foreign key to GXD_FixationMethod
gxd_specimen _genotype_key int4 10 foreign key to GXD_Genotype
gxd_specimen _specimen_key serial 10  √  nextval('gxd_specimen_seq'::regclass) primary key
gxd_specimen age text 2147483647 age of embryo or animal
gxd_specimen agemax numeric 131089  √  null maximum age range determined by age field; system calculated
gxd_specimen agemin numeric 131089  √  null minimum age range determined by age field; system calculated
gxd_specimen agenote text 2147483647  √  null age notes
gxd_specimen creation_date timestamp 29,6 now() date record was created
gxd_specimen hybridization text 2147483647 probe hybridized to? (sections, whole mount, section from whole mount)
gxd_specimen modification_date timestamp 29,6 now() date record was last modified
gxd_specimen sequencenum int4 10 sequence number for ordering records
gxd_specimen sex text 2147483647 sex of specimen (Female, Male, Pooled)
gxd_specimen specimenlabel text 2147483647  √  null specimen label
gxd_specimen specimennote text 2147483647  √  null specimen note
gxd_specimen_view _assay_key int4 10  √  null
gxd_specimen_view _embedding_key int4 10  √  null
gxd_specimen_view _fixation_key int4 10  √  null
gxd_specimen_view _genotype_key int4 10  √  null
gxd_specimen_view _specimen_key int4 10  √  null
gxd_specimen_view age text 2147483647  √  null
gxd_specimen_view agemax numeric 131089  √  null
gxd_specimen_view agemin numeric 131089  √  null
gxd_specimen_view agenote text 2147483647  √  null
gxd_specimen_view creation_date timestamp 29,6  √  null
gxd_specimen_view embeddingmethod text 2147483647  √  null
gxd_specimen_view fixation text 2147483647  √  null
gxd_specimen_view hybridization text 2147483647  √  null
gxd_specimen_view mgiid text 2147483647  √  null
gxd_specimen_view modification_date timestamp 29,6  √  null
gxd_specimen_view sequencenum int4 10  √  null
gxd_specimen_view sex text 2147483647  √  null
gxd_specimen_view specimenlabel text 2147483647  √  null
gxd_specimen_view specimennote text 2147483647  √  null
gxd_specimen_view strain text 2147483647  √  null
gxd_theilerstage _stage_key int4 10 primary key
gxd_theilerstage creation_date timestamp 29,6 now() date record was created
gxd_theilerstage description text 2147483647  √  null description of the anatomical developments
gxd_theilerstage dpcmax numeric 131089 approximate mapping to maximum DPC value
gxd_theilerstage dpcmin numeric 131089 approximate mapping to minimum DPC value
gxd_theilerstage modification_date timestamp 29,6 now() date record was last modified
gxd_theilerstage stage int4 10 Theiler Stage (1-28)
img_image _createdby_key int4 10 1001 user who created the record
img_image _image_key serial 10  √  nextval('img_image_seq'::regclass) primary key
img_image _imageclass_key int4 10 foreign key to VOC_Term where _Vocab_key = 83 (Image Class); 'Expression', 'Phenotypes', 'Molecular'
img_image _imagetype_key int4 10 foreign key to VOC_Term where _Vocab_key = 47 (Image Type)
img_image _modifiedby_key int4 10 1001 user who last modified the record
img_image _refs_key int4 10 foreign key to BIB_Refs
img_image _thumbnailimage_key int4 10  √  null foreign key to IMG_Image; if _ImageType_key is full size, then this refers to an IMG_Image object where _ImageType_key is thumbnail; it specifies that thumbnail image counterpart of the full size Image.
img_image creation_date timestamp 29,6 now() date record was created
img_image figurelabel text 2147483647 figure label
img_image modification_date timestamp 29,6 now() date record was last modified
img_image xdim int4 10  √  null X dimension of JPEG image
img_image ydim int4 10  √  null Y dimensions of JPEG image
img_image_acc_view _accession_key int4 10  √  null
img_image_acc_view _createdby_key int4 10  √  null
img_image_acc_view _logicaldb_key int4 10  √  null
img_image_acc_view _mgitype_key int4 10  √  null
img_image_acc_view _modifiedby_key int4 10  √  null
img_image_acc_view _object_key int4 10  √  null
img_image_acc_view accid text 2147483647  √  null
img_image_acc_view creation_date timestamp 29,6  √  null
img_image_acc_view logicaldb text 2147483647  √  null
img_image_acc_view modification_date timestamp 29,6  √  null
img_image_acc_view numericpart int4 10  √  null
img_image_acc_view preferred int2 5  √  null
img_image_acc_view prefixpart text 2147483647  √  null
img_image_acc_view private int2 5  √  null
img_image_summary2_view _image_key int4 10  √  null
img_image_summary2_view _imagepane_key int4 10  √  null
img_image_summary2_view accid text 2147483647  √  null
img_image_summary2_view figurelabel text 2147483647  √  null
img_image_summary2_view figurepanelabel text 2147483647  √  null
img_image_summary2_view height int4 10  √  null
img_image_summary2_view panelabel text 2147483647  √  null
img_image_summary2_view pixid int4 10  √  null
img_image_summary2_view width int4 10  √  null
img_image_summary2_view x int4 10  √  null
img_image_summary2_view xdim int4 10  √  null
img_image_summary2_view y int4 10  √  null
img_image_summary2_view ydim int4 10  √  null
img_image_summarybyreference_view _imagepane_key int4 10  √  null
img_image_summarybyreference_view _refs_key int4 10  √  null
img_image_summarybyreference_view assayid text 2147483647  √  null
img_image_summarybyreference_view assaytype text 2147483647  √  null
img_image_summarybyreference_view figurelabel text 2147483647  √  null
img_image_summarybyreference_view height int4 10  √  null
img_image_summarybyreference_view imageid text 2147483647  √  null
img_image_summarybyreference_view jnumid text 2147483647  √  null
img_image_summarybyreference_view markerid text 2147483647  √  null
img_image_summarybyreference_view panelabel text 2147483647  √  null
img_image_summarybyreference_view pixid text 2147483647  √  null
img_image_summarybyreference_view specimenlabel text 2147483647  √  null
img_image_summarybyreference_view specimennote text 2147483647  √  null
img_image_summarybyreference_view symbol text 2147483647  √  null
img_image_summarybyreference_view width int4 10  √  null
img_image_summarybyreference_view x int4 10  √  null
img_image_summarybyreference_view xdim int4 10  √  null
img_image_summarybyreference_view y int4 10  √  null
img_image_summarybyreference_view ydim int4 10  √  null
img_image_view _createdby_key int4 10  √  null
img_image_view _image_key int4 10  √  null
img_image_view _imageclass_key int4 10  √  null
img_image_view _imagetype_key int4 10  √  null
img_image_view _modifiedby_key int4 10  √  null
img_image_view _refs_key int4 10  √  null
img_image_view _thumbnailimage_key int4 10  √  null
img_image_view createdby text 2147483647  √  null
img_image_view creation_date timestamp 29,6  √  null
img_image_view figurelabel text 2147483647  √  null
img_image_view imageclass text 2147483647  √  null
img_image_view imagetype text 2147483647  √  null
img_image_view jnum int4 10  √  null
img_image_view jnumid text 2147483647  √  null
img_image_view mgiid text 2147483647  √  null
img_image_view modification_date timestamp 29,6  √  null
img_image_view modifiedb text 2147483647  √  null
img_image_view numericpart int4 10  √  null
img_image_view prefixpart text 2147483647  √  null
img_image_view short_citation text 2147483647  √  null
img_image_view xdim int4 10  √  null
img_image_view ydim int4 10  √  null
img_imagepane _image_key int4 10 foreign key to IMG_Image
img_imagepane _imagepane_key serial 10  √  nextval('img_imagepane_seq'::regclass) primary key
img_imagepane creation_date timestamp 29,6 now() date record was created
img_imagepane height int4 10  √  null height of image pdf
img_imagepane modification_date timestamp 29,6 now() date record was last modified
img_imagepane panelabel text 2147483647  √  null pane label
img_imagepane width int4 10  √  null width of image pdf
img_imagepane x int4 10  √  null x coordinate of image pdf
img_imagepane y int4 10  √  null y coordinate of image pdf
img_imagepane_assoc _assoc_key serial 10  √  nextval('img_imagepane_assoc_seq'::regclass) primary key
img_imagepane_assoc _createdby_key int4 10 1001 user who created the record
img_imagepane_assoc _imagepane_key int4 10 foreign key to IMG_ImagePane; specifies the Image Pane
img_imagepane_assoc _mgitype_key int4 10 foreign key to ACC_MGIType
img_imagepane_assoc _modifiedby_key int4 10 1001 user who last modified the record
img_imagepane_assoc _object_key int4 10 foreign key to any object defined in ACC_MGIType
img_imagepane_assoc creation_date timestamp 29,6 now() date record was created
img_imagepane_assoc isprimary int2 5 if = 1, then the association is primary, else secondary
img_imagepane_assoc modification_date timestamp 29,6 now() date record was last modified
img_imagepane_assoc_view _assoc_key int4 10  √  null
img_imagepane_assoc_view _createdby_key int4 10  √  null
img_imagepane_assoc_view _image_key int4 10  √  null
img_imagepane_assoc_view _imageclass_key int4 10  √  null
img_imagepane_assoc_view _imagepane_key int4 10  √  null
img_imagepane_assoc_view _mgitype_key int4 10  √  null
img_imagepane_assoc_view _modifiedby_key int4 10  √  null
img_imagepane_assoc_view _object_key int4 10  √  null
img_imagepane_assoc_view creation_date timestamp 29,6  √  null
img_imagepane_assoc_view figurelabel text 2147483647  √  null
img_imagepane_assoc_view isprimary int2 5  √  null
img_imagepane_assoc_view mgiid text 2147483647  √  null
img_imagepane_assoc_view modification_date timestamp 29,6  √  null
img_imagepane_assoc_view pixid text 2147483647  √  null
img_imagepane_assoc_view term text 2147483647  √  null
img_imagepaneallele_view _allele_key int4 10  √  null
img_imagepaneallele_view _assoc_key int4 10  √  null
img_imagepaneallele_view _imagepane_key int4 10  √  null
img_imagepaneallele_view alleleid text 2147483647  √  null
img_imagepaneallele_view figurelabel text 2147483647  √  null
img_imagepaneallele_view symbol text 2147483647  √  null
img_imagepanegenotype_view _allele_key int4 10  √  null
img_imagepanegenotype_view _assoc_key int4 10  √  null
img_imagepanegenotype_view _imagepane_key int4 10  √  null
img_imagepanegenotype_view accid text 2147483647  √  null
img_imagepanegenotype_view allelecomposition text 2147483647  √  null
img_imagepanegenotype_view figurelabel text 2147483647  √  null
img_imagepanegenotype_view strain text 2147483647  √  null
img_imagepanegxd_view _image_key int4 10  √  null
img_imagepanegxd_view _imagepane_key int4 10  √  null
img_imagepanegxd_view _refs_key int4 10  √  null
img_imagepanegxd_view jnum int4 10  √  null
img_imagepanegxd_view jnumid text 2147483647  √  null
img_imagepanegxd_view panelabel text 2147483647  √  null
img_imagepanegxd_view short_citation text 2147483647  √  null
map_coord_collection _collection_key int4 10 primary key
map_coord_collection _createdby_key int4 10 1001 user who created the record
map_coord_collection _modifiedby_key int4 10 1001 user who last modified the record
map_coord_collection abbreviation text 2147483647 short version of name
map_coord_collection creation_date timestamp 29,6 now() date record was created
map_coord_collection modification_date timestamp 29,6 now() date record was last modified
map_coord_collection name text 2147483647 the data provider of the collection
map_coord_feature _createdby_key int4 10 1001 user who created the record
map_coord_feature _feature_key int4 10 primary key
map_coord_feature _map_key int4 10 foreign key to MAP_Coordinate
map_coord_feature _mgitype_key int4 10 foreign key to ACC_MGIType
map_coord_feature _modifiedby_key int4 10 1001 user who last modified the record
map_coord_feature _object_key int4 10 foreign key to any object defined in ACC_MGIType
map_coord_feature creation_date timestamp 29,6 now() date record was created
map_coord_feature endcoordinate numeric 131089 coordinate of the last base pair
map_coord_feature modification_date timestamp 29,6 now() date record was last modified
map_coord_feature startcoordinate numeric 131089 coordinate of the first base pair
map_coord_feature strand bpchar 1  √  null if '+', the object is on the positive strand, else negative strand
map_coordinate _collection_key int4 10 foreign key to MAP_Coord_Collection
map_coordinate _createdby_key int4 10 1001 user who created the record
map_coordinate _map_key int4 10 primary key
map_coordinate _maptype_key int4 10 foreign key to VOC_Term where _Vocab_key = 29 (Map Type)
map_coordinate _mgitype_key int4 10  √  null foreign key to ACC_MGIType
map_coordinate _modifiedby_key int4 10 1001 user who last modified the record
map_coordinate _object_key int4 10  √  null foreign key to any object defined in ACC_MGIType
map_coordinate _units_key int4 10 foreign key to VOC_Term where _Vocab_key = 30 (Map Units)
map_coordinate abbreviation text 2147483647  √  null short version of name
map_coordinate creation_date timestamp 29,6 now() date record was created
map_coordinate length int4 10 map length in specified units (_Units_key)
map_coordinate modification_date timestamp 29,6 now() date record was last modified
map_coordinate name text 2147483647  √  null public Map label which is printed in the WI or on reports
map_coordinate sequencenum int4 10 orders the Map withing the specified Map Collection
map_coordinate version text 2147483647  √  null version of the specified map
map_gm_coord_feature_view _chromosome_key int4 10  √  null
map_gm_coord_feature_view _createdby_key int4 10  √  null
map_gm_coord_feature_view _feature_key int4 10  √  null
map_gm_coord_feature_view _modifiedby_key int4 10  √  null
map_gm_coord_feature_view _sequence_key int4 10  √  null
map_gm_coord_feature_view collectionname text 2147483647  √  null
map_gm_coord_feature_view creation_date timestamp 29,6  √  null
map_gm_coord_feature_view endcoordinate numeric 131089  √  null
map_gm_coord_feature_view genomicchromosome text 2147483647  √  null
map_gm_coord_feature_view modification_date timestamp 29,6  √  null
map_gm_coord_feature_view seqid text 2147483647  √  null
map_gm_coord_feature_view startcoordinate numeric 131089  √  null
map_gm_coord_feature_view strand bpchar 1  √  null
mgi_dbinfo creation_date timestamp 29,6 now() date record was created
mgi_dbinfo lastdump_date timestamp 29,6 now() date of last database dump
mgi_dbinfo modification_date timestamp 29,6 now() date record was last modified
mgi_dbinfo product_name text 2147483647 product name
mgi_dbinfo public_version text 2147483647 public version
mgi_dbinfo schema_version text 2147483647 schema version
mgi_dbinfo snp_data_version text 2147483647 snp data version
mgi_dbinfo snp_schema_version text 2147483647 snp schema version
mgi_keyvalue _createdby_key int4 10 1001 user who created the record
mgi_keyvalue _keyvalue_key serial 10  √  nextval('mgi_keyvalue_seq'::regclass) primary key
mgi_keyvalue _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_keyvalue _modifiedby_key int4 10 1001 user who last modified the record
mgi_keyvalue _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_keyvalue creation_date timestamp 29,6 now() date record was created
mgi_keyvalue key text 2147483647 string key
mgi_keyvalue modification_date timestamp 29,6 now() date record was last modified
mgi_keyvalue sequencenum int4 10 sequence number for ordering records
mgi_keyvalue value text 2147483647 string value
mgi_note _createdby_key int4 10 1001 user who created the record
mgi_note _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_note _modifiedby_key int4 10 1001 user who last modified the record
mgi_note _note_key serial 10  √  nextval('mgi_note_seq'::regclass) primary key
mgi_note _notetype_key int4 10 foreign key to MGI_NoteType
mgi_note _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_note creation_date timestamp 29,6 now() date record was created
mgi_note modification_date timestamp 29,6 now() date record was last modified
mgi_note note text 2147483647 note
mgi_note_allele_view _createdby_key int4 10  √  null
mgi_note_allele_view _mgitype_key int4 10  √  null
mgi_note_allele_view _modifiedby_key int4 10  √  null
mgi_note_allele_view _note_key int4 10  √  null
mgi_note_allele_view _notetype_key int4 10  √  null
mgi_note_allele_view _object_key int4 10  √  null
mgi_note_allele_view createdby text 2147483647  √  null
mgi_note_allele_view creation_date timestamp 29,6  √  null
mgi_note_allele_view mgitype text 2147483647  √  null
mgi_note_allele_view modification_date timestamp 29,6  √  null
mgi_note_allele_view modifiedby text 2147483647  √  null
mgi_note_allele_view note text 2147483647  √  null
mgi_note_allele_view notetype text 2147483647  √  null
mgi_note_allelevariant_view _createdby_key int4 10  √  null
mgi_note_allelevariant_view _mgitype_key int4 10  √  null
mgi_note_allelevariant_view _modifiedby_key int4 10  √  null
mgi_note_allelevariant_view _note_key int4 10  √  null
mgi_note_allelevariant_view _notetype_key int4 10  √  null
mgi_note_allelevariant_view _object_key int4 10  √  null
mgi_note_allelevariant_view createdby text 2147483647  √  null
mgi_note_allelevariant_view creation_date timestamp 29,6  √  null
mgi_note_allelevariant_view mgitype text 2147483647  √  null
mgi_note_allelevariant_view modification_date timestamp 29,6  √  null
mgi_note_allelevariant_view modifiedby text 2147483647  √  null
mgi_note_allelevariant_view note text 2147483647  √  null
mgi_note_allelevariant_view notetype text 2147483647  √  null
mgi_note_derivation_view _createdby_key int4 10  √  null
mgi_note_derivation_view _mgitype_key int4 10  √  null
mgi_note_derivation_view _modifiedby_key int4 10  √  null
mgi_note_derivation_view _note_key int4 10  √  null
mgi_note_derivation_view _notetype_key int4 10  √  null
mgi_note_derivation_view _object_key int4 10  √  null
mgi_note_derivation_view createdby text 2147483647  √  null
mgi_note_derivation_view creation_date timestamp 29,6  √  null
mgi_note_derivation_view mgitype text 2147483647  √  null
mgi_note_derivation_view modification_date timestamp 29,6  √  null
mgi_note_derivation_view modifiedby text 2147483647  √  null
mgi_note_derivation_view note text 2147483647  √  null
mgi_note_derivation_view notetype text 2147483647  √  null
mgi_note_genotype_view _createdby_key int4 10  √  null
mgi_note_genotype_view _mgitype_key int4 10  √  null
mgi_note_genotype_view _modifiedby_key int4 10  √  null
mgi_note_genotype_view _note_key int4 10  √  null
mgi_note_genotype_view _notetype_key int4 10  √  null
mgi_note_genotype_view _object_key int4 10  √  null
mgi_note_genotype_view createdby text 2147483647  √  null
mgi_note_genotype_view creation_date timestamp 29,6  √  null
mgi_note_genotype_view mgitype text 2147483647  √  null
mgi_note_genotype_view modification_date timestamp 29,6  √  null
mgi_note_genotype_view modifiedby text 2147483647  √  null
mgi_note_genotype_view note text 2147483647  √  null
mgi_note_genotype_view notetype text 2147483647  √  null
mgi_note_image_view _createdby_key int4 10  √  null
mgi_note_image_view _mgitype_key int4 10  √  null
mgi_note_image_view _modifiedby_key int4 10  √  null
mgi_note_image_view _note_key int4 10  √  null
mgi_note_image_view _notetype_key int4 10  √  null
mgi_note_image_view _object_key int4 10  √  null
mgi_note_image_view createdby text 2147483647  √  null
mgi_note_image_view creation_date timestamp 29,6  √  null
mgi_note_image_view mgitype text 2147483647  √  null
mgi_note_image_view modification_date timestamp 29,6  √  null
mgi_note_image_view modifiedby text 2147483647  √  null
mgi_note_image_view note text 2147483647  √  null
mgi_note_image_view notetype text 2147483647  √  null
mgi_note_marker_view _createdby_key int4 10  √  null
mgi_note_marker_view _mgitype_key int4 10  √  null
mgi_note_marker_view _modifiedby_key int4 10  √  null
mgi_note_marker_view _note_key int4 10  √  null
mgi_note_marker_view _notetype_key int4 10  √  null
mgi_note_marker_view _object_key int4 10  √  null
mgi_note_marker_view createdby text 2147483647  √  null
mgi_note_marker_view creation_date timestamp 29,6  √  null
mgi_note_marker_view mgitype text 2147483647  √  null
mgi_note_marker_view modification_date timestamp 29,6  √  null
mgi_note_marker_view modifiedby text 2147483647  √  null
mgi_note_marker_view note text 2147483647  √  null
mgi_note_marker_view notetype text 2147483647  √  null
mgi_note_probe_view _createdby_key int4 10  √  null
mgi_note_probe_view _mgitype_key int4 10  √  null
mgi_note_probe_view _modifiedby_key int4 10  √  null
mgi_note_probe_view _note_key int4 10  √  null
mgi_note_probe_view _notetype_key int4 10  √  null
mgi_note_probe_view _object_key int4 10  √  null
mgi_note_probe_view createdby text 2147483647  √  null
mgi_note_probe_view creation_date timestamp 29,6  √  null
mgi_note_probe_view mgitype text 2147483647  √  null
mgi_note_probe_view modification_date timestamp 29,6  √  null
mgi_note_probe_view modifiedby text 2147483647  √  null
mgi_note_probe_view note text 2147483647  √  null
mgi_note_probe_view notetype text 2147483647  √  null
mgi_note_strain_view _createdby_key int4 10  √  null
mgi_note_strain_view _mgitype_key int4 10  √  null
mgi_note_strain_view _modifiedby_key int4 10  √  null
mgi_note_strain_view _note_key int4 10  √  null
mgi_note_strain_view _notetype_key int4 10  √  null
mgi_note_strain_view _object_key int4 10  √  null
mgi_note_strain_view createdby text 2147483647  √  null
mgi_note_strain_view creation_date timestamp 29,6  √  null
mgi_note_strain_view mgitype text 2147483647  √  null
mgi_note_strain_view modification_date timestamp 29,6  √  null
mgi_note_strain_view modifiedby text 2147483647  √  null
mgi_note_strain_view note text 2147483647  √  null
mgi_note_strain_view notetype text 2147483647  √  null
mgi_note_vocevidence_view _createdby_key int4 10  √  null
mgi_note_vocevidence_view _mgitype_key int4 10  √  null
mgi_note_vocevidence_view _modifiedby_key int4 10  √  null
mgi_note_vocevidence_view _note_key int4 10  √  null
mgi_note_vocevidence_view _notetype_key int4 10  √  null
mgi_note_vocevidence_view _object_key int4 10  √  null
mgi_note_vocevidence_view createdby text 2147483647  √  null
mgi_note_vocevidence_view creation_date timestamp 29,6  √  null
mgi_note_vocevidence_view mgitype text 2147483647  √  null
mgi_note_vocevidence_view modification_date timestamp 29,6  √  null
mgi_note_vocevidence_view modifiedby text 2147483647  √  null
mgi_note_vocevidence_view note text 2147483647  √  null
mgi_note_vocevidence_view notetype text 2147483647  √  null
mgi_notetype _createdby_key int4 10 1001 user who created the record
mgi_notetype _mgitype_key int4 10  √  null foreign key to ACC_MGIType
mgi_notetype _modifiedby_key int4 10 1001 user who last modified the record
mgi_notetype _notetype_key int4 10 primary key
mgi_notetype creation_date timestamp 29,6 now() date record was created
mgi_notetype modification_date timestamp 29,6 now() date record was last modified
mgi_notetype notetype text 2147483647 description of the note type
mgi_notetype private int2 5 are notes of this type private?
mgi_notetype_strain_view _createdby_key int4 10  √  null
mgi_notetype_strain_view _mgitype_key int4 10  √  null
mgi_notetype_strain_view _modifiedby_key int4 10  √  null
mgi_notetype_strain_view _notetype_key int4 10  √  null
mgi_notetype_strain_view creation_date timestamp 29,6  √  null
mgi_notetype_strain_view modification_date timestamp 29,6  √  null
mgi_notetype_strain_view notetype text 2147483647  √  null
mgi_notetype_strain_view private int2 5  √  null
mgi_organism _createdby_key int4 10 1001 user who created the record
mgi_organism _modifiedby_key int4 10 1001 user who last modified the record
mgi_organism _organism_key serial 10  √  nextval('mgi_organism_seq'::regclass) organism (foreign key to MGI_Organism)
mgi_organism commonname text 2147483647 common name of organism
mgi_organism creation_date timestamp 29,6 now() date record was created
mgi_organism latinname text 2147483647  √  null latin name of organism
mgi_organism modification_date timestamp 29,6 now() date record was last modified
mgi_organism_allele_view _createdby_key int4 10  √  null
mgi_organism_allele_view _modifiedby_key int4 10  √  null
mgi_organism_allele_view _organism_key int4 10  √  null
mgi_organism_allele_view commonname text 2147483647  √  null
mgi_organism_allele_view creation_date timestamp 29,6  √  null
mgi_organism_allele_view latinname text 2147483647  √  null
mgi_organism_allele_view modification_date timestamp 29,6  √  null
mgi_organism_allele_view organism text 2147483647  √  null
mgi_organism_antigen_view _createdby_key int4 10  √  null
mgi_organism_antigen_view _modifiedby_key int4 10  √  null
mgi_organism_antigen_view _organism_key int4 10  √  null
mgi_organism_antigen_view commonname text 2147483647  √  null
mgi_organism_antigen_view creation_date timestamp 29,6  √  null
mgi_organism_antigen_view latinname text 2147483647  √  null
mgi_organism_antigen_view modification_date timestamp 29,6  √  null
mgi_organism_marker_view _createdby_key int4 10  √  null
mgi_organism_marker_view _modifiedby_key int4 10  √  null
mgi_organism_marker_view _organism_key int4 10  √  null
mgi_organism_marker_view commonname text 2147483647  √  null
mgi_organism_marker_view creation_date timestamp 29,6  √  null
mgi_organism_marker_view latinname text 2147483647  √  null
mgi_organism_marker_view modification_date timestamp 29,6  √  null
mgi_organism_marker_view organism text 2147483647  √  null
mgi_organism_mgitype _assoc_key serial 10  √  nextval('mgi_organism_mgitype_seq'::regclass) primary key
mgi_organism_mgitype _createdby_key int4 10 1001 user who created the record
mgi_organism_mgitype _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_organism_mgitype _modifiedby_key int4 10 1001 user who last modified the record
mgi_organism_mgitype _organism_key int4 10 foreign key to MGI_Organism
mgi_organism_mgitype creation_date timestamp 29,6 now() date record was created
mgi_organism_mgitype modification_date timestamp 29,6 now() date record was last modified
mgi_organism_mgitype sequencenum int4 10 enables us to define an ordered list of of Organisms for a given MGI Type
mgi_organism_mgitype_view _assoc_key int4 10  √  null
mgi_organism_mgitype_view _createdby_key int4 10  √  null
mgi_organism_mgitype_view _mgitype_key int4 10  √  null
mgi_organism_mgitype_view _modifiedby_key int4 10  √  null
mgi_organism_mgitype_view _organism_key int4 10  √  null
mgi_organism_mgitype_view commonname text 2147483647  √  null
mgi_organism_mgitype_view creation_date timestamp 29,6  √  null
mgi_organism_mgitype_view latinname text 2147483647  √  null
mgi_organism_mgitype_view modification_date timestamp 29,6  √  null
mgi_organism_mgitype_view sequencenum int4 10  √  null
mgi_organism_mgitype_view typename text 2147483647  √  null
mgi_organism_probe_view _createdby_key int4 10  √  null
mgi_organism_probe_view _modifiedby_key int4 10  √  null
mgi_organism_probe_view _organism_key int4 10  √  null
mgi_organism_probe_view commonname text 2147483647  √  null
mgi_organism_probe_view creation_date timestamp 29,6  √  null
mgi_organism_probe_view latinname text 2147483647  √  null
mgi_organism_probe_view modification_date timestamp 29,6  √  null
mgi_property _createdby_key int4 10 1001 user who created the record
mgi_property _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_property _modifiedby_key int4 10 1001 user who last modified the record
mgi_property _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_property _property_key serial 10  √  nextval('mgi_property_seq'::regclass) primary key
mgi_property _propertyterm_key int4 10 foreign key to VOC_Term
mgi_property _propertytype_key int4 10 foreign key to MGI_PropertyType
mgi_property creation_date timestamp 29,6 now() date record was created
mgi_property modification_date timestamp 29,6 now() date record was last modified
mgi_property sequencenum int4 10 sequence number for ordering records
mgi_property value text 2147483647 property value
mgi_propertytype _createdby_key int4 10 1001 user who created the record
mgi_propertytype _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_propertytype _modifiedby_key int4 10 1001 user who last modified the record
mgi_propertytype _propertytype_key int4 10 primary key
mgi_propertytype _vocab_key int4 10  √  null foreign key to VOC_Vocab
mgi_propertytype creation_date timestamp 29,6 now() date record was created
mgi_propertytype modification_date timestamp 29,6 now() date record was last modified
mgi_propertytype propertytype text 2147483647 property type
mgi_refassoctype _createdby_key int4 10 1001 user who created the record
mgi_refassoctype _mgitype_key int4 10  √  null foreign key to ACC_MGIType
mgi_refassoctype _modifiedby_key int4 10 1001 user who last modified the record
mgi_refassoctype _refassoctype_key int4 10 primary key
mgi_refassoctype allowonlyone int2 5 does this reference type allow only one association?
mgi_refassoctype assoctype text 2147483647 name of this reference association type (ex. "General").
mgi_refassoctype creation_date timestamp 29,6 now() date record was created
mgi_refassoctype modification_date timestamp 29,6 now() date record was last modified
mgi_reference_allele_view _assoc_key int4 10  √  null
mgi_reference_allele_view _createdby_key int4 10  √  null
mgi_reference_allele_view _mgitype_key int4 10  √  null
mgi_reference_allele_view _modifiedby_key int4 10  √  null
mgi_reference_allele_view _object_key int4 10  √  null
mgi_reference_allele_view _refassoctype_key int4 10  √  null
mgi_reference_allele_view _refs_key int4 10  √  null
mgi_reference_allele_view accid text 2147483647  √  null
mgi_reference_allele_view allowonlyone int2 5  √  null
mgi_reference_allele_view assoctype text 2147483647  √  null
mgi_reference_allele_view creation_date timestamp 29,6  √  null
mgi_reference_allele_view isreviewarticle int2 5  √  null
mgi_reference_allele_view isreviewarticlestring bpchar 3  √  null
mgi_reference_allele_view jnum int4 10  √  null
mgi_reference_allele_view jnumid text 2147483647  √  null
mgi_reference_allele_view markersymbol text 2147483647  √  null
mgi_reference_allele_view modification_date timestamp 29,6  √  null
mgi_reference_allele_view short_citation text 2147483647  √  null
mgi_reference_allele_view symbol text 2147483647  √  null
mgi_reference_allelevariant_view _assoc_key int4 10  √  null
mgi_reference_allelevariant_view _createdby_key int4 10  √  null
mgi_reference_allelevariant_view _mgitype_key int4 10  √  null
mgi_reference_allelevariant_view _modifiedby_key int4 10  √  null
mgi_reference_allelevariant_view _object_key int4 10  √  null
mgi_reference_allelevariant_view _refassoctype_key int4 10  √  null
mgi_reference_allelevariant_view _refs_key int4 10  √  null
mgi_reference_allelevariant_view allowonlyone int2 5  √  null
mgi_reference_allelevariant_view assoctype text 2147483647  √  null
mgi_reference_allelevariant_view creation_date timestamp 29,6  √  null
mgi_reference_allelevariant_view isreviewarticle int2 5  √  null
mgi_reference_allelevariant_view isreviewarticlestring bpchar 3  √  null
mgi_reference_allelevariant_view jnum int4 10  √  null
mgi_reference_allelevariant_view jnumid text 2147483647  √  null
mgi_reference_allelevariant_view modification_date timestamp 29,6  √  null
mgi_reference_allelevariant_view short_citation text 2147483647  √  null
mgi_reference_antibody_view _assoc_key int4 10  √  null
mgi_reference_antibody_view _createdby_key int4 10  √  null
mgi_reference_antibody_view _mgitype_key int4 10  √  null
mgi_reference_antibody_view _modifiedby_key int4 10  √  null
mgi_reference_antibody_view _object_key int4 10  √  null
mgi_reference_antibody_view _refassoctype_key int4 10  √  null
mgi_reference_antibody_view _refs_key int4 10  √  null
mgi_reference_antibody_view allowonlyone int2 5  √  null
mgi_reference_antibody_view assoctype text 2147483647  √  null
mgi_reference_antibody_view creation_date timestamp 29,6  √  null
mgi_reference_antibody_view isreviewarticle int2 5  √  null
mgi_reference_antibody_view isreviewarticlestring bpchar 3  √  null
mgi_reference_antibody_view jnum int4 10  √  null
mgi_reference_antibody_view jnumid text 2147483647  √  null
mgi_reference_antibody_view modification_date timestamp 29,6  √  null
mgi_reference_antibody_view short_citation text 2147483647  √  null
mgi_reference_assoc _assoc_key serial 10  √  nextval('mgi_reference_assoc_seq'::regclass) primary key
mgi_reference_assoc _createdby_key int4 10 1001 user who created the record
mgi_reference_assoc _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_reference_assoc _modifiedby_key int4 10 1001 user who last modified the record
mgi_reference_assoc _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_reference_assoc _refassoctype_key int4 10 foreign key to MGI_RefAssocType
mgi_reference_assoc _refs_key int4 10 foreign key to BIB_Refs
mgi_reference_assoc creation_date timestamp 29,6 now() date record was created
mgi_reference_assoc modification_date timestamp 29,6 now() date record was last modified
mgi_reference_marker_view _assoc_key int4 10  √  null
mgi_reference_marker_view _createdby_key int4 10  √  null
mgi_reference_marker_view _mgitype_key int4 10  √  null
mgi_reference_marker_view _modifiedby_key int4 10  √  null
mgi_reference_marker_view _object_key int4 10  √  null
mgi_reference_marker_view _refassoctype_key int4 10  √  null
mgi_reference_marker_view _refs_key int4 10  √  null
mgi_reference_marker_view accid text 2147483647  √  null
mgi_reference_marker_view allowonlyone int2 5  √  null
mgi_reference_marker_view assoctype text 2147483647  √  null
mgi_reference_marker_view createdby text 2147483647  √  null
mgi_reference_marker_view creation_date timestamp 29,6  √  null
mgi_reference_marker_view isreviewarticle int2 5  √  null
mgi_reference_marker_view isreviewarticlestring bpchar 3  √  null
mgi_reference_marker_view jnum int4 10  √  null
mgi_reference_marker_view jnumid text 2147483647  √  null
mgi_reference_marker_view modification_date timestamp 29,6  √  null
mgi_reference_marker_view modifiedby text 2147483647  √  null
mgi_reference_marker_view short_citation text 2147483647  √  null
mgi_reference_marker_view symbol text 2147483647  √  null
mgi_reference_strain_view _assoc_key int4 10  √  null
mgi_reference_strain_view _createdby_key int4 10  √  null
mgi_reference_strain_view _mgitype_key int4 10  √  null
mgi_reference_strain_view _modifiedby_key int4 10  √  null
mgi_reference_strain_view _object_key int4 10  √  null
mgi_reference_strain_view _refassoctype_key int4 10  √  null
mgi_reference_strain_view _refs_key int4 10  √  null
mgi_reference_strain_view accid text 2147483647  √  null
mgi_reference_strain_view allowonlyone int2 5  √  null
mgi_reference_strain_view assoctype text 2147483647  √  null
mgi_reference_strain_view creation_date timestamp 29,6  √  null
mgi_reference_strain_view isreviewarticle int2 5  √  null
mgi_reference_strain_view isreviewarticlestring bpchar 3  √  null
mgi_reference_strain_view jnum int4 10  √  null
mgi_reference_strain_view jnumid text 2147483647  √  null
mgi_reference_strain_view modification_date timestamp 29,6  √  null
mgi_reference_strain_view modifiedby text 2147483647  √  null
mgi_reference_strain_view short_citation text 2147483647  √  null
mgi_reference_strain_view strain text 2147483647  √  null
mgi_relationship _category_key int4 10 The category, or type, of this relationship
mgi_relationship _createdby_key int4 10 1001 user who created the record
mgi_relationship _evidence_key int4 10 The term for the relationship evidence
mgi_relationship _modifiedby_key int4 10 1001 user who last modified the record
mgi_relationship _object_key_1 int4 10 First object in the relationship
mgi_relationship _object_key_2 int4 10 Second object in the relationship
mgi_relationship _qualifier_key int4 10 The term for the relationship qualifier
mgi_relationship _refs_key int4 10 The relationship reference
mgi_relationship _relationship_key serial 10  √  nextval('mgi_relationship_seq'::regclass) Primary key
mgi_relationship _relationshipterm_key int4 10 The term identifying the relationship between the two objects
mgi_relationship creation_date timestamp 29,6 now() date record was created
mgi_relationship modification_date timestamp 29,6 now() date record was last modified
mgi_relationship_category _category_key int4 10 Primary key
mgi_relationship_category _createdby_key int4 10 1001 user who created the record
mgi_relationship_category _evidencevocab_key int4 10 Vocabulary that relationships draw their evidence terms from
mgi_relationship_category _mgitype_key_1 int4 10 MGI Type of the First object in the relationship
mgi_relationship_category _mgitype_key_2 int4 10 MGI Type of the Second object in the relationship
mgi_relationship_category _modifiedby_key int4 10 1001 user who last modified the record
mgi_relationship_category _qualifiervocab_key int4 10 The vocabulary that relationships draw their qualifier terms from
mgi_relationship_category _relationshipdag_key int4 10  √  null The DAG which optionally identifies an individual DAG which structures a subset of terms from the vocabulary for use by this category
mgi_relationship_category _relationshipvocab_key int4 10 The vocabulary that relationships draw their relationship terms from
mgi_relationship_category creation_date timestamp 29,6 now() date record was created
mgi_relationship_category modification_date timestamp 29,6 now() date record was last modified
mgi_relationship_category name text 2147483647 The name of this category
mgi_relationship_fear_view _category_key int4 10  √  null
mgi_relationship_fear_view _createdby_key int4 10  √  null
mgi_relationship_fear_view _evidence_key int4 10  √  null
mgi_relationship_fear_view _modifiedby_key int4 10  √  null
mgi_relationship_fear_view _object_key_1 int4 10  √  null
mgi_relationship_fear_view _object_key_2 int4 10  √  null
mgi_relationship_fear_view _organism_key int4 10  √  null
mgi_relationship_fear_view _qualifier_key int4 10  √  null
mgi_relationship_fear_view _refs_key int4 10  √  null
mgi_relationship_fear_view _relationship_key int4 10  √  null
mgi_relationship_fear_view _relationshipterm_key int4 10  √  null
mgi_relationship_fear_view alleleaccid text 2147483647  √  null
mgi_relationship_fear_view allelesymbol text 2147483647  √  null
mgi_relationship_fear_view categoryterm text 2147483647  √  null
mgi_relationship_fear_view createdby text 2147483647  √  null
mgi_relationship_fear_view creation_date timestamp 29,6  √  null
mgi_relationship_fear_view evidenceterm text 2147483647  √  null
mgi_relationship_fear_view jnum int4 10  √  null
mgi_relationship_fear_view jnumid text 2147483647  √  null
mgi_relationship_fear_view markeraccid text 2147483647  √  null
mgi_relationship_fear_view markersymbol text 2147483647  √  null
mgi_relationship_fear_view modification_date timestamp 29,6  √  null
mgi_relationship_fear_view modifiedby text 2147483647  √  null
mgi_relationship_fear_view organism text 2147483647  √  null
mgi_relationship_fear_view qualifierterm text 2147483647  √  null
mgi_relationship_fear_view relationshipterm text 2147483647  √  null
mgi_relationship_fear_view short_citation text 2147483647  √  null
mgi_relationship_markerqtlcandidate_view _object_key_1 int4 10  √  null
mgi_relationship_markerqtlcandidate_view _object_key_2 int4 10  √  null
mgi_relationship_markerqtlcandidate_view _relationship_key int4 10  √  null
mgi_relationship_markerqtlcandidate_view jnumid text 2147483647  √  null
mgi_relationship_markerqtlcandidate_view marker1 text 2147483647  √  null
mgi_relationship_markerqtlcandidate_view marker2 text 2147483647  √  null
mgi_relationship_markerqtlinteraction_view _object_key_1 int4 10  √  null
mgi_relationship_markerqtlinteraction_view _object_key_2 int4 10  √  null
mgi_relationship_markerqtlinteraction_view _relationship_key int4 10  √  null
mgi_relationship_markerqtlinteraction_view marker1 text 2147483647  √  null
mgi_relationship_markerqtlinteraction_view marker2 text 2147483647  √  null
mgi_relationship_markertss_view _category_key int4 10  √  null
mgi_relationship_markertss_view _createdby_key int4 10  √  null
mgi_relationship_markertss_view _evidence_key int4 10  √  null
mgi_relationship_markertss_view _modifiedby_key int4 10  √  null
mgi_relationship_markertss_view _object_key_1 int4 10  √  null
mgi_relationship_markertss_view _object_key_2 int4 10  √  null
mgi_relationship_markertss_view _qualifier_key int4 10  √  null
mgi_relationship_markertss_view _refs_key int4 10  √  null
mgi_relationship_markertss_view _relationship_key int4 10  √  null
mgi_relationship_markertss_view _relationshipterm_key int4 10  √  null
mgi_relationship_markertss_view categoryterm text 2147483647  √  null
mgi_relationship_markertss_view createdby text 2147483647  √  null
mgi_relationship_markertss_view creation_date timestamp 29,6  √  null
mgi_relationship_markertss_view evidenceterm text 2147483647  √  null
mgi_relationship_markertss_view jnum int4 10  √  null
mgi_relationship_markertss_view jnumid text 2147483647  √  null
mgi_relationship_markertss_view marker1 text 2147483647  √  null
mgi_relationship_markertss_view marker2 text 2147483647  √  null
mgi_relationship_markertss_view modification_date timestamp 29,6  √  null
mgi_relationship_markertss_view modifiedby text 2147483647  √  null
mgi_relationship_markertss_view qualifierterm text 2147483647  √  null
mgi_relationship_markertss_view relationshipterm text 2147483647  √  null
mgi_relationship_markertss_view short_citation text 2147483647  √  null
mgi_relationship_property _createdby_key int4 10 1001 user who created the record
mgi_relationship_property _modifiedby_key int4 10 1001 user who last modified the record
mgi_relationship_property _propertyname_key int4 10 The name of the property
mgi_relationship_property _relationship_key int4 10 The relationship this property applies to
mgi_relationship_property _relationshipproperty_key serial 10  √  nextval('mgi_relationship_property_seq'::regclass) Primary key
mgi_relationship_property creation_date timestamp 29,6 now() date record was created
mgi_relationship_property modification_date timestamp 29,6 now() date record was last modified
mgi_relationship_property sequencenum int4 10 Order of properties in this relationship
mgi_relationship_property value text 2147483647 value of the property
mgi_set _createdby_key int4 10 1001 user who created the record
mgi_set _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_set _modifiedby_key int4 10 1001 user who last modified the record
mgi_set _set_key int4 10 primary key
mgi_set creation_date timestamp 29,6 now() date record was created
mgi_set modification_date timestamp 29,6 now() date record was last modified
mgi_set name text 2147483647 set name
mgi_set sequencenum int4 10 sequence number for ordering records
mgi_setmember _createdby_key int4 10 1001 user who created the record
mgi_setmember _modifiedby_key int4 10 1001 user who last modified the record
mgi_setmember _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_setmember _set_key int4 10 foreign key to MGI_Set
mgi_setmember _setmember_key int4 10 primary key
mgi_setmember creation_date timestamp 29,6 now() date record was created
mgi_setmember label text 2147483647  √  null label of the member (optional)
mgi_setmember modification_date timestamp 29,6 now() date record was last modified
mgi_setmember sequencenum int4 10 order of the member within the Set
mgi_setmember_emapa _createdby_key int4 10 1001 user who created the record
mgi_setmember_emapa _modifiedby_key int4 10 1001 user who last modified the record
mgi_setmember_emapa _setmember_emapa_key int4 10 primary key
mgi_setmember_emapa _setmember_key int4 10 foreign key to MGI_SetMember
mgi_setmember_emapa _stage_key int4 10 foreign key to GXD_TheilerStage
mgi_setmember_emapa creation_date timestamp 29,6 now() date record was created
mgi_setmember_emapa modification_date timestamp 29,6 now() date record was last modified
mgi_synonym _createdby_key int4 10 1001 user who created the record
mgi_synonym _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_synonym _modifiedby_key int4 10 1001 user who last modified the record
mgi_synonym _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_synonym _refs_key int4 10  √  null foreign key to BIB_Refs
mgi_synonym _synonym_key serial 10  √  nextval('mgi_synonym_seq'::regclass) primary key
mgi_synonym _synonymtype_key int4 10 foreign key to MGI_SynonymType
mgi_synonym creation_date timestamp 29,6 now() date record was created
mgi_synonym modification_date timestamp 29,6 now() date record was last modified
mgi_synonym synonym text 2147483647 synonym
mgi_synonym_allele_view _createdby_key int4 10  √  null
mgi_synonym_allele_view _mgitype_key int4 10  √  null
mgi_synonym_allele_view _modifiedby_key int4 10  √  null
mgi_synonym_allele_view _object_key int4 10  √  null
mgi_synonym_allele_view _organism_key int4 10  √  null
mgi_synonym_allele_view _refs_key int4 10  √  null
mgi_synonym_allele_view _synonym_key int4 10  √  null
mgi_synonym_allele_view _synonymtype_key int4 10  √  null
mgi_synonym_allele_view allowonlyone int2 5  √  null
mgi_synonym_allele_view creation_date timestamp 29,6  √  null
mgi_synonym_allele_view jnum int4 10  √  null
mgi_synonym_allele_view jnumid text 2147483647  √  null
mgi_synonym_allele_view modification_date timestamp 29,6  √  null
mgi_synonym_allele_view modifiedby text 2147483647  √  null
mgi_synonym_allele_view short_citation text 2147483647  √  null
mgi_synonym_allele_view synonym text 2147483647  √  null
mgi_synonym_allele_view synonymtype text 2147483647  √  null
mgi_synonym_musmarker_view _createdby_key int4 10  √  null
mgi_synonym_musmarker_view _mgitype_key int4 10  √  null
mgi_synonym_musmarker_view _modifiedby_key int4 10  √  null
mgi_synonym_musmarker_view _object_key int4 10  √  null
mgi_synonym_musmarker_view _organism_key int4 10  √  null
mgi_synonym_musmarker_view _refs_key int4 10  √  null
mgi_synonym_musmarker_view _synonym_key int4 10  √  null
mgi_synonym_musmarker_view _synonymtype_key int4 10  √  null
mgi_synonym_musmarker_view allowonlyone int2 5  √  null
mgi_synonym_musmarker_view createdby text 2147483647  √  null
mgi_synonym_musmarker_view creation_date timestamp 29,6  √  null
mgi_synonym_musmarker_view jnum int4 10  √  null
mgi_synonym_musmarker_view jnumid text 2147483647  √  null
mgi_synonym_musmarker_view modification_date timestamp 29,6  √  null
mgi_synonym_musmarker_view modifiedby text 2147483647  √  null
mgi_synonym_musmarker_view short_citation text 2147483647  √  null
mgi_synonym_musmarker_view synonym text 2147483647  √  null
mgi_synonym_musmarker_view synonymtype text 2147483647  √  null
mgi_synonym_strain_view _createdby_key int4 10  √  null
mgi_synonym_strain_view _mgitype_key int4 10  √  null
mgi_synonym_strain_view _modifiedby_key int4 10  √  null
mgi_synonym_strain_view _object_key int4 10  √  null
mgi_synonym_strain_view _organism_key int4 10  √  null
mgi_synonym_strain_view _refs_key int4 10  √  null
mgi_synonym_strain_view _synonym_key int4 10  √  null
mgi_synonym_strain_view _synonymtype_key int4 10  √  null
mgi_synonym_strain_view allowonlyone int2 5  √  null
mgi_synonym_strain_view creation_date timestamp 29,6  √  null
mgi_synonym_strain_view jnum int4 10  √  null
mgi_synonym_strain_view jnumid text 2147483647  √  null
mgi_synonym_strain_view modification_date timestamp 29,6  √  null
mgi_synonym_strain_view modifiedby text 2147483647  √  null
mgi_synonym_strain_view short_citation text 2147483647  √  null
mgi_synonym_strain_view synonym text 2147483647  √  null
mgi_synonym_strain_view synonymtype text 2147483647  √  null
mgi_synonymtype _createdby_key int4 10 1001 user who created the record
mgi_synonymtype _mgitype_key int4 10  √  null foreign key to ACC_MGIType
mgi_synonymtype _modifiedby_key int4 10 1001 user who last modified the record
mgi_synonymtype _organism_key int4 10  √  null foreign key to MGI_Organism
mgi_synonymtype _synonymtype_key int4 10 primary key
mgi_synonymtype allowonlyone int2 5 if 1, then there can be at most one Synonym of this type for a given object
mgi_synonymtype creation_date timestamp 29,6 now() date record was created
mgi_synonymtype definition text 2147483647  √  null defintion of the synonym type
mgi_synonymtype modification_date timestamp 29,6 now() date record was last modified
mgi_synonymtype synonymtype text 2147483647 synonym type
mgi_synonymtype_strain_view _createdby_key int4 10  √  null
mgi_synonymtype_strain_view _mgitype_key int4 10  √  null
mgi_synonymtype_strain_view _modifiedby_key int4 10  √  null
mgi_synonymtype_strain_view _organism_key int4 10  √  null
mgi_synonymtype_strain_view _synonymtype_key int4 10  √  null
mgi_synonymtype_strain_view allowonlyone int2 5  √  null
mgi_synonymtype_strain_view creation_date timestamp 29,6  √  null
mgi_synonymtype_strain_view definition text 2147483647  √  null
mgi_synonymtype_strain_view modification_date timestamp 29,6  √  null
mgi_synonymtype_strain_view synonymtype text 2147483647  √  null
mgi_translation _createdby_key int4 10 1001 user who created the record
mgi_translation _modifiedby_key int4 10 1001 user who last modified the record
mgi_translation _object_key int4 10 foreign key to any object defined in ACC_MGIType
mgi_translation _translation_key serial 10  √  nextval('mgi_translation_seq'::regclass) primary key
mgi_translation _translationtype_key int4 10 foreign key to MGI_TranslationType
mgi_translation badname text 2147483647 bad name to translate
mgi_translation creation_date timestamp 29,6 now() date record was created
mgi_translation modification_date timestamp 29,6 now() date record was last modified
mgi_translation sequencenum int4 10 order of the Translation member
mgi_translationtype _createdby_key int4 10 1001 user who created the record
mgi_translationtype _mgitype_key int4 10 foreign key to ACC_MGIType
mgi_translationtype _modifiedby_key int4 10 1001 user who last modified the record
mgi_translationtype _translationtype_key int4 10 primary key
mgi_translationtype _vocab_key int4 10  √  null foreign key to VOC_Vocab
mgi_translationtype compressionchars text 2147483647  √  null list of characters to remove from a translation target before translation is applied.
mgi_translationtype creation_date timestamp 29,6 now() date record was created
mgi_translationtype modification_date timestamp 29,6 now() date record was last modified
mgi_translationtype regularexpression int2 5 if true (1), then apply a regular expression algorithm to the lookup of the translation target.
mgi_translationtype translationtype text 2147483647 name of the Translation Type
mgi_user _createdby_key int4 10 1001 user who created the record
mgi_user _group_key int4 10  √  null foreign key to VOC_Term where _Vocab_key = 127 (Workflow Group)
mgi_user _modifiedby_key int4 10 1001 user who last modified the record
mgi_user _user_key int4 10 primary key
mgi_user _userstatus_key int4 10 foreign key to VOC_Term where _Vocab_key = 22 (User Status)
mgi_user _usertype_key int4 10 foreign key to VOC_Term where _Vocab_key = 23 (User Type)
mgi_user creation_date timestamp 29,6 now() date record was created
mgi_user login text 2147483647 database login
mgi_user modification_date timestamp 29,6 now() date record was last modified
mgi_user name text 2147483647 user name
mgi_user orcid text 2147483647  √  null ORC ids (see orcid.org)
mgi_user_active_view _createdby_key int4 10  √  null
mgi_user_active_view _group_key int4 10  √  null
mgi_user_active_view _modifiedby_key int4 10  √  null
mgi_user_active_view _user_key int4 10  √  null
mgi_user_active_view _userstatus_key int4 10  √  null
mgi_user_active_view _usertype_key int4 10  √  null
mgi_user_active_view createdby text 2147483647  √  null
mgi_user_active_view creation_date timestamp 29,6  √  null
mgi_user_active_view login text 2147483647  √  null
mgi_user_active_view modification_date timestamp 29,6  √  null
mgi_user_active_view modifiedby text 2147483647  √  null
mgi_user_active_view name text 2147483647  √  null
mgi_user_active_view orcid text 2147483647  √  null
mgi_user_active_view usertype text 2147483647  √  null
mld_assay_types _assay_type_key serial 10  √  nextval('mld_assay_types_seq'::regclass) primary key
mld_assay_types creation_date timestamp 29,6 now() date record was created
mld_assay_types description text 2147483647 assay description
mld_assay_types modification_date timestamp 29,6 now() date record was last modified
mld_concordance _expt_key int4 10 foreign key to MLD_Expts
mld_concordance _marker_key int4 10  √  null foreign key to MRK_Marker
mld_concordance chromosome text 2147483647  √  null chromosome value; is NULL if _Marker_key is not NULL
mld_concordance cnn int4 10 -/-; number of Hybrid cells where neither the Concordance Marker/Chromosome nor the linkage Marker is present
mld_concordance cnp int4 10 -/+; number of Hybrid cells where the Concordance Marker/Chromosome is not present, but the linkage Marker is present
mld_concordance cpn int4 10 +/-; number of Hybrid cells where the Concordance Marker/Chromosome is present, but the linkage Marker is not present
mld_concordance cpp int4 10 +/+; number of Hybrid cells where both the Concordance Marker/Chromosome and the linkage Marker are present
mld_concordance creation_date timestamp 29,6 now() date record was created
mld_concordance modification_date timestamp 29,6 now() date record was last modified
mld_concordance sequencenum int4 10 sequence number for ordering records
mld_contig _contig_key int4 10 primary key
mld_contig _expt_key int4 10 foreign key to MLD_Expts
mld_contig creation_date timestamp 29,6 now() date record was created
mld_contig maxcm numeric 131089  √  null maximum cM position of markers within the Contig
mld_contig mincm numeric 131089  √  null minimum cM position of markers within the Contig
mld_contig minlink int4 10  √  null indicates the minimum number of common hits required to assemble YACs into the Contig.
mld_contig modification_date timestamp 29,6 now() date record was last modified
mld_contig name text 2147483647  √  null name of Contig
mld_contigprobe _contig_key int4 10 foreign key to MLD_Contig
mld_contigprobe _probe_key int4 10 foreign key to PRB_Probe
mld_contigprobe creation_date timestamp 29,6 now() date record was created
mld_contigprobe modification_date timestamp 29,6 now() date record was last modified
mld_contigprobe sequencenum int4 10 sequence number for ordering records
mld_expt_marker _allele_key int4 10  √  null foreign key to ALL_Allele
mld_expt_marker _assay_type_key int4 10 foreign key to MLD_Assay_Types
mld_expt_marker _assoc_key serial 10  √  nextval('mld_expt_marker_seq'::regclass)
mld_expt_marker _expt_key int4 10 foreign key to MLD_Expts
mld_expt_marker _marker_key int4 10 foreign key to MRK_Marker
mld_expt_marker creation_date timestamp 29,6 now() date record was created
mld_expt_marker description text 2147483647  √  null description of probes used, etc.
mld_expt_marker matrixdata int2 5 is Marker typed in haplotype data? yes (1), no (0) (MLD_MCDataList)
mld_expt_marker modification_date timestamp 29,6 now() date record was last modified
mld_expt_marker sequencenum int4 10 sequence number for ordering records
mld_expt_marker_view _allele_key int4 10  √  null
mld_expt_marker_view _assay_type_key int4 10  √  null
mld_expt_marker_view _assoc_key int4 10  √  null
mld_expt_marker_view _expt_key int4 10  √  null
mld_expt_marker_view _marker_key int4 10  √  null
mld_expt_marker_view _primary text 2147483647  √  null
mld_expt_marker_view accid text 2147483647  √  null
mld_expt_marker_view allele text 2147483647  √  null
mld_expt_marker_view assay text 2147483647  √  null
mld_expt_marker_view authors text 2147483647  √  null
mld_expt_marker_view chromosome text 2147483647  √  null
mld_expt_marker_view creation_date timestamp 29,6  √  null
mld_expt_marker_view description text 2147483647  √  null
mld_expt_marker_view expttype text 2147483647  √  null
mld_expt_marker_view jnum int4 10  √  null
mld_expt_marker_view jnumid text 2147483647  √  null
mld_expt_marker_view matrixdata int2 5  √  null
mld_expt_marker_view modification_date timestamp 29,6  √  null
mld_expt_marker_view sequencenum int4 10  √  null
mld_expt_marker_view short_citation text 2147483647  √  null
mld_expt_marker_view symbol text 2147483647  √  null
mld_expt_marker_view tag int4 10  √  null
mld_expt_notes _expt_key int4 10 foreign key to MLD_Expts
mld_expt_notes creation_date timestamp 29,6 now() date record was created
mld_expt_notes modification_date timestamp 29,6 now() date record was last modified
mld_expt_notes note text 2147483647 note
mld_expt_view _expt_key int4 10  √  null
mld_expt_view _primary text 2147483647  √  null
mld_expt_view _refs_key int4 10  √  null
mld_expt_view authors text 2147483647  √  null
mld_expt_view chromosome text 2147483647  √  null
mld_expt_view creation_date timestamp 29,6  √  null
mld_expt_view exptlabel text 2147483647  √  null
mld_expt_view expttype text 2147483647  √  null
mld_expt_view jnum int4 10  √  null
mld_expt_view jnumid text 2147483647  √  null
mld_expt_view mgiid text 2147483647  √  null
mld_expt_view modification_date timestamp 29,6  √  null
mld_expt_view numericpart int4 10  √  null
mld_expt_view prefixpart text 2147483647  √  null
mld_expt_view short_citation text 2147483647  √  null
mld_expt_view tag int4 10  √  null
mld_expts _expt_key serial 10  √  nextval('mld_expts_seq'::regclass) primary key
mld_expts _refs_key int4 10 foreign key to BIB_Refs
mld_expts chromosome text 2147483647 chromosome value
mld_expts creation_date timestamp 29,6 now() date record was created
mld_expts expttype text 2147483647 experiment type (ex. CROSS, RI, FISH, IN SITU, TEXT)
mld_expts modification_date timestamp 29,6 now() date record was last modified
mld_expts tag int4 10 unique integer value for each experiment type defined for a given reference (CROSS-1, CROSS-2, etc.)
mld_fish _expt_key int4 10 foreign key to MLD_Expts
mld_fish _strain_key int4 10 foreign key to PRB_Strain
mld_fish band text 2147483647  √  null cytogenetic position on chromosome to which marker is assigned
mld_fish cellorigin text 2147483647  √  null cell type from which analyzed metaphase spreads were derived
mld_fish creation_date timestamp 29,6 now() date record was created
mld_fish karyotype text 2147483647  √  null method used to identify chromosome bands
mld_fish label text 2147483647  √  null type of fluorescence on probe
mld_fish modification_date timestamp 29,6 now() date record was last modified
mld_fish nummetaphase int4 10  √  null # of metaphase spreads analyzed in experiment
mld_fish robertsonians text 2147483647  √  null chromosomal aberration used to identify marker assignment
mld_fish totaldouble int4 10  √  null # of double fluorescent signals indicating presence of marker
mld_fish totalsingle int4 10  √  null # of single flourescent signals indicating presence of marker
mld_fish_region _expt_key int4 10 foreign key to MLD_Expts
mld_fish_region creation_date timestamp 29,6 now() date record was created
mld_fish_region modification_date timestamp 29,6 now() date record was last modified
mld_fish_region region text 2147483647  √  null chromosomal region
mld_fish_region sequencenum int4 10 sequence number for ordering records
mld_fish_region totaldouble int4 10  √  null number of double signals detected in region
mld_fish_region totalsingle int4 10  √  null number of single signals detected in region
mld_hit _expt_key int4 10 foreign key to MLD_Expts
mld_hit _probe_key int4 10 foreign key to PRB_Probe
mld_hit _target_key int4 10 foreign key to PRB_Probe (Target (YAC))
mld_hit creation_date timestamp 29,6 now() date record was created
mld_hit modification_date timestamp 29,6 now() date record was last modified
mld_hybrid _expt_key int4 10 foreign key to MLD_Expts
mld_hybrid band text 2147483647  √  null region on chromosome to which marker is assigned according to experimental results
mld_hybrid chrsorgenes int2 5 does MLD_Concordance table contain Chromosome (0) or Marker (1) values?
mld_hybrid creation_date timestamp 29,6 now() date record was created
mld_hybrid modification_date timestamp 29,6 now() date record was last modified
mld_insitu _expt_key int4 10 foreign key to MLD_Expts
mld_insitu _strain_key int4 10 foreign key to PRB_Strain
mld_insitu band text 2147483647  √  null cytogenetic position on chromosome to which marker is assigned
mld_insitu cellorigin text 2147483647  √  null cell type from which analyzed metaphase spreads were derived
mld_insitu creation_date timestamp 29,6 now() date record was created
mld_insitu grainsonchrom int4 10  √  null # of grains hybridizing to correct chromosomal location
mld_insitu grainsotherchrom int4 10  √  null # of grains hybridizing to other chromosomal locations
mld_insitu karyotype text 2147483647  √  null method used to identify chromosome bands
mld_insitu modification_date timestamp 29,6 now() date record was last modified
mld_insitu nummetaphase int4 10  √  null # of metaphase spreads analyzed in experiment
mld_insitu robertsonians text 2147483647  √  null chromosomal aberration used to identify marker assignment
mld_insitu totalgrains int4 10  √  null # of grains observed in experiment
mld_isregion _expt_key int4 10 foreign key to MLD_Expts
mld_isregion creation_date timestamp 29,6 now() date record was created
mld_isregion graincount int4 10 # of grains observed over the region
mld_isregion modification_date timestamp 29,6 now() date record was last modified
mld_isregion region text 2147483647  √  null chromosomal region
mld_isregion sequencenum int4 10 sequence number for ordering records
mld_matrix _cross_key int4 10 foreign key to CRS_Cross
mld_matrix _expt_key int4 10 foreign key to MLD_Expts
mld_matrix creation_date timestamp 29,6 now() date record was created
mld_matrix female text 2147483647  √  null genotype of mother
mld_matrix female2 text 2147483647  √  null genotype of mother; overflow
mld_matrix male text 2147483647  √  null genotype of father
mld_matrix male2 text 2147483647  √  null genotype of father; overflow
mld_matrix modification_date timestamp 29,6 now() date record was last modified
mld_mc2point _expt_key int4 10 foreign key to MLD_Expts
mld_mc2point _marker_key_1 int4 10 foreign key to MRK_Marker
mld_mc2point _marker_key_2 int4 10 foreign key to MRK_Marker
mld_mc2point creation_date timestamp 29,6 now() date record was created
mld_mc2point modification_date timestamp 29,6 now() date record was last modified
mld_mc2point numparentals int4 10 # of animals exhibiting parental genotype
mld_mc2point numrecombinants int4 10 # of animals exhibiting recombinant genotype
mld_mc2point sequencenum int4 10 sequence number for ordering records
mld_mcdatalist _expt_key int4 10 foreign key to MLD_Expts
mld_mcdatalist alleleline text 2147483647 haplotypes for marker; order of alleles must correspond with order of Markers in Experiment Marker list (MLD_Expt_Marker)
mld_mcdatalist creation_date timestamp 29,6 now() date record was created
mld_mcdatalist modification_date timestamp 29,6 now() date record was last modified
mld_mcdatalist offspringnmbr int4 10 designates number of offspring detected with haplotype
mld_mcdatalist sequencenum int4 10 sequence number for ordering records
mld_notes _refs_key int4 10 foreign key to BIB_Refs
mld_notes creation_date timestamp 29,6 now() date record was created
mld_notes modification_date timestamp 29,6 now() date record was last modified
mld_notes note text 2147483647 note
mld_ri _expt_key int4 10 foreign key to MLD_Expts
mld_ri _riset_key int4 10 foreign key to RI_RISet
mld_ri creation_date timestamp 29,6 now() date record was created
mld_ri modification_date timestamp 29,6 now() date record was last modified
mld_ri ri_idlist text 2147483647 list of individual offspring typed
mld_ri2point _expt_key int4 10 foreign key to MLD_Expts
mld_ri2point _marker_key_1 int4 10 foreign key to MRK_Marker
mld_ri2point _marker_key_2 int4 10 foreign key to MRK_Marker
mld_ri2point creation_date timestamp 29,6 now() date record was created
mld_ri2point modification_date timestamp 29,6 now() date record was last modified
mld_ri2point numrecombinants int4 10 # of animals exhibiting recombinant genotype
mld_ri2point numtotal int4 10 # of animals typed
mld_ri2point ri_lines text 2147483647  √  null RI sets used in typing
mld_ri2point sequencenum int4 10 sequence number for ordering records
mld_ridata _expt_key int4 10 foreign key to MLD_Expts
mld_ridata _marker_key int4 10 foreign key to MRK_Marker
mld_ridata alleleline text 2147483647 haplotypes for marker; must correspond with listing of animals typed (MLD_RI.RI_IDList)
mld_ridata creation_date timestamp 29,6 now() date record was created
mld_ridata modification_date timestamp 29,6 now() date record was last modified
mld_ridata sequencenum int4 10 sequence number for ordering records
mld_statistics _expt_key int4 10 foreign key to MLD_Expts
mld_statistics _marker_key_1 int4 10 foreign key to MRK_Marker
mld_statistics _marker_key_2 int4 10 foreign key to MRK_Marker
mld_statistics creation_date timestamp 29,6 now() date record was created
mld_statistics modification_date timestamp 29,6 now() date record was last modified
mld_statistics pcntrecomb numeric 131089 percentage of recombination per number of mice
mld_statistics recomb int4 10 number of mice which recombined for Marker pair
mld_statistics sequencenum int4 10 sequence number for ordering records
mld_statistics stderr numeric 131089 standard error of the recombination percentage
mld_statistics total int4 10 total number of mice typed for Marker pair
mrk_acc_view _accession_key int4 10  √  null
mrk_acc_view _createdby_key int4 10  √  null
mrk_acc_view _logicaldb_key int4 10  √  null
mrk_acc_view _mgitype_key int4 10  √  null
mrk_acc_view _modifiedby_key int4 10  √  null
mrk_acc_view _object_key int4 10  √  null
mrk_acc_view _organism_key int4 10  √  null
mrk_acc_view accid text 2147483647  √  null
mrk_acc_view creation_date timestamp 29,6  √  null
mrk_acc_view logicaldb text 2147483647  √  null
mrk_acc_view modification_date timestamp 29,6  √  null
mrk_acc_view numericpart int4 10  √  null
mrk_acc_view preferred int2 5  √  null
mrk_acc_view prefixpart text 2147483647  √  null
mrk_acc_view private int2 5  √  null
mrk_accnoref_view _accession_key int4 10  √  null
mrk_accnoref_view _createdby_key int4 10  √  null
mrk_accnoref_view _logicaldb_key int4 10  √  null
mrk_accnoref_view _mgitype_key int4 10  √  null
mrk_accnoref_view _modifiedby_key int4 10  √  null
mrk_accnoref_view _object_key int4 10  √  null
mrk_accnoref_view accid text 2147483647  √  null
mrk_accnoref_view creation_date timestamp 29,6  √  null
mrk_accnoref_view description text 2147483647  √  null
mrk_accnoref_view logicaldb text 2147483647  √  null
mrk_accnoref_view mgitype text 2147483647  √  null
mrk_accnoref_view modification_date timestamp 29,6  √  null
mrk_accnoref_view numericpart int4 10  √  null
mrk_accnoref_view preferred int2 5  √  null
mrk_accnoref_view prefixpart text 2147483647  √  null
mrk_accnoref_view private int2 5  √  null
mrk_accnoref_view subtype text 2147483647  √  null
mrk_accref1_view _accession_key int4 10  √  null
mrk_accref1_view _createdby_key int4 10  √  null
mrk_accref1_view _logicaldb_key int4 10  √  null
mrk_accref1_view _mgitype_key int4 10  √  null
mrk_accref1_view _modifiedby_key int4 10  √  null
mrk_accref1_view _object_key int4 10  √  null
mrk_accref1_view _refs_key int4 10  √  null
mrk_accref1_view accid text 2147483647  √  null
mrk_accref1_view createdby text 2147483647  √  null
mrk_accref1_view creation_date timestamp 29,6  √  null
mrk_accref1_view jnum int4 10  √  null
mrk_accref1_view jnumid text 2147483647  √  null
mrk_accref1_view logicaldb text 2147483647  √  null
mrk_accref1_view mgitype text 2147483647  √  null
mrk_accref1_view modification_date timestamp 29,6  √  null
mrk_accref1_view modifiedby text 2147483647  √  null
mrk_accref1_view numericpart int4 10  √  null
mrk_accref1_view preferred int2 5  √  null
mrk_accref1_view prefixpart text 2147483647  √  null
mrk_accref1_view private int2 5  √  null
mrk_accref1_view short_citation text 2147483647  √  null
mrk_accref2_view _accession_key int4 10  √  null
mrk_accref2_view _createdby_key int4 10  √  null
mrk_accref2_view _logicaldb_key int4 10  √  null
mrk_accref2_view _mgitype_key int4 10  √  null
mrk_accref2_view _modifiedby_key int4 10  √  null
mrk_accref2_view _object_key int4 10  √  null
mrk_accref2_view _refs_key int4 10  √  null
mrk_accref2_view accid text 2147483647  √  null
mrk_accref2_view createdby text 2147483647  √  null
mrk_accref2_view creation_date timestamp 29,6  √  null
mrk_accref2_view jnum int4 10  √  null
mrk_accref2_view jnumid text 2147483647  √  null
mrk_accref2_view logicaldb text 2147483647  √  null
mrk_accref2_view mgitype text 2147483647  √  null
mrk_accref2_view modification_date timestamp 29,6  √  null
mrk_accref2_view modifiedby text 2147483647  √  null
mrk_accref2_view numericpart int4 10  √  null
mrk_accref2_view preferred int2 5  √  null
mrk_accref2_view prefixpart text 2147483647  √  null
mrk_accref2_view private int2 5  √  null
mrk_accref2_view short_citation text 2147483647  √  null
mrk_biotypemapping _biotypemapping_key int4 10 primary key
mrk_biotypemapping _biotypeterm_key int4 10 fk to voc_term
mrk_biotypemapping _biotypevocab_key int4 10 fk to voc_vocab; 1 of 3 provider biotype vocabs (103,104,105)
mrk_biotypemapping _createdby_key int4 10 1001 user who created the record
mrk_biotypemapping _marker_type_key int4 10 fk to mrk_types
mrk_biotypemapping _mcvterm_key int4 10 fk to voc_term where _vocab_key = 79 (Marker Category aka MCV/FeatureType term)
mrk_biotypemapping _modifiedby_key int4 10 1001 user who last modified the record
mrk_biotypemapping _primarymcvterm_key int4 10 fk to voc_term where _vocab_key = 79 (Primary MCV/FeatureType term)
mrk_biotypemapping creation_date timestamp 29,6 now() date record was created
mrk_biotypemapping modification_date timestamp 29,6 now() date record was last modified
mrk_biotypemapping usemcvchildren int4 10 0 use feature type/MCV children to determine raw biotype conflicts
mrk_chromosome _chromosome_key serial 10  √  nextval('mrk_chromosome_seq'::regclass) primary key
mrk_chromosome _createdby_key int4 10 1001 user who created the record
mrk_chromosome _modifiedby_key int4 10 1001 user who last modified the record
mrk_chromosome _organism_key int4 10 organism (foreign key to MGI_Organism)
mrk_chromosome chromosome text 2147483647 chromosome value
mrk_chromosome creation_date timestamp 29,6 now() date record was created
mrk_chromosome modification_date timestamp 29,6 now() date record was last modified
mrk_chromosome sequencenum int4 10 sequence number for ordering records
mrk_cluster _cluster_key serial 10  √  nextval('mrk_cluster_seq'::regclass) Primary key
mrk_cluster _clustersource_key int4 10 The term for the source or 'provider' of the cluster
mrk_cluster _clustertype_key int4 10 The term for the type of cluster
mrk_cluster _createdby_key int4 10 1001 user who created the record
mrk_cluster _modifiedby_key int4 10 1001 user who last modified the record
mrk_cluster cluster_date timestamp 29,6  √  now() Cluster Date
mrk_cluster clusterid text 2147483647  √  null Cluster Accession ID
mrk_cluster creation_date timestamp 29,6 now() date record was created
mrk_cluster modification_date timestamp 29,6 now() date record was last modified
mrk_cluster version text 2147483647  √  null Cluster version or release number
mrk_clustermember _cluster_key int4 10 Foreign key to MRK_Cluster
mrk_clustermember _clustermember_key serial 10  √  nextval('mrk_clustermember_seq'::regclass) Primary key
mrk_clustermember _marker_key int4 10 foreign key to MRK_Marker
mrk_clustermember sequencenum int4 10 order of members within this cluster
mrk_current _current_key int4 10 foreign key to MRK_Marker
mrk_current _marker_key int4 10 foreign key to MRK_Marker
mrk_current creation_date timestamp 29,6 now() date record was created
mrk_current modification_date timestamp 29,6 now() date record was last modified
mrk_current_view _current_key int4 10  √  null
mrk_current_view _marker_key int4 10  √  null
mrk_current_view _marker_type_key int4 10  √  null
mrk_current_view chromosome text 2147483647  √  null
mrk_current_view creation_date timestamp 29,6  √  null
mrk_current_view current_symbol text 2147483647  √  null
mrk_current_view modification_date timestamp 29,6  √  null
mrk_current_view symbol text 2147483647  √  null
mrk_do_cache _cache_key int4 10 primary key
mrk_do_cache _genotype_key int4 10 foreign key to GXD_Genotype
mrk_do_cache _marker_key int4 10 foreign key to MRK_Marker
mrk_do_cache _organism_key int4 10 foreign key to MGI_Organism
mrk_do_cache _refs_key int4 10 foreign key to BIB_Refs; reference for DO annotation
mrk_do_cache _term_key int4 10 foreign key to VOC_Term where _Vocab_key = 44 (DO)
mrk_do_cache creation_date timestamp 29,6 now() date record was created
mrk_do_cache genotypefootnote text 2147483647  √  null genotype footnote for WI
mrk_do_cache header text 2147483647 genotype header for WI
mrk_do_cache headerfootnote text 2147483647  √  null genotype header footnote for WI
mrk_do_cache jnumid text 2147483647 J: id of Annotation reference
mrk_do_cache modification_date timestamp 29,6 now() date record was last modified
mrk_do_cache omimcategory3 int4 10 disease mouse model format
mrk_do_cache qualifier text 2147483647  √  null DO qualifier
mrk_do_cache term text 2147483647 DO term
mrk_do_cache termid text 2147483647 DO term ID
mrk_history _assoc_key serial 10  √  nextval('mrk_history_seq'::regclass)
mrk_history _createdby_key int4 10 1001 user who created the record
mrk_history _history_key int4 10 foreign key to MRK_Marker
mrk_history _marker_event_key int4 10 foreign key to VOC_Term
mrk_history _marker_eventreason_key int4 10 foreign key to VOC_Term
mrk_history _marker_key int4 10 foreign key to MRK_Marker
mrk_history _modifiedby_key int4 10 1001 user who last modified the record
mrk_history _refs_key int4 10  √  null foreign key to BIB_Refs
mrk_history creation_date timestamp 29,6 now() date record was created
mrk_history event_date timestamp 29,6  √  now() date of the nomenclature event
mrk_history modification_date timestamp 29,6 now() date record was last modified
mrk_history name text 2147483647  √  null name of the symbol
mrk_history sequencenum int4 10 sequence number of the event
mrk_history_view _assoc_key int4 10  √  null
mrk_history_view _createdby_key int4 10  √  null
mrk_history_view _history_key int4 10  √  null
mrk_history_view _marker_event_key int4 10  √  null
mrk_history_view _marker_eventreason_key int4 10  √  null
mrk_history_view _marker_key int4 10  √  null
mrk_history_view _modifiedby_key int4 10  √  null
mrk_history_view _refs_key int4 10  √  null
mrk_history_view createdby text 2147483647  √  null
mrk_history_view creation_date timestamp 29,6  √  null
mrk_history_view event text 2147483647  √  null
mrk_history_view event_date timestamp 29,6  √  null
mrk_history_view event_display bpchar 10  √  null
mrk_history_view eventreason text 2147483647  √  null
mrk_history_view history text 2147483647  √  null
mrk_history_view historyname text 2147483647  √  null
mrk_history_view jnumid text 2147483647  √  null
mrk_history_view markername text 2147483647  √  null
mrk_history_view modification_date timestamp 29,6  √  null
mrk_history_view modifiedby text 2147483647  √  null
mrk_history_view name text 2147483647  √  null
mrk_history_view sequencenum int4 10  √  null
mrk_history_view short_citation text 2147483647  √  null
mrk_history_view symbol text 2147483647  √  null
mrk_label _label_key int4 10 primary key
mrk_label _label_status_key int4 10 1 = current, 2 = old
mrk_label _marker_key int4 10 foreign key to MRK_Marker
mrk_label _organism_key int4 10 organism (foreign key to MGI_Organism)
mrk_label _orthologorganism_key int4 10  √  null organism of ortholog (foreign key to MGI_Organism)
mrk_label creation_date timestamp 29,6 now() date record was created
mrk_label label text 2147483647 label (name, symbol, synonym)
mrk_label labeltype text 2147483647 label type (N, S, Y)
mrk_label labeltypename text 2147483647 specifies if label is current symbol, current name, allele symbol, allele name, etc.
mrk_label modification_date timestamp 29,6 now() date record was last modified
mrk_label priority int4 10 an integer representing the priority of this record for sorting purposes. the higher the number, the higher the priority.
mrk_location_cache _createdby_key int4 10 1001 user who created the record
mrk_location_cache _marker_key int4 10 primary key/foreign key to MRK_Marker
mrk_location_cache _marker_type_key int4 10 foreign key to MRK_Types
mrk_location_cache _modifiedby_key int4 10 1001 user who last modified the record
mrk_location_cache _organism_key int4 10 foreign key to MGI_Organism
mrk_location_cache chromosome text 2147483647 chromosome
mrk_location_cache cmoffset float8 17,17  √  null cytogenetic cmOffset
mrk_location_cache creation_date timestamp 29,6 now() date record was created
mrk_location_cache cytogeneticoffset text 2147483647  √  null cytogenetic cmOffset
mrk_location_cache endcoordinate float8 17,17  √  null end genome coordinate
mrk_location_cache genomicchromosome text 2147483647  √  null chromosome
mrk_location_cache mapunits text 2147483647  √  null units of genome coordinates
mrk_location_cache modification_date timestamp 29,6 now() date record was last modified
mrk_location_cache provider text 2147483647  √  null data provider of genome coordinates
mrk_location_cache sequencenum int4 10 chromosome order
mrk_location_cache startcoordinate float8 17,17  √  null start genome coordinate
mrk_location_cache strand bpchar 1  √  null strand for genome coordinate
mrk_location_cache version text 2147483647  √  null genome build version for genome coordinates
mrk_marker _createdby_key int4 10 1001 user who created the record
mrk_marker _marker_key serial 10  √  nextval('mrk_marker_seq'::regclass) primary key
mrk_marker _marker_status_key int4 10 foreign key to MRK_Status
mrk_marker _marker_type_key int4 10 foreign key to MRK_Types
mrk_marker _modifiedby_key int4 10 1001 user who last modified the record
mrk_marker _organism_key int4 10 foreign key to MGI_Organism
mrk_marker chromosome text 2147483647 chromosome
mrk_marker cmoffset float8 17,17  √  null approximate centimorgan (cM) position on chromosome
mrk_marker creation_date timestamp 29,6 now() date record was created
mrk_marker cytogeneticoffset text 2147483647  √  null cytogenetic band
mrk_marker modification_date timestamp 29,6 now() date record was last modified
mrk_marker name text 2147483647 official name of marker
mrk_marker symbol text 2147483647 official symbol of marker
mrk_marker_view _createdby_key int4 10  √  null
mrk_marker_view _marker_key int4 10  √  null
mrk_marker_view _marker_status_key int4 10  √  null
mrk_marker_view _marker_type_key int4 10  √  null
mrk_marker_view _modifiedby_key int4 10  √  null
mrk_marker_view _organism_key int4 10  √  null
mrk_marker_view chromosome text 2147483647  √  null
mrk_marker_view cmoffset float8 17,17  √  null
mrk_marker_view commonname text 2147483647  √  null
mrk_marker_view createdby text 2147483647  √  null
mrk_marker_view creation_date timestamp 29,6  √  null
mrk_marker_view cytogeneticoffset text 2147483647  √  null
mrk_marker_view latinname text 2147483647  √  null
mrk_marker_view markertype text 2147483647  √  null
mrk_marker_view modification_date timestamp 29,6  √  null
mrk_marker_view modifiedby text 2147483647  √  null
mrk_marker_view name text 2147483647  √  null
mrk_marker_view organism text 2147483647  √  null
mrk_marker_view status text 2147483647  √  null
mrk_marker_view symbol text 2147483647  √  null
mrk_mcv_cache _createdby_key int4 10 1001 user who created the record
mrk_mcv_cache _marker_key int4 10 foreign key to MRK_Marker
mrk_mcv_cache _mcvterm_key int4 10 foreign key to VOC_Term where _Vocab_key = 79 (Marker Category); 'gene', 'protein coding gene', 'non-coding RNA gene', etc.
mrk_mcv_cache _modifiedby_key int4 10 1001 user who last modified the record
mrk_mcv_cache creation_date timestamp 29,6 now() date record was created
mrk_mcv_cache directterms text 2147483647 direct vocabulary terms
mrk_mcv_cache modification_date timestamp 29,6 now() date record was last modified
mrk_mcv_cache qualifier bpchar 1 'D' = direct, 'I' = infered
mrk_mcv_cache term text 2147483647 term description (VOC_Term.term)
mrk_mcv_count_cache _createdby_key int4 10 1001 user who created the record
mrk_mcv_count_cache _mcvterm_key int4 10 foreign key to VOC_Term (_Vocab_key = 79)
mrk_mcv_count_cache _modifiedby_key int4 10 1001 user who last modified the record
mrk_mcv_count_cache creation_date timestamp 29,6 now() date record was created
mrk_mcv_count_cache markercount int4 10 the current number of markers annotated to this term
mrk_mcv_count_cache modification_date timestamp 29,6 now() date record was last modified
mrk_mouse_view _accession_key int4 10  √  null
mrk_mouse_view _createdby_key int4 10  √  null
mrk_mouse_view _marker_key int4 10  √  null
mrk_mouse_view _marker_status_key int4 10  √  null
mrk_mouse_view _marker_type_key int4 10  √  null
mrk_mouse_view _modifiedby_key int4 10  √  null
mrk_mouse_view _organism_key int4 10  √  null
mrk_mouse_view chromosome text 2147483647  √  null
mrk_mouse_view cmoffset float8 17,17  √  null
mrk_mouse_view commonname text 2147483647  √  null
mrk_mouse_view creation_date timestamp 29,6  √  null
mrk_mouse_view cytogeneticoffset text 2147483647  √  null
mrk_mouse_view latinname text 2147483647  √  null
mrk_mouse_view markertype text 2147483647  √  null
mrk_mouse_view mgiid text 2147483647  √  null
mrk_mouse_view modification_date timestamp 29,6  √  null
mrk_mouse_view name text 2147483647  √  null
mrk_mouse_view numericpart int4 10  √  null
mrk_mouse_view organism text 2147483647  √  null
mrk_mouse_view prefixpart text 2147483647  √  null
mrk_mouse_view status text 2147483647  √  null
mrk_mouse_view symbol text 2147483647  √  null
mrk_notes _marker_key int4 10 foreign key to MRK_Marker
mrk_notes creation_date timestamp 29,6 now() date record was created
mrk_notes modification_date timestamp 29,6 now() date record was last modified
mrk_notes note text 2147483647 note
mrk_reference _marker_key int4 10 foreign key to MRK_Marker
mrk_reference _refs_key int4 10 foreign key to BIB_Refs
mrk_reference creation_date timestamp 29,6 now() date record was created
mrk_reference jnum int4 10 J: accession id of the reference without the prefix; integer (xxxx)
mrk_reference jnumid text 2147483647 J: accession id of the reference (J:xxxx)
mrk_reference mgiid text 2147483647 MGI accession id of the reference (MGI:xxxx)
mrk_reference modification_date timestamp 29,6 now() date record was last modified
mrk_reference pubmedid text 2147483647  √  null pubmed accession id of the reference (xxxx)
mrk_status _marker_status_key int4 10 primary key
mrk_status creation_date timestamp 29,6 now() date record was created
mrk_status modification_date timestamp 29,6 now() date record was last modified
mrk_status status text 2147483647 status
mrk_strainmarker _createdby_key int4 10 1001 user who created the record
mrk_strainmarker _marker_key int4 10  √  null foreign key to MRK_Marker/if null, then no canonical gene
mrk_strainmarker _modifiedby_key int4 10 1001 user who last modified the record
mrk_strainmarker _refs_key int4 10 foreign key to BIB_Refs
mrk_strainmarker _strain_key int4 10 foreign key to PRB_Strain
mrk_strainmarker _strainmarker_key serial 10  √  nextval('mrk_strainmarker_seq'::regclass) primary key
mrk_strainmarker creation_date timestamp 29,6 now() date record was created
mrk_strainmarker modification_date timestamp 29,6 now() date record was last modified
mrk_summary_view _accession_key int4 10  √  null
mrk_summary_view _createdby_key int4 10  √  null
mrk_summary_view _logicaldb_key int4 10  √  null
mrk_summary_view _mgitype_key int4 10  √  null
mrk_summary_view _modifiedby_key int4 10  √  null
mrk_summary_view _object_key int4 10  √  null
mrk_summary_view accid text 2147483647  √  null
mrk_summary_view creation_date timestamp 29,6  √  null
mrk_summary_view description text 2147483647  √  null
mrk_summary_view mgiid text 2147483647  √  null
mrk_summary_view modification_date timestamp 29,6  √  null
mrk_summary_view numericpart int4 10  √  null
mrk_summary_view preferred int2 5  √  null
mrk_summary_view prefixpart text 2147483647  √  null
mrk_summary_view private int2 5  √  null
mrk_summary_view short_description text 2147483647  √  null
mrk_summary_view subtype text 2147483647  √  null
mrk_summarybyreference_view _marker_key int4 10  √  null
mrk_summarybyreference_view accid text 2147483647  √  null
mrk_summarybyreference_view featuretypes text 2147483647  √  null
mrk_summarybyreference_view jnumid text 2147483647  √  null
mrk_summarybyreference_view markerstatus text 2147483647  √  null
mrk_summarybyreference_view markertype text 2147483647  √  null
mrk_summarybyreference_view name text 2147483647  √  null
mrk_summarybyreference_view symbol text 2147483647  √  null
mrk_summarybyreference_view synonyms text 2147483647  √  null
mrk_types _marker_type_key int4 10 primary key
mrk_types creation_date timestamp 29,6 now() date record was created
mrk_types modification_date timestamp 29,6 now() date record was last modified
mrk_types name text 2147483647 marker type description
prb_acc_view _accession_key int4 10  √  null
prb_acc_view _createdby_key int4 10  √  null
prb_acc_view _logicaldb_key int4 10  √  null
prb_acc_view _mgitype_key int4 10  √  null
prb_acc_view _modifiedby_key int4 10  √  null
prb_acc_view _object_key int4 10  √  null
prb_acc_view accid text 2147483647  √  null
prb_acc_view creation_date timestamp 29,6  √  null
prb_acc_view description text 2147483647  √  null
prb_acc_view logicaldb text 2147483647  √  null
prb_acc_view modification_date timestamp 29,6  √  null
prb_acc_view numericpart int4 10  √  null
prb_acc_view preferred int2 5  √  null
prb_acc_view prefixpart text 2147483647  √  null
prb_acc_view private int2 5  √  null
prb_accref_view _accession_key int4 10  √  null
prb_accref_view _createdby_key int4 10  √  null
prb_accref_view _logicaldb_key int4 10  √  null
prb_accref_view _mgitype_key int4 10  √  null
prb_accref_view _modifiedby_key int4 10  √  null
prb_accref_view _object_key int4 10  √  null
prb_accref_view _reference_key int4 10  √  null
prb_accref_view accid text 2147483647  √  null
prb_accref_view creation_date timestamp 29,6  √  null
prb_accref_view logicaldb text 2147483647  √  null
prb_accref_view mgitype text 2147483647  √  null
prb_accref_view modification_date timestamp 29,6  √  null
prb_accref_view numericpart int4 10  √  null
prb_accref_view preferred int2 5  √  null
prb_accref_view prefixpart text 2147483647  √  null
prb_accref_view private int2 5  √  null
prb_alias _alias_key serial 10  √  nextval('prb_alias_seq'::regclass) primary key
prb_alias _createdby_key int4 10 1001 user who created the record
prb_alias _modifiedby_key int4 10 1001 user who last modified the record
prb_alias _reference_key int4 10 foreign key to PRB_Reference
prb_alias alias text 2147483647 alias name
prb_alias creation_date timestamp 29,6 now() date record was created
prb_alias modification_date timestamp 29,6 now() date record was last modified
prb_allele _allele_key serial 10  √  nextval('prb_allele_seq'::regclass) foreign key to ALL_Allele
prb_allele _createdby_key int4 10 1001 user who created the record
prb_allele _modifiedby_key int4 10 1001 user who last modified the record
prb_allele _rflv_key int4 10 foreign key to PRB_RFLV
prb_allele allele text 2147483647 arbitrary symbol assigned to the RFLV pair/fragment size. no correlation to phenotypic allele symbols.
prb_allele creation_date timestamp 29,6 now() date record was created
prb_allele fragments text 2147483647 fragment length
prb_allele modification_date timestamp 29,6 now() date record was last modified
prb_allele_strain _allele_key int4 10 foreign key to PRB_Allele
prb_allele_strain _allelestrain_key serial 10  √  nextval('prb_allele_strain_seq'::regclass) primary key
prb_allele_strain _createdby_key int4 10 1001 user who created the record
prb_allele_strain _modifiedby_key int4 10 1001 user who last modified the record
prb_allele_strain _strain_key int4 10 foreign key to PRB_Strain
prb_allele_strain creation_date timestamp 29,6 now() date record was created
prb_allele_strain modification_date timestamp 29,6 now() date record was last modified
prb_marker _assoc_key serial 10  √  nextval('prb_marker_seq'::regclass) primary key
prb_marker _createdby_key int4 10 1001 user who created the record
prb_marker _marker_key int4 10 foreign key to MRK_Marker
prb_marker _modifiedby_key int4 10 1001 user who last modified the record
prb_marker _probe_key int4 10 foreign key to PRB_Probe
prb_marker _refs_key int4 10 foreign key to BIB_Refs
prb_marker creation_date timestamp 29,6 now() date record was created
prb_marker modification_date timestamp 29,6 now() date record was last modified
prb_marker relationship bpchar 1  √  null relationship of Probe and Marker (H,E,A,M,P)
prb_marker_view _marker_key int4 10  √  null
prb_marker_view _modifiedby_key int4 10  √  null
prb_marker_view _probe_key int4 10  √  null
prb_marker_view _refs_key int4 10  √  null
prb_marker_view chromosome text 2147483647  √  null
prb_marker_view jnum int4 10  √  null
prb_marker_view modification_date timestamp 29,6  √  null
prb_marker_view modifiedby text 2147483647  √  null
prb_marker_view name text 2147483647  √  null
prb_marker_view relationship bpchar 1  √  null
prb_marker_view short_citation text 2147483647  √  null
prb_marker_view symbol text 2147483647  √  null
prb_notes _note_key serial 10  √  nextval('prb_notes_seq'::regclass) primary key
prb_notes _probe_key int4 10 foreign key to PRB_Probe
prb_notes creation_date timestamp 29,6 now() date record was created
prb_notes modification_date timestamp 29,6 now() date record was last modified
prb_notes note text 2147483647 note
prb_probe _createdby_key int4 10 1001 user who created the record
prb_probe _modifiedby_key int4 10 1001 user who last modified the record
prb_probe _probe_key serial 10  √  nextval('prb_probe_seq'::regclass) foreign key to PRB_Probe
prb_probe _segmenttype_key int4 10 foreign key to VOC_Term where _Vocab_key = 21 (Sequence Type)
prb_probe _source_key int4 10 foreign key to PRB_Source
prb_probe _vector_key int4 10 foreign key to VOC_Term where _Vocab_key = 24 (Segment Vector Type)
prb_probe ampprimer int4 10  √  null foreign key to PRB_Probe; segment type = primer
prb_probe creation_date timestamp 29,6 now() date record was created
prb_probe derivedfrom int4 10  √  null foreign key to PRB_Probe; parent
prb_probe insertsite text 2147483647  √  null site of probe on the vector
prb_probe insertsize text 2147483647  √  null size of probe
prb_probe modification_date timestamp 29,6 now() date record was last modified
prb_probe name text 2147483647 probe name
prb_probe primer1sequence text 2147483647  √  null sequence for first primer
prb_probe primer2sequence text 2147483647  √  null sequence for second primer
prb_probe productsize text 2147483647  √  null size of probe product
prb_probe regioncovered text 2147483647  √  null notes describing the sequence region where probe hybridizes
prb_probe_view _createdby_key int4 10  √  null
prb_probe_view _modifiedby_key int4 10  √  null
prb_probe_view _probe_key int4 10  √  null
prb_probe_view _segmenttype_key int4 10  √  null
prb_probe_view _source_key int4 10  √  null
prb_probe_view _vector_key int4 10  √  null
prb_probe_view ampprimer int4 10  √  null
prb_probe_view createdby text 2147483647  √  null
prb_probe_view creation_date timestamp 29,6  √  null
prb_probe_view derivedfrom int4 10  √  null
prb_probe_view insertsite text 2147483647  √  null
prb_probe_view insertsize text 2147483647  √  null
prb_probe_view mgiid text 2147483647  √  null
prb_probe_view modification_date timestamp 29,6  √  null
prb_probe_view modifiedby text 2147483647  √  null
prb_probe_view name text 2147483647  √  null
prb_probe_view numericpart int4 10  √  null
prb_probe_view parentclone text 2147483647  √  null
prb_probe_view prefixpart text 2147483647  √  null
prb_probe_view primer1sequence text 2147483647  √  null
prb_probe_view primer2sequence text 2147483647  √  null
prb_probe_view productsize text 2147483647  √  null
prb_probe_view regioncovered text 2147483647  √  null
prb_probe_view segmenttype text 2147483647  √  null
prb_probe_view vectortype text 2147483647  √  null
prb_ref_notes _reference_key int4 10 foreign key to PRB_Reference
prb_ref_notes creation_date timestamp 29,6 now() date record was created
prb_ref_notes modification_date timestamp 29,6 now() date record was last modified
prb_ref_notes note text 2147483647 note
prb_reference _createdby_key int4 10 1001 user who created the record
prb_reference _modifiedby_key int4 10 1001 user who last modified the record
prb_reference _probe_key int4 10 foreign key to PRB_Probe
prb_reference _reference_key serial 10  √  nextval('prb_reference_seq'::regclass) primary key
prb_reference _refs_key int4 10 foreign key to BIB_Refs
prb_reference creation_date timestamp 29,6 now() date record was created
prb_reference hasrmap int2 5 does reference have restriction map information? yes (1), no (0)
prb_reference hassequence int2 5 is sequence information presented in reference? yes (1), no (0)
prb_reference modification_date timestamp 29,6 now() date record was last modified
prb_rflv _createdby_key int4 10 1001 user who created the record
prb_rflv _marker_key int4 10 foreign key to MRK_Marker
prb_rflv _modifiedby_key int4 10 1001 user who last modified the record
prb_rflv _reference_key int4 10 foreign key to PRB_Reference
prb_rflv _rflv_key serial 10  √  nextval('prb_rflv_seq'::regclass) primary key
prb_rflv creation_date timestamp 29,6 now() date record was created
prb_rflv endonuclease text 2147483647  √  null endonuclease (An enzyme that cleaves its nucleic acid substrate at internal sites in the nucleotide sequence)
prb_rflv modification_date timestamp 29,6 now() date record was last modified
prb_source _cellline_key int4 10 foreign key to VOC_Term where _Vocab_key = 18 (Cell Line)
prb_source _createdby_key int4 10 1001 user who created the record
prb_source _gender_key int4 10 foreign key to VOC_Term where _Vocab_key = 17 (Gender)
prb_source _modifiedby_key int4 10 1001 user who last modified the record
prb_source _organism_key int4 10 organism (foreign key to MGI_Organism)
prb_source _refs_key int4 10  √  null foreign key to BIB_Refs
prb_source _segmenttype_key int4 10 foreign key to VOC_Term where _Vocab_key = 10 (Segment Type)
prb_source _source_key serial 10  √  nextval('prb_source_seq'::regclass) primary key
prb_source _strain_key int4 10 foreign key to PRB_Strain
prb_source _tissue_key int4 10 foreign key to PRB_Tissue
prb_source _vector_key int4 10 foreign key to VOC_Term where _Vocab_key = 24 (Segment Vector Type)
prb_source age text 2147483647 age of source
prb_source agemax numeric 131089 maximum age range determined by age field; system calculated
prb_source agemin numeric 131089 minimum age range determined by age field; system calculated
prb_source creation_date timestamp 29,6 now() date record was created
prb_source description text 2147483647  √  null description of library source
prb_source iscuratoredited int2 5 has any attribute of this record been modified by a curator?
prb_source modification_date timestamp 29,6 now() date record was last modified
prb_source name text 2147483647  √  null source name
prb_source_acc_view _accession_key int4 10  √  null
prb_source_acc_view _createdby_key int4 10  √  null
prb_source_acc_view _logicaldb_key int4 10  √  null
prb_source_acc_view _mgitype_key int4 10  √  null
prb_source_acc_view _modifiedby_key int4 10  √  null
prb_source_acc_view _object_key int4 10  √  null
prb_source_acc_view accid text 2147483647  √  null
prb_source_acc_view creation_date timestamp 29,6  √  null
prb_source_acc_view logicaldb text 2147483647  √  null
prb_source_acc_view modification_date timestamp 29,6  √  null
prb_source_acc_view numericpart int4 10  √  null
prb_source_acc_view preferred int2 5  √  null
prb_source_acc_view prefixpart text 2147483647  √  null
prb_source_acc_view private int2 5  √  null
prb_source_view _cellline_key int4 10  √  null
prb_source_view _createdby_key int4 10  √  null
prb_source_view _gender_key int4 10  √  null
prb_source_view _modifiedby_key int4 10  √  null
prb_source_view _organism_key int4 10  √  null
prb_source_view _refs_key int4 10  √  null
prb_source_view _segmenttype_key int4 10  √  null
prb_source_view _source_key int4 10  √  null
prb_source_view _strain_key int4 10  √  null
prb_source_view _tissue_key int4 10  √  null
prb_source_view _vector_key int4 10  √  null
prb_source_view age text 2147483647  √  null
prb_source_view agemax numeric 131089  √  null
prb_source_view agemin numeric 131089  √  null
prb_source_view cellline text 2147483647  √  null
prb_source_view createdby text 2147483647  √  null
prb_source_view creation_date timestamp 29,6  √  null
prb_source_view description text 2147483647  √  null
prb_source_view gender text 2147483647  √  null
prb_source_view iscuratoredited int2 5  √  null
prb_source_view modification_date timestamp 29,6  √  null
prb_source_view modifiedby text 2147483647  √  null
prb_source_view name text 2147483647  √  null
prb_source_view organism text 2147483647  √  null
prb_source_view segmenttype text 2147483647  √  null
prb_source_view sstandard int2 5  √  null
prb_source_view strain text 2147483647  √  null
prb_source_view tissue text 2147483647  √  null
prb_source_view tstandard int2 5  √  null
prb_source_view vectortype text 2147483647  √  null
prb_strain _createdby_key int4 10 1001 user who created the record
prb_strain _modifiedby_key int4 10 1001 user who last modified the record
prb_strain _species_key int4 10 foreign key to VOC_Term where _Vocab_key = 26 (Strain Species)
prb_strain _strain_key serial 10  √  nextval('prb_strain_seq'::regclass) primary key
prb_strain _straintype_key int4 10 foreign key to VOC_Term where _Vocab_key = 55 (Strain Type)
prb_strain creation_date timestamp 29,6 now() date record was created
prb_strain geneticbackground int2 5 genetic background/strain prefix
prb_strain modification_date timestamp 29,6 now() date record was last modified
prb_strain private int2 5 if 1, then the Strain record is private (deleted from public copies of the database)
prb_strain standard int2 5 if 1, then the strain is official.
prb_strain strain text 2147483647 strain description
prb_strain_acc_view _accession_key int4 10  √  null
prb_strain_acc_view _createdby_key int4 10  √  null
prb_strain_acc_view _logicaldb_key int4 10  √  null
prb_strain_acc_view _mgitype_key int4 10  √  null
prb_strain_acc_view _modifiedby_key int4 10  √  null
prb_strain_acc_view _object_key int4 10  √  null
prb_strain_acc_view accid text 2147483647  √  null
prb_strain_acc_view creation_date timestamp 29,6  √  null
prb_strain_acc_view logicaldb text 2147483647  √  null
prb_strain_acc_view modification_date timestamp 29,6  √  null
prb_strain_acc_view numericpart int4 10  √  null
prb_strain_acc_view preferred int2 5  √  null
prb_strain_acc_view prefixpart text 2147483647  √  null
prb_strain_acc_view private int2 5  √  null
prb_strain_attribute_view _annot_key int4 10  √  null
prb_strain_attribute_view _strain_key int4 10  √  null
prb_strain_attribute_view _term_key int4 10  √  null
prb_strain_attribute_view term text 2147483647  √  null
prb_strain_genotype _createdby_key int4 10 1001 user who created the record
prb_strain_genotype _genotype_key int4 10 foreign key to GXD_Genotype
prb_strain_genotype _modifiedby_key int4 10 1001 user who last modified the record
prb_strain_genotype _qualifier_key int4 10 foreign key to VOC_Term where _Vocab_key = 32 (Strain/Genotype Qualifier)
prb_strain_genotype _strain_key int4 10 foreign key to PRB_Strain
prb_strain_genotype _straingenotype_key serial 10  √  nextval('prb_strain_genotype_seq'::regclass) primary key
prb_strain_genotype creation_date timestamp 29,6 now() date record was created
prb_strain_genotype modification_date timestamp 29,6 now() date record was last modified
prb_strain_genotype_view _createdby_key int4 10  √  null
prb_strain_genotype_view _genotype_key int4 10  √  null
prb_strain_genotype_view _modifiedby_key int4 10  √  null
prb_strain_genotype_view _qualifier_key int4 10  √  null
prb_strain_genotype_view _strain_key int4 10  √  null
prb_strain_genotype_view _straingenotype_key int4 10  √  null
prb_strain_genotype_view creation_date timestamp 29,6  √  null
prb_strain_genotype_view description text 2147483647  √  null
prb_strain_genotype_view mgiid text 2147483647  √  null
prb_strain_genotype_view modification_date timestamp 29,6  √  null
prb_strain_genotype_view modifiedby text 2147483647  √  null
prb_strain_genotype_view qualifier text 2147483647  √  null
prb_strain_genotype_view strain text 2147483647  √  null
prb_strain_marker _allele_key int4 10  √  null foreign key to ALL_Allele
prb_strain_marker _createdby_key int4 10 1001 user who created the record
prb_strain_marker _marker_key int4 10  √  null foreign key to MRK_Marker
prb_strain_marker _modifiedby_key int4 10 1001 user who last modified the record
prb_strain_marker _qualifier_key int4 10 foreign key to VOC_Term where _Vocab_key = 31 (Strain Allele Qualifier); 'nomenclature'
prb_strain_marker _strain_key int4 10 foreign key to PRB_Strain
prb_strain_marker _strainmarker_key serial 10  √  nextval('prb_strain_marker_seq'::regclass) primary key
prb_strain_marker creation_date timestamp 29,6 now() date record was created
prb_strain_marker modification_date timestamp 29,6 now() date record was last modified
prb_strain_marker_view _allele_key int4 10  √  null
prb_strain_marker_view _createdby_key int4 10  √  null
prb_strain_marker_view _marker_key int4 10  √  null
prb_strain_marker_view _modifiedby_key int4 10  √  null
prb_strain_marker_view _qualifier_key int4 10  √  null
prb_strain_marker_view _strain_key int4 10  √  null
prb_strain_marker_view _strainmarker_key int4 10  √  null
prb_strain_marker_view allelesymbol text 2147483647  √  null
prb_strain_marker_view chromosome text 2147483647  √  null
prb_strain_marker_view creation_date timestamp 29,6  √  null
prb_strain_marker_view modification_date timestamp 29,6  √  null
prb_strain_marker_view qualifier text 2147483647  √  null
prb_strain_marker_view sequencenum int4 10  √  null
prb_strain_marker_view symbol text 2147483647  √  null
prb_strain_needsreview_view _annot_key int4 10  √  null
prb_strain_needsreview_view _annottype_key int4 10  √  null
prb_strain_needsreview_view _object_key int4 10  √  null
prb_strain_needsreview_view _qualifier_key int4 10  √  null
prb_strain_needsreview_view _term_key int4 10  √  null
prb_strain_needsreview_view creation_date timestamp 29,6  √  null
prb_strain_needsreview_view modification_date timestamp 29,6  √  null
prb_strain_needsreview_view term text 2147483647  √  null
prb_strain_view _createdby_key int4 10  √  null
prb_strain_view _modifiedby_key int4 10  √  null
prb_strain_view _species_key int4 10  √  null
prb_strain_view _strain_key int4 10  √  null
prb_strain_view _straintype_key int4 10  √  null
prb_strain_view createdby text 2147483647  √  null
prb_strain_view creation_date timestamp 29,6  √  null
prb_strain_view geneticbackground int2 5  √  null
prb_strain_view modification_date timestamp 29,6  √  null
prb_strain_view modifiedby text 2147483647  √  null
prb_strain_view private int2 5  √  null
prb_strain_view species text 2147483647  √  null
prb_strain_view standard int2 5  √  null
prb_strain_view strain text 2147483647  √  null
prb_strain_view straintype text 2147483647  √  null
prb_tissue _tissue_key serial 10  √  nextval('prb_tissue_seq'::regclass) primary key
prb_tissue creation_date timestamp 29,6 now() date record was created
prb_tissue modification_date timestamp 29,6 now() date record was last modified
prb_tissue standard int2 5 is the tissue a standard, official tissue? yes (1), no (0)
prb_tissue tissue text 2147483647 tissue description
ri_riset _riset_key int4 10 primary key
ri_riset _strain_key_1 int4 10 foreign key to PRB_Strain; 1st member of the cross
ri_riset _strain_key_2 int4 10 foreign key to PRB_Strain; 2nd member of the cross
ri_riset abbrev1 text 2147483647 Strain 1 Abbreviation
ri_riset abbrev2 text 2147483647 Strain 2 Abbreviation
ri_riset creation_date timestamp 29,6 now() date record was created
ri_riset designation text 2147483647 identifying label for the RI Set (ex. AKXL)
ri_riset modification_date timestamp 29,6 now() date record was last modified
ri_riset ri_idlist text 2147483647 labels which represent each member of the RI Set
ri_summary _marker_key int4 10 foreign key to MRK_Marker
ri_summary _riset_key int4 10 foreign key to RI_RISet
ri_summary _risummary_key int4 10 primary key
ri_summary creation_date timestamp 29,6 now() date record was created
ri_summary modification_date timestamp 29,6 now() date record was last modified
ri_summary summary text 2147483647 haplotype summary for this RI set
ri_summary_expt_ref _expt_key int4 10 foreign key to MLD_Expts
ri_summary_expt_ref _refs_key int4 10 foreign key to BIB_Refs
ri_summary_expt_ref _risummary_key int4 10 foreign key to RI_Summary
ri_summary_expt_ref creation_date timestamp 29,6 now() date record was created
ri_summary_expt_ref modification_date timestamp 29,6 now() date record was last modified
seq_allele_assoc _allele_key int4 10 foreign key to ALL_Allele
seq_allele_assoc _assoc_key int4 10 primary key
seq_allele_assoc _createdby_key int4 10 1001 user who created the record
seq_allele_assoc _modifiedby_key int4 10 1001 user who last modified the record
seq_allele_assoc _qualifier_key int4 10 foreign key to VOC_Term where _Vocab_key = 69 (Sequence Allele Association Qualifier)
seq_allele_assoc _refs_key int4 10 foreign key to BIB_Refs
seq_allele_assoc _sequence_key int4 10 foreign key to SEQ_Sequence
seq_allele_assoc creation_date timestamp 29,6 now() date record was created
seq_allele_assoc modification_date timestamp 29,6 now() date record was last modified
seq_coord_cache _createdby_key int4 10 1001 user who created the record
seq_coord_cache _map_key int4 10 foreign key to MAP_Collection
seq_coord_cache _modifiedby_key int4 10 1001 user who last modified the record
seq_coord_cache _sequence_key int4 10 foreign key to SEQ_Sequence
seq_coord_cache chromosome text 2147483647 chromosome on which the sequence resides
seq_coord_cache creation_date timestamp 29,6 now() date record was created
seq_coord_cache endcoordinate numeric 131089 end BP coordinate
seq_coord_cache mapunits text 2147483647 map units of these coordinates
seq_coord_cache modification_date timestamp 29,6 now() date record was last modified
seq_coord_cache provider text 2147483647 sequence provider
seq_coord_cache startcoordinate numeric 131089 start BP coordinate
seq_coord_cache strand bpchar 1 3' or 5' strand
seq_coord_cache version text 2147483647 sequence provider's version
seq_genemodel _createdby_key int4 10 1001 user who created the record
seq_genemodel _gmmarker_type_key int4 10  √  null the _Marker_Type_key (foreign key to MRK_Types) corresponding to the 'rawBiotype' attribute.
seq_genemodel _modifiedby_key int4 10 1001 user who last modified the record
seq_genemodel _sequence_key int4 10 foreign key to SEQ_Sequence
seq_genemodel creation_date timestamp 29,6 now() date record was created
seq_genemodel exoncount int4 10  √  null currently not being used
seq_genemodel modification_date timestamp 29,6 now() date record was last modified
seq_genemodel rawbiotype text 2147483647  √  null the raw biotype of this Gene Model as provided by the provider
seq_genemodel transcriptcount int4 10  √  null currently not being used.
seq_genetrap _createdby_key int4 10 1001 user who created the record
seq_genetrap _modifiedby_key int4 10 1001 user who last modified the record
seq_genetrap _reversecomp_key int4 10 foreign key to VOC_Term (_Vocab_key = 68). Answers the question is this sequence reverse complemented?
seq_genetrap _sequence_key int4 10 foreign key to SEQ_Sequence
seq_genetrap _tagmethod_key int4 10 foreign key to VOC_Term (_Vocab_key = 66) The name of the procedure used to produce a sequence tag from a gene trap insertion in a mutant cell line.
seq_genetrap _vectorend_key int4 10 foreign key to VOC_Term (_Vocab_key = 67)
seq_genetrap creation_date timestamp 29,6 now() date record was created
seq_genetrap goodhitcount int4 10  √  null Number of good blat hits
seq_genetrap modification_date timestamp 29,6 now() date record was last modified
seq_genetrap pointcoordinate numeric 131089  √  null The single coordinate picked to indicate where the insertion actually happened
seq_marker_cache _biotypeconflict_key int4 10 foreign key to VOC_Term where _Vocab_key = 76 (BioType Conflict); 'Conflict', 'Not Applicable'
seq_marker_cache _cache_key int4 10 primary key
seq_marker_cache _createdby_key int4 10 1001 user who created the record
seq_marker_cache _logicaldb_key int4 10 foreign key to ACC_LogicalDB
seq_marker_cache _marker_key int4 10 foreign key to MRK_Marker
seq_marker_cache _marker_type_key int4 10 foreign key to MRK_Types
seq_marker_cache _modifiedby_key int4 10 1001 user who last modified the record
seq_marker_cache _organism_key int4 10 foreign key to MGI_Organism
seq_marker_cache _qualifier_key int4 10 foreign key to VOC_Term where _Vocab_key =289 (Representative Sequence Qualifier); qualifies the association between the Marker and the Sequence
seq_marker_cache _refs_key int4 10 foreign key to BIB_Refs
seq_marker_cache _sequence_key int4 10 foreign key to SEQ_Sequence
seq_marker_cache _sequenceprovider_key int4 10 foreign key to VOC_Term where _Vocab_key = 25 (Sequence Provider)
seq_marker_cache _sequencetype_key int4 10 foreign key to VOC_Term where _Vocab_key = 21 (Sequence Type)
seq_marker_cache accid varchar 30 accession id of the Sequence
seq_marker_cache annotation_date timestamp 29,6 now() date of the annotation
seq_marker_cache creation_date timestamp 29,6 now() date record was created
seq_marker_cache modification_date timestamp 29,6 now() date record was last modified
seq_marker_cache rawbiotype text 2147483647  √  null raw biotype
seq_probe_cache _createdby_key int4 10 1001 user who created the record
seq_probe_cache _modifiedby_key int4 10 1001 user who last modified the record
seq_probe_cache _probe_key int4 10 foreign key to PRB_Probe
seq_probe_cache _refs_key int4 10 foreign key to BIB_Refs
seq_probe_cache _sequence_key int4 10 foreign key to SEQ_Sequence
seq_probe_cache annotation_date timestamp 29,6 now() date of the annotation
seq_probe_cache creation_date timestamp 29,6 now() date record was created
seq_probe_cache modification_date timestamp 29,6 now() date record was last modified
seq_sequence _createdby_key int4 10 1001 user who created the record
seq_sequence _modifiedby_key int4 10 1001 user who last modified the record
seq_sequence _organism_key int4 10 foreign key to MGI_Organism
seq_sequence _sequence_key int4 10 primary key
seq_sequence _sequenceprovider_key int4 10 foreign key to VOC_Term where _Vocab_key = 25 (Sequence Provider)
seq_sequence _sequencequality_key int4 10 foreign key to VOC_Term where _Vocab_key = 19 (Sequence Quality)
seq_sequence _sequencestatus_key int4 10 foreign key to VOC_Term where _Vocab_key = 20 (Sequence Status)
seq_sequence _sequencetype_key int4 10 foreign key to VOC_Term where _Vocab_key = 21 (Sequence Type)
seq_sequence creation_date timestamp 29,6 now() date record was created
seq_sequence description text 2147483647  √  null description
seq_sequence division bpchar 3  √  null GenBank division
seq_sequence length int4 10  √  null length of sequence
seq_sequence modification_date timestamp 29,6 now() date record was last modified
seq_sequence numberoforganisms int4 10  √  null for Swiss-Prot, number of non-mouse, non-human, non-rat organisms that are sources of this sequence
seq_sequence seqrecord_date timestamp 29,6 now() last modification date of the sequence record from the provider
seq_sequence sequence_date timestamp 29,6 now() last modification date of the sequence itself
seq_sequence version text 2147483647  √  null GenBank version
seq_sequence virtual int2 5 is this sequence virtual (consensus)?
seq_sequence_acc_view _accession_key int4 10  √  null
seq_sequence_acc_view _createdby_key int4 10  √  null
seq_sequence_acc_view _logicaldb_key int4 10  √  null
seq_sequence_acc_view _mgitype_key int4 10  √  null
seq_sequence_acc_view _modifiedby_key int4 10  √  null
seq_sequence_acc_view _object_key int4 10  √  null
seq_sequence_acc_view accid text 2147483647  √  null
seq_sequence_acc_view creation_date timestamp 29,6  √  null
seq_sequence_acc_view logicaldb text 2147483647  √  null
seq_sequence_acc_view modification_date timestamp 29,6  √  null
seq_sequence_acc_view numericpart int4 10  √  null
seq_sequence_acc_view preferred int2 5  √  null
seq_sequence_acc_view prefixpart text 2147483647  √  null
seq_sequence_acc_view private int2 5  √  null
seq_sequence_assoc _assoc_key int4 10 primary key
seq_sequence_assoc _createdby_key int4 10 1001 user who created the record
seq_sequence_assoc _modifiedby_key int4 10 1001 user who last modified the record
seq_sequence_assoc _qualifier_key int4 10 foreign key to VOC_Term where _Vocab_key = 78 (Sequence-Sequence Association Qualifier); 'transcribed from', 'translated from', 'processed from'
seq_sequence_assoc _sequence_key_1 int4 10 foreign key to SEQ_Sequence
seq_sequence_assoc _sequence_key_2 int4 10 foreign key to SEQ_Sequence
seq_sequence_assoc creation_date timestamp 29,6 now() date record was created
seq_sequence_assoc modification_date timestamp 29,6 now() date record was last modified
seq_sequence_raw _createdby_key int4 10 1001 user who created the record
seq_sequence_raw _modifiedby_key int4 10 1001 user who last modified the record
seq_sequence_raw _sequence_key int4 10 foreign key to SEQ_Sequence
seq_sequence_raw creation_date timestamp 29,6 now() date record was created
seq_sequence_raw modification_date timestamp 29,6 now() date record was last modified
seq_sequence_raw rawage text 2147483647  √  null age
seq_sequence_raw rawcellline text 2147483647  √  null cell line
seq_sequence_raw rawlibrary text 2147483647  √  null library
seq_sequence_raw raworganism text 2147483647  √  null organism
seq_sequence_raw rawsex text 2147483647  √  null gender
seq_sequence_raw rawstrain text 2147483647  √  null strain
seq_sequence_raw rawtissue text 2147483647  √  null tissue
seq_sequence_raw rawtype text 2147483647  √  null sequence type
seq_source_assoc _assoc_key serial 10  √  nextval('seq_source_assoc_seq'::regclass) primary key
seq_source_assoc _createdby_key int4 10 1001 user who created the record
seq_source_assoc _modifiedby_key int4 10 1001 user who last modified the record
seq_source_assoc _sequence_key int4 10 foreign key to SEQ_Sequence
seq_source_assoc _source_key int4 10 foreign key to PRB_Source
seq_source_assoc creation_date timestamp 29,6 now() date record was created
seq_source_assoc modification_date timestamp 29,6 now() date record was last modified
seq_summary_view _accession_key int4 10  √  null
seq_summary_view _createdby_key int4 10  √  null
seq_summary_view _logicaldb_key int4 10  √  null
seq_summary_view _mgitype_key int4 10  √  null
seq_summary_view _modifiedby_key int4 10  √  null
seq_summary_view _object_key int4 10  √  null
seq_summary_view accid text 2147483647  √  null
seq_summary_view creation_date timestamp 29,6  √  null
seq_summary_view description text 2147483647  √  null
seq_summary_view mgiid text 2147483647  √  null
seq_summary_view modification_date timestamp 29,6  √  null
seq_summary_view numericpart int4 10  √  null
seq_summary_view preferred int2 5  √  null
seq_summary_view prefixpart text 2147483647  √  null
seq_summary_view private int2 5  √  null
seq_summary_view short_description text 2147483647  √  null
seq_summary_view subtype text 2147483647  √  null
voc_allele_cache _allele_key int4 10 foreign key to ALL_Allele
voc_allele_cache _cache_key serial 10  √  nextval('voc_allele_cache_seq'::regclass)
voc_allele_cache _term_key int4 10 foreign key to VOC_Term
voc_allele_cache annottype text 2147483647 see table description for details
voc_annot _annot_key serial 10  √  nextval('voc_annot_seq'::regclass) primary key
voc_annot _annottype_key int4 10 foreign key to VOC_AnnotType; examples include 1000:GO/Marker), 1002:Mammelian Phenotypes/Genotype, 1020:DO/Genotype
voc_annot _object_key int4 10 foreign key to any object defined in ACC_MGIType
voc_annot _qualifier_key int4 10 foreign key to VOC_Term; based on the VOC_AnnotType._AnnotType_key
voc_annot _term_key int4 10 foreign key to VOC_Term; based on the VOC_AnnotType._Vocab_key
voc_annot creation_date timestamp 29,6 now() date record was created
voc_annot modification_date timestamp 29,6 now() date record was last modified
voc_annot_count_cache _cache_key serial 10  √  nextval('voc_annot_count_cache_seq'::regclass)
voc_annot_count_cache _mgitype_key int4 10 foreign key to ACC_MGIType
voc_annot_count_cache _term_key int4 10 foreign key to VOC_Term
voc_annot_count_cache annotcount int4 10 count of annotations of the given annotType to the given _Term_key
voc_annot_count_cache annottype text 2147483647 the type of annotation we are considering in this record
voc_annot_count_cache objectcount int4 10 count of objects of the given _MGIType_key with annotations of a given annotType to the given _Term_key
voc_annot_view _annot_key int4 10  √  null
voc_annot_view _annottype_key int4 10  √  null
voc_annot_view _evidencevocab_key int4 10  √  null
voc_annot_view _logicaldb_key int4 10  √  null
voc_annot_view _mgitype_key int4 10  √  null
voc_annot_view _object_key int4 10  √  null
voc_annot_view _qualifier_key int4 10  √  null
voc_annot_view _term_key int4 10  √  null
voc_annot_view _vocab_key int4 10  √  null
voc_annot_view accid text 2147483647  √  null
voc_annot_view annottype text 2147483647  √  null
voc_annot_view creation_date timestamp 29,6  √  null
voc_annot_view modification_date timestamp 29,6  √  null
voc_annot_view qualifier text 2147483647  √  null
voc_annot_view sequencenum int4 10  √  null
voc_annot_view term text 2147483647  √  null
voc_annotheader _annotheader_key int4 10 primary key
voc_annotheader _annottype_key int4 10 foreign key to VOC_AnnotType
voc_annotheader _approvedby_key int4 10  √  null user who approved the record
voc_annotheader _createdby_key int4 10 1001 user who created the record
voc_annotheader _modifiedby_key int4 10 1001 user who last modified the record
voc_annotheader _object_key int4 10 foreign key to any object defined in ACC_MGIType
voc_annotheader _term_key int4 10 Header Term for the annotation; foreign key to VOC_Term
voc_annotheader approval_date timestamp 29,6  √  now() date record was approved
voc_annotheader creation_date timestamp 29,6 now() date record was created
voc_annotheader isnormal int2 5 If all of the qualifiers for a given header term = 'norm' (see VOC_Annot._Qualifier_key) then isNormal = 1 (true), else 0 (false)
voc_annotheader modification_date timestamp 29,6 now() date record was last modified
voc_annotheader sequencenum int4 10 order of the Header Term for a specific Object
voc_annottype _annottype_key int4 10 primary key
voc_annottype _evidencevocab_key int4 10 foreign key to VOC_Term; examples include 3:GO Evidence Codes, 2:Mammalian Phenotype Evidence, 80:MCV Evidence Codes Codes
voc_annottype _mgitype_key int4 10 foreign key to ACC_MGIType
voc_annottype _qualifiervocab_key int4 10 foreign key to VOC_Term; examples include 52:GO Qualifier, 54:MP Qualifier
voc_annottype _vocab_key int4 10 foreign key to VOC_Vocab
voc_annottype creation_date timestamp 29,6 now() date record was created
voc_annottype modification_date timestamp 29,6 now() date record was last modified
voc_annottype name text 2147483647 annotation type name
voc_evidence _annot_key int4 10 foreign key to VOC_Annot
voc_evidence _annotevidence_key serial 10  √  nextval('voc_evidence_seq'::regclass) primary key
voc_evidence _createdby_key int4 10 1001 user who created the record
voc_evidence _evidenceterm_key int4 10 foreign key to VOC_Term; based on VOC_AnnotType; example _Vocab_key:3:GO Evidence Codes:IDA, IMP, IPI, TAS, etc.
voc_evidence _modifiedby_key int4 10 1001 user who last modified the record
voc_evidence _refs_key int4 10 foreign key to BIB_Refs
voc_evidence creation_date timestamp 29,6 now() date record was created
voc_evidence inferredfrom text 2147483647  √  null supporting acc id for the evidence
voc_evidence modification_date timestamp 29,6 now() date record was last modified
voc_evidence_property _annotevidence_key int4 10 foreign key to VOC_Evidence
voc_evidence_property _createdby_key int4 10 1001 user who created the record
voc_evidence_property _evidenceproperty_key serial 10  √  nextval('voc_evidence_property_seq'::regclass) primary key
voc_evidence_property _modifiedby_key int4 10 1001 user who last modified the record
voc_evidence_property _propertyterm_key int4 10 foreign key to VOC_Term; examples include: _Vocab_key = 82 (GO Property); 'evidence', 'anatomy', 'cell tyupe', 'text', etc.
voc_evidence_property creation_date timestamp 29,6 now() date record was created
voc_evidence_property modification_date timestamp 29,6 now() date record was last modified
voc_evidence_property sequencenum int4 10 sequnence number of the property within each stanza
voc_evidence_property stanza int4 10 a stanza represents a group of proeprties within the same evidence; group by _AnnotEvidence_key/stranza/sequenceNumber to retreive the ordered set of stanza's for a given annotation/evidence
voc_evidence_property value text 2147483647 the value that is assigned (i.e. the text) to the property
voc_evidence_view _annot_key int4 10  √  null
voc_evidence_view _annotevidence_key int4 10  √  null
voc_evidence_view _createdby_key int4 10  √  null
voc_evidence_view _evidenceterm_key int4 10  √  null
voc_evidence_view _modifiedby_key int4 10  √  null
voc_evidence_view _refs_key int4 10  √  null
voc_evidence_view createdby text 2147483647  √  null
voc_evidence_view creation_date timestamp 29,6  √  null
voc_evidence_view evidencecode text 2147483647  √  null
voc_evidence_view evidenceseqnum int4 10  √  null
voc_evidence_view inferredfrom text 2147483647  √  null
voc_evidence_view jnum int4 10  √  null
voc_evidence_view jnumid text 2147483647  √  null
voc_evidence_view modification_date timestamp 29,6  √  null
voc_evidence_view modifiedby text 2147483647  √  null
voc_evidence_view short_citation text 2147483647  √  null
voc_go_cache _cache_key serial 10  √  nextval('voc_go_cache_seq'::regclass)
voc_go_cache _dag_key int4 10 foreign key to DAG_DAG
voc_go_cache _term_key int4 10 foreign key to VOC_Term
voc_go_cache accid text 2147483647 GO accession id of the Term (GO:xxxxx)
voc_go_cache dagabbrev bpchar 5 DAG abbreviation name ('C', 'F', 'O', 'P')
voc_go_cache term text 2147483647 term name (VOC_Term.term)
voc_marker_cache _cache_key serial 10  √  nextval('voc_marker_cache_seq'::regclass)
voc_marker_cache _marker_key int4 10 foreign key to MRK_Marker
voc_marker_cache _term_key int4 10 foreign key to VOC_Term
voc_marker_cache annottype text 2147483647 see table description for details
voc_term _createdby_key int4 10 1001 user who created the record
voc_term _modifiedby_key int4 10 1001 user who last modified the record
voc_term _term_key serial 10  √  nextval('voc_term_seq'::regclass) primary key
voc_term _vocab_key int4 10 foreign key to VOC_Vocab
voc_term abbreviation text 2147483647  √  null abbervated term
voc_term creation_date timestamp 29,6 now() date record was created
voc_term isobsolete int2 5  √  null if 1, the term is obsolete and cannot be used in future annotations
voc_term modification_date timestamp 29,6 now() date record was last modified
voc_term note text 2147483647  √  null textual information/description
voc_term sequencenum int4 10  √  null enables us to define an ordered list of Terms for a Vocabulary which contains 0 DAGS. for structured vocabularies, the sequenceNum is null
voc_term term text 2147483647  √  null term
voc_term_acc_view _accession_key int4 10  √  null
voc_term_acc_view _createdby_key int4 10  √  null
voc_term_acc_view _logicaldb_key int4 10  √  null
voc_term_acc_view _mgitype_key int4 10  √  null
voc_term_acc_view _modifiedby_key int4 10  √  null
voc_term_acc_view _object_key int4 10  √  null
voc_term_acc_view accid text 2147483647  √  null
voc_term_acc_view creation_date timestamp 29,6  √  null
voc_term_acc_view logicaldb text 2147483647  √  null
voc_term_acc_view modification_date timestamp 29,6  √  null
voc_term_acc_view numericpart int4 10  √  null
voc_term_acc_view preferred int2 5  √  null
voc_term_acc_view prefixpart text 2147483647  √  null
voc_term_acc_view private int2 5  √  null
voc_term_emapa _createdby_key int4 10 1001 user who created the record
voc_term_emapa _defaultparent_key int4 10  √  null An EMAPA term can have multiple parents, this defines the single default.
voc_term_emapa _modifiedby_key int4 10 1001 user who last modified the record
voc_term_emapa _term_key int4 10 The EMAPA term
voc_term_emapa creation_date timestamp 29,6 now() date record was created
voc_term_emapa endstage int4 10 End Theiler Stage
voc_term_emapa modification_date timestamp 29,6 now() date record was last modified
voc_term_emapa startstage int4 10 Start Theiler Stage
voc_term_emaps _createdby_key int4 10 1001 user who created the record
voc_term_emaps _defaultparent_key int4 10  √  null An EMAPS term can have multiple parents, this defines the single default.
voc_term_emaps _emapa_term_key int4 10 The EMAPA term
voc_term_emaps _modifiedby_key int4 10 1001 user who last modified the record
voc_term_emaps _stage_key int4 10 The theiler stage for this EMAPS term
voc_term_emaps _term_key int4 10 The EMAPS term
voc_term_emaps creation_date timestamp 29,6 now() date record was created
voc_term_emaps modification_date timestamp 29,6 now() date record was last modified
voc_term_repqualifier_view _createdby_key int4 10  √  null
voc_term_repqualifier_view _modifiedby_key int4 10  √  null
voc_term_repqualifier_view _term_key int4 10  √  null
voc_term_repqualifier_view _vocab_key int4 10  √  null
voc_term_repqualifier_view abbreviation text 2147483647  √  null
voc_term_repqualifier_view creation_date timestamp 29,6  √  null
voc_term_repqualifier_view isobsolete int2 5  √  null
voc_term_repqualifier_view modification_date timestamp 29,6  √  null
voc_term_repqualifier_view name text 2147483647  √  null
voc_term_repqualifier_view note text 2147483647  √  null
voc_term_repqualifier_view sequencenum int4 10  √  null
voc_term_repqualifier_view term text 2147483647  √  null
voc_term_view _createdby_key int4 10  √  null
voc_term_view _logicaldb_key int4 10  √  null
voc_term_view _modifiedby_key int4 10  √  null
voc_term_view _term_key int4 10  √  null
voc_term_view _vocab_key int4 10  √  null
voc_term_view abbreviation text 2147483647  √  null
voc_term_view accid text 2147483647  √  null
voc_term_view creation_date timestamp 29,6  √  null
voc_term_view isobsolete int2 5  √  null
voc_term_view modification_date timestamp 29,6  √  null
voc_term_view note text 2147483647  √  null
voc_term_view obsoletestate text 2147483647  √  null
voc_term_view sequencenum int4 10  √  null
voc_term_view term text 2147483647  √  null
voc_term_view vocabname text 2147483647  √  null
voc_termfamily_view _createdby_key int4 10  √  null
voc_termfamily_view _modifiedby_key int4 10  √  null
voc_termfamily_view _term_key int4 10  √  null
voc_termfamily_view _vocab_key int4 10  √  null
voc_termfamily_view abbreviation text 2147483647  √  null
voc_termfamily_view accid text 2147483647  √  null
voc_termfamily_view creation_date timestamp 29,6  √  null
voc_termfamily_view isobsolete int2 5  √  null
voc_termfamily_view modification_date timestamp 29,6  √  null
voc_termfamily_view note text 2147483647  √  null
voc_termfamily_view searchid text 2147483647  √  null
voc_termfamily_view sequencenum int4 10  √  null
voc_termfamily_view term text 2147483647  √  null
voc_termfamilyedges_view _child_key int4 10  √  null
voc_termfamilyedges_view _edge_key int4 10  √  null
voc_termfamilyedges_view _parent_key int4 10  √  null
voc_termfamilyedges_view label text 2147483647  √  null
voc_termfamilyedges_view searchid text 2147483647  √  null
voc_vocab _logicaldb_key int4 10 foreign key to ACC_LogicalDB; identifies the logical DB for the Accession IDs of the Vocabulary Terms
voc_vocab _refs_key int4 10 foreign key to BIB_Refs
voc_vocab _vocab_key int4 10 primary key
voc_vocab creation_date timestamp 29,6 now() date record was created
voc_vocab isprivate int2 5  √  null if 1, then the Accession IDs of the Vocabulary Terms are private, else they are public
voc_vocab issimple int2 5  √  null if 1, the Vocabulary is a simple vocabulary (no DAG), else the Vocabulary is structured (has 1 or more DAGS)
voc_vocab modification_date timestamp 29,6 now() date record was last modified
voc_vocab name text 2147483647 vocabulary name
voc_vocabdag _dag_key int4 10 foreign key to DAG_DAG
voc_vocabdag _vocab_key int4 10 foreign key to VOC_Vocab
voc_vocabdag creation_date timestamp 29,6 now() date record was created
voc_vocabdag modification_date timestamp 29,6 now() date record was last modified
wks_rosetta _marker_key int4 10  √  null foreign key to MRK_Marker
wks_rosetta _rosetta_key int4 10 primary key
wks_rosetta creation_date timestamp 29,6 now() date record was created
wks_rosetta modification_date timestamp 29,6 now() date record was last modified
wks_rosetta wks_markersymbol text 2147483647  √  null Marker symbol used in WK Silvers book
wks_rosetta wks_markerurl text 2147483647  √  null URL to appropriate page in WK Silvers book