Database – Loan Document Entity (loan_document_entity)
Holds loan document information for a loan
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 | ||
user_id | int(11) | ID of the associated agent user | ||
user_name | varchar(255) | Associated user name | ||
remote_addr | char(20) | IP address of the client machine | ||
section_id | int(11) | ID of the associated section for the entity | ||
file_attachment_id | int(11) | file attachment id | ||
filename | varchar(500) | file name | ||
description | text | The description of the entity instance | ||
ip | int(11) | IP address | ||
size | int(11) | Size of the generated file | ||
customer_visible | tinyint(1) | Whether or not it is visible to the customer | 1 - yes, 0 - no | |
archived | tinyint(1) | Whether or not the entity is archived | 1 - yes, 0 - no | |
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 | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |