common.faxes
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fax_id | int(11) | NO | PRI | auto_increment | ||
| fax_cus_id | int(11) | NO | MUL | |||
| fax_cli_id | int(11) | NO | MUL | |||
| fax_acc_id | int(11) | NO | ||||
| fax_ord_id | int(11) | NO | ||||
| fax_usr_id | int(11) | NO | MUL | |||
| fax_sfax_id | varchar(20) | NO | ||||
| fax_area | char(1) | NO | 0 | |||
| fax_company | varchar(20) | NO | ||||
| fax_number | varchar(10) | NO | ||||
| fax_num_pages | tinyint(4) | NO | ||||
| fax_done | char(1) | NO | 0 | MUL | ||
| fax_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| fax_created | timestamp | YES | CURRENT_TIMESTAMP |