123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373 |
- ALTER TABLE `zh_rpt_tree_node_cust`
- ADD COLUMN `tender_id` INT NULL DEFAULT -1 COMMENT '新需求,跟标段走,不跟客户走' AFTER `cust_acc_id`,
- ADD INDEX `tender` (`tender_id` ASC);
- ;
- CREATE TABLE `zh_stage_yjcl` (
- `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- `uuid` varchar(36) NOT NULL DEFAULT '' COMMENT 'uuid',
- `add_sid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '新增期id',
- `add_sorder` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '新增期序号',
- `add_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建人id',
- `tid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '标段id',
- `sid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '期id',
- `sorder` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '期序号',
- `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
- `m_order` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
- `spec` varchar(255) NOT NULL DEFAULT '' COMMENT '规格型号',
- `unit` varchar(20) NOT NULL DEFAULT '' COMMENT '单位',
- `tax` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '税率',
- `arrive_time` varchar(50) NOT NULL DEFAULT '' COMMENT '到场时间',
- `source` varchar(255) NOT NULL DEFAULT '' COMMENT '材料来源',
- `bills_code` varchar(255) NOT NULL DEFAULT '' COMMENT '单据号',
- `location` varchar(50) NOT NULL DEFAULT '' COMMENT '存放位置',
- `prepare_pos` varchar(255) NOT NULL DEFAULT '' COMMENT '拟用于部位',
- `memo` varchar(1000) NOT NULL DEFAULT '' COMMENT '备注',
- `arrive_qty` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '到场数量',
- `arrive_tp` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '到场金额',
- `unit_price` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '单价',
- `ex_tax_up` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '除税单价',
- `qty` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '本期数量',
- `tp` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '本期金额',
- `pre_qty` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '截止上期数量',
- `pre_tp` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '截止上期金额',
- `pre_used` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上期是否使用',
- `shistory` text NULL COMMENT '审批历史',
- PRIMARY KEY (`id`)
- );
- ALTER TABLE `zh_budget_std`
- ADD COLUMN `ht_project_template_id` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '合同-项目合同模版-id列表(‘,’分隔)' AFTER `zb_bills_id`,
- ADD COLUMN `ht_tender_template_id` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '合同-标段合同模版-id列表(‘,’分隔)' AFTER `ht_project_template_id`;
- ALTER TABLE `zh_shenpi_audit`
- ADD COLUMN `audit_ledger_id` varchar(5000) NOT NULL DEFAULT '' COMMENT '审批台账id' AFTER `audit_order`;
- ALTER TABLE `zh_stage_audit`
- ADD COLUMN `audit_ledger_id` varchar(5000) NOT NULL DEFAULT '' COMMENT '审批台账id' AFTER `audit_order`,
- ADD COLUMN `audit_locked` tinyint(1) NOT NULL DEFAULT 0 COMMENT '审批锁定(仅协审用)' AFTER `audit_ledger_id`;
- ALTER TABLE `zh_ledger_audit`
- ADD COLUMN `audit_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '审批类型' AFTER `audit_order`,
- ADD COLUMN `audit_ledger_id` varchar(5000) NOT NULL DEFAULT '' COMMENT '审批台账id' AFTER `audit_id`;
- ALTER TABLE `zh_revise_audit`
- ADD COLUMN `audit_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '审批类型' AFTER `audit_order`,
- ADD COLUMN `audit_ledger_id` varchar(5000) NOT NULL DEFAULT '' COMMENT '审批台账id' AFTER `audit_type`;
- ALTER TABLE `zh_tender_cache`
- MODIFY COLUMN `ledger_flow_cur_uid` varchar(1000) NOT NULL DEFAULT '0' COMMENT '台账-当前流程人id' AFTER `ledger_status`,
- MODIFY COLUMN `ledger_flow_pre_uid` varchar(1000) NOT NULL DEFAULT '0' COMMENT '台账-上一流程人id' AFTER `ledger_flow_cur_info`;
- CREATE TABLE `zh_contract_tree` (
- `id` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '自增id',
- `spid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '项目id',
- `tid` int(11) DEFAULT NULL COMMENT '标段id',
- `contract_type` tinyint(1) NOT NULL COMMENT '合同类型(1是支出,2是收入)',
- `contract_id` int(11) NOT NULL COMMENT '节点id',
- `contract_pid` int(11) NOT NULL COMMENT '父节点id',
- `level` tinyint(4) NOT NULL COMMENT '层级',
- `order` mediumint(4) NOT NULL DEFAULT '0' COMMENT '同级排序',
- `full_path` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '层级定位辅助字段parent.full_path.contract_id',
- `is_leaf` tinyint(1) NOT NULL COMMENT '是否叶子节点,界面显示辅助字段',
- `code` varchar(50) CHARACTER SET utf8 DEFAULT '' COMMENT '节点编号',
- `name` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '名称',
- `unit` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '单位',
- `remark` varchar(1000) CHARACTER SET utf8 DEFAULT '' COMMENT '备注',
- PRIMARY KEY (`id`),
- KEY `sub_id` (`spid`),
- KEY `tid` (`tid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT = '合同管理树结构表';
- CREATE TABLE `zh_contract` (
- `id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
- `spid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '项目id',
- `tid` int(11) DEFAULT NULL COMMENT '标段id',
- `contract_type` tinyint(1) DEFAULT NULL COMMENT '合同类型(1是支出,2是收入)',
- `uid` int(11) DEFAULT NULL COMMENT '创建人id',
- `contract_id` int(11) NOT NULL COMMENT '节点id',
- `contract_pid` int(11) NOT NULL COMMENT '父节点id',
- `level` tinyint(4) NOT NULL COMMENT '层级',
- `is_leaf` tinyint(1) DEFAULT '1' COMMENT '是否是子节点',
- `order` mediumint(4) NOT NULL DEFAULT '0' COMMENT '同级排序',
- `full_path` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '层级定位辅助字段parent.full_path.contract_id',
- `c_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '合同编号',
- `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '合同名称',
- `total_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '合同金额',
- `pay_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '累计支付(回款)金额',
- `debit_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '累计扣款金额',
- `yf_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '累计应付(应回)金额',
- `sf_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '累计已付(已回)金额',
- `party_a` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '甲方',
- `party_a_user` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '甲方签约人',
- `party_b` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '乙方',
- `party_b_user` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '乙方签约人',
- `sign_date` datetime DEFAULT NULL COMMENT '签订日期',
- `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '签约地点',
- `entity` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '单位',
- `bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '开户行',
- `bank_account` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '收款账号',
- `settle_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '结算书编号',
- `remark` varchar(1000) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '备注',
- `exist_pay` tinyint(1) DEFAULT '0' COMMENT '是否存在合同支付(回款)',
- `create_time` datetime DEFAULT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='合同详情表';
- CREATE TABLE `zh_contract_pay` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '项目id',
- `tid` int(11) DEFAULT NULL COMMENT '标段id',
- `contract_type` tinyint(1) NOT NULL COMMENT '合同类型(1是支出,2是收入)',
- `cid` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '合同详情id',
- `uid` int(11) DEFAULT NULL COMMENT '创建人id',
- `pay_time` datetime DEFAULT NULL COMMENT '支付日期',
- `pay_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '付款金额',
- `debit_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '扣款金额',
- `yf_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '应付(回)金额',
- `sf_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '实付金额',
- `pay_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '支付方式',
- `remark` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
- `create_time` datetime DEFAULT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT = '合同支付表';
- CREATE TABLE `zh_contract_pay_attachment` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '项目id',
- `tid` int(11) DEFAULT NULL COMMENT '标段id',
- `contract_type` tinyint(1) NOT NULL COMMENT '合同类型(1是支出,2是收入)',
- `cid` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '合同详情id',
- `cpid` int(11) NOT NULL COMMENT '合同支付id',
- `uid` int(11) NOT NULL COMMENT '上传者id',
- `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
- `fileext` varchar(5) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
- `filesize` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
- `filepath` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
- `upload_time` datetime NOT NULL COMMENT '上传时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `idx_cid` (`cpid`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '合同支付附件表';
- CREATE TABLE `zh_contract_attachment` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '项目id',
- `tid` int(11) DEFAULT NULL COMMENT '标段id',
- `contract_type` tinyint(1) NOT NULL COMMENT '合同类型(1是支出,2是收入)',
- `cid` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '合同详情id',
- `uid` int(11) NOT NULL COMMENT '上传者id',
- `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
- `fileext` varchar(5) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
- `filesize` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
- `filepath` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
- `upload_time` datetime NOT NULL COMMENT '上传时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `idx_cid` (`cid`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '合同文件表';
- CREATE TABLE `zh_contract_audit` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '项目id',
- `tid` int(11) DEFAULT NULL COMMENT '标段id',
- `uid` int(11) NOT NULL COMMENT '用户id',
- `permission_add` tinyint(1) DEFAULT '0' COMMENT '添加合同权限',
- `permission_edit` tinyint(1) DEFAULT '0' COMMENT '编辑节点权限',
- `permission_show_unit` tinyint(1) DEFAULT '0' COMMENT '查看该节点下同单位下合同权限',
- `permission_show_node` tinyint(1) DEFAULT '0' COMMENT '查看该节点下所有合同权限',
- `create_time` datetime DEFAULT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '合同权限用户表';
- CREATE TABLE `zh_contract_tree_audit` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '项目id',
- `tid` int(11) DEFAULT NULL COMMENT '标段id',
- `contract_type` tinyint(1) DEFAULT NULL COMMENT '合同类型(1是支出,2是收入)',
- `contract_id` int(11) DEFAULT NULL COMMENT '节点id',
- `uid` int(11) DEFAULT NULL COMMENT '节点授权人id',
- `create_time` datetime DEFAULT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '合同节点授权用户表';
- CREATE TABLE `zh_financial_audit` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '项目id',
- `uid` int(11) NOT NULL COMMENT '用户id',
- `permission_transfer_show` tinyint(1) DEFAULT '1' COMMENT '查看划拨权限',
- `permission_transfer_add` tinyint(1) DEFAULT '0' COMMENT '添加划拨权限',
- `permission_transfer_file` tinyint(1) DEFAULT '0' COMMENT '划拨文件权限',
- `permission_pay_show` tinyint(1) DEFAULT '1' COMMENT '查看支付权限',
- `permission_pay_file` tinyint(1) DEFAULT '0' COMMENT '支付文件权限',
- `create_time` datetime DEFAULT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资金监管权限用户表';
- CREATE TABLE `zh_financial_pay` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '项目id',
- `tid` int(11) NOT NULL COMMENT '标段id',
- `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '支付编号',
- `create_time` datetime DEFAULT NULL COMMENT '申请时间',
- `uid` int(11) DEFAULT NULL COMMENT '申请人',
- `used` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资金用途',
- `total_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '支付金额',
- `small_expenses_tp` decimal(30,8) DEFAULT '0.00000000' COMMENT '小额支出支付金额',
- `times` tinyint(3) DEFAULT '1' COMMENT '次数',
- `status` tinyint(2) DEFAULT NULL COMMENT '审批状态',
- `entity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '申请支付单位',
- `bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '单位开户行',
- `bank_account` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '支付账号',
- `remark` text COLLATE utf8_unicode_ci COMMENT '备注',
- `final_auditor_str` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
- `entities` varchar(5000) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '收款单位',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资金支付表';
- CREATE TABLE `zh_financial_pay_attachment` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '项目id',
- `fpid` int(11) NOT NULL COMMENT '申请支付id',
- `fpcid` int(11) DEFAULT NULL COMMENT '支付明细id',
- `uid` int(11) NOT NULL COMMENT '上传者id',
- `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
- `fileext` varchar(5) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
- `filesize` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
- `filepath` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
- `upload_time` datetime NOT NULL COMMENT '上传时间',
- `type` tinyint(1) DEFAULT '0' COMMENT '文件类型(0为普通,1为发票)',
- `bill` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '发票号',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `idx_trid` (`fpid`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资金支付文件表';
- CREATE TABLE `zh_financial_pay_audit` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `spid` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '项目id',
- `tid` int(11) NOT NULL COMMENT '标段id',
- `fpid` int(11) NOT NULL COMMENT '资金支付id',
- `aid` int(11) NOT NULL COMMENT '审批人id',
- `order` int(11) NOT NULL COMMENT '审批顺序',
- `times` int(11) NOT NULL DEFAULT '1' COMMENT '审批次数',
- `status` int(1) NOT NULL COMMENT '审批状态',
- `begin_time` datetime DEFAULT NULL COMMENT '开始审批时间',
- `end_time` datetime DEFAULT NULL COMMENT '结束审批时间',
- `opinion` varchar(1000) CHARACTER SET utf8 DEFAULT NULL COMMENT '审批意见',
- `audit_type` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '审批类型(1个人,2会签,3或签)',
- `audit_order` tinyint(4) unsigned NOT NULL COMMENT '审批顺序',
- PRIMARY KEY (`id`),
- KEY `idx_sid_order_times` (`fpid`,`order`,`times`),
- KEY `idx_sid_status_aid_order_times` (`fpid`,`status`,`aid`,`order`,`times`),
- KEY `idx_sid_times_status` (`fpid`,`times`,`status`),
- KEY `idx_tid_aid` (`tid`,`aid`),
- KEY `idx_sid_times_aid` (`fpid`,`times`,`aid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资金支付审批表';
- CREATE TABLE `zh_financial_pay_contract` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '项目id',
- `tid` int(11) DEFAULT NULL COMMENT '标段id',
- `fpid` int(11) DEFAULT NULL COMMENT '申请支付id',
- `cid` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '合同id',
- `c_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '合同编号',
- `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '合同名称',
- `total_price` decimal(30,8) DEFAULT NULL COMMENT '合同金额',
- `entity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '收款单位',
- `bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '开户行',
- `bank_account` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '开户行账号',
- `small_expenses` tinyint(1) DEFAULT '0' COMMENT '是否小额支出',
- `pay_price` decimal(30,8) DEFAULT NULL COMMENT '支付金额',
- `settle_price` decimal(30,8) DEFAULT NULL COMMENT '结算金额',
- `pay_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '支付方式',
- `bill` tinyint(1) DEFAULT '0' COMMENT '是否需要发票',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资金支付明细表';
- CREATE TABLE `zh_financial_pay_tender` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '项目id',
- `tid` int(11) NOT NULL COMMENT '标段id',
- `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '开户名称',
- `bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '开户银行',
- `bank_account` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '开户账号',
- `contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系人',
- `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '联系电话',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资金支付标段数据表';
- CREATE TABLE `zh_financial_pay_tender_audit` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '项目id',
- `tid` int(11) NOT NULL COMMENT '标段id',
- `uid` int(11) NOT NULL COMMENT '用户id',
- `is_report` tinyint(1) DEFAULT '0' COMMENT '是否为填报人',
- `create_time` datetime DEFAULT NULL COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资金支付标段人员权限表';
- CREATE TABLE `zh_financial_transfer` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '项目id',
- `t_time` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '划拨年月',
- `total_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '划拨金额',
- `uid` int(11) NOT NULL COMMENT '填报人',
- `is_lock` tinyint(1) DEFAULT '0' COMMENT '是否已锁定',
- `create_time` datetime DEFAULT NULL COMMENT '创建时间',
- `remark` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资金划拨表';
- CREATE TABLE `zh_financial_transfer_attachment` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '项目id',
- `trid` int(11) NOT NULL COMMENT '划拨年月id',
- `uid` int(11) NOT NULL COMMENT '上传者id',
- `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
- `fileext` varchar(5) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
- `filesize` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
- `filepath` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
- `upload_time` datetime NOT NULL COMMENT '上传时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `idx_trid` (`trid`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资金划拨文件表';
- CREATE TABLE `zh_financial_transfer_tender` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '项目id',
- `trid` int(11) NOT NULL COMMENT '资金划拨id',
- `tid` int(11) NOT NULL COMMENT '标段id',
- `sorder` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '期数,以逗号分隔',
- `uid` int(11) NOT NULL COMMENT '创建人id',
- `is_lock` tinyint(1) DEFAULT '0' COMMENT '是否锁定',
- `total_price` decimal(30,8) DEFAULT '0.00000000' COMMENT '合同金额',
- `contract_tp` decimal(30,8) DEFAULT '0.00000000' COMMENT '本期合同计量',
- `qc_tp` decimal(30,8) DEFAULT '0.00000000' COMMENT '本期数量变更计量',
- `pc_tp` decimal(30,8) DEFAULT '0.00000000' COMMENT '本期补差',
- `yf_tp` decimal(30,8) DEFAULT '0.00000000' COMMENT '本期应付',
- `sf_tp` decimal(30,8) DEFAULT '0.00000000' COMMENT '本期实付',
- `hb_tp` decimal(30,8) DEFAULT '0.00000000' COMMENT '本期划拨',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资金划拨标段表';
- CREATE TABLE `zh_financial_transfer_tender_attachment` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `spid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '项目id',
- `trid` int(11) NOT NULL COMMENT '划拨年月id',
- `ftid` int(11) NOT NULL COMMENT '划拨标段id',
- `uid` int(11) NOT NULL COMMENT '上传者id',
- `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
- `fileext` varchar(5) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
- `filesize` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
- `filepath` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
- `upload_time` datetime NOT NULL COMMENT '上传时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `idx_trid` (`trid`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='资金划拨文件表';
- ALTER TABLE `zh_account_cert`
- ADD COLUMN `cert_type` varchar(255) NULL DEFAULT '' COMMENT '证书分类字符' AFTER `type`,
- ADD COLUMN `cert_name` varchar(255) NULL DEFAULT '' COMMENT '证书名称字符' AFTER `name`;
- -- update请放在最后
- Update zh_filing_template SET is_fixed = 1 WHERE tree_level = 1;
|