77 lines
4.9 KiB
SQL
77 lines
4.9 KiB
SQL
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for education
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `education`;
|
|
CREATE TABLE `education` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`info_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
|
`school` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学校',
|
|
`major` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业',
|
|
`start_date` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开始时间',
|
|
`end_date` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '结束时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for info
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `info`;
|
|
CREATE TABLE `info` (
|
|
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'openid',
|
|
`app_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'appid',
|
|
`app_secret` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'appsecret',
|
|
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名字',
|
|
`position` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位',
|
|
`sex` int(1) NULL DEFAULT NULL COMMENT '性别',
|
|
`birthday` datetime(0) NULL DEFAULT NULL COMMENT '生日',
|
|
`blog` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '博客',
|
|
`github` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'github',
|
|
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
|
|
`phone` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
|
|
`introduce` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '自我介绍',
|
|
`technologies` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
|
|
PRIMARY KEY (`id`, `app_id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project`;
|
|
CREATE TABLE `project` (
|
|
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`info_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
|
`project_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目num',
|
|
`project_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
|
|
`project_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目类型',
|
|
`project_desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '项目描述',
|
|
`skill_desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '技术要点',
|
|
`dev_env` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '开发环境',
|
|
`responsibility_desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '责任描述',
|
|
`demo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预览地址',
|
|
`project_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目地址',
|
|
`start_date` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目开始时间',
|
|
`end_date` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目结束时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for work_experience
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `work_experience`;
|
|
CREATE TABLE `work_experience` (
|
|
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`info_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
|
|
`company` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司',
|
|
`position` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位',
|
|
`start_date` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开始时间',
|
|
`end_date` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '结束时间',
|
|
`explain` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '工作内容',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|