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. |