SchemaSpy - Table pub.mgd.all_allele

A record in this table represents the Molecular Mutation for a specific Allele. An Allele can have 0 or more Molecular Mutations.

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

_assoc_key

serial

√

nextval('all_allele_mutation_seq'::regclass)

Implied Constraint R

_allele_key

int4

all_allele._allele_key

all_allele_mutation__allele_key_fkey C

foreign key to ALL_Allele

_mutation_key

int4

voc_term._term_key

all_allele_mutation__mutation_key_fkey R

foreign key to ALL_Molecular_Mutation

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 741,714 rows at Tue Feb 17 06:11 EST 2026

Indexes:

Column(s)	Type	Sort	Constraint Name
_assoc_key	Primary key	Asc	all_allele_mutation_pkey
_allele_key	Performance	Asc	all_allele_mutation_idx_allele_key
creation_date	Performance	Asc	all_allele_mutation_idx_creation_date
modification_date	Performance	Asc	all_allele_mutation_idx_modification_date
_mutation_key	Performance	Asc	all_allele_mutation_idx_mutation_key