SchemaSpy - Table pub.mgd.mgi

A record in this table represents a relationship, of a particular category, between any two objects with an MGI Type. For example a relationship between two Markers or a relationship between an Allele and a Marker.
See MGI_Relationship_Category

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

_relationship_key

serial

√

nextval('mgi_relationship_seq'::regclass)

mgi_relationship_property._relationship_key

mgi_relationship_property__relationship_key_fkey C

Primary key

_category_key

int4

mgi_relationship_category._category_key

mgi_relationship__category_key_fkey R

The category, or type, of this relationship

_object_key_1

int4

First object in the relationship

_object_key_2

int4

Second object in the relationship

_relationshipterm_key

int4

voc_term._term_key

mgi_relationship__relationshipterm_key_fkey R

The term identifying the relationship between the two objects

_qualifier_key

int4

voc_term._term_key

mgi_relationship__qualifier_key_fkey R

The term for the relationship qualifier

_evidence_key

int4

voc_term._term_key

mgi_relationship__evidence_key_fkey R

The term for the relationship evidence

_refs_key

int4

bib_refs._refs_key

mgi_relationship__refs_key_fkey R

The relationship reference

_createdby_key

int4

1001

mgi_user._user_key

mgi_relationship__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

1001

mgi_user._user_key

mgi_relationship__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 4,798,810 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_relationship_key	Primary key, Used to cluster data	Asc	mgi_relationship_pkey
_category_key	Performance	Asc	mgi_relationship_idx_category_key
_object_key_1 + _object_key_2	Performance	Asc/Asc	mgi_relationship_idx_clustered
_createdby_key	Performance	Asc	mgi_relationship_idx_createdby_key
_evidence_key	Performance	Asc	mgi_relationship_idx_evidence_key
_modifiedby_key	Performance	Asc	mgi_relationship_idx_modifiedby_key
_object_key_2	Performance	Asc	mgi_relationship_idx_object_key_2
_qualifier_key	Performance	Asc	mgi_relationship_idx_qualifier_key
_refs_key	Performance	Asc	mgi_relationship_idx_refs_key
_relationshipterm_key	Performance	Asc	mgi_relationship_idx_relationshipterm_key