| Field | Type | Null | Key | Default | Extra |
| id | int(11) | NO | PRI | NULL | auto_increment |
| login | varchar(255) | YES | MUL | | |
| password | varchar(255) | YES | | | |
| basic_account | int(11) | YES | MUL | 0 | |
| is_blocked | int(11) | YES | | 0 | |
| discount_period_id | int(11) | YES | | 0 | |
| advance_payment | int(11) | YES | | 0 | |
| create_date | int(11) | YES | | NULL | |
| last_change_date | int(11) | YES | | NULL | |
| who_create | int(11) | YES | | NULL | |
| who_change | int(11) | YES | | NULL | |
| is_juridical | int(11) | YES | | 0 | |
| full_name | text | YES | | NULL | |
| juridical_address | text | YES | | NULL | |
| actual_address | text | YES | | NULL | |
| work_telephone | varchar(255) | YES | | NULL | |
| home_telephone | varchar(255) | YES | | NULL | |
| mobile_telephone | varchar(255) | YES | | NULL | |
| web_page | varchar(255) | YES | | NULL | |
| icq_number | varchar(255) | YES | | NULL | |
| tax_number | varchar(255) | YES | | NULL | |
| kpp_number | varchar(255) | YES | | NULL | |
| bank_id | int(11) | YES | | 0 | |
| bank_account | varchar(255) | YES | | NULL | |
| email | varchar(255) | YES | | NULL | |
| house_id | int(11) | YES | | NULL | |
| flat_number | varchar(255) | YES | | NULL | |
| entrance | varchar(255) | YES | | NULL | |
| floor | varchar(255) | YES | | NULL | |
| district | varchar(255) | YES | | NULL | |
| building | varchar(255) | YES | | NULL | |
| passport | varchar(255) | YES | | NULL | |
| comments | text | YES | | NULL | |
| personal_manager | varchar(255) | YES | | NULL | |
| connect_date | int(11) | YES | | NULL | |
| remote_switch_id | int(11) | YES | | 0 | |
| port_number | int(11) | YES | | 0 | |
| personal_currency_coef | double | YES | | 1 | |
| binded_currency_code | int(11) | YES | | 810 | |
| is_deleted | int(11) | YES | | 0 | |
| is_send_invoice | int(11) | YES | | 0 | |
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
| users | 0 | PRIMARY | 1 | id | A | 8283 | NULL | NULL | | BTREE | |
| users | 1 | u_acc_idx | 1 | basic_account | A | 8283 | NULL | NULL | YES | BTREE | |
| users | 1 | u_acc_idx | 2 | is_deleted | A | 8283 | NULL | NULL | YES | BTREE | |
| users | 1 | my_usr | 1 | login | A | 8283 | NULL | NULL | YES | BTREE | |
| users | 1 | my_usr | 2 | is_deleted | A | 8283 | NULL | NULL | YES | BTREE | |
