-- 数字藏品预约活动表
drop TABLE if exists `sweet_collection_reservation`;
CREATE TABLE `sweet_collection_reservation`
(
    `mid`             bigint unsigned NOT NULL AUTO_INCREMENT,
    `reservation_id`  varchar(255) NOT NULL DEFAULT '' COMMENT 'reservation_id',
    `nickname`        varchar(50)  NOT NULL DEFAULT '' COMMENT '称呼',
    `mobile`          varchar(11)  NOT NULL DEFAULT '' COMMENT '手机号',
    `mailbox`         varchar(255) NOT NULL DEFAULT '' COMMENT '邮箱',
    `enterprise_name` varchar(255) NOT NULL DEFAULT '' COMMENT '企业名称',
    `title`           varchar(255) NOT NULL DEFAULT '' COMMENT '职务',
    `created_at`      datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updated_at`      datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`mid`),
    KEY               `sweet_reservation_id` (`reservation_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET utf8mb4
  COLLATE utf8mb4_unicode_ci
  ROW_FORMAT = DYNAMIC COMMENT '数字藏品预约活动表';