Database – Email Tool Entity (email_tool_entity)
Email tools generate and send out emails to different customers, generally about information for a loan.
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 | ||
company_email_id | int(11) | Company Email ID | ||
email_subject | text | email subject | ||
email_content | text | email content | ||
query | text | Query used to select entities to process | ||
sent | tinyint(1) | Whether or not was sent | 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 |