Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
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
Legend: SourceForge.net
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 10
all_allele._allele_key all_label__allele_key_fkey C
foreign key to ALL_Allele
_label_status_key int4 10 1 = current, 2 = old
priority int4 10 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,546,236 rows at Mon Nov 20 05:26 EST 2017

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

Close relationships  within of separation: