Table: dbo.Transmit_Online_Bill_Pay_Selection
This is a locking table assuring that no more than one bank transaction is ever being locked tying the transaction to the user who locked it.
Columns
NameTypeConstraintsDescription
bank_transaction_KEYint (4)NOT NULLThe primary key for this table and foreign key to the Online Bill Pay Bank Transaction table.
user_session_guiduniqueidentifier (16)NOT NULLForeign key to the User Session table.
Primary key
NameColumnsDescription
PK_Transmit_Online_Bill_Pay_Selection$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Transmit_Online_Bill_Pay_Selection__Online_Bill_Pay_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYOnline_Bill_Pay_Bank_Transaction (bank_transaction_KEY)
FK_Transmit_Online_Bill_Pay_Selection__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)

Schema diagram