Table: Term
Information about customizable terms.
Columns
NameTypeConstraintsDescription
term_KEYintNOT NULLHardcoded primary key.
create_datedatetimeNOT NULL
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
descriptionnvarchar (50)NOT NULLSystem description.
pluralnvarchar (30)NOT NULLUser defined plural description.
singularnvarchar (30)NOT NULLUser defined singular description.
plural_tokennvarchar (60)NOT NULLToken that is replaced with plural term.
singular_tokennvarchar (60)NOT NULLToken that is replaced with singular term.
plural_defaultnvarchar (60)NOT NULLDefault plural description.
singular_defaultnvarchar (60)NOT NULLDefault singular description.
system_checksumvarbinary (20)NOT NULLChecksum value used to ensure that system-defined values are not modified.
Primary key
NameColumnsDescription
PK_Term$term_KEYterm_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Term__descriptiondescriptionEach description must be unique.
UK_Term__plural_tokenplural_token
UK_Term__singular_tokensingular_token

Schema diagram