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