luminghui
/
itax-admin-lxzy
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
8 Commits
1 Branch
0 Tags
3.5 MiB
 
 
Tag: Branch: Tree: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
itax-admin-lxzy/itax-configuration/v7.0.0.4/sql/bigb_itax_base_structure.sql

1098 lines
91 KiB
Raw Permalink Blame History

/*
Navicat Premium Data Transfer
Source Server : 10.1.1.109-企业名片
Source Server Type : MySQL
Source Server Version : 50634
Source Host : 10.1.1.109:3306
Source Schema : itax_base
Target Server Type : MySQL
Target Server Version : 50634
File Encoding : 65001
Date: 18/04/2023 17:09:10
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for all_dept_data
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`all_dept_data`;
CREATE TABLE `itax_base`. `all_dept_data` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`group_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端集团名称',
`dept_data` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '客户组织数据',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '数据更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for area_code
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`area_code`;
CREATE TABLE `itax_base`. `area_code` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`area_code` int(3) NULL DEFAULT NULL COMMENT '地区编码',
`area_name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地区名称',
`remark` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`area_region` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地区代码基础信息表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for count_item_config
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`count_item_config`;
CREATE TABLE `itax_base`. `count_item_config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`item_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '统计项名称',
`business_des` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务描述',
`relation_menu` int(20) NULL DEFAULT NULL COMMENT '关联菜单ID',
`menu_type` tinyint(10) NULL DEFAULT NULL COMMENT '统计项类型,添加时手动配置 1本月开票量2税盘余票3销项金额4销项税额5异常税务指标6申报任务7今日采集发票8今日签收发票9今日认证发票10已缴税额11进项发票税额12签收发票税额13未打印发票14三个月后认证预期发票',
`show` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否展示0展示，1隐藏',
`count_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '统计数值接口url',
`detail_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '统计详情接口url',
`sort` int(11) NULL DEFAULT NULL COMMENT '图片顺序以10为单位递增',
`img_data` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '图片',
`update_time` datetime(0) NULL DEFAULT NULL,
`item_label` int(10) NULL DEFAULT NULL COMMENT '统计项标签;1-进项、2-销项、3-全税',
`show_sum` int(2) NULL DEFAULT NULL COMMENT '是否展示汇总页面0展示，1隐藏',
`label_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标识名称',
`count_item_type` int(10) NULL DEFAULT NULL COMMENT '统计项类型 0数据类统计指标；1异常类统计指标',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '统计项配置表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_business
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_business`;
CREATE TABLE `itax_base`. `flow_business` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`menu_id` int(20) NULL DEFAULT NULL COMMENT '业务系统ID',
`business_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`approval_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '审批业务key',
`del_flag` int(11) NULL DEFAULT NULL COMMENT '启用状态：1:启用,2:未启用',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 154 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流审批业务表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_deploy
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_deploy`;
CREATE TABLE `itax_base`. `flow_deploy` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`dept_id` bigint(20) NULL DEFAULT NULL,
`approval_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`flow_id` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流部署表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_dept
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_dept`;
CREATE TABLE `itax_base`. `flow_dept` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`flow_id` bigint(20) NOT NULL COMMENT '流程ID',
`dept_id` bigint(20) NOT NULL COMMENT '适用企业ID',
`approval_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '审批业务key',
`version` int(11) NOT NULL COMMENT '版本号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 335 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流组织绑定表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_hi_task
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_hi_task`;
CREATE TABLE `itax_base`. `flow_hi_task` (
`task_id` bigint(20) NOT NULL COMMENT '节点任务ID',
`flow_pr_id` bigint(20) NULL DEFAULT NULL COMMENT '流程执行ID',
`node_id` bigint(20) NULL DEFAULT NULL COMMENT '节点ID',
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '审批人ID',
`approval_status` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批状态:Y:同意，N:拒绝，S:审批中',
`approval_opinion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批意见',
`start_time` datetime(0) NULL DEFAULT NULL COMMENT '审批开始时间',
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '审批结束时间',
PRIMARY KEY (`task_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流历史表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_info
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_info`;
CREATE TABLE `itax_base`. `flow_info` (
`flow_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流程ID',
`flow_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批流名称',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批流备注',
`approval_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批业务key',
`dept_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人组织ID',
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人用户ID',
`publish_status` int(11) NULL DEFAULT NULL COMMENT '发布状态:0:未发布，1:已发布',
`del_flag` int(11) NULL DEFAULT NULL COMMENT '删除状态:0:删除,1:启用,2:未启用',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`flow_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流定义表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_node
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_node`;
CREATE TABLE `itax_base`. `flow_node` (
`node_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流程节点ID',
`flow_id` bigint(20) NULL DEFAULT NULL COMMENT '流程ID',
`node_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点名称',
`node_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '起始节点:start,过程节点:node,结束节点:end',
`node_sort` int(11) NULL DEFAULT NULL COMMENT '节点顺序',
`auth_type` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点权限类型:u:指定用户，r:指定角色',
`role_type` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色类型：固定角色:fix，层级角色:lvl',
`approval_way` int(11) NULL DEFAULT NULL COMMENT '审批方式:1:会签,2:或签',
`no_approver_way` int(11) NULL DEFAULT 1 COMMENT '审批人找不到时：1：自动通过',
`same_approver_way` int(11) NULL DEFAULT 1 COMMENT '审批人相同时：1：自动通过',
PRIMARY KEY (`node_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 91 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流节点定义表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_node_ccuer
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_node_ccuer`;
CREATE TABLE `itax_base`. `flow_node_ccuer` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`node_id` bigint(20) NULL DEFAULT NULL COMMENT '节点ID',
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '抄送用户ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流抄送表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_node_fix_role
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_node_fix_role`;
CREATE TABLE `itax_base`. `flow_node_fix_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`node_id` bigint(20) NULL DEFAULT NULL COMMENT '节点ID',
`role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
`dept_id` bigint(20) NULL DEFAULT NULL COMMENT '角色所属组织ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流节点固定角色关系表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_node_lvl_role
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_node_lvl_role`;
CREATE TABLE `itax_base`. `flow_node_lvl_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`node_id` bigint(20) NULL DEFAULT NULL COMMENT '节点ID',
`role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
`level` int(11) NULL DEFAULT NULL COMMENT '审批组织层级数',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流节点层级角色关系表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_node_user
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_node_user`;
CREATE TABLE `itax_base`. `flow_node_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`node_id` bigint(20) NULL DEFAULT NULL COMMENT '节点ID',
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '节点审批人用户ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 250 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流节点用户关系表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_process
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_process`;
CREATE TABLE `itax_base`. `flow_process` (
`flow_pr_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流程执行ID',
`flow_id` bigint(20) NULL DEFAULT NULL COMMENT '流程ID',
`act_node_id` bigint(20) NULL DEFAULT NULL COMMENT '当前激活节点ID',
`process_status` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '进行中:run，结束:end',
`approval_status` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批状态:Y:同意，N:拒绝，S:审批中',
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '发起人用户id',
`dept_id` bigint(20) NULL DEFAULT NULL COMMENT '发起人组织id',
`start_time` datetime(0) NULL DEFAULT NULL COMMENT '流程发起时间',
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '流程结束时间',
PRIMARY KEY (`flow_pr_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1072 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流流程实例表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_ru_process_user
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_ru_process_user`;
CREATE TABLE `itax_base`. `flow_ru_process_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`flow_pr_id` bigint(20) NULL DEFAULT NULL,
`node_id` bigint(20) NULL DEFAULT NULL COMMENT '节点ID',
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '节点审批人用户ID',
`role_id` bigint(20) NULL DEFAULT 0 COMMENT '节点绑定的角色id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34910 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流流程实例绑定用户表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for flow_ru_task
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`flow_ru_task`;
CREATE TABLE `itax_base`. `flow_ru_task` (
`task_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '节点任务ID',
`flow_pr_id` bigint(20) NULL DEFAULT NULL COMMENT '流程执行ID',
`node_id` bigint(20) NULL DEFAULT NULL COMMENT '节点ID',
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '审批人ID',
`start_time` datetime(0) NULL DEFAULT NULL COMMENT '审批开始时间',
PRIMARY KEY (`task_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38188 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作流待办事项表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for global_configurations
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`global_configurations`;
CREATE TABLE `itax_base`. `global_configurations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`log_mq_host` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`log_mq_prot` int(10) NULL DEFAULT NULL,
`log_mq_username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`log_mq_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`itax_url_itax_base_api` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`rest_pushUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`itaxBase_url_queryUserInfo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`xxl_sso_redis_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`xxl_sso_redis_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`itax_url_itax_bench_front` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`redirect_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`itax_url_itax_base_front` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`itaxBase_sso` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`itax_job_admin_addresses` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for itax_job_qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`itax_job_qrtz_calendars`;
CREATE TABLE `itax_base`. `itax_job_qrtz_calendars` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`CALENDAR` blob NOT NULL,
PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for itax_job_qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`itax_job_qrtz_fired_triggers`;
CREATE TABLE `itax_base`. `itax_job_qrtz_fired_triggers` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`ENTRY_ID` varchar(95) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`FIRED_TIME` bigint(13) NOT NULL,
`SCHED_TIME` bigint(13) NOT NULL,
`PRIORITY` int(11) NOT NULL,
`STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for itax_job_qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`itax_job_qrtz_job_details`;
CREATE TABLE `itax_base`. `itax_job_qrtz_job_details` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`IS_DURABLE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`JOB_DATA` blob NULL,
PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for itax_job_qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`itax_job_qrtz_locks`;
CREATE TABLE `itax_base`. `itax_job_qrtz_locks` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`LOCK_NAME` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for itax_job_qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`itax_job_qrtz_paused_trigger_grps`;
CREATE TABLE `itax_base`. `itax_job_qrtz_paused_trigger_grps` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for itax_job_qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`itax_job_qrtz_scheduler_state`;
CREATE TABLE `itax_base`. `itax_job_qrtz_scheduler_state` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`LAST_CHECKIN_TIME` bigint(13) NOT NULL,
`CHECKIN_INTERVAL` bigint(13) NOT NULL,
PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for itax_job_qrtz_trigger_group
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`itax_job_qrtz_trigger_group`;
CREATE TABLE `itax_base`. `itax_job_qrtz_trigger_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '执行器AppName',
`title` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '执行器名称',
`order` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
`address_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '执行器地址类型：0=自动注册、1=手动录入',
`address_list` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行器地址列表，多地址逗号分隔',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for itax_job_qrtz_trigger_info
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`itax_job_qrtz_trigger_info`;
CREATE TABLE `itax_base`. `itax_job_qrtz_trigger_info` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`job_group` int(11) NOT NULL COMMENT '执行器主键ID',
`job_cron` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务执行CRON',
`job_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`add_time` datetime(0) NULL DEFAULT NULL,
`update_time` datetime(0) NULL DEFAULT NULL,
`author` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者',
`alarm_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报警邮件',
`executor_route_strategy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行器路由策略',
`executor_handler` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行器任务handler',
`executor_param` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行器任务参数',
`executor_block_strategy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '阻塞处理策略',
`executor_timeout` int(11) NOT NULL DEFAULT 0 COMMENT '任务执行超时时间，单位秒',
`executor_fail_retry_count` int(11) NOT NULL DEFAULT 0 COMMENT '失败重试次数',
`glue_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'GLUE类型',
`glue_source` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'GLUE源代码',
`glue_remark` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'GLUE备注',
`glue_updatetime` datetime(0) NULL DEFAULT NULL COMMENT 'GLUE更新时间',
`child_jobid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '子任务ID，多个逗号分隔',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for itax_job_qrtz_trigger_log
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`itax_job_qrtz_trigger_log`;
CREATE TABLE `itax_base`. `itax_job_qrtz_trigger_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`job_group` int(11) NOT NULL COMMENT '执行器主键ID',
`job_id` int(11) NOT NULL COMMENT '任务，主键ID',
`executor_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行器地址，本次执行的地址',
`executor_handler` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行器任务handler',
`executor_param` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行器任务参数',
`executor_sharding_param` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2',
`executor_fail_retry_count` int(11) NOT NULL DEFAULT 0 COMMENT '失败重试次数',
`trigger_time` datetime(0) NULL DEFAULT NULL COMMENT '调度-时间',
`trigger_code` int(11) NOT NULL COMMENT '调度-结果',
`trigger_msg` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '调度-日志',
`handle_time` datetime(0) NULL DEFAULT NULL COMMENT '执行-时间',
`handle_code` int(11) NOT NULL COMMENT '执行-状态',
`handle_msg` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '执行-日志',
`alarm_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18394 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for itax_job_qrtz_trigger_logglue
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`itax_job_qrtz_trigger_logglue`;
CREATE TABLE `itax_base`. `itax_job_qrtz_trigger_logglue` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`job_id` int(11) NOT NULL COMMENT '任务，主键ID',
`glue_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'GLUE类型',
`glue_source` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'GLUE源代码',
`glue_remark` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'GLUE备注',
`add_time` timestamp(0) NULL DEFAULT NULL,
`update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for itax_job_qrtz_trigger_registry
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`itax_job_qrtz_trigger_registry`;
CREATE TABLE `itax_base`. `itax_job_qrtz_trigger_registry` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`registry_group` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`registry_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`registry_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 114 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for notify_info
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`notify_info`;
CREATE TABLE `itax_base`. `notify_info` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水ID',
`info_title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息标题',
`info` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息内容',
`notify_time` datetime(0) NULL DEFAULT NULL COMMENT '通知时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`info_type` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息类型 1.审批消息2.预警消息3业务提醒4通知公告',
`user_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID',
`dept_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门ID',
`read_status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '读取状态 已读：Y 未读：N',
`info_label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 36694 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`qrtz_blob_triggers`;
CREATE TABLE `itax_base`. `qrtz_blob_triggers` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '计划名称',
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '触发器名称',
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '触发器组',
`BLOB_DATA` blob NULL COMMENT '触发器信息',
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
INDEX `SCHED_NAME`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务相关设置' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`qrtz_calendars`;
CREATE TABLE `itax_base`. `qrtz_calendars` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`CALENDAR` blob NOT NULL,
PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`qrtz_cron_triggers`;
CREATE TABLE `itax_base`. `qrtz_cron_triggers` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`CRON_EXPRESSION` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TIME_ZONE_ID` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务相关设置' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`qrtz_fired_triggers`;
CREATE TABLE `itax_base`. `qrtz_fired_triggers` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`ENTRY_ID` varchar(95) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`FIRED_TIME` bigint(13) NOT NULL,
`SCHED_TIME` bigint(13) NOT NULL,
`PRIORITY` int(11) NOT NULL,
`STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`qrtz_job_details`;
CREATE TABLE `itax_base`. `qrtz_job_details` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`IS_DURABLE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`JOB_DATA` blob NULL,
PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`qrtz_locks`;
CREATE TABLE `itax_base`. `qrtz_locks` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`LOCK_NAME` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`qrtz_paused_trigger_grps`;
CREATE TABLE `itax_base`. `qrtz_paused_trigger_grps` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`qrtz_scheduler_state`;
CREATE TABLE `itax_base`. `qrtz_scheduler_state` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`LAST_CHECKIN_TIME` bigint(13) NOT NULL,
`CHECKIN_INTERVAL` bigint(13) NOT NULL,
PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`qrtz_simple_triggers`;
CREATE TABLE `itax_base`. `qrtz_simple_triggers` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`REPEAT_COUNT` bigint(7) NOT NULL,
`REPEAT_INTERVAL` bigint(12) NOT NULL,
`TIMES_TRIGGERED` bigint(10) NOT NULL,
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务相关设置' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`qrtz_simprop_triggers`;
CREATE TABLE `itax_base`. `qrtz_simprop_triggers` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`STR_PROP_1` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`STR_PROP_2` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`STR_PROP_3` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`INT_PROP_1` int(11) NULL DEFAULT NULL,
`INT_PROP_2` int(11) NULL DEFAULT NULL,
`LONG_PROP_1` bigint(20) NULL DEFAULT NULL,
`LONG_PROP_2` bigint(20) NULL DEFAULT NULL,
`DEC_PROP_1` decimal(13, 4) NULL DEFAULT NULL,
`DEC_PROP_2` decimal(13, 4) NULL DEFAULT NULL,
`BOOL_PROP_1` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`BOOL_PROP_2` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务相关设置' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`qrtz_triggers`;
CREATE TABLE `itax_base`. `qrtz_triggers` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`NEXT_FIRE_TIME` bigint(13) NULL DEFAULT NULL,
`PREV_FIRE_TIME` bigint(13) NULL DEFAULT NULL,
`PRIORITY` int(11) NULL DEFAULT NULL,
`TRIGGER_STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`TRIGGER_TYPE` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`START_TIME` bigint(13) NOT NULL,
`END_TIME` bigint(13) NULL DEFAULT NULL,
`CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`MISFIRE_INSTR` smallint(2) NULL DEFAULT NULL,
`JOB_DATA` blob NULL,
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
INDEX `IDX_QRTZ_T_J`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
INDEX `IDX_QRTZ_T_JG`(`SCHED_NAME`, `JOB_GROUP`) USING BTREE,
INDEX `IDX_QRTZ_T_C`(`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE,
INDEX `IDX_QRTZ_T_G`(`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE,
INDEX `IDX_QRTZ_T_STATE`(`SCHED_NAME`, `TRIGGER_STATE`) USING BTREE,
INDEX `IDX_QRTZ_T_N_STATE`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE,
INDEX `IDX_QRTZ_T_N_G_STATE`(`SCHED_NAME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE,
INDEX `IDX_QRTZ_T_NEXT_FIRE_TIME`(`SCHED_NAME`, `NEXT_FIRE_TIME`) USING BTREE,
INDEX `IDX_QRTZ_T_NFT_ST`(`SCHED_NAME`, `TRIGGER_STATE`, `NEXT_FIRE_TIME`) USING BTREE,
INDEX `IDX_QRTZ_T_NFT_MISFIRE`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`) USING BTREE,
INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`, `TRIGGER_STATE`) USING BTREE,
INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE,
CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for schedule_job
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`schedule_job`;
CREATE TABLE `itax_base`. `schedule_job` (
`job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
`bean_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'spring bean名称',
`method_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '方法名',
`params` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数',
`cron_expression` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'cron表达式',
`status` tinyint(4) NULL DEFAULT NULL COMMENT '任务状态 0：正常 1：暂停',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`job_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for schedule_job_log
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`schedule_job_log`;
CREATE TABLE `itax_base`. `schedule_job_log` (
`log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
`job_id` bigint(20) NOT NULL COMMENT '任务id',
`bean_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'spring bean名称',
`method_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '方法名',
`params` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数',
`status` tinyint(4) NOT NULL COMMENT '任务状态 0：成功 1：失败',
`error` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '失败信息',
`times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`log_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务日志' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for skin_color
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`skin_color`;
CREATE TABLE `itax_base`. `skin_color` (
`color_id` bigint(20) NOT NULL AUTO_INCREMENT,
`color_coding` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '颜色编码',
PRIMARY KEY (`color_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_configuration
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_configuration`;
CREATE TABLE `itax_base`. `sys_configuration` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
`logo` mediumblob NULL COMMENT '图片logo',
`pass_word` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_dept`;
CREATE TABLE `itax_base`.`sys_dept` (
`dept_id` bigint(20) NOT NULL AUTO_INCREMENT,
`parent_id` bigint(20) DEFAULT '0' COMMENT '上级部门ID，一级部门为0',
`name` varchar(50) DEFAULT NULL COMMENT '部门名称',
`code` varchar(255) DEFAULT NULL COMMENT '树形编码',
`level` tinyint(4) DEFAULT NULL COMMENT '层级',
`taxpayer_code` varchar(50) DEFAULT NULL COMMENT '纳税人税号',
`taxpayer_name` varchar(128) DEFAULT NULL COMMENT '纳税人名称',
`taxpayer_address` varchar(128) DEFAULT NULL COMMENT '纳税人地址',
`taxpayer_phone` varchar(20) DEFAULT NULL COMMENT '纳税人电话',
`taxpayer_bank` varchar(128) DEFAULT NULL COMMENT '纳税人银行',
`taxpayer_account` varchar(30) DEFAULT NULL COMMENT '纳税人账号',
`area_id` int(20) DEFAULT NULL COMMENT '地区编码',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`dept_type` int(128) DEFAULT NULL COMMENT '部门类型，1.总公司 2.子公司 3.分支机构 4.部门',
`create_user` bigint(20) DEFAULT NULL COMMENT '创建人',
`contact_name` varchar(100) DEFAULT NULL COMMENT '联系人姓名',
`contact_phone` varchar(100) DEFAULT NULL COMMENT '联系人电话',
`contact_email` varchar(100) DEFAULT NULL COMMENT '联系人邮箱',
`dept_sname` varchar(100) DEFAULT NULL COMMENT '组织简称',
`taxpayer_type` int(20) DEFAULT NULL COMMENT '纳税人类型',
`enterprise_numbers` varchar(200) DEFAULT NULL COMMENT '企业编码',
`invoice_name` varchar(200) DEFAULT NULL COMMENT '开票名称',
`invoice_nsrsbh` varchar(200) DEFAULT NULL COMMENT '开票税号',
`source_id` varchar(100) DEFAULT NULL,
`tenant_id` varchar(100) DEFAULT '1' COMMENT '租户id',
`omp_dept_id` varchar(100) DEFAULT NULL COMMENT '中台企业id',
`omp_parent_id` varchar(100) DEFAULT '0' COMMENT '中台父级企业id',
PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门管理';
-- ----------------------------
-- Table structure for sys_dept_tata
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_dept_tata`;
CREATE TABLE `itax_base`. `sys_dept_tata` (
`dept_id` bigint(50) NOT NULL AUTO_INCREMENT COMMENT '组织ID',
`parent_id` bigint(20) NULL DEFAULT NULL COMMENT '上级部门ID，一级部门为0',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称',
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '树形编码',
`level` tinyint(4) NULL DEFAULT NULL COMMENT '层级',
`taxpayer_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人税号',
`taxpayer_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人名称',
`taxpayer_address` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人地址',
`taxpayer_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人电话',
`taxpayer_bank` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人银行',
`taxpayer_account` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人账号',
`taxpayer_type` int(20) NULL DEFAULT NULL,
`area_id` int(20) NULL DEFAULT NULL COMMENT '地区编码',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`dept_type` int(128) NULL DEFAULT NULL COMMENT '部门类型，1.总公司 2.子公司 3.分支机构 4.部门',
`create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`contact_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人姓名',
`contact_phone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人电话',
`contact_email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人邮箱',
`dept_sname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织简称',
`enterprise_numbers` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`data_source` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '数据来源0为本系统录入，1为辅助运营系统同步',
`verify_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '认证状态 ：0 ： 未认证 ； 1 ：认证中； 2 ：已认证通过；3 ： 认证不通过',
PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 229 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'TATA部门管理' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_distributor_info
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_distributor_info`;
CREATE TABLE `itax_base`. `sys_distributor_info` (
`distributor_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分销商-渠道id',
`distributor_name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分销商-渠道名称',
`parent_distributor_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级分销商id',
`create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`distributor_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分销商-渠道信息表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_jobs
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_jobs`;
CREATE TABLE `itax_base`. `sys_jobs` (
`jobs_id` bigint(20) NOT NULL AUTO_INCREMENT,
`jobs_name` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '岗位名称',
`jobs_instructions` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '岗位说明',
`dept_id` bigint(20) NULL DEFAULT NULL COMMENT '所属组织',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`jobs_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_jobs_role
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_jobs_role`;
CREATE TABLE `itax_base`. `sys_jobs_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色id',
`jobs_id` bigint(20) NULL DEFAULT NULL COMMENT '岗位id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_log`;
CREATE TABLE `itax_base`.`sys_log` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`opt_user_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人',
`module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '系统名称，例如销项发票管理、进项发票管理、计缴申报管理等等。',
`opt_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '功能名称各系统自定义。例如：销项-电票冲红、进项-手工认证、计缴申报管理-新增取数规则等等',
`opt_result` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作结果',
`opt_dept` bigint(20) NULL DEFAULT NULL COMMENT '操作主体公司，deptId',
`keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字，唯一标识（便于检索）',
`ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问ip',
`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作结果说明',
`opt_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '日志入库时间',
`month` int(11) NOT NULL COMMENT '月，分区字段必填',
`operation_method` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`request_parameter` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
`return_parameter` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
PRIMARY KEY (`id`, `month`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19712 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_log_opt
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_log_opt`;
CREATE TABLE `itax_base`. `sys_log_opt` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`opt_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
`sys_module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '系统模块标识',
`create_time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_manager_dept
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_manager_dept`;
CREATE TABLE `itax_base`. `sys_manager_dept` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`manager_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色ID',
`dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
`permission_flag` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识 0 本部门 1本部门以及下级',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与部门对应关系' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_manager_info
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_manager_info`;
CREATE TABLE `itax_base`.`sys_manager_info` (
`manager_id` varchar(100) NOT NULL,
`manager_name` varchar(100) DEFAULT NULL COMMENT '管理组名称',
`remark` varchar(300) DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
`create_user_id` bigint(100) DEFAULT NULL COMMENT '创建人id',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_user_id` bigint(100) DEFAULT NULL COMMENT '更新人id',
`cascade_flag` varchar(2) DEFAULT NULL COMMENT '数据权限是否级联选择 0 不级联 1 级联选择',
`tenant_id` varchar(255) DEFAULT NULL COMMENT '客户ID',
KEY `idx_manager_id` (`manager_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员角色表';
-- ----------------------------
-- Table structure for sys_manager_menu
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_manager_menu`;
CREATE TABLE `itax_base`. `sys_manager_menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`manager_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色ID',
`menu_id` bigint(20) NULL DEFAULT NULL COMMENT '菜单ID',
PRIMARY KEY (`id`) USING BTREE,
INDEX `manager_id_idx`(`manager_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与菜单对应关系' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_manager_role
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_manager_role`;
CREATE TABLE `itax_base`. `sys_manager_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`manager_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理组ID',
`role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
PRIMARY KEY (`id`) USING BTREE,
INDEX `p_manager_id`(`manager_id`) USING BTREE,
INDEX `p_role_id`(`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理与角色对应关系' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_manager_user
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_manager_user`;
CREATE TABLE `itax_base`. `sys_manager_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`manager_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理组ID',
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '菜单ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与菜单对应关系' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_menu`;
CREATE TABLE `itax_base`.`sys_menu` (
`menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
`parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
`name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
`url` varchar(400) DEFAULT NULL COMMENT '菜单URL',
`perms` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
`type` int(11) DEFAULT NULL COMMENT '类型 0：目录 1：菜单 2：按钮',
`icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
`order_num` int(11) DEFAULT NULL COMMENT '排序',
`system_sign` varchar(10) DEFAULT NULL COMMENT '系统标识',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`puser_id` bigint(10) DEFAULT NULL COMMENT '创建人id',
`tenant_id` varchar(255) DEFAULT NULL COMMENT '客户ID',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=91802619 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='菜单管理';
-- ----------------------------
-- Table structure for sys_menu_copy_48
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_menu_copy_48`;
CREATE TABLE `itax_base`. `sys_menu_copy_48` (
`menu_id` bigint(16) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
`parent_id` bigint(16) NULL DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
`url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单URL',
`perms` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
`type` int(11) NULL DEFAULT NULL COMMENT '类型 0：目录 1：菜单 2：按钮',
`icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
`order_num` int(11) NULL DEFAULT NULL COMMENT '排序',
`system_sign` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '系统标识',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`puser_id` bigint(10) NULL DEFAULT NULL COMMENT '创建人id',
PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单管理' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_role`;
CREATE TABLE `itax_base`.`sys_role` (
`role_id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_name` varchar(100) DEFAULT NULL COMMENT '角色名称',
`type` int(5) DEFAULT '0' COMMENT '是否为共享角色0：否,1:是',
`remark` varchar(300) DEFAULT NULL COMMENT '备注',
`dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`p_user_id` bigint(100) DEFAULT NULL COMMENT '创建人id',
`manager_id` varchar(100) DEFAULT NULL COMMENT '创建人所属管理组',
`role_type` int(5) DEFAULT '1' COMMENT '角色类型 1 仅本部门 2 本部门以及下属组织 3自定义 默认1',
`omp_dept_id` varchar(100) DEFAULT NULL COMMENT '映射部门id',
`tenant_id` varchar(255) DEFAULT NULL COMMENT '客户ID',
PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色';
-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_role_dept`;
CREATE TABLE `itax_base`. `sys_role_dept` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
`dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1486 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与部门对应关系' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_role_menu`;
CREATE TABLE `itax_base`. `sys_role_menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
`menu_id` bigint(20) NULL DEFAULT NULL COMMENT '菜单ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38834 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与菜单对应关系' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_user`;
CREATE TABLE `itax_base`.`sys_user` (
`user_id` bigint(20) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL COMMENT '用户名',
`password` varchar(100) DEFAULT NULL COMMENT '密码',
`salt` varchar(20) DEFAULT NULL COMMENT '盐',
`email` varchar(100) DEFAULT NULL COMMENT '邮箱',
`mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
`status` tinyint(4) DEFAULT NULL COMMENT '状态 0：禁用 1：正常',
`ep_id` bigint(20) DEFAULT NULL COMMENT '所属企业ID',
`dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
`password_update_time` datetime DEFAULT NULL COMMENT '密码更新时间 此字段用于判断多长时间密码更新一次',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`number` varchar(20) DEFAULT NULL COMMENT '员工编号',
`name` varchar(50) DEFAULT NULL COMMENT '姓名',
`last_login_time` datetime DEFAULT NULL COMMENT '上次登录时间',
`obv_password` varchar(100) DEFAULT NULL COMMENT '明文密码',
`manager_id` varchar(100) DEFAULT NULL COMMENT '创建人所属管理组ID',
`p_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
`login_count` int(11) DEFAULT NULL COMMENT '登录次数',
`borad_auth` int(10) DEFAULT NULL COMMENT '0默认看板 1 默认看板+总览看板 ',
`skin_color_id` bigint(20) DEFAULT '1' COMMENT '皮肤id-默认1 蓝色',
`user_source` int(10) DEFAULT '1' COMMENT '''1.系统用户，2.TATA同步用户''',
`user_type` int(10) DEFAULT NULL COMMENT '用户类型 1 超管 2 普通用户 3 管理员',
`tenant_id` varchar(255) DEFAULT NULL COMMENT '客户ID',
`distributor_id` varchar(255) DEFAULT NULL COMMENT '渠道ID',
`omp_dept_id` varchar(100) DEFAULT NULL,
PRIMARY KEY (`user_id`) USING BTREE,
KEY `dept_id_inx` (`dept_id`) USING BTREE,
KEY `ep_id_idx` (`ep_id`) USING BTREE,
KEY `p_user_id` (`p_user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统用户';
-- ----------------------------
-- Table structure for sys_user_dept
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_user_dept`;
CREATE TABLE `itax_base`. `sys_user_dept` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
`dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12849 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与部门对应关系' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_user_dept_tata
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_user_dept_tata`;
CREATE TABLE `itax_base`. `sys_user_dept_tata` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
`dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12284 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'TATA同步角色与部门对应关系' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_user_distributor
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_user_distributor`;
CREATE TABLE `itax_base`. `sys_user_distributor` (
`id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '关系表id',
`distributor_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分销商-渠道id',
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`distributor_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分销商-渠道信息表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`sys_user_role`;
CREATE TABLE `itax_base`. `sys_user_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID',
`role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8651 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户与角色对应关系' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for tabinfo_province
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`tabinfo_province`;
CREATE TABLE `itax_base`. `tabinfo_province` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`provinceName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省份名称',
`provinceShortName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省份简称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for tabinfo_summ
-- ----------------------------
DROP TABLE IF EXISTS `itax_base`.`tabinfo_summ`;
CREATE TABLE `itax_base`. `tabinfo_summ` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`taxpayercode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税号',
`config_id` int(11) NULL DEFAULT NULL COMMENT '选项卡关联id',
`content` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '选项卡展示内容',
`detail` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
`updatetime` datetime(0) NULL DEFAULT NULL,
`user_id` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 502 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '选项卡数据表' ROW_FORMAT = DYNAMIC;
SET FOREIGN_KEY_CHECKS = 1;