CREATE TABLE IF NOT EXISTS survey_responses (
  id CHAR(36) NOT NULL PRIMARY KEY,
  created_at DATETIME NOT NULL,
  duration_sec SMALLINT UNSIGNED NOT NULL DEFAULT 1,
  channel ENUM('online','field') NOT NULL DEFAULT 'online',
  enumerator VARCHAR(20) NOT NULL DEFAULT '',
  demo TINYINT(1) NOT NULL DEFAULT 0,
  biz_owner TINYINT(1) NOT NULL DEFAULT 0,
  answers_json JSON NOT NULL,
  contact_consent TINYINT(1) NOT NULL DEFAULT 0,
  contact_name VARCHAR(80) NULL,
  contact_phone VARCHAR(20) NULL,
  created_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_created_at (created_at),
  INDEX idx_channel (channel),
  INDEX idx_biz_owner (biz_owner),
  INDEX idx_contact_consent (contact_consent)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
