Table: dbo.Bank_Transaction_Event_Type
Table to store the event type for bank transactions
Columns
Name | Type | Constraints | Description
bank_transaction_event_type_KEY | int (4) | NOT NULL | Primary key for this table.
description | nvarchar (100) | NOT NULL | Description of the bank transaction event type.

Primary key
Name | Columns | Description
PK_Bank_Transaction_Event_Type | bank_transaction_event_type_KEY |
Unique constraints
Name | Columns | Description
UK_Bank_Transaction_Event_Type$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Bank_Transaction_Event__Bank_Transaction_Event_Type__bank_transaction_event_type_KEY | bank_transaction_event_type_KEY | Bank_Transaction_Event |
FK_Insurepay_N_Payroll_Bank_Transaction__Bank_Transaction_Event_Type__bank_transaction_event_type_KEY | bank_transaction_event_type_KEY | Insurepay_N_Payroll_Bank_Transaction |
FK_XactPay_N_Payroll_Bank_Transaction__Bank_Transaction_Event_Type__bank_transaction_event_type_KEY | bank_transaction_event_type_KEY | XactPay_N_Payroll_Bank_Transaction |