use ryvue;

DROP TABLE IF EXISTS `ido_resume`;
CREATE TABLE `ido_resume` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '简历编号',
  `u_id` int NOT NULL COMMENT '用户id',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姓名',
  `self_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '证件照',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手机号',
  `email` varchar(255) NOT NULL COMMENT '邮箱',
  `purpose` varchar(255) NOT NULL COMMENT '求职意向',
  `self_introduction` text NOT NULL COMMENT '自我介绍',
  `honor` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '证书/荣誉',
  `experience` text NOT NULL COMMENT '工作/项目经历',
  `resume_path` varchar(255) NOT NULL COMMENT '上传的简历',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;