| id |
bigint(20)
|
|
|
|
| host |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| language_code |
varchar(8)
|
utf8mb4_unicode_ci
|
|
|
| entity_type |
enum('product', 'category', 'blog', 'static_page', 'homepage', 'shop', 'contact', 'faq')
|
utf8mb4_unicode_ci
|
|
|
| entity_id |
int(10)
|
|
|
|
| entity_slug |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| url |
varchar(512)
|
utf8mb4_unicode_ci
|
|
|
| http_status |
smallint(6)
|
|
|
|
| canonical_url |
varchar(512)
|
utf8mb4_unicode_ci
|
|
|
| canonical_ok |
tinyint(1)
|
|
|
|
| robots_indexable |
tinyint(1)
|
|
|
|
| hreflang_ok |
tinyint(1)
|
|
|
|
| sitemap_eligible |
tinyint(1)
|
|
|
|
| sitemap_included |
tinyint(1)
|
|
|
|
| readiness_status |
enum('ready', 'missing_translation', 'fallback_detected', 'wrong_language_indexable', 'inactive_entity', 'wrong_canonical', 'hreflang_conflict', 'noindex_conflict', 'redirecting', 'not_found', 'gone', 'server_error', 'in_sitemap_but_not_ready', 'ready_but_missing_from_sitemap', 'sitemap_ineligible', 'needs_review')
|
utf8mb4_unicode_ci
|
|
|
| issue_code |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| issue_details_json |
longtext
|
utf8mb4_bin
|
|
|
| checked_at |
timestamp
|
|
|
|
