142 lines
11 KiB
SQL
142 lines
11 KiB
SQL
-- 外协比例
|
|
alter table bus_completion_confirmation add column outsourcing_proportion varchar(1000) comment '外协比例' default '';
|
|
|
|
alter table bus_project_type_dict_item add column xh int comment '序号' default 0;
|
|
|
|
CREATE TABLE `bus_contract_gjch` (
|
|
`id` varchar(60) NOT NULL COMMENT '主键',
|
|
`project_id` varchar(60) DEFAULT NULL COMMENT '项目id',
|
|
`name` varchar(500) DEFAULT NULL COMMENT '关键技术名称',
|
|
`zbmc` varchar(500) DEFAULT NULL COMMENT '指标',
|
|
`zbyzfs` varchar(500) DEFAULT NULL COMMENT '指标验证方式',
|
|
`yffs` varchar(500) DEFAULT NULL COMMENT '研发方式',
|
|
`note` longtext COMMENT '备注',
|
|
`department_code` varchar(500) DEFAULT NULL COMMENT '部门code',
|
|
`create_user` varchar(60) DEFAULT NULL COMMENT '创建人',
|
|
`create_time` varchar(60) DEFAULT NULL COMMENT '创建时间',
|
|
`update_user` varchar(60) DEFAULT NULL COMMENT '修改人',
|
|
`update_time` varchar(60) DEFAULT NULL COMMENT '修改时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='关键技术策划';
|
|
|
|
CREATE TABLE `bus_contract_zscq` (
|
|
`id` varchar(60) NOT NULL COMMENT '主键',
|
|
`project_id` varchar(60) DEFAULT NULL COMMENT '项目id',
|
|
`name` varchar(500) DEFAULT NULL COMMENT '类别',
|
|
`zscqname` varchar(500) DEFAULT NULL COMMENT '成果/知识产权名称',
|
|
`djsj` varchar(500) DEFAULT NULL COMMENT '申报或登记时间',
|
|
`note` longtext COMMENT '备注',
|
|
`department_code` varchar(500) DEFAULT NULL COMMENT '部门code',
|
|
`create_user` varchar(60) DEFAULT NULL COMMENT '创建人',
|
|
`create_time` varchar(60) DEFAULT NULL COMMENT '创建时间',
|
|
`update_user` varchar(60) DEFAULT NULL COMMENT '修改人',
|
|
`update_time` varchar(60) DEFAULT NULL COMMENT '修改时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='成果与知识产权策划';
|
|
|
|
|
|
CREATE TABLE `bus_aqfxqd` (
|
|
`id` varchar(60) NOT NULL COMMENT '主键',
|
|
`project_id` varchar(60) DEFAULT NULL COMMENT '项目id',
|
|
`name` varchar(500) DEFAULT NULL COMMENT '作业活动',
|
|
`weizhi_name` varchar(500) DEFAULT NULL COMMENT '地点/场所/位置',
|
|
`fxks` varchar(500) DEFAULT NULL COMMENT '风险描述',
|
|
`kndzsglx` varchar(500) DEFAULT NULL COMMENT '可能导致的事故类型',
|
|
`ydcs` varchar(500) DEFAULT NULL COMMENT '应对措施',
|
|
`zrr_name` varchar(500) DEFAULT NULL COMMENT '责任人',
|
|
`note` longtext COMMENT '备注',
|
|
`department_code` varchar(500) DEFAULT NULL COMMENT '部门code',
|
|
`create_user` varchar(60) DEFAULT NULL COMMENT '创建人',
|
|
`create_time` varchar(60) DEFAULT NULL COMMENT '创建时间',
|
|
`update_user` varchar(60) DEFAULT NULL COMMENT '修改人',
|
|
`update_time` varchar(60) DEFAULT NULL COMMENT '修改时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='安全风险清单';
|
|
|
|
CREATE TABLE `bus_implement_zybzch` (
|
|
`id` varchar(60) NOT NULL COMMENT '主键',
|
|
`project_id` varchar(60) DEFAULT NULL COMMENT '项目id',
|
|
`zybzch` longtext COMMENT '资源保障策划',
|
|
`department_code` varchar(500) DEFAULT NULL COMMENT '部门code',
|
|
`create_user` varchar(60) DEFAULT NULL COMMENT '创建人',
|
|
`create_time` varchar(60) DEFAULT NULL COMMENT '创建时间',
|
|
`update_user` varchar(60) DEFAULT NULL COMMENT '修改人',
|
|
`update_time` varchar(60) DEFAULT NULL COMMENT '修改时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='资源保障策划';
|
|
|
|
|
|
|
|
|
|
|
|
DROP TABLE IF EXISTS `bus_project_type_dict`;
|
|
CREATE TABLE `bus_project_type_dict` (
|
|
`id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
|
|
`dict_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典名称',
|
|
`dict_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典编码',
|
|
`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
|
|
`xh` int(11) NULL DEFAULT NULL COMMENT '序号',
|
|
`del_flag` int(11) NULL DEFAULT NULL COMMENT '删除状态',
|
|
`create_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
|
`create_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
|
|
`update_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目类型字典' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of bus_project_type_dict
|
|
-- ----------------------------
|
|
INSERT INTO `bus_project_type_dict` VALUES ('1637439892318306305', '技术服务', 'jsfw', '', 1, 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:04:27', NULL, NULL);
|
|
INSERT INTO `bus_project_type_dict` VALUES ('1637439950220673025', '等级修改', 'djxl', '', 2, 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:04:40', NULL, NULL);
|
|
INSERT INTO `bus_project_type_dict` VALUES ('1637440048027648002', '综合保障', 'zhbz', '', 3, 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:05:04', NULL, NULL);
|
|
INSERT INTO `bus_project_type_dict` VALUES ('1637440148770635778', '装备生产', 'zbsc', '', 4, 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:05:28', NULL, NULL);
|
|
INSERT INTO `bus_project_type_dict` VALUES ('1637440249819807745', '科研开发', 'kykf_code', '', 5, 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:05:52', NULL, NULL);
|
|
INSERT INTO `bus_project_type_dict` VALUES ('1637440348864102402', '民品项目', 'mpxm_code', '', 6, 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:06:15', NULL, NULL);
|
|
INSERT INTO `bus_project_type_dict` VALUES ('1637440424466432002', '其他', 'other_xm', '', 7, 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:06:34', NULL, NULL);
|
|
|
|
-- ----------------------------
|
|
-- Table structure for bus_project_type_dict_item
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `bus_project_type_dict_item`;
|
|
CREATE TABLE `bus_project_type_dict_item` (
|
|
`id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
|
|
`project_type_dict_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目类型字典code',
|
|
`dict_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典名称',
|
|
`dict_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典编码',
|
|
`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
|
|
`del_flag` int(11) NULL DEFAULT NULL COMMENT '删除状态',
|
|
`create_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
|
`create_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
|
|
`update_user` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
|
|
`update_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新时间',
|
|
`xh` int(11) NULL DEFAULT 0 COMMENT '序号',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目类型字典明细' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of bus_project_type_dict_item
|
|
-- ----------------------------
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637440672307855361', 'jsfw', '新船交付', 'xcjf', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:07:33', 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:12:41', 0);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637442274477387777', 'jsfw', '首套', 'shoutao_code', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:13:55', NULL, NULL, 1);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637442387933310977', 'jsfw', '后续', 'houxu_code', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:14:22', NULL, NULL, 2);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637442476848361474', 'jsfw', '加改装', 'jia_gz', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:14:43', NULL, NULL, 3);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637442578799308801', 'djxl', '一级', 'one_level', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:15:07', NULL, NULL, 0);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637442623539949570', 'djxl', '二级', 'tow_level', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:15:18', NULL, NULL, 1);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637442683627548674', 'djxl', '三级', 'three_level', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:15:32', NULL, NULL, 2);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637442807174967297', 'zhbz', '临抢修', 'ls_qx_code', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:16:02', NULL, NULL, 0);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637442917191561217', 'zbsc', '首套', 'shoutao_code_sc', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:16:28', NULL, NULL, 0);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637442994601635842', 'zbsc', '后续', 'houxu_code_sc', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:16:46', NULL, NULL, 1);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637443182288351234', 'kykf_code', '技术开发', 'jskf_one', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:17:31', NULL, NULL, 0);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637443246318596098', 'kykf_code', '辅助科研', 'fzky', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:17:46', NULL, NULL, 1);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637443335778906114', 'kykf_code', '预先研究', 'yxyj_code', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:18:08', NULL, NULL, 2);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637443498824085506', 'kykf_code', '国拨资产', 'gbzc_code', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:18:47', NULL, NULL, 3);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637443566004252673', 'kykf_code', '自筹', 'zc_code', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:19:03', NULL, NULL, 4);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637443656810934273', 'kykf_code', '其他', 'qt_one_code', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:19:24', NULL, NULL, 5);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637443771898441729', 'mpxm_code', '民品订购', 'mpdg_code', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:19:52', NULL, NULL, 0);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637443858351435778', 'mpxm_code', '民品服务', 'mpfw_code', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:20:12', NULL, NULL, 1);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637443947610419202', 'mpxm_code', '民品研制', 'mpyz_code', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:20:34', NULL, NULL, 2);
|
|
INSERT INTO `bus_project_type_dict_item` VALUES ('1637444049674612737', 'mpxm_code', '军民融合', 'jmrh_code', '', 0, 'e9ca23d68d884d4ebb19d07889727dae', '2023-03-19 21:20:58', NULL, NULL, 3);
|
|
|
|
|