Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.gxd_htexperiment
A record in this table represents one high-througput expression experiment. There can be zero or more samples per experiment (GXD_HTSample) and zero or more experiment variables (GXD_ExperimentVariable). Many other experiment attributes are stored as properties (MGI_Property), as notes (MGI_Note), and as accession IDs (ACC_Accession).

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_experiment_key int4 10
gxd_htexperimentvariable._experiment_key gxd_htexperimentvariable__experiment_key_fkey C
gxd_htsample._experiment_key gxd_htsample__experiment_key_fkey C
primary key
_source_key int4 10
voc_term._term_key gxd_htexperiment__source_key_fkey R
foreign key to VOC_Term, identifies site from which we downloaded raw data for this experiment
name text 2147483647  √  null name/title of the experiment
description text 2147483647  √  null textual description
release_date timestamp 29,6  √  null date the experiment was first uploaded to source
lastupdate_date timestamp 29,6  √  null date the experiment was last updated at source
evaluated_date timestamp 29,6  √  null
_evaluationstate_key int4 10
voc_term._term_key gxd_htexperiment__evaluationstate_key_fkey R
foreign key to VOC_Term, identifying whether this experiment has been curated or not
_curationstate_key int4 10
voc_term._term_key gxd_htexperiment__curationstate_key_fkey R
foreign key to VOC_Term, identifying whether curation for this experiment has finished
_studytype_key int4 10
voc_term._term_key gxd_htexperiment__studytype_key_fkey R
foreign key to VOC_Term, identifying whether this experiment is a baseline or differential study
_experimenttype_key int4 10
voc_term._term_key gxd_htexperiment__experimenttype_key_fkey R
foreign key to VOC_Term, in identifying the MGI curated value for experiment type
_evaluatedby_key int4 10  √  null
mgi_user._user_key gxd_htexperiment__evaluatedby_key_fkey R
foreign key to MGI_User; user who evaluated this experiment and set its _Relevance_key
_initialcuratedby_key int4 10  √  null
mgi_user._user_key gxd_htexperiment__initialcuratedby_key_fkey R
foreign key to MGI_User; user who first curated the experiment, converting it from its raw status
_lastcuratedby_key int4 10  √  null
mgi_user._user_key gxd_htexperiment__lastcuratedby_key_fkey R
foreign key to MGI_User; user who last curated the experiment, converting it from its raw status
initial_curated_date timestamp 29,6  √  null date record was first curated
last_curated_date timestamp 29,6  √  null date record was last curated
_createdby_key int4 10 1001
mgi_user._user_key gxd_htexperiment__createdby_key_fkey R
foreign key to MGI_User; user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key gxd_htexperiment__modifiedby_key_fkey R
foreign key to MGI_User; user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 16,130 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_experiment_key Primary key, Used to cluster data Asc gxd_htexperiment_pkey
_createdby_key Performance Asc gxd_htexperiment_idx_createdby_key
creation_date Performance Asc gxd_htexperiment_idx_creation_date
_curationstate_key Performance Asc gxd_htexperiment_idx_curationstate_key
_evaluatedby_key Performance Asc gxd_htexperiment_idx_evaluatedby_key
_evaluationstate_key Performance Asc gxd_htexperiment_idx_evaluationstate_key
_experimenttype_key Performance Asc gxd_htexperiment_idx_experimenttype_key
_initialcuratedby_key Performance Asc gxd_htexperiment_idx_initialcuratedby_key
_lastcuratedby_key Performance Asc gxd_htexperiment_idx_lastcuratedby_key
_modifiedby_key Performance Asc gxd_htexperiment_idx_modifiedby_key
_source_key Performance Asc gxd_htexperiment_idx_source_key
_studytype_key Performance Asc gxd_htexperiment_idx_studytype_key

Close relationships  within of separation: