Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.gxd_htsample_rnaseqset_cache
A join table to provide easy access to RNASeqSet and RNASeqSet_Combined data

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
_assoc_key serial 10  √  nextval('gxd_htsample_rnaseqset_cache_seq'::regclass)
primary key
_rnaseqcombined_key int4 10
gxd_htsample_rnaseqcombined
foreign key to GXD_HTSample_RNASeqCombined
_rnaseqset_key int4 10
gxd_htsample_rnaseqset
foreign key to GXD_HTSample_RNASeqSet
_createdby_key int4 10 1001
mgi_user
_modifiedby_key int4 10 1001
mgi_user
creation_date timestamp 29,6 now()
modification_date timestamp 29,6 now()

Table contained 36,724,708 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort
_assoc_key Primary key Asc
_createdby_key Performance Asc
_modifiedby_key Performance Asc
_rnaseqcombined_key Performance Asc
_rnaseqset_key Performance Asc

Close relationships  within of separation: