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
Name | Type | Constraints | Description
direct_deposit_processing_locked_transaction_KEY | int (4) | NOT NULL | The primary key.
transaction_KEY | int (4) | NOT NULL | Key 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_KEY | int (4) | NOT NULL | Type of the transction being locked - relates to the table in which the transaction exists.
user_session_guid | uniqueidentifier (16) | NOT NULL | Guid which ties a particular user session to a table row.

Primary key
Name | Columns | Description
PK_Direct_Deposit_Processing_Locked_Transaction | direct_deposit_processing_locked_transaction_KEY |
Unique constraints
Name | Columns | Description
UK_Direct_Deposit_Processing_Locked_Transaction$transaction_KEY$direct_deposit_processing_locked_transaction_type_KEY | transaction_KEY, direct_deposit_processing_locked_transaction_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Direct_Deposit_Processing_Locked_Transaction__Direct_Deposit_Processing_Locked_Transaction_Type__direct_deposit_processing_lo | direct_deposit_processing_locked_transaction_type_KEY | Direct_Deposit_Processing_Locked_Transaction_Type (direct_deposit_processing_locked_transaction_type_KEY) |