-- SQL Setup for AK-AIMH April 2026 Webinar Feedback System
-- Webinar: The Unique Toddler World: Key Foundational Elements for a Lifetime of Thriving
-- Date: April 14, 2026
-- Database name: akaimh_survey0426
--
-- Run this in phpMyAdmin after creating the database akaimh_survey0426

CREATE TABLE IF NOT EXISTS `webinar_feedback` (
  `id`           INT(11)      NOT NULL AUTO_INCREMENT,
  `fullname`     VARCHAR(255) NOT NULL,
  `email`        VARCHAR(255) NOT NULL,
  `roles`        VARCHAR(500) NOT NULL,
  `q4`           TINYINT(1)   NOT NULL COMMENT 'Satisfied with training/technical assistance',
  `q5`           TINYINT(1)   NOT NULL COMMENT 'Knowledge of foundational role of toddler development increased',
  `q6`           TINYINT(1)   NOT NULL COMMENT 'Likelihood to use strategies supporting toddler independence/emotions',
  `q7`           TINYINT(1)   NOT NULL COMMENT 'Before: Understand foundational role of toddler development',
  `q8`           TINYINT(1)   NOT NULL COMMENT 'After: Understand foundational role of toddler development',
  `q9`           TINYINT(1)   NOT NULL COMMENT 'Before: Understand primacy of parent-child relationship',
  `q10`          TINYINT(1)   NOT NULL COMMENT 'After: Understand primacy of parent-child relationship',
  `q11`          TINYINT(1)   NOT NULL COMMENT 'Before: Interplay between development areas and role of play',
  `q12`          TINYINT(1)   NOT NULL COMMENT 'After: Interplay between development areas and role of play',
  `q13`          TINYINT(1)   NOT NULL COMMENT 'Overall training rating',
  `q14`          TEXT                  COMMENT 'Additional comments (optional)',
  `submitted_at` DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
