Database – Checking account entity (checking_account_entity)
Description
This table holds Secure Payments bank account information. This entity stores the relationship between LoanPro accounts and Secure Payments accounts.
Checking Account Entity
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The ID of the entity | ||
token | text | Secure Payments Token | ||
deleted | tinyint(4) | States if the entity was deleted | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
address_id | int(11) | ID of associated address | ||
processor | varchar(100) | Payment processor identifier | ||
account_type | varchar(100) | Secure Payments account type | bankacct.type.checking bankacct.type.savings | |
account_number | varchar(100) | The bank account number | ||
routing_number | varchar(100) | The routing number for the bank the account is held by |