1.sql 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. DROP TABLE IF EXISTS `monitoring_indicator`;
  2. CREATE TABLE `monitoring_indicator` (
  3. `id` int(20) NOT NULL AUTO_INCREMENT,
  4. `alarm_amount` decimal(18,0) NOT NULL DEFAULT '0' COMMENT '报警金额',
  5. `limit_amount` decimal(18,0) NOT NULL DEFAULT '0' COMMENT '限制金额',
  6. `sub_type` varchar(2) DEFAULT NULL,
  7. PRIMARY KEY (`id`)
  8. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='风险监控';
  9. DROP TABLE IF EXISTS `sys_dept_sub`;
  10. CREATE TABLE `sys_dept_sub` (
  11. `sub_id` int(11) NOT NULL AUTO_INCREMENT,
  12. `dept_id` int(20) NOT NULL,
  13. `subject_type` varchar(2) NOT NULL DEFAULT '0' COMMENT '认证方式0-人力家 1-税邦云',
  14. `app_id` varchar(32) DEFAULT NULL,
  15. `app_secret` varchar(64) DEFAULT NULL,
  16. `rsa_public_key` varchar(255) DEFAULT NULL,
  17. `query_url` varchar(255) DEFAULT NULL,
  18. `subject_name` varchar(128) DEFAULT NULL COMMENT '结算主体',
  19. `limit_amount` decimal(18,2) DEFAULT NULL,
  20. `enable_flag` varchar(2) DEFAULT '0',
  21. PRIMARY KEY (`sub_id`)
  22. ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COMMENT='部门结算主体管理';
  23. DROP TABLE IF EXISTS `wm_dept_budget`;
  24. CREATE TABLE `wm_dept_budget` (
  25. `id` int(11) NOT NULL AUTO_INCREMENT,
  26. `dept_id` int(11) DEFAULT NULL COMMENT '所属机构',
  27. `belong_date` varchar(20) DEFAULT NULL COMMENT '预算月份',
  28. `declare_dept` varchar(255) DEFAULT NULL COMMENT '申报机构',
  29. `budget_type` varchar(2) DEFAULT NULL COMMENT '预算类型',
  30. `budget` int(20) DEFAULT NULL COMMENT '预算值',
  31. `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  32. PRIMARY KEY (`id`)
  33. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='预算管理';