cnbg-be/db/v2121.4.16/1.sql

DROP TABLE IF EXISTS `monitoring_indicator`;
CREATE TABLE `monitoring_indicator` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `alarm_amount` decimal(18,0) NOT NULL DEFAULT '0' COMMENT '报警金额',
  `limit_amount` decimal(18,0) NOT NULL DEFAULT '0' COMMENT '限制金额',
  `sub_type` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='风险监控';


DROP TABLE IF EXISTS `sys_dept_sub`;
CREATE TABLE `sys_dept_sub` (
  `sub_id` int(11) NOT NULL AUTO_INCREMENT,
  `dept_id` int(20) NOT NULL,
  `subject_type` varchar(2) NOT NULL DEFAULT '0' COMMENT '认证方式0-人力家 1-税邦云',
  `app_id` varchar(32) DEFAULT NULL,
  `app_secret` varchar(64) DEFAULT NULL,
  `rsa_public_key` varchar(255) DEFAULT NULL,
  `query_url` varchar(255) DEFAULT NULL,
  `subject_name` varchar(128) DEFAULT NULL COMMENT '结算主体',
  `limit_amount` decimal(18,2) DEFAULT NULL,
  `enable_flag` varchar(2) DEFAULT '0',
  PRIMARY KEY (`sub_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COMMENT='部门结算主体管理';

DROP TABLE IF EXISTS `wm_dept_budget`;
CREATE TABLE `wm_dept_budget` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dept_id` int(11) DEFAULT NULL COMMENT '所属机构',
  `belong_date` varchar(20) DEFAULT NULL COMMENT '预算月份',
  `declare_dept` varchar(255) DEFAULT NULL COMMENT '申报机构',
  `budget_type` varchar(2) DEFAULT NULL COMMENT '预算类型',
  `budget` int(20) DEFAULT NULL COMMENT '预算值',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='预算管理';