-- 动态表单报名提交表
DROP TABLE IF EXISTS `sweet_form_submission`;
CREATE TABLE `sweet_form_submission`
(
    `mid`            bigint unsigned NOT NULL AUTO_INCREMENT primary key,
    `submission_id`  varchar(64)     NOT NULL DEFAULT '' COMMENT '提交ID',
    `activity_name`  varchar(128)    NOT NULL DEFAULT '' COMMENT '活动名称/标识',
    `data`           json            NOT NULL COMMENT '报名数据JSON',
    `created_at`     datetime        NULL     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updated_at`     datetime        NULL     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    KEY `idx_submission_id` (`submission_id`),
    KEY `idx_activity_name` (`activity_name`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci
  ROW_FORMAT = DYNAMIC COMMENT ='动态表单报名提交表';
