Table: dbo.Journal_Entry_Event
Table for journal entry events.
Columns
NameTypeConstraintsDescription
journal_entry_event_KEYint (4)NOT NULLPrimary key for this table.
journal_entry_KEYint (4)NOT NULLKey to the Journal Entry table.
journal_entry_event_type_KEYint (4)NOT NULLKey to the Journal Entry event type table.
event_datedatetime (8, 3)NOT NULLThe date and time of the journal entry event.
staff_KEYint (4)NOT NULLKey to the Staff table.
Primary key
NameColumnsDescription
PK_Journal_Entry_Eventjournal_entry_event_KEY
Unique constraints
NameColumnsDescription
UK_Journal_Entry_Event$journal_entry_KEY$journal_entry_event_type_KEYjournal_entry_KEY, journal_entry_event_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Journal_Entry_Event__Journal_Entry__journal_entry_KEYjournal_entry_KEYJournal_Entry (journal_entry_KEY)
FK_Journal_Entry_Event__Journal_Entry_Event_Type__journal_entry_event_type_KEYjournal_entry_event_type_KEYJournal_Entry_Event_Type (journal_entry_event_type_KEY)
FK_Journal_Entry_Event__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram