Таблица: production_ecommerce.users
Структура столбцов (DESCRIBE users)
| Поле (Field) | Тип данных (Type) | Null | Ключ (Key) | По умолчанию | Дополнительно (Extra) |
|---|---|---|---|---|---|
| id | bigint unsigned | NO | PRI | NONE | auto_increment |
| varchar(190) | NO | UNI | NONE | ||
| full_name | varchar(120) | NO | NONE | ||
| role | enum('customer','manager','admin') | NO | MUL | 'customer' | |
| created_at | timestamp | NO | MUL | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
Обзор данных (SELECT * FROM users LIMIT 50)
| id | full_name | role | is_active | created_at | |
|---|---|---|---|---|---|
| 1001 | a.sokolov@corp-retail.ru | Алексей Соколов | admin | 1 | 2026-01-15 10:14:22 |
| 1002 | m.ivanova@corp-retail.ru | Мария Иванова | manager | 1 | 2026-02-03 14:32:09 |
| 1003 | dmitry.volkov@mail-client.ru | Дмитрий Волков | customer | 1 | 2026-03-19 08:45:51 |
| 1004 | elena.smirnova@inbox-pro.ru | Елена Смирнова | customer | 1 | 2026-04-02 19:11:04 |