| Table: dbo.Employee_Event | |||
| Columns | |||
| Name | Type | Constraints | Description |
| employee_event_KEY | int (4) | NOT NULL | Primary key for this table |
| employee_KEY | int (4) | NOT NULL | Employee related to this date |
| employee_event_type_KEY | int (4) | NOT NULL | The employee event type |
| event_date | smalldatetime (4) | NOT NULL | The date the event occurred |
| note | nvarchar (400) | NOT NULL | Used to provide further information about the event |
| Primary key | |||
| Name | Columns | Description | |
| PK_Employee_Event | employee_event_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Employee_Event__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) | |
| FK_Employee_Event__Employee_Event_Type__employee_event_type_KEY | employee_event_type_KEY | Employee_Event_Type (employee_event_type_KEY) | |