Table: dbo.Employee_Event
Columns
NameTypeConstraintsDescription
employee_event_KEYint (4)NOT NULLPrimary key for this table
employee_KEYint (4)NOT NULLEmployee related to this date
employee_event_type_KEYint (4)NOT NULLThe employee event type
event_datesmalldatetime (4)NOT NULLThe date the event occurred
notenvarchar (400)NOT NULLUsed to provide further information about the event
Primary key
NameColumnsDescription
PK_Employee_Eventemployee_event_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Event__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_Event__Employee_Event_Type__employee_event_type_KEYemployee_event_type_KEYEmployee_Event_Type (employee_event_type_KEY)

Schema diagram