SchemaSpy - Table pub.mgd.gxd

A record in this table represents a GXD "index" relationship between a Reference and a Marker. Precusor to fully coding a GXD paper. All records in the GXD Index may or may not be entered into the GXD Assay table. See GXD_Index_Stages.

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

_index_key

serial

√

nextval('gxd_index_seq'::regclass)

gxd_index_stages._index_key

gxd_index_stages__index_key_fkey C

primary key

_refs_key

int4

bib_refs._refs_key

gxd_index__refs_key_fkey R

foreign key to BIB_Refs

_marker_key

int4

mrk_marker._marker_key

gxd_index__marker_key_fkey R

foreign key to MRK_Marker

_priority_key

int4

voc_term._term_key

gxd_index__priority_key_fkey R

foreign key to VOC_Term where _Vocab_key = 11 (GXD Index Priority); 'High', 'Medium', 'Low'

_conditionalmutants_key

int4

voc_term._term_key

gxd_index__conditionalmutants_key_fkey R

foreign key to VOC_Term where _Vocab_key = 74 (GXD Conditional Mutants); 'Both tg & KI', 'Induce (minor)', 'Inducile', 'Knocked in', 'Tg (minor amt)', 'Transgenic', 'Not Specified', 'Not Applicable'

comments

text

2147483647

√

null

textual information

_createdby_key

int4

1001

mgi_user._user_key

gxd_index__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

1001

mgi_user._user_key

gxd_index__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 269,745 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_index_key	Primary key	Asc	gxd_index_pkey
_marker_key + _refs_key	Must be unique	Asc/Asc	gxd_index_idx_clustered
_conditionalmutants_key	Performance	Asc	gxd_index_idx_conditionalmutants_key
_createdby_key	Performance	Asc	gxd_index_idx_createdby_key
creation_date	Performance	Asc	gxd_index_idx_creation_date
modification_date	Performance	Asc	gxd_index_idx_modification_date
_modifiedby_key	Performance	Asc	gxd_index_idx_modifiedby_key
_priority_key	Performance	Asc	gxd_index_idx_priority_key
_refs_key	Performance	Asc	gxd_index_idx_refs_key