administrator
/
technological-brain-server
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
technological-brain-server/target/classes/db/demo.sql

356 lines
25 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

/*
Navicat Premium Data Transfer
Source Server : local
Source Server Type : MySQL
Source Server Version : 80041
Source Host : localhost:3306
Source Schema : demo
Target Server Type : MySQL
Target Server Version : 80041
File Encoding : 65001
Date: 09/05/2025 20:09:53
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for academic_award
-- ----------------------------
DROP TABLE IF EXISTS `academic_award`;
CREATE TABLE `academic_award` (
`award_id` int NOT NULL COMMENT '奖项id',
`talent_id` int NOT NULL COMMENT '人才id',
`award_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '奖励名称',
`award_level` enum('国家级','省级','市级','其他') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '奖励级别',
`award_time` date NOT NULL COMMENT '授予时间',
`awarding_agency` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '授予机构',
PRIMARY KEY (`award_id`) USING BTREE,
INDEX `talent_id`(`talent_id` ASC) USING BTREE,
CONSTRAINT `academic_award_ibfk_1` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '7学术奖励信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for department_basic
-- ----------------------------
DROP TABLE IF EXISTS `department_basic`;
CREATE TABLE `department_basic` (
`STIUL_id` int NOT NULL COMMENT '科室员工号',
`STIUL_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '人员姓名',
`STIUL_org` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所属科室',
`STIUL_gender` enum('男','女') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '性别',
`STIUL_politicalstatus` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '政治面貌',
`STIUL_professionaltitle` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '职称',
`STIUL_entrydate` date NOT NULL COMMENT '入职时间',
`STIUL_email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '电子邮箱',
`STIUL_projectID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '项目验收证书编号',
`STIUL_registrationID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '成果登记编号',
`STIUL_ProjectDate` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '成果登记日期',
PRIMARY KEY (`STIUL_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '10科室基本信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for employment_unit
-- ----------------------------
DROP TABLE IF EXISTS `employment_unit`;
CREATE TABLE `employment_unit` (
`talent_id` int NOT NULL COMMENT '人才id',
`work_unit` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '工作单位',
`position` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '职务',
`professional_title` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '职称',
`entry_date` date NOT NULL COMMENT '入职时间',
PRIMARY KEY (`talent_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '11工作单位信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for enterprise_info
-- ----------------------------
DROP TABLE IF EXISTS `enterprise_info`;
CREATE TABLE `enterprise_info` (
`company_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '企业名称',
`taxpayer_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '纳税人识别号',
`company_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '企业类型',
`is_high_tech_certified` tinyint(1) NULL DEFAULT NULL COMMENT '是否高新技术企业认证（0：否，1：是）',
`qualification_certificate` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '资质证书',
`company_status` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '企业状态',
`legal_representative` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '法定代表人',
`talent_id` int NULL DEFAULT NULL COMMENT '法定代表人id',
`registered_capital` decimal(20, 2) NULL DEFAULT NULL COMMENT '注册资本（单位：万元）',
`company_address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '企业地址',
`province` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '所属省份',
`city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '所属城市',
`district` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '所属区域',
`industry_category` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '所属行业门类',
`industry_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '所属行业名称',
`year_of_establishment` year NULL DEFAULT NULL COMMENT '成立年份',
`establishment_date` date NULL DEFAULT NULL COMMENT '成立日期',
`employee_count` int NULL DEFAULT NULL COMMENT '员工人数',
`website` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '网址',
`business_scope` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '经营范围',
`contact_phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系电话',
`contact_email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系邮箱',
`update_date` date NULL DEFAULT NULL COMMENT '更新日期',
`resume_table` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '简历表格（可存储相关文件路径或内容）',
PRIMARY KEY (`taxpayer_id`) USING BTREE,
INDEX `enterprise_id`(`talent_id` ASC) USING BTREE,
CONSTRAINT `enterprise_id` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '18企业信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for honorary_title
-- ----------------------------
DROP TABLE IF EXISTS `honorary_title`;
CREATE TABLE `honorary_title` (
`honor_id` int NOT NULL COMMENT '荣誉ID',
`talent_id` int NOT NULL COMMENT '人才ID',
`honor_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '荣誉称号',
`award_time` datetime NOT NULL COMMENT '授予时间',
`awarding_agency` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '授予机构',
PRIMARY KEY (`honor_id`) USING BTREE,
INDEX `talent_id`(`talent_id` ASC) USING BTREE,
CONSTRAINT `honorary_title_ibfk_1` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '13荣誉称号信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for papers_and_monographs
-- ----------------------------
DROP TABLE IF EXISTS `papers_and_monographs`;
CREATE TABLE `papers_and_monographs` (
`paper_book_id` int NOT NULL COMMENT '论文专著ID',
`talent_id` int NOT NULL COMMENT '人才ID',
`title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
`publication_time` datetime NOT NULL COMMENT '发表时间',
`journal_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '刊物名称',
`volume_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '卷号',
`issue_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '期号',
`page_range` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '页码',
`doi` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'DOI号',
`work_type` enum('论文','专著') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '著作类型',
PRIMARY KEY (`paper_book_id`) USING BTREE,
INDEX `talent_id`(`talent_id` ASC) USING BTREE,
CONSTRAINT `papers_and_monographs_ibfk_1` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '14论文专著信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for patent
-- ----------------------------
DROP TABLE IF EXISTS `patent`;
CREATE TABLE `patent` (
`patent_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '专利id',
`talent_id` int NOT NULL COMMENT '人才id',
`patent_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '专利名称',
`patent_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '专利编号',
`application_time` date NOT NULL COMMENT '申请时间',
`authorization_time` date NOT NULL COMMENT '授权时间',
PRIMARY KEY (`patent_id`) USING BTREE,
INDEX `talent_id`(`talent_id` ASC) USING BTREE,
CONSTRAINT `patent_ibfk_1` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '6专利信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for project_initiation
-- ----------------------------
DROP TABLE IF EXISTS `project_initiation`;
CREATE TABLE `project_initiation` (
`project_proposal_id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '立项项目编号',
`STIUL_id` int NOT NULL COMMENT '科室人员工号',
`project_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目名称',
`project_from` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目来源',
`project_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目类型',
`funding_from` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '资金来源组织',
`undertaking_unit` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '承担单位',
`project_person` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目负责人',
`project_account` float NULL DEFAULT NULL COMMENT '项目金额',
`start_time` date NULL DEFAULT NULL COMMENT '项目启动时间',
`end_time` date NULL DEFAULT NULL COMMENT '项目终止时间',
`project_status` enum('在研','结项验收','自然结项') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目当前状态',
`id` int NOT NULL,
PRIMARY KEY (`project_proposal_id`, `id`) USING BTREE,
INDEX `project_proposal_id`(`project_proposal_id` ASC) USING BTREE,
INDEX `department_id`(`STIUL_id` ASC) USING BTREE,
CONSTRAINT `department_id` FOREIGN KEY (`STIUL_id`) REFERENCES `department_basic` (`STIUL_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '4立项项目信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for research_project
-- ----------------------------
DROP TABLE IF EXISTS `research_project`;
CREATE TABLE `research_project` (
`project_id` int NOT NULL COMMENT '项目ID',
`TitleOriginal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目名称',
`titleEnglish` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目名称英文版',
`projectType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目类型',
`keywordOriginal` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检索关键词',
`keywordEn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检索关键词英文',
`applyAbstractOriginal` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '摘要',
`applyAbstractEn` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '摘要英文',
`Funding` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预算/财政拨款',
`Currency` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货币单位',
`FundingDollar` float NULL DEFAULT NULL COMMENT '项目金额(美元)',
`applyYear` float NULL DEFAULT NULL COMMENT '申请年份',
`planStartDate` datetime NULL DEFAULT NULL COMMENT '项目启动时间',
`planEndDate` datetime NULL DEFAULT NULL COMMENT '项目终止时间',
`PI` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目负责人',
`awardOrg` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '承担单位',
`awardOrgState` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省份',
`awardOrgCountry` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国家',
`FunderName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资金名称',
`FunderGroup` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资金来源组织',
`FunderCountry` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资金国家',
`originalOne` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学科大类（第一学科）',
`originalTwo` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学科小类',
`talent_id` int NULL DEFAULT NULL COMMENT '项目负责人id',
PRIMARY KEY (`project_id`) USING BTREE,
INDEX `id`(`talent_id` ASC) USING BTREE,
CONSTRAINT `id` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '5科研项目信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for research_project_talent
-- ----------------------------
DROP TABLE IF EXISTS `research_project_talent`;
CREATE TABLE `research_project_talent` (
`project_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '科室人员工号',
`talent_id` int NOT NULL COMMENT '人才id',
PRIMARY KEY (`project_id`) USING BTREE,
INDEX `talent_id`(`talent_id` ASC) USING BTREE,
CONSTRAINT `research_project_talent_ibfk_1` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '15科研项目人才信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for resume
-- ----------------------------
DROP TABLE IF EXISTS `resume`;
CREATE TABLE `resume` (
`resume_id` int NOT NULL COMMENT '履历ID',
`talent_id` int NOT NULL COMMENT '人才ID',
`start_time` datetime NOT NULL COMMENT '起始时间',
`end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
`unit` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在单位',
`work_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工作内容',
PRIMARY KEY (`resume_id`) USING BTREE,
INDEX `talent_id`(`talent_id` ASC) USING BTREE,
CONSTRAINT `resume_ibfk_1` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '12履历信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for review_experience
-- ----------------------------
DROP TABLE IF EXISTS `review_experience`;
CREATE TABLE `review_experience` (
`review_id` int NOT NULL COMMENT '评审id',
`talent_id` int NOT NULL COMMENT '人才id',
`review_project` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '评审项目',
`review_time` datetime NOT NULL COMMENT '评审时间',
`reviewing_agency` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '评审机构',
`review_role` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '评审角色',
PRIMARY KEY (`review_id`) USING BTREE,
INDEX `talent_id`(`talent_id` ASC) USING BTREE,
CONSTRAINT `review_experience_ibfk_1` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '8评审经历信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for talent_basic
-- ----------------------------
DROP TABLE IF EXISTS `talent_basic`;
CREATE TABLE `talent_basic` (
`talent_id` int NOT NULL COMMENT '人才id',
`name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '姓名',
`sex` enum('男','女') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '性别',
`age` int NULL DEFAULT NULL COMMENT '年龄',
`unit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '单位',
`highest_edu` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '最高学历',
`highest_school` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '最高学历毕业学校',
`Classify_grade` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '分类定级人才',
`pro` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职称',
`pro_qual` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职称等级',
`space` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '地区',
`image` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '人才图片路径',
`HTPQ` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '最高技术职务资格名称',
PRIMARY KEY (`talent_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '2人才基本信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for talent_project_initiation
-- ----------------------------
DROP TABLE IF EXISTS `talent_project_initiation`;
CREATE TABLE `talent_project_initiation` (
`talent_id` int NOT NULL,
`project_proposal_id` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
PRIMARY KEY (`talent_id`, `project_proposal_id`) USING BTREE,
INDEX `project_proposal_id`(`project_proposal_id` ASC) USING BTREE,
CONSTRAINT `talent_project_initiation_ibfk_1` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `talent_project_initiation_ibfk_2` FOREIGN KEY (`project_proposal_id`) REFERENCES `project_initiation` (`project_proposal_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '17人才立项信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for talent_report
-- ----------------------------
DROP TABLE IF EXISTS `talent_report`;
CREATE TABLE `talent_report` (
`talent_id` int NOT NULL COMMENT '人才id',
`report_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报告id',
PRIMARY KEY (`talent_id`, `report_id`) USING BTREE,
INDEX `report_id`(`report_id` ASC) USING BTREE,
CONSTRAINT `talent_report_ibfk_1` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `talent_report_ibfk_2` FOREIGN KEY (`report_id`) REFERENCES `tech_report` (`report_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '16人才报告信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for tech_report
-- ----------------------------
DROP TABLE IF EXISTS `tech_report`;
CREATE TABLE `tech_report` (
`report_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报告编号',
`project_id` int NOT NULL COMMENT '项目id',
`report_cname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报告名称(中文)',
`report_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报告名称(英文)',
`authorc` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '作者（中文）',
`author` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '作者（英文）',
`workplacec` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '作者单位(中文)',
`workplace` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '作者单位(英文)',
`keywordc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关键词（中文）',
`keyword` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关键词（英文）',
`summaryc` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '摘要（中文）',
`summary` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '摘要（英文）',
`writing_time` datetime NOT NULL COMMENT '编撰时间',
`institution` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支持机构',
`project_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '项目名称',
`report_type` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报告类型',
`channel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支持渠道',
`ispublic` enum('是','否') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '是否公开',
`report_status` enum('草稿','已发布','已撤回') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报告状态',
`report_path` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报告全文路径',
PRIMARY KEY (`report_id`) USING BTREE,
INDEX `project_id_index`(`project_id` ASC) USING BTREE,
CONSTRAINT `tech_research_p_id` FOREIGN KEY (`project_id`) REFERENCES `research_project` (`project_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '3科技报告信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for universal
-- ----------------------------
DROP TABLE IF EXISTS `universal`;
CREATE TABLE `universal` (
`created_time` datetime NOT NULL COMMENT '创建时间',
`updated_time` datetime NOT NULL COMMENT '更新时间'
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '1通用信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for work_domain
-- ----------------------------
DROP TABLE IF EXISTS `work_domain`;
CREATE TABLE `work_domain` (
`domain_id` int NOT NULL COMMENT '领域id',
`talent_id` int NOT NULL COMMENT '人才id',
`discipline_domain` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学科项目',
`industry_domain` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '行业领域',
PRIMARY KEY (`domain_id`) USING BTREE,
INDEX `talent_id`(`talent_id` ASC) USING BTREE,
CONSTRAINT `work_domain_ibfk_1` FOREIGN KEY (`talent_id`) REFERENCES `talent_basic` (`talent_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '9工作领域信息表' ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink