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
Implied relationships
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._sample_key gxd_htsample_rnaseq__sample_key_fkey C
gxd_htsample_rnaseqsetmember._sample_key gxd_htsample_rnaseqsetmember__sample_key_fkey C
primary key
_experiment_key int4 10
gxd_htexperiment._experiment_key gxd_htsample__experiment_key_fkey C
foreign key to GXD_HTExperiment, identifies the experiment with which this sample is associated
_relevance_key int4 10
voc_term._term_key gxd_htsample__relevance_key_fkey R
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._organism_key gxd_htsample__organism_key_fkey R
foreign key to MGI_Organism, identifying type of organism for the sample
_sex_key int4 10
voc_term._term_key gxd_htsample__sex_key_fkey R
foreign key to VOC_Term, identifying sex of the sample
_emapa_key int4 10  √  null
voc_term._term_key gxd_htsample__emapa_key_fkey R
foreign key to VOC_Term, identifying the EMAPA structure for this sample
_stage_key int4 10  √  null
gxd_theilerstage._stage_key gxd_htsample__stage_key_fkey R
foreign key to GXD_TheilerStage, identifying the Theiler Stage of the sample
_genotype_key int4 10
gxd_genotype._genotype_key gxd_htsample__genotype_key_fkey R
foreign key to GXD_Genotype, identifying the genotype of the sample
_celltype_term_key int4 10  √  null
voc_term._term_key gxd_htsample__celltype_term_key_fkey R
foreign key to VOC_Term where _Vocab_key = 102 (Cell Ontology)
_createdby_key int4 10 1001
mgi_user._user_key gxd_htsample__createdby_key_fkey R
foreign key to MGI_User; user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key gxd_htsample__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 143,635 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort Constraint Name
_sample_key Primary key Asc gxd_htsample_pkey
_celltype_term_key Performance Asc gxd_htsample_idx_celltype_term_key
_createdby_key Performance Asc gxd_htsample_idx_createdby_key
creation_date Performance Asc gxd_htsample_idx_creation_date
_emapa_key Performance Asc gxd_htsample_idx_emapa_key
_experiment_key Performance Asc gxd_htsample_idx_experiment_key
_genotype_key Performance Asc gxd_htsample_idx_genotype_key
modification_date Performance Asc gxd_htsample_idx_modification_date
_modifiedby_key Performance Asc gxd_htsample_idx_modifiedby_key
_organism_key Performance Asc gxd_htsample_idx_organism_key
_relevance_key Performance Asc gxd_htsample_idx_relevance_key
_sex_key Performance Asc gxd_htsample_idx_sex_key
_stage_key Performance Asc gxd_htsample_idx_stage_key

Close relationships  within of separation: