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 Nov 20 05:26 EST 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

pub.mgd contains 4168 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 int4 10 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 int4 10 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_logicaldb_view _createdby_key int4 10  √  null
acc_logicaldb_view _logicaldb_key int4 10  √  null
acc_logicaldb_view _modifiedby_key int4 10  √  null
acc_logicaldb_view _organism_key int4 10  √  null
acc_logicaldb_view creation_date timestamp 29,6  √  null
acc_logicaldb_view description text 2147483647  √  null
acc_logicaldb_view modification_date timestamp 29,6  √  null
acc_logicaldb_view name text 2147483647  √  null
acc_logicaldb_view organism text 2147483647  √  null
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 int4 10 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 int4 10 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_mutation _allele_key int4 10 foreign key to ALL_Allele
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 _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 int4 10 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 int4 10 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 _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_NoteType._NoteType_key = 1034 (Driver)
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 symbol text 2147483647 Allele symbol
all_derivation_summary_view _accession_key int4 10  √  null
all_derivation_summary_view _logicaldb_key int4 10  √  null
all_derivation_summary_view _mgitype_key int4 10  √  null
all_derivation_summary_view _object_key int4 10  √  null
all_derivation_summary_view accid text 2147483647  √  null
all_derivation_summary_view creation_date timestamp 29,6  √  null
all_derivation_summary_view description text 2147483647  √  null
all_derivation_summary_view mgiid text 2147483647  √  null
all_derivation_summary_view modification_date timestamp 29,6  √  null
all_derivation_summary_view numericpart int4 10  √  null
all_derivation_summary_view preferred int2 5  √  null
all_derivation_summary_view prefixpart text 2147483647  √  null
all_derivation_summary_view private int2 5  √  null
all_derivation_summary_view short_description text 2147483647  √  null
all_derivation_summary_view subtype text 2147483647  √  null
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
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_all2_view _createdby_key int4 10  √  null
bib_all2_view _modifiedby_key int4 10  √  null
bib_all2_view _primary text 2147483647  √  null
bib_all2_view _referencetype_key int4 10  √  null
bib_all2_view _refs_key int4 10  √  null
bib_all2_view abstract text 2147483647  √  null
bib_all2_view authors text 2147483647  √  null
bib_all2_view citation text 2147483647  √  null
bib_all2_view createdby text 2147483647  √  null
bib_all2_view creation_date timestamp 29,6  √  null
bib_all2_view date text 2147483647  √  null
bib_all2_view isdiscard int2 5  √  null
bib_all2_view isreviewarticle int2 5  √  null
bib_all2_view issue text 2147483647  √  null
bib_all2_view jnum int4 10  √  null
bib_all2_view jnumid text 2147483647  √  null
bib_all2_view journal text 2147483647  √  null
bib_all2_view modification_date timestamp 29,6  √  null
bib_all2_view modifiedby text 2147483647  √  null
bib_all2_view pgs text 2147483647  √  null
bib_all2_view referencetype text 2147483647  √  null
bib_all2_view short_citation text 2147483647  √  null
bib_all2_view title text 2147483647  √  null
bib_all2_view vol text 2147483647  √  null
bib_all2_view year int4 10  √  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 isdiscard int2 5  √  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_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_markers int4 10  √  null
bib_associateddata_view has_probes 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 citation text 2147483647 long citation format
bib_citation_cache doiid text 2147483647  √  null DOI (digital object identifier) accession ID
bib_citation_cache isdiscard int2 5
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
bib_citation_cache short_citation text 2147483647 short citation format
bib_dataset _createdby_key int4 10 1001 user who created the record
bib_dataset _dataset_key int4 10 primary key
bib_dataset _modifiedby_key int4 10 1001 user who last modified the record
bib_dataset abbreviation text 2147483647 data set abbreviation
bib_dataset creation_date timestamp 29,6 now() date record was created
bib_dataset dataset text 2147483647 data set name
bib_dataset inmgiprocedure text 2147483647  √  null stored procedure to check if given Reference is in this particular data set
bib_dataset isobsolete int2 5 if 1, then data set is obsolete
bib_dataset modification_date timestamp 29,6 now() date record was last modified
bib_dataset sequencenum int4 10 sequence number for ordering records
bib_dataset_assoc _assoc_key int4 10 primary key
bib_dataset_assoc _createdby_key int4 10 1001 user who created the record
bib_dataset_assoc _dataset_key int4 10 foreign key to BIB_DataSet
bib_dataset_assoc _modifiedby_key int4 10 1001 user who last modified the record
bib_dataset_assoc _refs_key int4 10 foreign key to BIB_Refs
bib_dataset_assoc creation_date timestamp 29,6 now() date record was created
bib_dataset_assoc isincomplete int2 5
bib_dataset_assoc isneverused int2 5 if 1, then Reference will never be annotated to this data set
bib_dataset_assoc modification_date timestamp 29,6 now() date record was last modified
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_notes sequencenum int4 10 sequence number for ordering records
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 int4 10 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 isdiscard int2 5 is this a discarded reference?
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_summary_all_view _accession_key int4 10  √  null
bib_summary_all_view _createdby_key int4 10  √  null
bib_summary_all_view _logicaldb_key int4 10  √  null
bib_summary_all_view _mgitype_key int4 10  √  null
bib_summary_all_view _modifiedby_key int4 10  √  null
bib_summary_all_view _object_key int4 10  √  null
bib_summary_all_view accid text 2147483647  √  null
bib_summary_all_view creation_date timestamp 29,6  √  null
bib_summary_all_view description text 2147483647  √  null
bib_summary_all_view mgiid text 2147483647  √  null
bib_summary_all_view modification_date timestamp 29,6  √  null
bib_summary_all_view numericpart int4 10  √  null
bib_summary_all_view preferred int2 5  √  null
bib_summary_all_view prefixpart text 2147483647  √  null
bib_summary_all_view private int2 5  √  null
bib_summary_all_view subtype text 2147483647  √  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 isdiscard int2 5  √  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
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_cross_view _cross_key int4 10  √  null
crs_cross_view _femalestrain_key int4 10  √  null
crs_cross_view _malestrain_key int4 10  √  null
crs_cross_view _strainho_key int4 10  √  null
crs_cross_view _strainht_key int4 10  √  null
crs_cross_view abbrevho text 2147483647  √  null
crs_cross_view abbrevht text 2147483647  √  null
crs_cross_view allelefromsegparent int2 5  √  null
crs_cross_view creation_date timestamp 29,6  √  null
crs_cross_view display text 2147483647  √  null
crs_cross_view displayed int2 5  √  null
crs_cross_view f1directionknown int2 5  √  null
crs_cross_view femaleallele1 bpchar 1  √  null
crs_cross_view femaleallele2 bpchar 1  √  null
crs_cross_view femalestrain text 2147483647  √  null
crs_cross_view maleallele1 bpchar 1  √  null
crs_cross_view maleallele2 bpchar 1  √  null
crs_cross_view malestrain text 2147483647  √  null
crs_cross_view modification_date timestamp 29,6  √  null
crs_cross_view nprogeny int4 10  √  null
crs_cross_view strainho text 2147483647  √  null
crs_cross_view strainht text 2147483647  √  null
crs_cross_view type text 2147483647  √  null
crs_cross_view whosecross text 2147483647  √  null
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
go_tracking_view _completedby_key int4 10  √  null
go_tracking_view _createdby_key int4 10  √  null
go_tracking_view _marker_key int4 10  √  null
go_tracking_view _modifiedby_key int4 10  √  null
go_tracking_view completedby text 2147483647  √  null
go_tracking_view completion_date timestamp 29,6  √  null
go_tracking_view creation_date timestamp 29,6  √  null
go_tracking_view isreferencegene int2 5  √  null
go_tracking_view modification_date timestamp 29,6  √  null
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 int4 10 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 int4 10 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 int4 10 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_antibodyclass _antibodyclass_key int4 10 primary key
gxd_antibodyclass class text 2147483647 class description
gxd_antibodyclass creation_date timestamp 29,6 now() date record was created
gxd_antibodyclass modification_date timestamp 29,6 now() date record was last modified
gxd_antibodymarker _antibody_key int4 10 foreign key to GXD_Antibody
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 int4 10 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_antibodytype _antibodytype_key int4 10 primary key
gxd_antibodytype antibodytype text 2147483647 antibody type description
gxd_antibodytype creation_date timestamp 29,6 now() date record was created
gxd_antibodytype modification_date timestamp 29,6 now() date record was last modified
gxd_antigen _antigen_key int4 10 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 int4 10 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_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 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_assaynote sequencenum int4 10 order of the note segment (for reconstructing the entire note).
gxd_assaytype _assaytype_key int4 10 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_embeddingmethod _embedding_key int4 10 primary key
gxd_embeddingmethod creation_date timestamp 29,6 now() date record was created
gxd_embeddingmethod embeddingmethod text 2147483647 embedding method description
gxd_embeddingmethod modification_date timestamp 29,6 now() date record was last modified
gxd_expression _assay_key int4 10 foreign key to GXD_Assay
gxd_expression _assaytype_key int4 10 foreign key to GXD_AssayType
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_fixationmethod _fixation_key int4 10 primary key
gxd_fixationmethod creation_date timestamp 29,6 now() date record was created
gxd_fixationmethod fixation text 2147483647 fixation method description
gxd_fixationmethod modification_date timestamp 29,6 now() date record was last modified
gxd_gelband _gelband_key int4 10 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 GXD_Strength
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_gelcontrol _gelcontrol_key int4 10 primary key
gxd_gelcontrol creation_date timestamp 29,6 now() date record was created
gxd_gelcontrol gellanecontent text 2147483647 content description
gxd_gelcontrol modification_date timestamp 29,6 now() date record was last modified
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 int4 10 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 _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 _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_gelrnatype _gelrnatype_key int4 10 primary key
gxd_gelrnatype creation_date timestamp 29,6 now() date record was created
gxd_gelrnatype modification_date timestamp 29,6 now() date record was last modified
gxd_gelrnatype rnatype text 2147483647 RNA type description
gxd_gelrow _assay_key int4 10 foreign key to GXD_Assay
gxd_gelrow _gelrow_key int4 10 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_gelunits _gelunits_key int4 10 primary key
gxd_gelunits creation_date timestamp 29,6 now() date record was created
gxd_gelunits modification_date timestamp 29,6 now() date record was last modified
gxd_gelunits units text 2147483647 unit description
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 int4 10 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_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_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 int4 10 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 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 int4 10 primary key
gxd_htexperimentvariable _term_key int4 10 foreign key to VOC_Term, identifying whether the experiment variable
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 int4 10 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 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_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 int4 10 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 _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_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 GXD_Pattern
gxd_insituresult _result_key int4 10 primary key
gxd_insituresult _specimen_key int4 10 foreign key to GXD_Specimen
gxd_insituresult _strength_key int4 10 foreign key to GXD_Strength
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 creation_date timestamp 29,6 now() date record was created
gxd_insituresultimage modification_date timestamp 29,6 now() date record was last modified
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 _specimen_key int4 10  √  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 modification_date timestamp 29,6  √  null
gxd_isresultimage_view panelabel text 2147483647  √  null
gxd_isresultimage_view sequencenum int4 10  √  null
gxd_isresultimage_view xdim 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 _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 _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_label _label_key int4 10 primary key
gxd_label creation_date timestamp 29,6 now() date record was created
gxd_label label text 2147483647 label description
gxd_label modification_date timestamp 29,6 now() date record was last modified
gxd_pattern _pattern_key int4 10 primary key
gxd_pattern creation_date timestamp 29,6 now() date record was created
gxd_pattern modification_date timestamp 29,6 now() date record was last modified
gxd_pattern pattern text 2147483647 pattern description
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 int4 10 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_probesense _sense_key int4 10 primary key
gxd_probesense creation_date timestamp 29,6 now() date record was created
gxd_probesense modification_date timestamp 29,6 now() date record was last modified
gxd_probesense sense text 2147483647 sense description
gxd_secondary _secondary_key int4 10 primary key
gxd_secondary creation_date timestamp 29,6 now() date record was created
gxd_secondary modification_date timestamp 29,6 now() date record was last modified
gxd_secondary secondary text 2147483647 secondary description
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 int4 10 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_strength _strength_key int4 10 primary key
gxd_strength creation_date timestamp 29,6 now() date record was created
gxd_strength modification_date timestamp 29,6 now() date record was last modified
gxd_strength strength text 2147483647 strength description
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)
gxd_visualizationmethod _visualization_key int4 10 primary key
gxd_visualizationmethod creation_date timestamp 29,6 now() date record was created
gxd_visualizationmethod modification_date timestamp 29,6 now() date record was last modified
gxd_visualizationmethod visualization text 2147483647 visualization description
img_image _createdby_key int4 10 1001 user who created the record
img_image _image_key int4 10 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 _mgitype_key int4 10 foreign key to ACC_MGIType
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_summary_view _accession_key int4 10  √  null
img_image_summary_view _createdby_key int4 10  √  null
img_image_summary_view _logicaldb_key int4 10  √  null
img_image_summary_view _mgitype_key int4 10  √  null
img_image_summary_view _modifiedby_key int4 10  √  null
img_image_summary_view _object_key int4 10  √  null
img_image_summary_view accid text 2147483647  √  null
img_image_summary_view creation_date timestamp 29,6  √  null
img_image_summary_view description text 2147483647  √  null
img_image_summary_view mgiid text 2147483647  √  null
img_image_summary_view modification_date timestamp 29,6  √  null
img_image_summary_view numericpart int4 10  √  null
img_image_summary_view preferred int2 5  √  null
img_image_summary_view prefixpart text 2147483647  √  null
img_image_summary_view private int2 5  √  null
img_image_summary_view short_description text 2147483647  √  null
img_image_summary_view subtype text 2147483647  √  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 _mgitype_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 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 mgitype text 2147483647  √  null
img_image_view modification_date timestamp 29,6  √  null
img_image_view modifiedby 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 int4 10 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 int4 10 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 _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_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
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_measurement _statistic_key int4 10 FK to MGI_Statistic, indicating which statistic we are measuring
mgi_measurement floatvalue numeric 131089  √  null the measurement itself (if the value is a float), or null if it is an integer
mgi_measurement intvalue int4 10  √  null the measurement itself (if the value is an integer), or null if it is a float
mgi_measurement islatest int4 10 flag to indicate whether this measurement is the most recent for this statistic (1) or not (0); is an int so it can be indexed
mgi_measurement timerecorded timestamp 29,6 now() date/time at which the measurement was taken
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 int4 10 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_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 creation_date timestamp 29,6  √  null
mgi_note_allele_view modification_date timestamp 29,6  √  null
mgi_note_allele_view note text 2147483647  √  null
mgi_note_allele_view notetype text 2147483647  √  null
mgi_note_allele_view sequencenum int4 10  √  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 creation_date timestamp 29,6  √  null
mgi_note_derivation_view modification_date timestamp 29,6  √  null
mgi_note_derivation_view note text 2147483647  √  null
mgi_note_derivation_view notetype text 2147483647  √  null
mgi_note_derivation_view sequencenum int4 10  √  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 creation_date timestamp 29,6  √  null
mgi_note_genotype_view modification_date timestamp 29,6  √  null
mgi_note_genotype_view note text 2147483647  √  null
mgi_note_genotype_view notetype text 2147483647  √  null
mgi_note_genotype_view sequencenum int4 10  √  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 creation_date timestamp 29,6  √  null
mgi_note_image_view modification_date timestamp 29,6  √  null
mgi_note_image_view note text 2147483647  √  null
mgi_note_image_view notetype text 2147483647  √  null
mgi_note_image_view sequencenum int4 10  √  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 creation_date timestamp 29,6  √  null
mgi_note_marker_view modification_date timestamp 29,6  √  null
mgi_note_marker_view note text 2147483647  √  null
mgi_note_marker_view notetype text 2147483647  √  null
mgi_note_marker_view sequencenum int4 10  √  null
mgi_note_mrkgo_view _createdby_key int4 10  √  null
mgi_note_mrkgo_view _mgitype_key int4 10  √  null
mgi_note_mrkgo_view _modifiedby_key int4 10  √  null
mgi_note_mrkgo_view _note_key int4 10  √  null
mgi_note_mrkgo_view _notetype_key int4 10  √  null
mgi_note_mrkgo_view _object_key int4 10  √  null
mgi_note_mrkgo_view creation_date timestamp 29,6  √  null
mgi_note_mrkgo_view modification_date timestamp 29,6  √  null
mgi_note_mrkgo_view note text 2147483647  √  null
mgi_note_mrkgo_view notetype text 2147483647  √  null
mgi_note_mrkgo_view sequencenum int4 10  √  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 creation_date timestamp 29,6  √  null
mgi_note_probe_view modification_date timestamp 29,6  √  null
mgi_note_probe_view note text 2147483647  √  null
mgi_note_probe_view notetype text 2147483647  √  null
mgi_note_probe_view sequencenum int4 10  √  null
mgi_note_sequence_view _createdby_key int4 10  √  null
mgi_note_sequence_view _mgitype_key int4 10  √  null
mgi_note_sequence_view _modifiedby_key int4 10  √  null
mgi_note_sequence_view _note_key int4 10  √  null
mgi_note_sequence_view _notetype_key int4 10  √  null
mgi_note_sequence_view _object_key int4 10  √  null
mgi_note_sequence_view creation_date timestamp 29,6  √  null
mgi_note_sequence_view modification_date timestamp 29,6  √  null
mgi_note_sequence_view note text 2147483647  √  null
mgi_note_sequence_view notetype text 2147483647  √  null
mgi_note_sequence_view sequencenum int4 10  √  null
mgi_note_source_view _createdby_key int4 10  √  null
mgi_note_source_view _mgitype_key int4 10  √  null
mgi_note_source_view _modifiedby_key int4 10  √  null
mgi_note_source_view _note_key int4 10  √  null
mgi_note_source_view _notetype_key int4 10  √  null
mgi_note_source_view _object_key int4 10  √  null
mgi_note_source_view creation_date timestamp 29,6  √  null
mgi_note_source_view modification_date timestamp 29,6  √  null
mgi_note_source_view note text 2147483647  √  null
mgi_note_source_view notetype text 2147483647  √  null
mgi_note_source_view sequencenum int4 10  √  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 creation_date timestamp 29,6  √  null
mgi_note_strain_view modification_date timestamp 29,6  √  null
mgi_note_strain_view note text 2147483647  √  null
mgi_note_strain_view notetype text 2147483647  √  null
mgi_note_strain_view sequencenum int4 10  √  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 creation_date timestamp 29,6  √  null
mgi_note_vocevidence_view modification_date timestamp 29,6  √  null
mgi_note_vocevidence_view note text 2147483647  √  null
mgi_note_vocevidence_view notetype text 2147483647  √  null
mgi_note_vocevidence_view sequencenum int4 10  √  null
mgi_notechunk _createdby_key int4 10 1001 user who created the record
mgi_notechunk _modifiedby_key int4 10 1001 user who last modified the record
mgi_notechunk _note_key int4 10 foreign key to MGI_Note
mgi_notechunk creation_date timestamp 29,6 now() date record was created
mgi_notechunk modification_date timestamp 29,6 now() date record was last modified
mgi_notechunk note text 2147483647 note
mgi_notechunk sequencenum int4 10 order of the note segment (for reconstructing the entire note).
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_alldriver_view _createdby_key int4 10  √  null
mgi_notetype_alldriver_view _mgitype_key int4 10  √  null
mgi_notetype_alldriver_view _modifiedby_key int4 10  √  null
mgi_notetype_alldriver_view _notetype_key int4 10  √  null
mgi_notetype_alldriver_view creation_date timestamp 29,6  √  null
mgi_notetype_alldriver_view modification_date timestamp 29,6  √  null
mgi_notetype_alldriver_view notetype text 2147483647  √  null
mgi_notetype_alldriver_view private int2 5  √  null
mgi_notetype_allele_view _createdby_key int4 10  √  null
mgi_notetype_allele_view _mgitype_key int4 10  √  null
mgi_notetype_allele_view _modifiedby_key int4 10  √  null
mgi_notetype_allele_view _notetype_key int4 10  √  null
mgi_notetype_allele_view creation_date timestamp 29,6  √  null
mgi_notetype_allele_view modification_date timestamp 29,6  √  null
mgi_notetype_allele_view notetype text 2147483647  √  null
mgi_notetype_allele_view private int2 5  √  null
mgi_notetype_derivation_view _createdby_key int4 10  √  null
mgi_notetype_derivation_view _mgitype_key int4 10  √  null
mgi_notetype_derivation_view _modifiedby_key int4 10  √  null
mgi_notetype_derivation_view _notetype_key int4 10  √  null
mgi_notetype_derivation_view creation_date timestamp 29,6  √  null
mgi_notetype_derivation_view modification_date timestamp 29,6  √  null
mgi_notetype_derivation_view notetype text 2147483647  √  null
mgi_notetype_derivation_view private int2 5  √  null
mgi_notetype_genotype_view _createdby_key int4 10  √  null
mgi_notetype_genotype_view _mgitype_key int4 10  √  null
mgi_notetype_genotype_view _modifiedby_key int4 10  √  null
mgi_notetype_genotype_view _notetype_key int4 10  √  null
mgi_notetype_genotype_view creation_date timestamp 29,6  √  null
mgi_notetype_genotype_view modification_date timestamp 29,6  √  null
mgi_notetype_genotype_view notetype text 2147483647  √  null
mgi_notetype_genotype_view private int2 5  √  null
mgi_notetype_image_view _createdby_key int4 10  √  null
mgi_notetype_image_view _mgitype_key int4 10  √  null
mgi_notetype_image_view _modifiedby_key int4 10  √  null
mgi_notetype_image_view _notetype_key int4 10  √  null
mgi_notetype_image_view creation_date timestamp 29,6  √  null
mgi_notetype_image_view modification_date timestamp 29,6  √  null
mgi_notetype_image_view notetype text 2147483647  √  null
mgi_notetype_image_view private int2 5  √  null
mgi_notetype_marker_view _createdby_key int4 10  √  null
mgi_notetype_marker_view _mgitype_key int4 10  √  null
mgi_notetype_marker_view _modifiedby_key int4 10  √  null
mgi_notetype_marker_view _notetype_key int4 10  √  null
mgi_notetype_marker_view creation_date timestamp 29,6  √  null
mgi_notetype_marker_view modification_date timestamp 29,6  √  null
mgi_notetype_marker_view notetype text 2147483647  √  null
mgi_notetype_marker_view private int2 5  √  null
mgi_notetype_mrkgo_view _createdby_key int4 10  √  null
mgi_notetype_mrkgo_view _mgitype_key int4 10  √  null
mgi_notetype_mrkgo_view _modifiedby_key int4 10  √  null
mgi_notetype_mrkgo_view _notetype_key int4 10  √  null
mgi_notetype_mrkgo_view creation_date timestamp 29,6  √  null
mgi_notetype_mrkgo_view modification_date timestamp 29,6  √  null
mgi_notetype_mrkgo_view notetype text 2147483647  √  null
mgi_notetype_mrkgo_view private int2 5  √  null
mgi_notetype_probe_view _createdby_key int4 10  √  null
mgi_notetype_probe_view _mgitype_key int4 10  √  null
mgi_notetype_probe_view _modifiedby_key int4 10  √  null
mgi_notetype_probe_view _notetype_key int4 10  √  null
mgi_notetype_probe_view creation_date timestamp 29,6  √  null
mgi_notetype_probe_view modification_date timestamp 29,6  √  null
mgi_notetype_probe_view notetype text 2147483647  √  null
mgi_notetype_probe_view private int2 5  √  null
mgi_notetype_sequence_view _createdby_key int4 10  √  null
mgi_notetype_sequence_view _mgitype_key int4 10  √  null
mgi_notetype_sequence_view _modifiedby_key int4 10  √  null
mgi_notetype_sequence_view _notetype_key int4 10  √  null
mgi_notetype_sequence_view creation_date timestamp 29,6  √  null
mgi_notetype_sequence_view modification_date timestamp 29,6  √  null
mgi_notetype_sequence_view notetype text 2147483647  √  null
mgi_notetype_sequence_view private int2 5  √  null
mgi_notetype_source_view _createdby_key int4 10  √  null
mgi_notetype_source_view _mgitype_key int4 10  √  null
mgi_notetype_source_view _modifiedby_key int4 10  √  null
mgi_notetype_source_view _notetype_key int4 10  √  null
mgi_notetype_source_view creation_date timestamp 29,6  √  null
mgi_notetype_source_view modification_date timestamp 29,6  √  null
mgi_notetype_source_view notetype text 2147483647  √  null
mgi_notetype_source_view private int2 5  √  null
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_notetype_vocevidence_view _createdby_key int4 10  √  null
mgi_notetype_vocevidence_view _mgitype_key int4 10  √  null
mgi_notetype_vocevidence_view _modifiedby_key int4 10  √  null
mgi_notetype_vocevidence_view _notetype_key int4 10  √  null
mgi_notetype_vocevidence_view creation_date timestamp 29,6  √  null
mgi_notetype_vocevidence_view modification_date timestamp 29,6  √  null
mgi_notetype_vocevidence_view notetype text 2147483647  √  null
mgi_notetype_vocevidence_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 int4 10 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_acc_view _accession_key int4 10  √  null
mgi_organism_acc_view _createdby_key int4 10  √  null
mgi_organism_acc_view _logicaldb_key int4 10  √  null
mgi_organism_acc_view _mgitype_key int4 10  √  null
mgi_organism_acc_view _modifiedby_key int4 10  √  null
mgi_organism_acc_view _object_key int4 10  √  null
mgi_organism_acc_view accid text 2147483647  √  null
mgi_organism_acc_view creation_date timestamp 29,6  √  null
mgi_organism_acc_view logicaldb text 2147483647  √  null
mgi_organism_acc_view modification_date timestamp 29,6  √  null
mgi_organism_acc_view numericpart int4 10  √  null
mgi_organism_acc_view preferred int2 5  √  null
mgi_organism_acc_view prefixpart text 2147483647  √  null
mgi_organism_acc_view private int2 5  √  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 _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 organism (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
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_organism_summary_view _accession_key int4 10  √  null
mgi_organism_summary_view _logicaldb_key int4 10  √  null
mgi_organism_summary_view _mgitype_key int4 10  √  null
mgi_organism_summary_view _object_key int4 10  √  null
mgi_organism_summary_view accid text 2147483647  √  null
mgi_organism_summary_view creation_date timestamp 29,6  √  null
mgi_organism_summary_view description text 2147483647  √  null
mgi_organism_summary_view mgiid text 2147483647  √  null
mgi_organism_summary_view modification_date timestamp 29,6  √  null
mgi_organism_summary_view numericpart int4 10  √  null
mgi_organism_summary_view preferred int2 5  √  null
mgi_organism_summary_view prefixpart text 2147483647  √  null
mgi_organism_summary_view private int2 5  √  null
mgi_organism_summary_view short_description text 2147483647  √  null
mgi_organism_summary_view subtype text 2147483647  √  null
mgi_organism_view _createdby_key int4 10  √  null
mgi_organism_view _modifiedby_key int4 10  √  null
mgi_organism_view _organism_key int4 10  √  null
mgi_organism_view commonname text 2147483647  √  null
mgi_organism_view createdby text 2147483647  √  null
mgi_organism_view creation_date timestamp 29,6  √  null
mgi_organism_view latinname text 2147483647  √  null
mgi_organism_view modification_date timestamp 29,6  √  null
mgi_organism_view modifiedby text 2147483647  √  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 int4 10 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 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 modification_date timestamp 29,6  √  null
mgi_reference_allele_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 int4 10 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 allowonlyone int2 5  √  null
mgi_reference_marker_view assoctype 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_sequence_view _assoc_key int4 10  √  null
mgi_reference_sequence_view _createdby_key int4 10  √  null
mgi_reference_sequence_view _mgitype_key int4 10  √  null
mgi_reference_sequence_view _modifiedby_key int4 10  √  null
mgi_reference_sequence_view _object_key int4 10  √  null
mgi_reference_sequence_view _refassoctype_key int4 10  √  null
mgi_reference_sequence_view _refs_key int4 10  √  null
mgi_reference_sequence_view allowonlyone int2 5  √  null
mgi_reference_sequence_view assoctype text 2147483647  √  null
mgi_reference_sequence_view creation_date timestamp 29,6  √  null
mgi_reference_sequence_view isreviewarticle int2 5  √  null
mgi_reference_sequence_view isreviewarticlestring bpchar 3  √  null
mgi_reference_sequence_view jnum int4 10  √  null
mgi_reference_sequence_view jnumid text 2147483647  √  null
mgi_reference_sequence_view modification_date timestamp 29,6  √  null
mgi_reference_sequence_view short_citation 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 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_reftype_allele_view _createdby_key int4 10  √  null
mgi_reftype_allele_view _mgitype_key int4 10  √  null
mgi_reftype_allele_view _modifiedby_key int4 10  √  null
mgi_reftype_allele_view _refassoctype_key int4 10  √  null
mgi_reftype_allele_view allowonlyone int2 5  √  null
mgi_reftype_allele_view assoctype text 2147483647  √  null
mgi_reftype_allele_view creation_date timestamp 29,6  √  null
mgi_reftype_allele_view modification_date timestamp 29,6  √  null
mgi_reftype_antibody_view _createdby_key int4 10  √  null
mgi_reftype_antibody_view _mgitype_key int4 10  √  null
mgi_reftype_antibody_view _modifiedby_key int4 10  √  null
mgi_reftype_antibody_view _refassoctype_key int4 10  √  null
mgi_reftype_antibody_view allowonlyone int2 5  √  null
mgi_reftype_antibody_view assoctype text 2147483647  √  null
mgi_reftype_antibody_view creation_date timestamp 29,6  √  null
mgi_reftype_antibody_view modification_date timestamp 29,6  √  null
mgi_reftype_marker_view _createdby_key int4 10  √  null
mgi_reftype_marker_view _mgitype_key int4 10  √  null
mgi_reftype_marker_view _modifiedby_key int4 10  √  null
mgi_reftype_marker_view _refassoctype_key int4 10  √  null
mgi_reftype_marker_view allowonlyone int2 5  √  null
mgi_reftype_marker_view assoctype text 2147483647  √  null
mgi_reftype_marker_view creation_date timestamp 29,6  √  null
mgi_reftype_marker_view modification_date timestamp 29,6  √  null
mgi_reftype_sequence_view _createdby_key int4 10  √  null
mgi_reftype_sequence_view _mgitype_key int4 10  √  null
mgi_reftype_sequence_view _modifiedby_key int4 10  √  null
mgi_reftype_sequence_view _refassoctype_key int4 10  √  null
mgi_reftype_sequence_view allowonlyone int2 5  √  null
mgi_reftype_sequence_view assoctype text 2147483647  √  null
mgi_reftype_sequence_view creation_date timestamp 29,6  √  null
mgi_reftype_sequence_view modification_date timestamp 29,6  √  null
mgi_reftype_strain_view _createdby_key int4 10  √  null
mgi_reftype_strain_view _mgitype_key int4 10  √  null
mgi_reftype_strain_view _modifiedby_key int4 10  √  null
mgi_reftype_strain_view _refassoctype_key int4 10  √  null
mgi_reftype_strain_view allowonlyone int2 5  √  null
mgi_reftype_strain_view assoctype text 2147483647  √  null
mgi_reftype_strain_view creation_date timestamp 29,6  √  null
mgi_reftype_strain_view modification_date timestamp 29,6  √  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 int4 10 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_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 int4 10 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_roletask _createdby_key int4 10 1001 user who created the record
mgi_roletask _modifiedby_key int4 10 1001 user who last modified the record
mgi_roletask _role_key int4 10 foreign key to VOC_Term where _Vocab_key = 33 (User Role)
mgi_roletask _roletask_key int4 10 primary key
mgi_roletask _task_key int4 10 foreign key to VOC_Term where _Vocab_key = 34 (User Task)
mgi_roletask creation_date timestamp 29,6 now() date record was created
mgi_roletask modification_date timestamp 29,6 now() date record was last modified
mgi_roletask_view _createdby_key int4 10  √  null
mgi_roletask_view _modifiedby_key int4 10  √  null
mgi_roletask_view _role_key int4 10  √  null
mgi_roletask_view _roletask_key int4 10  √  null
mgi_roletask_view _task_key int4 10  √  null
mgi_roletask_view creation_date timestamp 29,6  √  null
mgi_roletask_view modification_date timestamp 29,6  √  null
mgi_roletask_view userrole text 2147483647  √  null
mgi_roletask_view usertask text 2147483647  √  null
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_statistic _statistic_key int4 10 primary key
mgi_statistic abbreviation text 2147483647 a short abbreviation to uniquely identify this statistic (not for display)
mgi_statistic definition text 2147483647  √  null a longer description of this statistic (what is being measured?)
mgi_statistic hasintvalue int2 5 flag to indicate whether measurements for this statistic will have integer values (1) or float values (0)
mgi_statistic isprivate int2 5 flag to indicate whether this statistic and its measurements are for public use (0) or only within MGI (1)
mgi_statistic name text 2147483647 name of the statistic
mgi_statistic_view _statistic_key int4 10  √  null
mgi_statistic_view abbreviation text 2147483647  √  null
mgi_statistic_view definition text 2147483647  √  null
mgi_statistic_view floatvalue numeric 131089  √  null
mgi_statistic_view groupname text 2147483647  √  null
mgi_statistic_view hasintvalue int2 5  √  null
mgi_statistic_view intvalue int4 10  √  null
mgi_statistic_view isprivate int2 5  √  null
mgi_statistic_view name text 2147483647  √  null
mgi_statistic_view sequencenum int4 10  √  null
mgi_statistic_view timerecorded timestamp 29,6  √  null
mgi_statisticsql _statistic_key int4 10 FK to MGI_Statistic, indicating the statistic for which we are defining the SQL
mgi_statisticsql sequencenum int4 10 integer value to use in ordering the various records (SQL chunks) for a statistic's SQL
mgi_statisticsql sqlchunk text 2147483647 portion of the SQL statement for computing a measurement of this statistic
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 int4 10 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 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_goterm_view _createdby_key int4 10  √  null
mgi_synonym_goterm_view _mgitype_key int4 10  √  null
mgi_synonym_goterm_view _modifiedby_key int4 10  √  null
mgi_synonym_goterm_view _object_key int4 10  √  null
mgi_synonym_goterm_view _organism_key int4 10  √  null
mgi_synonym_goterm_view _refs_key int4 10  √  null
mgi_synonym_goterm_view _synonym_key int4 10  √  null
mgi_synonym_goterm_view _synonymtype_key int4 10  √  null
mgi_synonym_goterm_view allowonlyone int2 5  √  null
mgi_synonym_goterm_view creation_date timestamp 29,6  √  null
mgi_synonym_goterm_view jnum int4 10  √  null
mgi_synonym_goterm_view modification_date timestamp 29,6  √  null
mgi_synonym_goterm_view modifiedby text 2147483647  √  null
mgi_synonym_goterm_view short_citation text 2147483647  √  null
mgi_synonym_goterm_view synonym text 2147483647  √  null
mgi_synonym_goterm_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 creation_date timestamp 29,6  √  null
mgi_synonym_musmarker_view jnum int4 10  √  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 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_allele_view _createdby_key int4 10  √  null
mgi_synonymtype_allele_view _mgitype_key int4 10  √  null
mgi_synonymtype_allele_view _modifiedby_key int4 10  √  null
mgi_synonymtype_allele_view _organism_key int4 10  √  null
mgi_synonymtype_allele_view _synonymtype_key int4 10  √  null
mgi_synonymtype_allele_view allowonlyone int2 5  √  null
mgi_synonymtype_allele_view creation_date timestamp 29,6  √  null
mgi_synonymtype_allele_view definition text 2147483647  √  null
mgi_synonymtype_allele_view modification_date timestamp 29,6  √  null
mgi_synonymtype_allele_view synonymtype text 2147483647  √  null
mgi_synonymtype_goterm_view _createdby_key int4 10  √  null
mgi_synonymtype_goterm_view _mgitype_key int4 10  √  null
mgi_synonymtype_goterm_view _modifiedby_key int4 10  √  null
mgi_synonymtype_goterm_view _organism_key int4 10  √  null
mgi_synonymtype_goterm_view _synonymtype_key int4 10  √  null
mgi_synonymtype_goterm_view allowonlyone int2 5  √  null
mgi_synonymtype_goterm_view creation_date timestamp 29,6  √  null
mgi_synonymtype_goterm_view definition text 2147483647  √  null
mgi_synonymtype_goterm_view modification_date timestamp 29,6  √  null
mgi_synonymtype_goterm_view synonymtype text 2147483647  √  null
mgi_synonymtype_musmarker_view _createdby_key int4 10  √  null
mgi_synonymtype_musmarker_view _mgitype_key int4 10  √  null
mgi_synonymtype_musmarker_view _modifiedby_key int4 10  √  null
mgi_synonymtype_musmarker_view _organism_key int4 10  √  null
mgi_synonymtype_musmarker_view _synonymtype_key int4 10  √  null
mgi_synonymtype_musmarker_view allowonlyone int2 5  √  null
mgi_synonymtype_musmarker_view creation_date timestamp 29,6  √  null
mgi_synonymtype_musmarker_view definition text 2147483647  √  null
mgi_synonymtype_musmarker_view modification_date timestamp 29,6  √  null
mgi_synonymtype_musmarker_view synonymtype text 2147483647  √  null
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 int4 10 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_translation_view _createdby_key int4 10  √  null
mgi_translation_view _modifiedby_key int4 10  √  null
mgi_translation_view _object_key int4 10  √  null
mgi_translation_view _translation_key int4 10  √  null
mgi_translation_view _translationtype_key int4 10  √  null
mgi_translation_view badname text 2147483647  √  null
mgi_translation_view createdby text 2147483647  √  null
mgi_translation_view creation_date timestamp 29,6  √  null
mgi_translation_view modification_date timestamp 29,6  √  null
mgi_translation_view modifiedby text 2147483647  √  null
mgi_translation_view sequencenum int4 10  √  null
mgi_translationstrain_view _createdby_key int4 10  √  null
mgi_translationstrain_view _mgitype_key int4 10  √  null
mgi_translationstrain_view _modifiedby_key int4 10  √  null
mgi_translationstrain_view _object_key int4 10  √  null
mgi_translationstrain_view _translation_key int4 10  √  null
mgi_translationstrain_view _translationtype_key int4 10  √  null
mgi_translationstrain_view badname text 2147483647  √  null
mgi_translationstrain_view compressionchars text 2147483647  √  null
mgi_translationstrain_view creation_date timestamp 29,6  √  null
mgi_translationstrain_view goodname text 2147483647  √  null
mgi_translationstrain_view modification_date timestamp 29,6  √  null
mgi_translationstrain_view regularexpression int2 5  √  null
mgi_translationstrain_view sequencenum int4 10  √  null
mgi_translationstrain_view translationtype text 2147483647  √  null
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 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 name text 2147483647  √  null
mgi_user_active_view orcid text 2147483647  √  null
mgi_user_active_view usertype text 2147483647  √  null
mgi_userrole _createdby_key int4 10 1001 user who created the record
mgi_userrole _modifiedby_key int4 10 1001 user who last modified the record
mgi_userrole _role_key int4 10 foreign key to VOC_Term where _Vocab_key = 33 (User Role)
mgi_userrole _user_key int4 10 foreign key to MGI_User
mgi_userrole _userrole_key int4 10 primary key
mgi_userrole creation_date timestamp 29,6 now() date record was created
mgi_userrole modification_date timestamp 29,6 now() date record was last modified
mgi_userrole_view _createdby_key int4 10  √  null
mgi_userrole_view _modifiedby_key int4 10  √  null
mgi_userrole_view _role_key int4 10  √  null
mgi_userrole_view _user_key int4 10  √  null
mgi_userrole_view _userrole_key int4 10  √  null
mgi_userrole_view createdby text 2147483647  √  null
mgi_userrole_view creation_date timestamp 29,6  √  null
mgi_userrole_view login text 2147483647  √  null
mgi_userrole_view modification_date timestamp 29,6  √  null
mgi_userrole_view modifiedby text 2147483647  √  null
mgi_userrole_view userrole text 2147483647  √  null
mgi_usertask_view _createdby_key int4 10  √  null
mgi_usertask_view _modifiedby_key int4 10  √  null
mgi_usertask_view _role_key int4 10  √  null
mgi_usertask_view _user_key int4 10  √  null
mgi_usertask_view _userrole_key int4 10  √  null
mgi_usertask_view createdby text 2147483647  √  null
mgi_usertask_view creation_date timestamp 29,6  √  null
mgi_usertask_view login text 2147483647  √  null
mgi_usertask_view modification_date timestamp 29,6  √  null
mgi_usertask_view modifiedby text 2147483647  √  null
mgi_usertask_view userrole text 2147483647  √  null
mgi_usertask_view usertask text 2147483647  √  null
mld_acc_view _accession_key int4 10  √  null
mld_acc_view _createdby_key int4 10  √  null
mld_acc_view _logicaldb_key int4 10  √  null
mld_acc_view _mgitype_key int4 10  √  null
mld_acc_view _modifiedby_key int4 10  √  null
mld_acc_view _object_key int4 10  √  null
mld_acc_view accid text 2147483647  √  null
mld_acc_view creation_date timestamp 29,6  √  null
mld_acc_view logicaldb text 2147483647  √  null
mld_acc_view modification_date timestamp 29,6  √  null
mld_acc_view numericpart int4 10  √  null
mld_acc_view preferred int2 5  √  null
mld_acc_view prefixpart text 2147483647  √  null
mld_acc_view private int2 5  √  null
mld_assay_types _assay_type_key int4 10 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_concordance_view _expt_key int4 10  √  null
mld_concordance_view _marker_key int4 10  √  null
mld_concordance_view _primary text 2147483647  √  null
mld_concordance_view authors text 2147483647  √  null
mld_concordance_view chromosome text 2147483647  √  null
mld_concordance_view cnn int4 10  √  null
mld_concordance_view cnp int4 10  √  null
mld_concordance_view cpn int4 10  √  null
mld_concordance_view cpp int4 10  √  null
mld_concordance_view creation_date timestamp 29,6  √  null
mld_concordance_view jnum int4 10  √  null
mld_concordance_view jnumid text 2147483647  √  null
mld_concordance_view modification_date timestamp 29,6  √  null
mld_concordance_view sequencenum int4 10  √  null
mld_concordance_view short_citation text 2147483647  √  null
mld_concordance_view symbol text 2147483647  √  null
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 _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 gene text 2147483647  √  null original marker symbol; marker symbol used when record was inserted; OBSOLETE/REMOVE FROM SCHEMA
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 _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 gene 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_notes sequencenum int4 10 sequence number of 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 int4 10 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_fish_view _expt_key int4 10  √  null
mld_fish_view _primary text 2147483647  √  null
mld_fish_view _strain_key int4 10  √  null
mld_fish_view authors text 2147483647  √  null
mld_fish_view band text 2147483647  √  null
mld_fish_view cellorigin text 2147483647  √  null
mld_fish_view creation_date timestamp 29,6  √  null
mld_fish_view jnum int4 10  √  null
mld_fish_view jnumid text 2147483647  √  null
mld_fish_view karyotype text 2147483647  √  null
mld_fish_view label text 2147483647  √  null
mld_fish_view modification_date timestamp 29,6  √  null