migrate/1763536049_create_exam_appointed_log.up.sql

10 lines
465 B
SQL

CREATE TABLE `ufutx_exam_appointed_log` (
`id` INT NOT NULL AUTO_INCREMENT,
`user_id` INTEGER NOT NULL COMMENT '用户id',
`name` VARCHAR(50) DEFAULT NULL COMMENT '昵称',
`mobile` VARCHAR(50) DEFAULT NULL COMMENT '手机号',
`appointed_time` JSON DEFAULT NULL COMMENT '预约事项',
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB COMMENT = '预约记录';