Saltar al contenido

xpms.canon_label

TablaSeguridad a nivel de fila activa

Translated canon labels, one per vocabulary, canon code and locale (Section 15, ADR 0053). Codes are never translated, and en-US is never stored here: it is the canon table's own label. Read through xpms.canon_labels or xpms.canon_label_of, which fall back to en-US.

Clave primaria: vocabulary, code, locale_code

Columnas de xpms.canon_label
ColumnaTipoAdmite nulosDescripción
vocabularyxpms.canon_codeNoThe vocabulary (xpms.canon_vocabulary).Hace referencia a xpms.canon_vocabulary.vocabulary
codexpms.canon_codeNoThe canon code the label is for, as the vocabulary stores it (<parent>/<code> for a two-column key).
locale_codexpms.canon_codeNoThe locale of the label (xpms.dim_locale), never en-US.Hace referencia a xpms.dim_locale.locale_code
labelxpms.canon_textNoThe label in that locale.
provenancexpms.canon_codeNoWho wrote it: catalog (copied from the app catalogs), machine (the Google Translate pipeline, ADR 0037) or human.
updated_attimestamp with time zoneNoWhen the label was last loaded.