Table: dbo.Term
Columns
NameTypeConstraintsDescription
term_KEYint (4)NOT NULLHardcoded primary key.
descriptionnvarchar (60)NOT NULLSystem description.
pluralnvarchar (30)NOT NULLUser defined plural description.
singularnvarchar (30)NOT NULLUser defined singular description.
Primary key
NameColumnsDescription
PK_Termterm_KEY
Unique constraints
NameColumnsDescription
UK_Term$descriptiondescription

Schema diagram