Table: dbo.Journal_Entry_Event
Table for journal entry events.
Columns
Name | Type | Constraints | Description
journal_entry_event_KEY | int (4) | NOT NULL | Primary key for this table.
journal_entry_KEY | int (4) | NOT NULL | Key to the Journal Entry table.
journal_entry_event_type_KEY | int (4) | NOT NULL | Key to the Journal Entry event type table.
event_date | datetime (8, 3) | NOT NULL | The date and time of the journal entry event.
staff_KEY | int (4) | NOT NULL | Key to the Staff table.

Primary key
Name | Columns | Description
PK_Journal_Entry_Event | journal_entry_event_KEY |
Unique constraints
Name | Columns | Description
UK_Journal_Entry_Event$journal_entry_KEY$journal_entry_event_type_KEY | journal_entry_KEY, journal_entry_event_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Journal_Entry_Event__Journal_Entry__journal_entry_KEY | journal_entry_KEY | Journal_Entry (journal_entry_KEY) |
FK_Journal_Entry_Event__Journal_Entry_Event_Type__journal_entry_event_type_KEY | journal_entry_event_type_KEY | Journal_Entry_Event_Type (journal_entry_event_type_KEY) |
FK_Journal_Entry_Event__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |