Database – Loan Document Entity (loan_document_entity)
Description
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 |