Database – Custom Form Tool Entity (custom_form_tool_entity)
Description
This holds information on custom forms that have been or are being generated for loans.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
user_id | int(11) | ID of the associated agent user | ||
custom_form_id | int(11) | ID of associated custom form entity | ||
pdf_output | varchar(100) | Encoded options for PDF output | pdf.output.multiple, pdf.output.single | |
query | text | Query used to select entities to process | ||
done | tinyint(1) | Whether or not the tool is complete | 1 - yes, 0 - no | |
file_name | varchar(255) | Name of the file being imported | ||
url | text | The link to the generated file | ||
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 |