12345678910111213141516171819202122232425262728293031323334 |
- ALTER TABLE `zh_budget_std`
- ADD COLUMN `zb_chapter_id` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '招标-项目节-id列表(\',\'分隔)' AFTER `in_time`,
- ADD COLUMN `zb_template_id` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '招标-新建模板-id列表(\',\'分隔)' AFTER `zb_chapter_id`,
- ADD COLUMN `zb_bills_id` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '招标-工程量清单-id列表(\',\'分隔)' AFTER `zb_template_id`;
- CREATE TABLE `zh_budget_zb` (
- `id` varchar(36) NOT NULL COMMENT 'uuid',
- `bid` int(10) NOT NULL COMMENT '概算投资项目id',
- `tree_id` int(10) NOT NULL COMMENT '节点id',
- `tree_pid` int(10) NOT NULL COMMENT '父节点id',
- `level` tinyint(4) NOT NULL COMMENT '层级',
- `order` mediumint(4) NOT NULL DEFAULT '0' COMMENT '同级排序',
- `full_path` varchar(255) DEFAULT '' COMMENT '层级定位辅助字段parent.full_path-tree_id',
- `is_leaf` tinyint(1) NOT NULL COMMENT '是否叶子节点,界面显示辅助字段',
- `code` varchar(50) DEFAULT '' COMMENT '节点编号',
- `b_code` varchar(50) DEFAULT NULL,
- `name` varchar(255) DEFAULT NULL COMMENT '名称',
- `unit` varchar(15) DEFAULT '' COMMENT '单位',
- `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
- `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
- `total_price` decimal(24,8) DEFAULT '0.00000000' COMMENT '金额',
- `dgn_qty1` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '设计数量1',
- `dgn_qty2` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '设计数量2',
- `drawing_code` varchar(255) DEFAULT NULL COMMENT '图册号',
- `memo` varchar(1000) DEFAULT '' COMMENT '备注',
- `node_type` int(4) unsigned DEFAULT '0' COMMENT '节点类别',
- `source` varchar(30) DEFAULT '' COMMENT '添加源',
- `remark` varchar(60) DEFAULT '' COMMENT '备注',
- PRIMARY KEY (`id`),
- KEY `idx_bid` (`bid`),
- KEY `idx_tree_pid` (`tree_pid`),
- KEY `idx_level` (`level`),
- KEY `idx_full_path` (`bid`,`full_path`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='招标预算数据';
|