/* Navicat MySQL Data Transfer Source Server : ubuntu-jl Source Server Version : 50722 Source Host : 192.168.1.70:3306 Source Database : calculation Target Server Type : MYSQL Target Server Version : 50722 File Encoding : 65001 Date: 2019-06-05 10:02:57 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for zh_tender_node_template -- ---------------------------- DROP TABLE IF EXISTS `zh_tender_node_template`; CREATE TABLE `zh_tender_node_template` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id', `code` varchar(15) DEFAULT '' COMMENT '节点编号', `name` varchar(60) NOT NULL COMMENT '名称', `unit` varchar(15) DEFAULT '' COMMENT '单位', `source` varchar(30) DEFAULT '' COMMENT '图(册)号', `remark` varchar(60) DEFAULT '' COMMENT '备注', `pid` int(10) NOT NULL COMMENT '父id', `level` mediumint(5) NOT NULL COMMENT '层级', `order` mediumint(255) NOT NULL COMMENT '同级排序', `full_path` varchar(255) NOT NULL COMMENT '层级定位辅助字段parent.full_path.ledger_id', `is_leaf` tinyint(255) NOT NULL COMMENT '是否叶子节点，界面显示辅助字段', PRIMARY KEY (`id`), KEY `idx_code` (`code`) ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COMMENT='标段项目节点模板数据表'; -- ---------------------------- -- Records of zh_tender_node_template -- ---------------------------- INSERT INTO `zh_tender_node_template` VALUES ('1', '1', '第一部分 建筑安装工程费', '公路公里', '', '', '-1', '1', '1', '1', '0'); INSERT INTO `zh_tender_node_template` VALUES ('2', '1-1', '临时工程', '公路公里', '', '', '1', '2', '1', '1.2', '1'); INSERT INTO `zh_tender_node_template` VALUES ('3', '1-2', '路基工程', 'km', '', '', '1', '2', '2', '1.3', '1'); INSERT INTO `zh_tender_node_template` VALUES ('4', '1-3', '路面工程', 'km/㎡', '', '', '1', '2', '3', '1.4', '1'); INSERT INTO `zh_tender_node_template` VALUES ('5', '1-4', '桥梁涵洞工程', 'km', '', '', '1', '2', '4', '1.5', '1'); INSERT INTO `zh_tender_node_template` VALUES ('6', '1-10', '建安工程其他费用', '公路公里', '', '', '1', '2', '5', '1.6', '0'); INSERT INTO `zh_tender_node_template` VALUES ('7', '1-10-1', '其他建安工程', '项', '', '', '6', '3', '1', '1.6.7', '0'); INSERT INTO `zh_tender_node_template` VALUES ('8', '1-10-1-1', '计日工', '项', '', '', '7', '4', '1', '1.6.7.8', '0'); INSERT INTO `zh_tender_node_template` VALUES ('9', '1-10-1-1-1', '劳务', '项', '', '', '8', '5', '1', '1.6.7.8.9', '1'); INSERT INTO `zh_tender_node_template` VALUES ('10', '1-10-1-1-2', '材料', '项', '', '', '8', '5', '2', '1.6.7.8.10', '1'); INSERT INTO `zh_tender_node_template` VALUES ('11', '1-10-1-1-3', '机械', '项', '', '', '8', '5', '3', '1.6.7.8.11', '1'); INSERT INTO `zh_tender_node_template` VALUES ('12', '1-10-1-2', '工程管理专项费用', '项', '', '', '7', '4', '2', '1.6.7.12', '1'); INSERT INTO `zh_tender_node_template` VALUES ('13', '1-10-1-3', '索赔', '项', '', '', '7', '4', '3', '1.6.7.13', '1'); INSERT INTO `zh_tender_node_template` VALUES ('14', '1-10-1-4', '价差调整', '项', '', '', '7', '4', '4', '1.6.7.14', '1'); INSERT INTO `zh_tender_node_template` VALUES ('15', '1-10-1-5', '代扣代付项目增减建设成本', '项', '', '', '7', '4', '5', '1.6.7.15', '1'); INSERT INTO `zh_tender_node_template` VALUES ('16', '1-10-2', '尾工工程', '项', '', '', '6', '3', '2', '1.6.16', '1'); INSERT INTO `zh_tender_node_template` VALUES ('17', '1-10-3', '报废工程', '项', '', '', '6', '3', '3', '1.6.17', '1'); INSERT INTO `zh_tender_node_template` VALUES ('18', '2', '第二部分 设备及工具、器具购置费', '公路公里', '', '', '-1', '1', '2', '18', '0'); INSERT INTO `zh_tender_node_template` VALUES ('19', '2-1', '设备购置费', '公路公里', '', '', '18', '2', '1', '18.19', '1'); INSERT INTO `zh_tender_node_template` VALUES ('20', '2-2', '工具、器具购置', '公路公里', '', '', '18', '2', '2', '18.20', '1'); INSERT INTO `zh_tender_node_template` VALUES ('21', '2-3', '办公及生活用家具购置', '公路公里', '', '', '18', '2', '3', '18.21', '1'); INSERT INTO `zh_tender_node_template` VALUES ('22', '3', '第三部分 工程建设其他费用', '公路公里', '', '', '-1', '1', '3', '22', '0'); INSERT INTO `zh_tender_node_template` VALUES ('23', '3-1', '土地征用及拆迁补偿费', '公路公里', '', '', '22', '2', '1', '22.23', '0'); INSERT INTO `zh_tender_node_template` VALUES ('24', '3-1-1', '土地补偿费', '公路公里', '', '', '23', '3', '1', '22.23.24', '1'); INSERT INTO `zh_tender_node_template` VALUES ('25', '3-1-2', '征用耕地安置补助费', '公路公里', '', '', '23', '3', '2', '22.23.25', '1'); INSERT INTO `zh_tender_node_template` VALUES ('26', '3-1-3', '拆迁补偿费', '公路公里', '', '', '23', '3', '3', '22.23.26', '1'); INSERT INTO `zh_tender_node_template` VALUES ('27', '3-1-4', '复耕费', '公路公里', '', '', '23', '3', '4', '22.23.27', '1'); INSERT INTO `zh_tender_node_template` VALUES ('28', '3-1-5', '耕地开垦费', '公路公里', '', '', '23', '3', '5', '22.23.28', '1'); INSERT INTO `zh_tender_node_template` VALUES ('29', '3-1-6', '森林植被恢复费', '公路公里', '', '', '23', '3', '6', '22.23.29', '1'); INSERT INTO `zh_tender_node_template` VALUES ('30', '3-1-7', '其它', '公路公里', '', '', '23', '3', '7', '22.23.30', '1'); INSERT INTO `zh_tender_node_template` VALUES ('31', '3-2', '建设项目管理费', '公路公里', '', '', '22', '2', '2', '22.31', '0'); INSERT INTO `zh_tender_node_template` VALUES ('32', '3-2-1', '建设单位（业主）管理费', '公路公里', '', '', '31', '3', '1', '22.31.32', '1'); INSERT INTO `zh_tender_node_template` VALUES ('33', '3-2-2', '工程监理费', '公路公里', '', '', '31', '3', '2', '22.31.33', '1'); INSERT INTO `zh_tender_node_template` VALUES ('34', '3-2-3', '设计文件审查费', '公路公里', '', '', '31', '3', '3', '22.31.34', '1'); INSERT INTO `zh_tender_node_template` VALUES ('35', '3-2-4', '竣（交）工验收试验检测费', '公路公里', '', '', '31', '3', '4', '22.31.35', '1'); INSERT INTO `zh_tender_node_template` VALUES ('36', '3-3', '研究试验费', '公路公里', '', '', '22', '2', '3', '22.36', '1'); INSERT INTO `zh_tender_node_template` VALUES ('37', '3-4', '建设项目前期工作费', '公路公里', '', '', '22', '2', '4', '22.37', '1'); INSERT INTO `zh_tender_node_template` VALUES ('38', '3-5', '专项评价（估）费', '公路公里', '', '', '22', '2', '5', '22.38', '1'); INSERT INTO `zh_tender_node_template` VALUES ('39', '3-6', '施工机构迁移费', '公路公里', '', '', '22', '2', '6', '22.39', '1'); INSERT INTO `zh_tender_node_template` VALUES ('40', '3-7', '供电贴费', '公路公里', '', '', '22', '2', '7', '22.40', '1'); INSERT INTO `zh_tender_node_template` VALUES ('41', '3-8', '联合试运转费', '公路公里', '', '', '22', '2', '8', '22.41', '1'); INSERT INTO `zh_tender_node_template` VALUES ('42', '3-9', '生产人员培训费', '公路公里', '', '', '22', '2', '9', '22.42', '1'); INSERT INTO `zh_tender_node_template` VALUES ('43', '3-10', '固定资产投资方向调节税', '公路公里', '', '', '22', '2', '10', '22.43', '1'); INSERT INTO `zh_tender_node_template` VALUES ('44', '3-11', '建设期贷款利息', '公路公里', '', '', '22', '2', '11', '22.44', '1'); INSERT INTO `zh_tender_node_template` VALUES ('45', '', '预备费', '元', '', '', '-1', '1', '4', '45', '0'); INSERT INTO `zh_tender_node_template` VALUES ('46', '', '1.价差预备费', '元', '', '', '45', '2', '1', '45.46', '1'); INSERT INTO `zh_tender_node_template` VALUES ('47', '', '2.基本预备费', '元', '', '', '45', '2', '2', '45.47', '0'); INSERT INTO `zh_tender_node_template` VALUES ('48', '', '暂列金额(不含计日工总额)', '元', '', '', '47', '3', '1', '45.47.48', '1'); INSERT INTO `zh_tender_node_template` VALUES ('49', '', '保险费', '元', '', '', '47', '3', '2', '45.47.49', '1'); INSERT INTO `zh_tender_node_template` VALUES ('50', '', '新增加费用项目(不作预备费基数)', '元', '', '', '-1', '1', '5', '50', '0'); INSERT INTO `zh_tender_node_template` VALUES ('51', '', '*请在此输入费用项目', '', '', '', '50', '2', '1', '50.51', '1'); INSERT INTO `zh_tender_node_template` VALUES ('52', '', '其中：回收金额', '元', '', '', '-1', '1', '6', '52', '0'); INSERT INTO `zh_tender_node_template` VALUES ('53', '', '*请在此输入费用项目', '', '', '', '52', '2', '1', '52.53', '1');