Table: dbo.Bank_Transaction_Event
Table to store bank transactions events
Columns
Name | Type | Constraints | Description
bank_transaction_event_KEY | int (4) | NOT NULL | Primary key for this table.
bank_transaction_KEY | int (4) | NOT NULL | Key to the Bank Transaction table.
bank_transaction_event_type_KEY | int (4) | NOT NULL | Key to the Bank Transaction event type table.
event_date | datetime (8, 3) | NOT NULL | The date and time of the bank transaction event.
staff_KEY | int (4) | NOT NULL | Key to the Staff table.

Primary key
Name | Columns | Description
PK_Bank_Transaction_Event | bank_transaction_event_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Transaction_Event__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Bank_Transaction_Event__Bank_Transaction_Event_Type__bank_transaction_event_type_KEY | bank_transaction_event_type_KEY | Bank_Transaction_Event_Type (bank_transaction_event_type_KEY) |
FK_Bank_Transaction_Event__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |