Table: dbo.Event_Type
Columns
NameTypeConstraintsDescription
descriptionnvarchar (80)NOT NULLPractice-defined description (unique).
event_type_KEYint (4)NOT NULLThis constraint prevents inadvertent inserts into the Event_Type table.
Primary key
NameColumnsDescription
PK_Event_Typeevent_type_KEY
Unique constraints
NameColumnsDescription
UK_Event_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Recorded_Event__Event_Type__event_type_KEYevent_type_KEYRecorded_Event

Schema diagram