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


How did we do?


Powered by HelpDocs (opens in a new tab)