| 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 | ||