Database – Loan To Admin Tool Map (admin_tool__loan)
This table does the many-to-many mapping between admin tools and loans. It allows for admin tools to affect multiple loans and loans to be affected by multiple admin tools. This allows for mapping specific loans to a loan admin tool rather than having it all based on a query.
Column | Data Type | Column Info | Value Notes | Other |
admin_tool_id | INT(11) | Tool id | ||
loan_id | VARCHAR(45) | The id of the associated loan account | ||
lastUpdated | TIMESTAMP | Timestamp of when the entity was last updated |