xpms.canon_vocabulary
TableRow level security on
Canon vocabularies whose labels are translated (Section 15, ADR 0053): where each one's codes and English labels live. The vocabulary id names its label file in packages/i18n/canon/<locale>/.
Primary key: vocabulary
| Column | Type | Nullable | Description |
|---|---|---|---|
| vocabulary | xpms.canon_code | No | Vocabulary id, for example department or jobTitle. |
| ordinal | integer | No | Display order. |
| source_table | regclass | No | The canon table holding the codes and their English labels. |
| code_column | xpms.canon_code | No | Column holding the code. Codes are never translated. |
| parent_column | xpms.canon_code | Yes | For a two-column key, the column that scopes the code; the stored code is <parent>/<code> (record subtypes, scoped by kind). NULL otherwise. |
| label_column | xpms.canon_code | No | Column holding the English (en-US) label. |
| description | xpms.canon_text | No | What the vocabulary is, in English. |