CREATE TABLE intake_items (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  batch_id BIGINT UNSIGNED NOT NULL,
  project_id BIGINT UNSIGNED NOT NULL,
  kind VARCHAR(16) NOT NULL,
  payload JSON NULL,
  file_path VARCHAR(1024) NULL,
  original_name VARCHAR(512) NULL,
  mime_type VARCHAR(255) NULL,
  size_bytes BIGINT UNSIGNED NULL,
  content_hash CHAR(64) NOT NULL,
  status VARCHAR(32) NOT NULL DEFAULT 'pending',
  error TEXT NULL,
  metadata JSON NULL,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY idx_intake_items_project_hash (project_id, content_hash),
  KEY idx_intake_items_project_status (project_id, status),
  KEY idx_intake_items_batch (batch_id),
  CONSTRAINT fk_intake_items_batch FOREIGN KEY (batch_id) REFERENCES intake_batches (id),
  CONSTRAINT fk_intake_items_project FOREIGN KEY (project_id) REFERENCES projects (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;