Database – Collateral Entity (collateral_entity)
Updated 3 months ago
This holds collateral information for loans, such as automobile or property information useful for identification in the case of reposession or foreclosure. Not all loans will have collateral.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
loan_id | int(11) | The id of the associated loan account | ||
a | varchar(100) | Collateral field A | ||
b | varchar(100) | Collateral field B | ||
c | varchar(100) | Collateral field C | ||
d | varchar(100) | Collateral field D | ||
additional | varchar(500) | Additional collateral info | ||
collateral_type | varchar(100) | Collection for the type of the associated collateral | collateral.type.car, collateral.type.consumer, collateral.type.mortgage, collateral.type.other | |
vin | char(17) | Collateral VIN number | ||
distance | int(11) | Distance on odometer | ||
book_value | decimal(11,2) | Collateral book value | ||
color | varchar(50) | stoplight color | stoplight.color.* | |
gps_status | char(40) | Status of a GPS on the collateral | collateral.gpsstatus.installed, collateral.gpsstatus.none, collateral.gpsstatus.notinstalled | |
gps_code | varchar(100) | Code of a GPS on the collateral | ||
license_plate | varchar(100) | License plate number for the collateral | ||
gap | varchar(500) | Amount covered by GAP insurance | ||
warranty | varchar(500) | Amount covered by warranty | ||
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |