-- 業種と予約チャネルのマッピングテーブル
CREATE TABLE industry_channel_mappings (
  id INT AUTO_INCREMENT PRIMARY KEY,
  industry_id INT NOT NULL,
  source_id INT NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY unique_industry_source (industry_id, source_id),
  FOREIGN KEY (industry_id) REFERENCES industries(id) ON DELETE CASCADE,
  FOREIGN KEY (source_id) REFERENCES reservation_sources(id) ON DELETE CASCADE
);
