Table: Loan Insurance Info

Table: Loan Insurance Info

Holds insurance information for a loan.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
company_namevarchar(255)Insurance Company Name
insuredvarchar(255)Name of insured
agent_namevarchar(255)Agent name
policy_numberchar(20)Insurance policy number
phonechar(15)Insurance company phone number
deductiblechar(15)Insurance deductible
start_datedateInsurance start date
end_datedateInsurance end date
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List