Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.ri_summary_expt_ref
A record in this table defines the Experiment and Reference for an RI Summary record. There is one or more RI_Summary_Expt_Ref records per RI_Summary record.

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
_risummary_key int4 10
ri_summary._risummary_key Implied Constraint R
foreign key to RI_Summary
_expt_key int4 10
mld_expts._expt_key ri_summary_expt_ref__expt_key_fkey R
foreign key to MLD_Expts
_refs_key int4 10
bib_refs._refs_key ri_summary_expt_ref__refs_key_fkey R
foreign key to BIB_Refs
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 12,716 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_risummary_key + _expt_key Primary key, Used to cluster data Asc/Asc ri_summary_expt_ref_pkey
_expt_key Performance Asc ri_summary_expt_ref_idx_expt_key
_refs_key Performance Asc ri_summary_expt_ref_idx_refs_key

Close relationships  within of separation: