Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.gxd_htsample
A record in this table represents one curated sample for a high-throughput expression experiment (GXD_HTExperiment). Each sample can have accession IDs (ACC_Accession), associated organisms (GXD_HTSampleOrganism), notes (MGI_Note), properties (MGI_Property), and a genotype (GXD_Genotype).

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_sample_key serial 10  √  nextval('gxd_htsample_seq'::regclass)
gxd_htsample_rnaseq
gxd_htsample_rnaseqsetmember
primary key
_experiment_key int4 10
gxd_htexperiment
foreign key to GXD_HTExperiment, identifies the experiment with which this sample is associated
_relevance_key int4 10
voc_term
foreign key to VOC_Term, identifies if this sample is relevant for GXD or, if not, why not
name text 2147483647  √  null name/title of the sample
age text 2147483647  √  null textual age of the sample
agemin numeric 131089  √  null
agemax numeric 131089  √  null
_organism_key int4 10
mgi_organism
foreign key to MGI_Organism, identifying type of organism for the sample
_sex_key int4 10
voc_term
foreign key to VOC_Term, identifying sex of the sample
_emapa_key int4 10  √  null
voc_term
foreign key to VOC_Term, identifying the EMAPA structure for this sample
_stage_key int4 10  √  null
gxd_theilerstage
foreign key to GXD_TheilerStage, identifying the Theiler Stage of the sample
_genotype_key int4 10
gxd_genotype
foreign key to GXD_Genotype, identifying the genotype of the sample
_celltype_term_key int4 10  √  null
voc_term
foreign key to VOC_Term where _Vocab_key = 102 (Cell Ontology)
_createdby_key int4 10 1001
mgi_user
foreign key to MGI_User; user who created the record
_modifiedby_key int4 10 1001
mgi_user
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 143,635 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort
_sample_key Primary key Asc
_celltype_term_key Performance Asc
_createdby_key Performance Asc
creation_date Performance Asc
_emapa_key Performance Asc
_experiment_key Performance Asc
_genotype_key Performance Asc
modification_date Performance Asc
_modifiedby_key Performance Asc
_organism_key Performance Asc
_relevance_key Performance Asc
_sex_key Performance Asc
_stage_key Performance Asc

Close relationships  within of separation: