Table: dbo.Bank_Transaction_Event_Type
Table to store the event type for bank transactions
Columns
NameTypeConstraintsDescription
bank_transaction_event_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (100)NOT NULLDescription of the bank transaction event type.
Primary key
NameColumnsDescription
PK_Bank_Transaction_Event_Typebank_transaction_event_type_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Transaction_Event_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Transaction_Event__Bank_Transaction_Event_Type__bank_transaction_event_type_KEYbank_transaction_event_type_KEYBank_Transaction_Event
FK_Insurepay_N_Payroll_Bank_Transaction__Bank_Transaction_Event_Type__bank_transaction_event_type_KEYbank_transaction_event_type_KEYInsurepay_N_Payroll_Bank_Transaction
FK_XactPay_N_Payroll_Bank_Transaction__Bank_Transaction_Event_Type__bank_transaction_event_type_KEYbank_transaction_event_type_KEYXactPay_N_Payroll_Bank_Transaction

Schema diagram