Database – Loan Insurance Info (loan_insurance_entity)
Description
Holds insurance information for a loan.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
company_name | varchar(255) | Insurance Company Name | ||
insured | varchar(255) | Name of insured | ||
agent_name | varchar(255) | Agent name | ||
policy_number | char(20) | Insurance policy number | ||
phone | char(15) | Insurance company phone number | ||
deductible | char(15) | Insurance deductible | ||
start_date | date | Insurance start date | ||
end_date | date | Insurance end date | ||
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |