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 |