SchemaSpy - Table pub.mgd.all

A record in this table represents an Allele Label (current symbol, current name, synonym). This table is a cache table of all "labels" for a given Allele...representing the different ways in which a user may search for a particular Allele. This table is loaded via the alllabelload product.

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

_allele_key

int4

all_allele._allele_key

all_label__allele_key_fkey C

foreign key to ALL_Allele

_label_status_key

int4

1 = current, 2 = old

priority

int4

an integer representing the priority of this record for sorting purposes. the higher the number, the higher the priority.

label

text

2147483647

label type (N, S, Y)

labeltype

text

2147483647

specifies if label is current symbol, current name, allele symbol, allele name, etc.

labeltypename

text

2147483647

label (name, symbol, synonym)

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 1,573,653 rows at Mon Mar 09 10:28 EDT 2020

Indexes:

Column(s)	Type	Sort	Constraint Name
_allele_key + priority + labeltype + label	Primary key, Used to cluster data	Asc/Asc/Asc/Asc	all_label_pkey
lower(label)	Performance	Asc	all_label_0
label	Performance	Asc	all_label_idx_label
_label_status_key	Performance	Asc	all_label_idx_label_status_key
priority	Performance	Asc	all_label_idx_priority