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 |