You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
17 lines
979 B
17 lines
979 B
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; |