Database – Loan To Admin Tool Map (admin_tool__loan)
Description
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.
Table Fields
Field | Data Type | Column Info | Value Notes |
admin_tool_id | INT(11) | Tool id | |
loan_id | VARCHAR(45) | The id of the associated loan account | |
loan_type | varchar(100) | The loan type | Default is set to: Entity.Loan |
lastUpdated | TIMESTAMP | Timestamp of when the entity was last updated |