user_payout_transactions
This table is an audit log of all the payout transactions initiated by a user when redeeming reward tokens.
Model
id
int4
user_id
int4
Foreign Key (person table)
amount
float8
status
varchar
payout_id
text
payout_transaction_data
json
error_code
json
source
varchar
fund_account_id
varchar
created_at
timestamp
updated_at
timestamp
reference
json
Description of fields
id
The primary key of the table.
user_id
ID of the user who initiated the payout.
amount
Amount (in INR) involved in the transaction.
status
Status of the transaction.
Pending - This means the payout has been started but is still not complete between the Bolbhav bank and user bank.
Processed - This means the payout was successful and the amount has been deducted from Bolbhav bank.
Reversed - This means the payout was unsuccessful for some reasons.
payout_id
This is a unique ID of the payout that Bolbhav uses to mark each payout.
payout_transaction_data
Data received from payout provider (currently RazorPay). This will include more details about the payout transaction and the corresponding fields based on the transaction status.
error_code
This is the error JSON as received by payout provider. Here's one example:
source
This field captures the source of the transaction details. This field is currently hardcoded to store "RazorpayX" value as all payout transactions are being done through Razorpay.
fund_account_id
The foreign key referring to the fund account id for which the payout transaction has been triggered.
created_at
Timestamp at which payout entry was created.
updated_at
Timestamp at which payout entry was last updated.
reference
Additional details that are captured to store information about the fund account id at the time of the transaction. A sample entry looks like:
Last updated