| efax_id | int(11) unsigned | NO | | PRI | auto_increment | |
| efax_name | varchar(256) | NO | | | | User friendly name for file |
| efax_ext_id | varchar(32) | NO | | MUL | | |
| efax_acc_id | int(11) | NO | 0 | MUL | | |
| efax_page_count | int(11) | NO | 0 | | | |
| efax_to | varchar(11) | NO | | | | |
| efax_from | varchar(11) | NO | | | | |
| efax_opened | tinyint(1) | NO | 0 | | | |
| efax_path_loc | tinyint(4) | NO | 0 | | | 1: local, 2: cloudfiles |
| efax_path | text | YES | | | | |
| efax_sent | varchar(22) | NO | | | | |
| efax_size | varchar(120) | NO | 0 | | | |
| efax_incoming | tinyint(1) | NO | 0 | | | True for inbound, False for outbound |
| efax_draft | tinyint(1) | NO | 0 | | | True for inbound, False for outbound |
| efax_starred | tinyint(1) | NO | 0 | | | |
| efax_archived | tinyint(1) | NO | 0 | | | |
| efax_read | tinyint(1) | NO | 0 | | | |
| efax_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| efax_created | timestamp | YES | CURRENT_TIMESTAMP | | | |