Table pub.mgd.all_label 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 |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 1,580,799 rows at Mon Sep 28 09:47 EDT 2020 |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
_allele_key + priority + labeltype + label | Primary key | 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 |
![]() ![]() |