Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.gxd_htsample_rnaseqsetmember
A record in this table represents a GXD_HTSample member of the GXD_HTSample_RNASeqSet

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
_rnaseqsetmember_key serial 10  √  nextval('gxd_htsample_rnaseqsetmember_seq'::regclass) primary key
_rnaseqset_key int4 10
gxd_htsample_rnaseqset._rnaseqset_key gxd_htsample_rnaseqsetmember__rnaseqset_key_fkey C
foreign key to GXD_HTSample_RNASeq, identifing the set
_sample_key int4 10
gxd_htsample._sample_key gxd_htsample_rnaseqsetmember__sample_key_fkey C
foreign key to GXD_HTSample, identifying the sample member
_createdby_key int4 10 1001
mgi_user._user_key gxd_htsample_rnaseqsetmember__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key gxd_htsample_rnaseqsetmember__modifiedby_key_fkey R
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 1,845 rows at Mon Mar 09 10:28 EDT 2020

Indexes:
Column(s) Type Sort Constraint Name
_rnaseqsetmember_key Primary key, Used to cluster data Asc gxd_htsample_rnaseqsetmember_pkey
_createdby_key Performance Asc gxd_htsample_rnaseqsetmember_idx_createdby_key
_modifiedby_key Performance Asc gxd_htsample_rnaseqsetmember_idx_modifiedby_key
_rnaseqset_key Performance Asc gxd_htsample_rnaseqsetmember_idx_rnaseqset_key
_sample_key Performance Asc gxd_htsample_rnaseqsetmember_idx_sample_key

Close relationships  within of separation: