+---------------------+---------------+------+-----+---------------------+----------------+
| Field               | Type          | Null | Key | Default             | Extra          |
+---------------------+---------------+------+-----+---------------------+----------------+
| id                  | int           | NO   | PRI | NULL                | auto_increment |
| number              | varchar(20)   | NO   | MUL | NULL                |                |
| reseller_id         | int           | YES  | MUL | NULL                |                |
| pricelist_id        | int           | NO   | MUL | NULL                |                |
| paypal_permission   | tinyint(1)    | NO   |     | 0                   |                |
| reference           | varchar(100)  | NO   |     | NULL                |                |
| status              | tinyint(1)    | NO   |     | 0                   |                |
| sweep_id            | tinyint(1)    | NO   |     | 0                   |                |
| creation            | datetime      | NO   |     | 1000-01-01 00:00:00 |                |
| credit_limit        | decimal(20,5) | NO   |     | 0.00000             |                |
| posttoexternal      | tinyint(1)    | NO   |     | 0                   |                |
| balance             | decimal(20,5) | NO   |     | 0.00000             |                |
| password            | varchar(100)  | NO   |     |                     |                |
| first_name          | varchar(40)   | NO   |     |                     |                |
| last_name           | varchar(40)   | NO   |     |                     |                |
| company_name        | varchar(40)   | NO   |     |                     |                |
| address_1           | varchar(80)   | NO   |     |                     |                |
| address_2           | varchar(80)   | NO   |     |                     |                |
| postal_code         | varchar(12)   | NO   |     |                     |                |
| province            | varchar(20)   | NO   |     |                     |                |
| city                | varchar(20)   | NO   |     |                     |                |
| country_id          | int           | NO   |     | 0                   |                |
| telephone_1         | varchar(20)   | NO   |     |                     |                |
| telephone_2         | varchar(20)   | NO   |     |                     |                |
| email               | varchar(80)   | NO   |     |                     |                |
| notification_email  | varchar(80)   | NO   |     |                     |                |
| language_id         | int           | NO   |     | 0                   |                |
| currency_id         | int           | NO   |     | 0                   |                |
| maxchannels         | int           | NO   |     | 1                   |                |
| cps                 | int           | NO   |     | 0                   |                |
| dialed_modify       | mediumtext    | NO   |     | NULL                |                |
| type                | tinyint(1)    | YES  |     | 0                   |                |
| timezone_id         | int           | NO   |     | 0                   |                |
| inuse               | int           | NO   |     | 0                   |                |
| deleted             | tinyint(1)    | NO   |     | 0                   |                |
| notify_credit_limit | decimal(20,5) | NO   |     | 0.00000             |                |
| notify_flag         | tinyint(1)    | NO   |     | NULL                |                |
| notify_email        | varchar(80)   | NO   |     | NULL                |                |
| commission_rate     | int           | NO   |     | 0                   |                |
| invoice_day         | int           | NO   |     | 0                   |                |
| invoice_interval    | int           | NO   |     | NULL                |                |
| invoice_note        | text          | NO   |     | NULL                |                |
| last_bill_date      | datetime      | NO   |     | 0000-00-00 00:00:00 |                |
| pin                 | varchar(20)   | NO   |     | NULL                |                |
| first_used          | datetime      | NO   |     | NULL                |                |
| expiry              | datetime      | NO   |     | NULL                |                |
| validfordays        | int           | NO   |     | 3652                |                |
| local_call_cost     | decimal(20,5) | NO   |     | 0.00000             |                |
| pass_link_status    | tinyint(1)    | NO   |     | 0                   |                |
| local_call          | tinyint(1)    | NO   |     | 1                   |                |
| charge_per_min      | varchar(100)  | NO   |     | NULL                |                |
| is_recording        | tinyint(1)    | NO   |     | 1                   |                |
| allow_ip_management | tinyint(1)    | NO   |     | 1                   |                |
| permission_id       | int           | NO   |     | 0                   |                |
| deleted_date        | datetime      | NO   |     | 1000-01-01 00:00:00 |                |
| localization_id     | int           | YES  |     | 0                   |                |
| notifications       | tinyint       | NO   |     | 0                   |                |
| is_distributor      | tinyint       | NO   |     | 1                   |                |
| generate_invoice    | tinyint       | NO   |     | 0                   |                |
| std_cid_translation | varchar(100)  | NO   |     | NULL                |                |
| did_cid_translation | varchar(100)  | NO   |     | NULL                |                |
| tax_number          | varchar(100)  | YES  |     | NULL                |                |
+---------------------+---------------+------+-----+---------------------+----------------+