SchemaSpy - Table pub.mgd.ri

A record in this table represents the definition of a Recombinant Inbred Strain.

Generated by
SchemaSpy

Legend:

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

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

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

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 Mar 09 10:28 EDT 2020

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