Table: Term
Information about customizable terms.
Columns
NameTypeConstraintsDescription
term_KEYintNOT NULLHardcoded primary key.
create_date_utcdatetimeNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
descriptionnvarchar (50)NOT NULLSystem description.
pluralnvarchar (50)NOT NULLUser defined plural description.
singularnvarchar (50)NOT NULLUser defined singular description.
Primary key
NameColumnsDescription
PK_Term$term_KEYterm_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Term$descriptiondescriptionEach description must be unique.

Schema diagram