Table: dbo.Direct_Deposit_Processing_Locked_Transaction
This table holds transaction identifiers for direct deposit transactions currently being processed to prevent multiple processing instances.
Columns
NameTypeConstraintsDescription
direct_deposit_processing_locked_transaction_KEYint (4)NOT NULLThe primary key.
transaction_KEYint (4)NOT NULLKey to the transaction being locked - foreign key into the table indicated by direct_deposit_processing_locked_transaction_type_KEY - no FK constraint.
direct_deposit_processing_locked_transaction_type_KEYint (4)NOT NULLType of the transction being locked - relates to the table in which the transaction exists.
user_session_guiduniqueidentifier (16)NOT NULLGuid which ties a particular user session to a table row.
Primary key
NameColumnsDescription
PK_Direct_Deposit_Processing_Locked_Transactiondirect_deposit_processing_locked_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Direct_Deposit_Processing_Locked_Transaction$transaction_KEY$direct_deposit_processing_locked_transaction_type_KEYtransaction_KEY, direct_deposit_processing_locked_transaction_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Direct_Deposit_Processing_Locked_Transaction__Direct_Deposit_Processing_Locked_Transaction_Type__direct_deposit_processing_lodirect_deposit_processing_locked_transaction_type_KEYDirect_Deposit_Processing_Locked_Transaction_Type (direct_deposit_processing_locked_transaction_type_KEY)

Schema diagram