| Name | Description | Type | Additional information | 
|---|---|---|---|
| id | 
                         Primary Key  | 
                    globally unique identifier | 
                                 Required  | 
                
| db_table_id | 
                         db_table_id  | 
                    globally unique identifier | |
| id_in_table | 
                         id_in_table  | 
                    globally unique identifier | |
| date_sent | 
                         utc date time email sent.  | 
                    date | |
| type | 
                         type, like CONTRACT_RENEW , IMPORT_DONE , JOB_APPROVAL , JOB_PLANNING , ORDER , PURCHASE_ORDER , TASK  | 
                    string | |
| subject | 
                         subject of email  | 
                    string | |
| message | 
                         email message in html format  | 
                    string |