Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.ri_riset
A record in this table represents the definition of a Recombinant Inbred Strain.

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
_riset_key int4 10
mld_ri._riset_key Implied Constraint R
mld_ri_view._riset_key Implied Constraint R
ri_riset_view._riset_key Implied Constraint R
ri_summary._riset_key ri_summary__riset_key_fkey R
primary key
_strain_key_1 int4 10
prb_strain._strain_key ri_riset__strain_key_1_fkey R
foreign key to PRB_Strain; 1st member of the cross
_strain_key_2 int4 10
prb_strain._strain_key ri_riset__strain_key_2_fkey R
foreign key to PRB_Strain; 2nd member of the cross
designation text 2147483647 identifying label for the RI Set (ex. AKXL)
abbrev1 text 2147483647 Strain 1 Abbreviation
abbrev2 text 2147483647 Strain 2 Abbreviation
ri_idlist text 2147483647 labels which represent each member of the RI Set
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 40 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_riset_key Primary key, Used to cluster data Asc ri_riset_pkey
designation Must be unique Asc ri_riset_idx_designation
_strain_key_1 Performance Asc ri_riset_idx_strain_key_1
_strain_key_2 Performance Asc ri_riset_idx_strain_key_2

Close relationships  within of separation: