Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| keyword_id | text | 2147483647 | null |
|
|
primary key. prefix is ecl- |
||||
| keyword_label | text | 2147483647 | null |
|
|
Text string for presenting the keyword to users |
||||
| keyword_description | text | 2147483647 | √ | null |
|
|
Opportunity to provide some explanation of expected usage of keyword to guide usage |
|||
| keyword_altlabel | text | 2147483647 | √ | null |
|
|
other synonyms for the keyword label |
|||
| keyword_type_id | text | 2147483647 | √ | null |
|
|
keyword type, used to construct UI facets. FK to keyword_type table, for better consistency. types compiled by SMR |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| eclkeyword_pkey | Primary key | Asc | keyword_id |
Relationships
Close relationships within degrees of separation
