Table: Term
Information about customizable terms.
Columns
Name | Type | Constraints | Description
term_KEY | int | NOT NULL | Hardcoded primary key.
create_date | datetime | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
description | nvarchar (50) | NOT NULL | System description.
plural | nvarchar (30) | NOT NULL | User defined plural description.
singular | nvarchar (30) | NOT NULL | User defined singular description.
plural_token | nvarchar (60) | NOT NULL | Token that is replaced with plural term.
singular_token | nvarchar (60) | NOT NULL | Token that is replaced with singular term.
plural_default | nvarchar (60) | NOT NULL | Default plural description.
singular_default | nvarchar (60) | NOT NULL | Default singular description.
system_checksum | varbinary (20) | NOT NULL | Checksum value used to ensure that system-defined values are not modified.

Primary key
Name | Columns | Description
PK_Term$term_KEY | term_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Term__description | description | Each description must be unique.
UK_Term__plural_token | plural_token |
UK_Term__singular_token | singular_token |