-- Phase 4 only — non-runtime augmentation.
-- Analyst annotations never change fitment outcomes.

-- LEGACY_READ
-- LEGACY TABLE WARNING:
-- product_fitment is deprecated and must not be used for
-- fitment evaluation, confidence scoring, or reconciliation.
-- Use fitment_resolved instead.
CREATE TABLE IF NOT EXISTS product_fitment_annotations (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    product_id BIGINT UNSIGNED NOT NULL,
    note TEXT NOT NULL,
    tags VARCHAR(255) NOT NULL DEFAULT '',
    created_by VARCHAR(80) NOT NULL DEFAULT '',
    created_at DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00',
    INDEX idx_annotations_product (product_id)
);
