Table: Term
Information about customizable terms.
Columns
Name | Type | Constraints | Description
term_KEY | int | NOT NULL | Hardcoded primary key.
create_date_utc | datetime | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date_utc | datetime | NOT NULL |
description | nvarchar (50) | NOT NULL | System description.
plural | nvarchar (50) | NOT NULL | User defined plural description.
singular | nvarchar (50) | NOT NULL | User defined singular description.

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.