Колонки
| Field | Type | Collation | Null | Key | Default | Extra | Comment |
| id |
bigint(20) unsigned |
|
NO |
PRI PK
|
|
auto_increment |
|
| url |
varchar(600) |
utf8mb4_unicode_ci |
NO |
UNI |
|
|
|
| sku |
varchar(80) |
utf8mb4_unicode_ci |
YES |
MUL |
|
|
|
| title |
varchar(600) |
utf8mb4_unicode_ci |
YES |
|
|
|
|
| description_html |
mediumtext |
utf8mb4_unicode_ci |
YES |
|
|
|
|
| image_url |
varchar(600) |
utf8mb4_unicode_ci |
YES |
|
|
|
|
| image_url_two |
varchar(600) |
utf8mb4_unicode_ci |
YES |
|
|
|
|
| image_url_three |
varchar(600) |
utf8mb4_unicode_ci |
YES |
|
|
|
|
| image_url_four |
varchar(600) |
utf8mb4_unicode_ci |
YES |
|
|
|
|
| image_url_five |
varchar(600) |
utf8mb4_unicode_ci |
YES |
|
|
|
|
| lastmod |
date |
|
YES |
|
|
|
|
| http_status |
smallint(6) |
|
YES |
|
|
|
|
| fetched_at |
datetime |
|
YES |
MUL |
|
|
|
| content_hash |
char(64) |
utf8mb4_unicode_ci |
YES |
|
|
|
|
| error |
text |
utf8mb4_unicode_ci |
YES |
|
|
|
|
Индексы
| Key_name | Non_unique | Seq | Column_name | Index_type | Cardinality |
| PRIMARY |
0 |
1 |
id |
BTREE |
24663 |
| uq_url |
0 |
1 |
url |
BTREE |
24663 |
| idx_sku |
1 |
1 |
sku |
BTREE |
24663 |
| idx_fetched |
1 |
1 |
fetched_at |
BTREE |
24663 |
Foreign keys
FK не обнаружены.