| uid | bigint(10) |
|
|
|
| id | bigint(10) |
|
|
|
| date_insert | datetime |
|
|
|
| date_close | datetime |
|
|
2200-01-01 01:01:01.000000
|
| susers_id | bigint(10) unsigned |
|
|
0
|
| sgor_id | int(9) |
|
|
0
|
| norg | varchar(200) |
|
|
|
| aorg | varchar(200) |
|
|
|
| is_eq_address | tinyint(1) unsigned |
|
|
0
|
| forg | varchar(200) |
|
|
|
| rsch | varchar(34) |
|
|
|
| korsch | varchar(34) |
|
|
|
| ogrn | varchar(20) |
|
|
|
| kpp | varchar(20) |
|
|
|
| pri | int(1) |
|
|
0
|
| fax | varchar(20) |
|
|
|
| fax_country | varchar(2) |
|
|
|
| tel | varchar(20) |
|
|
|
| tel_country | varchar(2) |
|
|
|
| fio | varchar(50) |
|
|
|
| unn | varchar(15) |
|
|
|
| okp | varchar(20) |
|
|
|
| dtz | date |
|
|
|
| uname | varchar(200) |
|
|
|
| bname | varchar(50) |
|
|
|
| bik | varchar(30) |
|
|
|
| timz | varchar(10) |
|
|
|
| is_del | int(11) |
|
|
0
|
| fiob | varchar(50) |
|
|
|
| descr | text |
|
|
|
| external_id | varchar(100) |
|
|
|
| passport | varchar(250) |
|
|
|
| discount | double |
|
|
0
|
| ndsc | int(2) unsigned |
|
|
99
|
| email | text |
|
|
|
| birthday | date |
|
|
|
| okpo | varchar(10) |
|
|
|
| card_loyalty | varchar(22) |
|
|
|
| contr_localization_key | varchar(100) |
|
|
|
| legal_form_id | int(11) |
|
|
|
| field_id | int(11) |
|
|
|
| custom_field_name | varchar(200) |
|
|
|