Table: dbo.Bank_Transaction_Event
Table to store bank transactions events
Columns
NameTypeConstraintsDescription
bank_transaction_event_KEYint (4)NOT NULLPrimary key for this table.
bank_transaction_KEYint (4)NOT NULLKey to the Bank Transaction table.
bank_transaction_event_type_KEYint (4)NOT NULLKey to the Bank Transaction event type table.
event_datedatetime (8, 3)NOT NULLThe date and time of the bank transaction event.
staff_KEYint (4)NOT NULLKey to the Staff table.
Primary key
NameColumnsDescription
PK_Bank_Transaction_Eventbank_transaction_event_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Transaction_Event__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Bank_Transaction_Event__Bank_Transaction_Event_Type__bank_transaction_event_type_KEYbank_transaction_event_type_KEYBank_Transaction_Event_Type (bank_transaction_event_type_KEY)
FK_Bank_Transaction_Event__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram