/*
Navicat MySQL Data Transfer

Source Server         : atms_mysql_didi_bak
Source Server Version : 50725
Source Host           : 10.158.230.16:3306
Source Database       : tax_admin_didi

Target Server Type    : MYSQL
Target Server Version : 50725
File Encoding         : 65001

Date: 2019-02-27 13:58:54
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for account_mapping
-- ----------------------------
DROP TABLE IF EXISTS `account_mapping`;
CREATE TABLE `account_mapping` (
  `id` varchar(128) NOT NULL,
  `enterprise_account_code` varchar(50) NOT NULL DEFAULT '',
  `standard_account_code` varchar(50) NOT NULL DEFAULT '',
  `enterprise_account_set_id` varchar(128) NOT NULL DEFAULT '',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `industry_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `account_mapping_organization_id_IDX` (`organization_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for account_mapping_keyword
-- ----------------------------
DROP TABLE IF EXISTS `account_mapping_keyword`;
CREATE TABLE `account_mapping_keyword` (
  `id` varchar(128) NOT NULL,
  `standard_code` varchar(50) NOT NULL DEFAULT '',
  `full_name` varchar(200) NOT NULL DEFAULT '',
  `rule_type` int(11) NOT NULL DEFAULT '0',
  `industry_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for account_mapping_manual
-- ----------------------------
DROP TABLE IF EXISTS `account_mapping_manual`;
CREATE TABLE `account_mapping_manual` (
  `id` varchar(128) NOT NULL,
  `standard_code` varchar(50) NOT NULL DEFAULT '',
  `full_name` varchar(200) NOT NULL DEFAULT '',
  `enterprise_account_set_id` varchar(128) NOT NULL DEFAULT '',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `industry_id` varchar(128) NOT NULL DEFAULT '',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `account_mapping_manual_organization_id_IDX` (`organization_id`,`enterprise_account_set_id`,`industry_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for ACT_EVT_LOG
-- ----------------------------
DROP TABLE IF EXISTS `ACT_EVT_LOG`;
CREATE TABLE `ACT_EVT_LOG` (
  `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT,
  `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DATA_` longblob,
  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_PROCESSED_` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`LOG_NR_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_GE_BYTEARRAY
-- ----------------------------
DROP TABLE IF EXISTS `ACT_GE_BYTEARRAY`;
CREATE TABLE `ACT_GE_BYTEARRAY` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BYTES_` longblob,
  `GENERATED_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`),
  CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_GE_PROPERTY
-- ----------------------------
DROP TABLE IF EXISTS `ACT_GE_PROPERTY`;
CREATE TABLE `ACT_GE_PROPERTY` (
  `NAME_` varchar(64) COLLATE utf8_bin NOT NULL,
  `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  PRIMARY KEY (`NAME_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_ACTINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_ACTINST`;
CREATE TABLE `ACT_HI_ACTINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`),
  KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`),
  KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`),
  KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_ATTACHMENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_ATTACHMENT`;
CREATE TABLE `ACT_HI_ATTACHMENT` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_COMMENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_COMMENT`;
CREATE TABLE `ACT_HI_COMMENT` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `FULL_MSG_` longblob,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_DETAIL
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_DETAIL`;
CREATE TABLE `ACT_HI_DETAIL` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`),
  KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`),
  KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`),
  KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_IDENTITYLINK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_IDENTITYLINK`;
CREATE TABLE `ACT_HI_IDENTITYLINK` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_PROCINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_PROCINST`;
CREATE TABLE `ACT_HI_PROCINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`),
  KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_TASKINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_TASKINST`;
CREATE TABLE `ACT_HI_TASKINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `CLAIM_TIME_` datetime(3) DEFAULT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `PRIORITY_` int(11) DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_VARINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_VARINST`;
CREATE TABLE `ACT_HI_VARINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME_` datetime(3) DEFAULT NULL,
  `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`),
  KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_ID_GROUP
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_GROUP`;
CREATE TABLE `ACT_ID_GROUP` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_ID_INFO
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_INFO`;
CREATE TABLE `ACT_ID_INFO` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PASSWORD_` longblob,
  `PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_ID_MEMBERSHIP
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_MEMBERSHIP`;
CREATE TABLE `ACT_ID_MEMBERSHIP` (
  `USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`USER_ID_`,`GROUP_ID_`),
  KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`),
  CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `ACT_ID_GROUP` (`ID_`),
  CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `ACT_ID_USER` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_ID_USER
-- ----------------------------
DROP TABLE IF EXISTS `ACT_ID_USER`;
CREATE TABLE `ACT_ID_USER` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_PROCDEF_INFO
-- ----------------------------
DROP TABLE IF EXISTS `ACT_PROCDEF_INFO`;
CREATE TABLE `ACT_PROCDEF_INFO` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`),
  KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`),
  CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RE_DEPLOYMENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RE_DEPLOYMENT`;
CREATE TABLE `ACT_RE_DEPLOYMENT` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RE_MODEL
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RE_MODEL`;
CREATE TABLE `ACT_RE_MODEL` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `VERSION_` int(11) DEFAULT NULL,
  `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`),
  KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`),
  KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`),
  CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`),
  CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RE_PROCDEF
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RE_PROCDEF`;
CREATE TABLE `ACT_RE_PROCDEF` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VERSION_` int(11) NOT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL,
  `HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_EVENT_SUBSCR
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_EVENT_SUBSCR`;
CREATE TABLE `ACT_RU_EVENT_SUBSCR` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`),
  KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`),
  CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_EXECUTION
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_EXECUTION`;
CREATE TABLE `ACT_RU_EXECUTION` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `IS_ACTIVE_` tinyint(4) DEFAULT NULL,
  `IS_CONCURRENT_` tinyint(4) DEFAULT NULL,
  `IS_SCOPE_` tinyint(4) DEFAULT NULL,
  `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `CACHED_ENT_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`),
  KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`),
  KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`),
  KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`),
  CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_IDENTITYLINK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_IDENTITYLINK`;
CREATE TABLE `ACT_RU_IDENTITYLINK` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),
  KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),
  KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`),
  KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`),
  CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `ACT_RU_TASK` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_JOB
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_JOB`;
CREATE TABLE `ACT_RU_JOB` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
  CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_TASK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_TASK`;
CREATE TABLE `ACT_RU_TASK` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PRIORITY_` int(11) DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`),
  KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`),
  KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`),
  CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_VARIABLE
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_VARIABLE`;
CREATE TABLE `ACT_RU_VARIABLE` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`),
  KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),
  KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),
  CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for adjustment_table
-- ----------------------------
DROP TABLE IF EXISTS `adjustment_table`;
CREATE TABLE `adjustment_table` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `period` int(11) NOT NULL DEFAULT '0' COMMENT '期间',
  `segment1` varchar(300) NOT NULL DEFAULT '' COMMENT '主体',
  `segment2` varchar(300) NOT NULL DEFAULT '' COMMENT '成本中心',
  `segment3` varchar(300) NOT NULL DEFAULT '' COMMENT '科目',
  `segment4` varchar(300) NOT NULL DEFAULT '' COMMENT '辅助科目',
  `segment5` varchar(300) NOT NULL DEFAULT '' COMMENT '利润中心',
  `segment6` varchar(300) NOT NULL DEFAULT '' COMMENT '产品',
  `segment7` varchar(300) NOT NULL DEFAULT '' COMMENT '项目',
  `segment8` varchar(300) NOT NULL DEFAULT '' COMMENT '公司间',
  `segment9` varchar(300) NOT NULL DEFAULT '' COMMENT '备用1',
  `segment10` varchar(300) NOT NULL DEFAULT '' COMMENT '备用2',
  `segment1_name` varchar(300) NOT NULL DEFAULT '' COMMENT '主体说明',
  `segment2_name` varchar(300) NOT NULL DEFAULT '' COMMENT '成本中心说明',
  `segment3_name` varchar(300) NOT NULL DEFAULT '' COMMENT '科目说明',
  `segment4_name` varchar(300) NOT NULL DEFAULT '' COMMENT '辅助科目说明',
  `segment5_name` varchar(300) NOT NULL DEFAULT '' COMMENT '利润中心说明',
  `segment6_name` varchar(300) NOT NULL DEFAULT '' COMMENT '产品说明',
  `segment7_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目说明',
  `segment8_name` varchar(300) NOT NULL DEFAULT '' COMMENT '公司间说明',
  `segment9_name` varchar(300) NOT NULL DEFAULT '' COMMENT '备用1说明',
  `segment10_name` varchar(300) NOT NULL DEFAULT '' COMMENT '备用2说明',
  `period_dr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本期借方发生额',
  `period_cr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本期贷方发生额',
  `end_bal_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币期末余额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='调整表';

-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `id` varchar(128) NOT NULL,
  `parent_id` varchar(128) DEFAULT '',
  `name` varchar(200) NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `area_name_IDX` (`name`) USING BTREE,
  KEY `area_parent_id_IDX` (`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for area_region
-- ----------------------------
DROP TABLE IF EXISTS `area_region`;
CREATE TABLE `area_region` (
  `id` varchar(128) NOT NULL,
  `area_id` varchar(128) NOT NULL DEFAULT '',
  `region_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `area_region_area_id_IDX` (`area_id`,`region_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for asset_detail_group
-- ----------------------------
DROP TABLE IF EXISTS `asset_detail_group`;
CREATE TABLE `asset_detail_group` (
  `id` bigint(18) NOT NULL DEFAULT '0',
  `asset_group_id` bigint(18) NOT NULL DEFAULT '0' COMMENT '表asset_group的主键',
  `detail_group_name` varchar(200) NOT NULL DEFAULT '' COMMENT '资产分类二级分类名称',
  `asset_group_type` int(10) NOT NULL DEFAULT '0' COMMENT '隶属的资产一级分类的类型代码',
  `group_year` int(10) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `detail_group_type` int(10) NOT NULL DEFAULT '0' COMMENT '二级分类的类型代码',
  `key_values` varchar(500) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `asset_detail_group_asset_group_type_IDX` (`asset_group_type`,`detail_group_type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资产分类二级分类';

-- ----------------------------
-- Table structure for asset_group
-- ----------------------------
DROP TABLE IF EXISTS `asset_group`;
CREATE TABLE `asset_group` (
  `id` bigint(18) NOT NULL DEFAULT '0',
  `asset_group_name` varchar(200) NOT NULL DEFAULT '' COMMENT '资产分类一级分类名称',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `asset_group_type` int(10) NOT NULL DEFAULT '0' COMMENT '资产一级分类的类型代码',
  PRIMARY KEY (`id`),
  UNIQUE KEY `asset_group_asset_group_name_IDX` (`asset_group_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资产分类一级分类';

-- ----------------------------
-- Table structure for asset_group_result
-- ----------------------------
DROP TABLE IF EXISTS `asset_group_result`;
CREATE TABLE `asset_group_result` (
  `id` bigint(18) NOT NULL DEFAULT '0',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '表project主键',
  `period` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `asset_name` varchar(400) NOT NULL DEFAULT '' COMMENT '资产类别-资产清单中资产分类弹框中的资产类别,包含资产清单Grid中的所有资产类别',
  `asset_group_id` bigint(18) NOT NULL DEFAULT '0' COMMENT '资产一级分类主键',
  `asset_detail_group_id` bigint(18) NOT NULL DEFAULT '0' COMMENT '资产二级分类主键',
  `tax_depreciation_period` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '税务折旧期限',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资产分类(资产类别与资产二级分类对应的对应关系,资产清单页面中的资产分类弹框用到此表)';

-- ----------------------------
-- Table structure for assets_list
-- ----------------------------
DROP TABLE IF EXISTS `assets_list`;
CREATE TABLE `assets_list` (
  `id` bigint(18) NOT NULL DEFAULT '0',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '表project主键',
  `period` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `asset_number` varchar(100) NOT NULL DEFAULT '' COMMENT '资产编号',
  `asset_group_name` varchar(400) NOT NULL DEFAULT '' COMMENT '资产类别-页面',
  `asset_detail_group_id` bigint(18) NOT NULL DEFAULT '0' COMMENT '资产二级分类主键',
  `asset_description` varchar(1000) NOT NULL DEFAULT '' COMMENT '资产说明',
  `buy_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '购入日期',
  `depreciation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开始折旧日期',
  `depreciation_period` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '折旧期限',
  `acquisition_value` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '原值',
  `adjustment_value` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '调整值',
  `disposed_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '报废日期',
  `residual_rate` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '残值率',
  `year_depreciation_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '本年折旧额',
  `year_adjustment_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '本年调整额',
  `year_end_value` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '年终剩余价值',
  `status` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `account_acquisition_value` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '财务原值(按照文档所说:该值就是上面的原值加上调整值么)',
  `account_month_depreciation_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '财务每月折旧额',
  `account_year_depreciation_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '财务本年折旧额(上方的本年折旧额 + 本年折旧调整额)',
  `account_total_depreciation_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '财务累计折旧额',
  `tax_depreciation_period` int(10) NOT NULL DEFAULT '0' COMMENT '税务折旧期限',
  `tax_to_last_year_depreciation_period` int(10) NOT NULL DEFAULT '0' COMMENT '截止去年累计折旧期间',
  `tax_to_current_year_depreciation_period` int(10) NOT NULL DEFAULT '0' COMMENT '截止本年累计折旧期间',
  `tax_year_depreciation_period` int(10) NOT NULL DEFAULT '0' COMMENT '本年折旧期间',
  `tax_month_depreciation_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '税务每月折旧额',
  `tax_to_current_year_depreciation_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '税务累计折旧额',
  `tax_current_year_depreciation_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '税务本年折旧额',
  `total_difference_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '累计差异',
  `year_difference_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '当年差异',
  `is_retain` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '保留差异',
  `asset_type` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '资产一级分类(固定资产、长期分摊、无形资产)',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `tax_account_compare` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '税会折旧大小比较结果;1表示税大,2表示会大',
  `tax_group_name` varchar(200) NOT NULL DEFAULT '' COMMENT '税法分类,也是资产二级分类(asset_detail_group表中的detailGroupName)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资产清单';

-- ----------------------------
-- Table structure for balance_sheet
-- ----------------------------
DROP TABLE IF EXISTS `balance_sheet`;
CREATE TABLE `balance_sheet` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源 GL',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间yyyymm',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `status` varchar(10) NOT NULL DEFAULT '' COMMENT '关账标识 Y/N',
  `ledger_id` varchar(128) NOT NULL DEFAULT '' COMMENT '账套ID',
  `ledger_name` varchar(300) NOT NULL DEFAULT '' COMMENT '账套名称',
  `ledger_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '账套币种',
  `entity_code` varchar(300) NOT NULL DEFAULT '' COMMENT '机构编码',
  `entity_name` varchar(300) NOT NULL DEFAULT '' COMMENT '机构名称',
  `category` varchar(300) NOT NULL DEFAULT '' COMMENT '主体性质 单体/合并',
  `frequency` varchar(300) NOT NULL DEFAULT '' COMMENT '频度 固定值M,仅期间(月度含13期)报表数据',
  `item_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目名称',
  `end_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '期末余额',
  `beg_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '年初余额',
  `prc_flag` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为国外 0-国内,1-国外',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资产负债表。月度,次月传送上月,全部主体,只传送账套币种即折算后本位币币种金额';

-- ----------------------------
-- Table structure for balance_sheet_final
-- ----------------------------
DROP TABLE IF EXISTS `balance_sheet_final`;
CREATE TABLE `balance_sheet_final` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源 GL',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间yyyymm',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `status` varchar(10) NOT NULL DEFAULT '' COMMENT '关账标识 Y/N',
  `ledger_id` varchar(128) NOT NULL DEFAULT '' COMMENT '账套ID',
  `ledger_name` varchar(300) NOT NULL DEFAULT '' COMMENT '账套名称',
  `ledger_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '账套币种',
  `entity_code` varchar(300) NOT NULL DEFAULT '' COMMENT '机构编码',
  `entity_name` varchar(300) NOT NULL DEFAULT '' COMMENT '机构名称',
  `category` varchar(300) NOT NULL DEFAULT '' COMMENT '主体性质 单体/合并',
  `frequency` varchar(300) NOT NULL DEFAULT '' COMMENT '频度 固定值M,仅期间(月度含13期)报表数据',
  `item_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目名称',
  `end_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '期末余额',
  `beg_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '年初余额',
  `prc_flag` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为国外 0-国内,1-国外',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资产负债表。最新版本,与接口导入、excel导入中最新版本一致';

-- ----------------------------
-- Table structure for balance_sheet_manual
-- ----------------------------
DROP TABLE IF EXISTS `balance_sheet_manual`;
CREATE TABLE `balance_sheet_manual` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源 GL',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间yyyymm',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `status` varchar(10) NOT NULL DEFAULT '' COMMENT '关账标识 Y/N',
  `ledger_id` varchar(128) NOT NULL DEFAULT '' COMMENT '账套ID',
  `ledger_name` varchar(300) NOT NULL DEFAULT '' COMMENT '账套名称',
  `ledger_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '账套币种',
  `entity_code` varchar(300) NOT NULL DEFAULT '' COMMENT '机构编码',
  `entity_name` varchar(300) NOT NULL DEFAULT '' COMMENT '机构名称',
  `category` varchar(300) NOT NULL DEFAULT '' COMMENT '主体性质 单体/合并',
  `frequency` varchar(300) NOT NULL DEFAULT '' COMMENT '频度 固定值M,仅期间(月度含13期)报表数据',
  `item_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目名称',
  `end_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '期末余额',
  `beg_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '年初余额',
  `prc_flag` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为国外 0-国内,1-国外',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资产负债表。人工调整,excel导入';

-- ----------------------------
-- Table structure for business_unit
-- ----------------------------
DROP TABLE IF EXISTS `business_unit`;
CREATE TABLE `business_unit` (
  `id` varchar(128) NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `is_active` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `business_unit_name_IDX` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for cache
-- ----------------------------
DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `id` varchar(128) NOT NULL,
  `cache_key` varchar(255) NOT NULL DEFAULT '',
  `last_modify_time` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for cash_flow
-- ----------------------------
DROP TABLE IF EXISTS `cash_flow`;
CREATE TABLE `cash_flow` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号 系统唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构id',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(128) NOT NULL DEFAULT '' COMMENT '数据来源GL',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间 yyyyMM',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 YYYY-MM',
  `status` varchar(10) NOT NULL DEFAULT '' COMMENT '关账标识 Y/N',
  `ledger_id` varchar(128) NOT NULL DEFAULT '' COMMENT '账套ID',
  `ledger_name` varchar(300) NOT NULL DEFAULT '' COMMENT '账套名称',
  `ledger_currency_code` varchar(128) NOT NULL DEFAULT '' COMMENT '账套币种',
  `entity_code` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编码',
  `entity_name` varchar(300) NOT NULL DEFAULT '' COMMENT '机构名称',
  `category` varchar(300) NOT NULL DEFAULT '' COMMENT '主体性质(单体/合并)',
  `frequency` varchar(300) NOT NULL DEFAULT '' COMMENT '频度(固定值M,\n仅期间(月度含13期)报表数据)',
  `item_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目中文名称',
  `item_name2` varchar(300) NOT NULL DEFAULT '' COMMENT '项目英文名称',
  `period_amt` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本期发生',
  `ytd_amt` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本年累计',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='月度,次月传送上月,全部主体,只传送账套币种即折算后本位币币种金额';

-- ----------------------------
-- Table structure for cell_data_source
-- ----------------------------
DROP TABLE IF EXISTS `cell_data_source`;
CREATE TABLE `cell_data_source` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `cell_template_id` bigint(19) NOT NULL DEFAULT '0',
  `cell_data_id` bigint(19) NOT NULL DEFAULT '0',
  `data_source_id` bigint(19) NOT NULL DEFAULT '0',
  `operation_type` int(10) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `project_id` varchar(128) NOT NULL DEFAULT '',
  `period` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `cell_data_source_cell_data_id_IDX` (`cell_data_id`,`data_source_id`,`project_id`,`period`) USING BTREE,
  KEY `cell_data_source_cell_template_id_IDX` (`cell_template_id`,`cell_data_id`,`data_source_id`,`project_id`,`period`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for cell_template
-- ----------------------------
DROP TABLE IF EXISTS `cell_template`;
CREATE TABLE `cell_template` (
  `id` bigint(19) NOT NULL,
  `report_template_id` bigint(19) NOT NULL DEFAULT '0',
  `row_index` int(10) NOT NULL DEFAULT '0',
  `row_name` varchar(1000) DEFAULT '',
  `column_index` int(10) NOT NULL DEFAULT '0',
  `column_name` varchar(1000) DEFAULT '',
  `comment` varchar(3000) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `copy_from_id` bigint(19) NOT NULL DEFAULT '0',
  `data_type` int(10) NOT NULL DEFAULT '0',
  `is_read_only` tinyint(1) NOT NULL DEFAULT '0',
  `create_by` varchar(128) DEFAULT '',
  `update_by` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `cell_template_report_template_id_IDX` (`report_template_id`,`row_index`,`column_index`,`copy_from_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for cell_template_config
-- ----------------------------
DROP TABLE IF EXISTS `cell_template_config`;
CREATE TABLE `cell_template_config` (
  `id` bigint(19) NOT NULL,
  `cell_template_id` bigint(19) NOT NULL DEFAULT '0',
  `report_template_id` bigint(19) NOT NULL DEFAULT '0',
  `data_source_type` int(4) NOT NULL DEFAULT '0',
  `formula` varchar(1000) DEFAULT '',
  `formula_description` varchar(1000) DEFAULT '',
  `account_codes` varchar(1000) DEFAULT '',
  `invoice_type` int(10) NOT NULL DEFAULT '0',
  `tax_rate` varchar(50) DEFAULT '',
  `invoice_amount_type` int(10) NOT NULL DEFAULT '0',
  `model_ids` varchar(1000) DEFAULT '',
  `create_by` varchar(128) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(128) DEFAULT '',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `invoice_category` varchar(50) DEFAULT '',
  `formula_data_source` varchar(1000) DEFAULT '',
  `validation` varchar(1000) DEFAULT '',
  `validation_description` varchar(1000) DEFAULT '',
  `voucher_keyword` varchar(1000) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `cell_template_config_cell_template_id_IDX` (`cell_template_id`) USING BTREE,
  KEY `cell_template_config_report_template_id_IDX` (`report_template_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for certified_invoices_list
-- ----------------------------
DROP TABLE IF EXISTS `certified_invoices_list`;
CREATE TABLE `certified_invoices_list` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `taxpayer_id_num` varchar(300) NOT NULL DEFAULT '' COMMENT '纳税人识别号 ',
  `certified_month` int(11) NOT NULL DEFAULT '0' COMMENT '认证月份',
  `unit` varchar(20) NOT NULL DEFAULT '' COMMENT '单位:元',
  `seq_no` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '序号',
  `invoice_code` varchar(50) NOT NULL DEFAULT '' COMMENT '发票代码',
  `invoice_num` varchar(50) NOT NULL DEFAULT '' COMMENT '发票号码',
  `billing_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开票日期',
  `sales_tax_num` varchar(50) NOT NULL DEFAULT '' COMMENT '销方税号',
  `salesperson_name` varchar(50) NOT NULL DEFAULT '' COMMENT '销方名称',
  `amount` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '金额',
  `tax_amount` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '税额',
  `verification_method` varchar(50) NOT NULL DEFAULT '' COMMENT '认证方式',
  `certified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '确认/认证日期',
  `invoice_type` varchar(50) NOT NULL DEFAULT '' COMMENT '发票类型',
  `invoice_status` varchar(50) NOT NULL DEFAULT '' COMMENT '发票状态',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='已认证发票清单';

-- ----------------------------
-- Table structure for cit_balance_sheet_prc_adjust
-- ----------------------------
DROP TABLE IF EXISTS `cit_balance_sheet_prc_adjust`;
CREATE TABLE `cit_balance_sheet_prc_adjust` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源 GL',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间yyyymm',
  `item_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目名称',
  `end_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '期末余额',
  `beg_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '年初余额',
  `create_by` varchar(100) NOT NULL DEFAULT '' COMMENT '创建人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资产负债表(单家PRC)调整';

-- ----------------------------
-- Table structure for cit_data_import_log
-- ----------------------------
DROP TABLE IF EXISTS `cit_data_import_log`;
CREATE TABLE `cit_data_import_log` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号',
  `taxpayer_id_num` varchar(128) NOT NULL DEFAULT '' COMMENT '纳税人识别号',
  `type` tinyint(2) unsigned DEFAULT '0' COMMENT '导入类型(随着类型的增加增加数字即可)。0-未定义,1-日记账调整,2-资产负债表,3-',
  `company_code` varchar(300) NOT NULL DEFAULT '' COMMENT '公司代码',
  `company_name` varchar(300) NOT NULL DEFAULT '' COMMENT '公司名称',
  `file_type` varchar(20) NOT NULL DEFAULT '' COMMENT '文件类型',
  `period_year` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '年度',
  `tms_period_month` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间',
  `period_month` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `period_status` varchar(20) NOT NULL DEFAULT '' COMMENT 'Oracle期间状态',
  `operator` varchar(50) NOT NULL DEFAULT '' COMMENT '操作人',
  `operate_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间',
  `import_result` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '导入结果',
  `error_msg` varchar(300) NOT NULL DEFAULT '导入成功' COMMENT '校验问题',
  `record_size` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '记录条数',
  `display` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否为最新导入记录。0-不是,1-是 。写入新提交记录时更新旧的为0',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='CIT数据导入记录。';

-- ----------------------------
-- Table structure for cit_draft_account_mapping
-- ----------------------------
DROP TABLE IF EXISTS `cit_draft_account_mapping`;
CREATE TABLE `cit_draft_account_mapping` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号 系统唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号 对应机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID ',
  `period` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源 GL',
  `acct_code` varchar(128) NOT NULL DEFAULT '' COMMENT '科目代码',
  `account_name` varchar(400) NOT NULL DEFAULT '' COMMENT '科目名称 ',
  `attribute` varchar(128) NOT NULL DEFAULT '' COMMENT '小类 ',
  `created_by` varchar(300) NOT NULL DEFAULT '' COMMENT '创建人 ',
  `updated_by` varchar(300) NOT NULL DEFAULT '' COMMENT '最后更新人 ',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间 ',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间 ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='底稿&科目Mapping表';

-- ----------------------------
-- Table structure for cit_eam_assets_disposal
-- ----------------------------
DROP TABLE IF EXISTS `cit_eam_assets_disposal`;
CREATE TABLE `cit_eam_assets_disposal` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号 系统唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号 对应机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID ',
  `period` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源 GL',
  `occur_period` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发生期间',
  `asset_label_number` varchar(128) NOT NULL DEFAULT '' COMMENT '资产标签号',
  `compensation_sale_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '赔偿/变卖金额',
  `created_by` varchar(300) NOT NULL DEFAULT '' COMMENT '创建人 ',
  `updated_by` varchar(300) NOT NULL DEFAULT '' COMMENT '最后更新人 ',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间 ',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间 ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='EAM资产处置金额记录表';

-- ----------------------------
-- Table structure for cit_journal_entry_adjust
-- ----------------------------
DROP TABLE IF EXISTS `cit_journal_entry_adjust`;
CREATE TABLE `cit_journal_entry_adjust` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号 系统唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号 对应机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID ',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期 ',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源 GL',
  `ledger_id` varchar(128) NOT NULL DEFAULT '' COMMENT '账套ID ',
  `ledger_name` varchar(300) NOT NULL DEFAULT '' COMMENT '账套名称 ',
  `currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '账套币种 ',
  `status` varchar(10) NOT NULL DEFAULT '' COMMENT '关账标识 Y/N',
  `header_id` varchar(128) NOT NULL DEFAULT '' COMMENT '日记账头ID ',
  `line_num` varchar(300) NOT NULL DEFAULT '' COMMENT '日记账行号 ',
  `approval_status` varchar(20) NOT NULL DEFAULT '' COMMENT '审批状态 ',
  `posted_status` varchar(20) NOT NULL DEFAULT '' COMMENT '过账 ',
  `account_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '会计期间 yyyymm',
  `accounting_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '凭证日期 ',
  `journal_source` varchar(20) NOT NULL DEFAULT '' COMMENT '日记账来源 ',
  `category` varchar(50) NOT NULL DEFAULT '' COMMENT '日记账类别 ',
  `name` varchar(300) NOT NULL DEFAULT '' COMMENT '日记账名称 ',
  `voucher_num` varchar(128) NOT NULL DEFAULT '' COMMENT '凭证编号 ',
  `description` varchar(500) NOT NULL DEFAULT '' COMMENT '摘要 ',
  `org_code` varchar(300) NOT NULL DEFAULT '' COMMENT '主体代码 ',
  `subject_code` varchar(300) NOT NULL DEFAULT '' COMMENT '科目代码 ',
  `org_name` varchar(300) NOT NULL DEFAULT '' COMMENT '主体说明 ',
  `subject_name` varchar(300) NOT NULL DEFAULT '' COMMENT '科目说明 ',
  `accounted_dr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '借方金额 ',
  `accounted_cr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '贷方金额 ',
  `created_by` varchar(300) NOT NULL DEFAULT '' COMMENT '创建人 ',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期 ',
  `late_updated_by` varchar(300) NOT NULL DEFAULT '' COMMENT '最后更新人 ',
  `late_updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后更新日期 ',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间 ',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间 ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='CIT日记账调整版';

-- ----------------------------
-- Table structure for cit_profit_prc_adjust
-- ----------------------------
DROP TABLE IF EXISTS `cit_profit_prc_adjust`;
CREATE TABLE `cit_profit_prc_adjust` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间yyyymm',
  `item_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目名称',
  `period_amt` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本期发生额',
  `ytd_amt` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本年累计',
  `create_by` varchar(100) NOT NULL DEFAULT '' COMMENT '创建人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='利润表表(单家PRC)调整';

-- ----------------------------
-- Table structure for cit_salary_advance
-- ----------------------------
DROP TABLE IF EXISTS `cit_salary_advance`;
CREATE TABLE `cit_salary_advance` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号 系统唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号 对应机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID ',
  `period` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源 GL',
  `po_no` varchar(22) NOT NULL DEFAULT '0' COMMENT 'PO号',
  `po_subject_code` varchar(128) NOT NULL DEFAULT '' COMMENT 'PO主体CODE',
  `po_subject_name` varchar(300) NOT NULL DEFAULT '' COMMENT 'PO主体名称',
  `advance` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '预提',
  `approved_standard_invoice_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '已批准标准发票金额',
  `created_by` varchar(300) NOT NULL DEFAULT '' COMMENT '创建人 ',
  `updated_by` varchar(300) NOT NULL DEFAULT '' COMMENT '最后更新人 ',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间 ',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间 ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='预提重分类数据源(工资薪金预提)';

-- ----------------------------
-- Table structure for cit_trial_balance
-- ----------------------------
DROP TABLE IF EXISTS `cit_trial_balance`;
CREATE TABLE `cit_trial_balance` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `account_code` varchar(300) NOT NULL DEFAULT '' COMMENT '科目代码',
  `account_description` varchar(300) NOT NULL DEFAULT '' COMMENT '科目说明',
  `account_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `beginning_balance` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '期初余额',
  `ending_balance` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '期末余额',
  `create_by` varchar(100) NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='CIT试算平衡表';

-- ----------------------------
-- Table structure for coupa_purchasing_report
-- ----------------------------
DROP TABLE IF EXISTS `coupa_purchasing_report`;
CREATE TABLE `coupa_purchasing_report` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `bill_num` varchar(300) NOT NULL DEFAULT '' COMMENT '账单',
  `company_code` varchar(300) NOT NULL DEFAULT '' COMMENT '机构代码',
  `billing_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记账日期',
  `invoice_num` varchar(50) NOT NULL DEFAULT '' COMMENT '发票编号',
  `line_num` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '行号',
  `head_up_status` varchar(20) NOT NULL DEFAULT '' COMMENT '抬头状态',
  `invoice_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发票日期',
  `invoice_receipt_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发票接收日期',
  `pay_expiration` varchar(20) NOT NULL DEFAULT '' COMMENT '付款期限',
  `purchase_order_num` varchar(300) NOT NULL DEFAULT '' COMMENT '采购订单号',
  `purchase_order_line_num` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '采购订单行号',
  `description` varchar(300) NOT NULL DEFAULT '' COMMENT '说明',
  `supplier_num` varchar(20) NOT NULL DEFAULT '' COMMENT '供应商号',
  `supplier` varchar(300) NOT NULL DEFAULT '' COMMENT '供应商',
  `total_amount` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '总计',
  `currency` varchar(20) NOT NULL DEFAULT '' COMMENT '货币',
  `paid` tinyint(1) NOT NULL DEFAULT '0' COMMENT '已付款',
  `amortization` tinyint(1) NOT NULL DEFAULT '0' COMMENT '摊销',
  `prepayments` tinyint(1) NOT NULL DEFAULT '0' COMMENT '预付款',
  `review_reason` varchar(300) NOT NULL DEFAULT '' COMMENT '审核原因',
  `commodity` varchar(300) NOT NULL DEFAULT '' COMMENT '商品',
  `commodity_code` varchar(50) NOT NULL DEFAULT '' COMMENT 'Commodity Code',
  `founder` varchar(50) NOT NULL DEFAULT '' COMMENT '创建人',
  `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `current_approver` varchar(50) NOT NULL DEFAULT '' COMMENT '当前批准人',
  `last_updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次更新日期',
  `last_updated_person` varchar(50) NOT NULL DEFAULT '' COMMENT '上次更新人',
  `total_tax_amount` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '总税额',
  `total_tax_amount_header` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '总计税额(抬头)',
  `billing_note` varchar(300) NOT NULL DEFAULT '' COMMENT 'Billing Note',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='coupa发票报告';

-- ----------------------------
-- Table structure for customer
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
  `id` varchar(128) NOT NULL,
  `code` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL DEFAULT '',
  `enter_prise_account_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `customer_code_IDX` (`code`,`enter_prise_account_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for data_import_log
-- ----------------------------
DROP TABLE IF EXISTS `data_import_log`;
CREATE TABLE `data_import_log` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号',
  `taxpayer_id_num` varchar(128) NOT NULL DEFAULT '' COMMENT '纳税人识别号',
  `type` tinyint(2) unsigned DEFAULT '0' COMMENT '导入类型。0-未定义,1-利润表,2-资产负债表',
  `company_code` varchar(300) NOT NULL DEFAULT '' COMMENT '公司代码',
  `company_name` varchar(300) NOT NULL DEFAULT '' COMMENT '公司名称',
  `file_type` varchar(20) NOT NULL DEFAULT '' COMMENT '文件类型',
  `period_year` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '年度',
  `tms_period_month` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间',
  `period_month` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `period_status` varchar(20) NOT NULL DEFAULT '' COMMENT 'Oracle期间状态',
  `operator` varchar(50) NOT NULL DEFAULT '' COMMENT '操作人',
  `operate_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间',
  `import_result` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '导入结果',
  `error_msg` varchar(300) NOT NULL DEFAULT '导入成功' COMMENT '校验问题',
  `record_size` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '记录条数',
  `display` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否为最新导入记录。0-不是,1-是 。写入新提交记录时更新旧的为0',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据校验日志记录。';

-- ----------------------------
-- Table structure for data_validate_log
-- ----------------------------
DROP TABLE IF EXISTS `data_validate_log`;
CREATE TABLE `data_validate_log` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目编号',
  `result` varchar(128) DEFAULT NULL COMMENT '结果信息',
  `period` varchar(128) NOT NULL DEFAULT '' COMMENT '期间',
  `validate_result` varchar(300) DEFAULT '' COMMENT '校验结果(end  or error )',
  `validate_user` varchar(300) NOT NULL DEFAULT '' COMMENT '校验人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据校验日志记录。';

-- ----------------------------
-- Table structure for dictionary
-- ----------------------------
DROP TABLE IF EXISTS `dictionary`;
CREATE TABLE `dictionary` (
  `id` varchar(128) NOT NULL,
  `code` varchar(200) NOT NULL DEFAULT '',
  `dict_key` varchar(200) NOT NULL DEFAULT '',
  `dict_value` varchar(500) NOT NULL DEFAULT '',
  `parent_code` varchar(200) DEFAULT '',
  `order_index` int(10) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `remark` varchar(500) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for dimension
-- ----------------------------
DROP TABLE IF EXISTS `dimension`;
CREATE TABLE `dimension` (
  `id` varchar(128) NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `attribute_id` varchar(128) DEFAULT '',
  `order_index` int(5) NOT NULL DEFAULT '0',
  `is_mandatory` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `is_system_dimension` tinyint(1) NOT NULL DEFAULT '0',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `dimension_attribute_id_IDX` (`attribute_id`,`is_active`,`is_system_dimension`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for dimension_value
-- ----------------------------
DROP TABLE IF EXISTS `dimension_value`;
CREATE TABLE `dimension_value` (
  `id` varchar(128) NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `dimension_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `dimension_value_name_IDX` (`name`,`is_active`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for dimension_value_org
-- ----------------------------
DROP TABLE IF EXISTS `dimension_value_org`;
CREATE TABLE `dimension_value_org` (
  `id` varchar(128) NOT NULL,
  `dimension_value_id` varchar(128) NOT NULL DEFAULT '',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dimension_value_org_dimension_value_id_IDX` (`dimension_value_id`,`organization_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for enterprise_account
-- ----------------------------
DROP TABLE IF EXISTS `enterprise_account`;
CREATE TABLE `enterprise_account` (
  `id` varchar(128) NOT NULL,
  `code` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(200) NOT NULL DEFAULT '',
  `parent_code` varchar(50) DEFAULT '',
  `full_name` varchar(200) DEFAULT '',
  `acct_prop` int(10) DEFAULT '0',
  `sub_prop` int(10) DEFAULT '0',
  `acct_level` int(10) DEFAULT '0',
  `direction` int(10) NOT NULL DEFAULT '0',
  `is_leaf` tinyint(1) NOT NULL DEFAULT '0',
  `rule_type` int(10) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `english_name` varchar(200) DEFAULT '',
  `std_code` varchar(50) DEFAULT '',
  `enterprise_account_set_id` varchar(128) NOT NULL DEFAULT '',
  `creator_id` varchar(128) NOT NULL DEFAULT '',
  `updator_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `enterprise_account_acct_level_IDX` (`acct_level`,`enterprise_account_set_id`) USING BTREE,
  KEY `enterprise_account_code_IDX` (`code`) USING BTREE,
  KEY `enterprise_account_parent_code_IDX` (`parent_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for enterprise_account_set
-- ----------------------------
DROP TABLE IF EXISTS `enterprise_account_set`;
CREATE TABLE `enterprise_account_set` (
  `id` varchar(128) NOT NULL,
  `code` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(500) NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `creator_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `enterprise_account_set_name_IDX` (`name`) USING BTREE,
  KEY `enterprise_account_set_code_IDX` (`code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for enterprise_account_set_org
-- ----------------------------
DROP TABLE IF EXISTS `enterprise_account_set_org`;
CREATE TABLE `enterprise_account_set_org` (
  `id` varchar(128) NOT NULL,
  `enterprise_account_set_id` varchar(128) NOT NULL DEFAULT '',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `effective_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `expired_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `enterprise_account_set_org_enterprise_account_set_id_IDX` (`enterprise_account_set_id`,`organization_id`,`effective_date`,`expired_date`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for equity_information
-- ----------------------------
DROP TABLE IF EXISTS `equity_information`;
CREATE TABLE `equity_information` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `e_num` int(4) NOT NULL COMMENT '股权信息序号。从1开始',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '对应机构编号',
  `investor_name` varchar(200) DEFAULT '' COMMENT '投资方名称。表格里的文本框',
  `investor_economic_nature` varchar(500) DEFAULT '' COMMENT '投资方经济性质',
  `certificate_type` varchar(20) DEFAULT '' COMMENT '证件类型',
  `id_num` varchar(30) DEFAULT '' COMMENT '证件号码.',
  `investment_amount` bigint(22) DEFAULT '0' COMMENT '投资金额.',
  `investment_currency` varchar(10) DEFAULT '' COMMENT '投资金额币种.',
  `investment_radio` float DEFAULT '0' COMMENT '投资比例',
  `payable_shareholder_name` varchar(200) DEFAULT '' COMMENT '实缴股东名称.',
  `payable_shareholder_id_num` varchar(100) DEFAULT '' COMMENT '实缴股东证件编号',
  `payable_capital_contribution_amount` bigint(22) DEFAULT '0' COMMENT '实缴出资金额',
  `payable_capital_contribution_currency` varchar(10) DEFAULT '' COMMENT '实缴出资币种',
  `payable_contribution_proportion` float DEFAULT '0' COMMENT '实缴出资比例。百分比,多个股东合计为100%',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`,`e_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='股权信息表';

-- ----------------------------
-- Table structure for equity_information_history
-- ----------------------------
DROP TABLE IF EXISTS `equity_information_history`;
CREATE TABLE `equity_information_history` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `e_num` int(4) NOT NULL COMMENT '股权信息序号。从1开始',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '对应机构编号',
  `investor_name` varchar(200) DEFAULT '' COMMENT '投资方名称。表格里的文本框',
  `investor_economic_nature` varchar(500) DEFAULT '' COMMENT '投资方经济性质',
  `certificate_type` varchar(20) DEFAULT '' COMMENT '证件类型',
  `id_num` varchar(30) DEFAULT '' COMMENT '证件号码.',
  `investment_amount` bigint(22) DEFAULT '0' COMMENT '投资金额.',
  `investment_currency` varchar(10) DEFAULT '' COMMENT '投资金额币种.',
  `investment_radio` float DEFAULT '0' COMMENT '投资比例',
  `payable_shareholder_name` varchar(200) DEFAULT '' COMMENT '实缴股东名称.',
  `payable_shareholder_id_num` varchar(100) DEFAULT '' COMMENT '实缴股东证件编号',
  `payable_capital_contribution_amount` bigint(22) DEFAULT '0' COMMENT '实缴出资金额',
  `payable_capital_contribution_currency` varchar(10) DEFAULT '' COMMENT '实缴出资币种',
  `payable_contribution_proportion` float DEFAULT '0' COMMENT '实缴出资比例。百分比,多个股东合计为100%',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`,`e_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='股权信息表-历史表';

-- ----------------------------
-- Table structure for formula_config
-- ----------------------------
DROP TABLE IF EXISTS `formula_config`;
CREATE TABLE `formula_config` (
  `id` varchar(128) NOT NULL,
  `formula_name` varchar(500) NOT NULL DEFAULT '',
  `description` varchar(500) NOT NULL DEFAULT '',
  `calculate_status` int(10) NOT NULL DEFAULT '0',
  `data_source_type` int(10) DEFAULT '0',
  `data_source_name` varchar(500) DEFAULT '',
  `chinese_name` varchar(500) DEFAULT '',
  `english_name` varchar(500) DEFAULT '',
  `service_type` varchar(128) DEFAULT '',
  `industry` varchar(128) DEFAULT '',
  `required_param_num` int(10) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `formula_config_formula_name_IDX` (`formula_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for formula_param_config
-- ----------------------------
DROP TABLE IF EXISTS `formula_param_config`;
CREATE TABLE `formula_param_config` (
  `id` varchar(128) NOT NULL,
  `name` varchar(500) NOT NULL DEFAULT '',
  `display_format` varchar(500) DEFAULT '',
  `param_type` int(10) NOT NULL DEFAULT '0',
  `param_data_type` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `formula_param_config_name_IDX` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for formula_param_mapping
-- ----------------------------
DROP TABLE IF EXISTS `formula_param_mapping`;
CREATE TABLE `formula_param_mapping` (
  `id` varchar(128) NOT NULL,
  `formula_id` varchar(128) NOT NULL DEFAULT '',
  `formula_param_id` varchar(128) NOT NULL DEFAULT '',
  `param_index` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `formula_param_mapping_formula_id_UIDX` (`formula_id`,`formula_param_id`,`param_index`) USING BTREE,
  UNIQUE KEY `formula_param_mapping_formula_id_IDX` (`formula_id`,`formula_param_id`,`param_index`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for formula_param_option
-- ----------------------------
DROP TABLE IF EXISTS `formula_param_option`;
CREATE TABLE `formula_param_option` (
  `id` varchar(128) NOT NULL,
  `formula_param_id` varchar(128) NOT NULL DEFAULT '',
  `value` varchar(500) NOT NULL DEFAULT '',
  `name` varchar(500) NOT NULL DEFAULT '',
  `short_name` varchar(500) NOT NULL DEFAULT '',
  `option_index` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for gl_balance
-- ----------------------------
DROP TABLE IF EXISTS `gl_balance`;
CREATE TABLE `gl_balance` (
  `id` bigint(22) DEFAULT NULL,
  `code_combination_id` bigint(22) DEFAULT NULL,
  `code_combination_code` varchar(300) DEFAULT NULL,
  `code_combination_description` varchar(300) DEFAULT NULL,
  `attribute12` varchar(300) DEFAULT NULL,
  `segment1` varchar(300) DEFAULT NULL,
  `segment2` varchar(300) DEFAULT NULL,
  `segment3` varchar(300) DEFAULT NULL,
  `segment4` varchar(300) DEFAULT NULL,
  `segment5` varchar(300) DEFAULT NULL,
  `segment6` varchar(300) DEFAULT NULL,
  `segment7` varchar(300) DEFAULT NULL,
  `period_name` varchar(10) DEFAULT NULL,
  `begin_dr_balance` bigint(22) DEFAULT NULL,
  `begin_cr_balance` bigint(22) DEFAULT NULL,
  `ptd_dr` bigint(22) DEFAULT NULL,
  `ptd_cr` bigint(22) DEFAULT NULL,
  `ytd_dr` bigint(22) DEFAULT NULL,
  `ytd_cr` bigint(22) DEFAULT NULL,
  `end_dr_balance` bigint(22) DEFAULT NULL,
  `end_cr_balance` bigint(22) DEFAULT NULL,
  `attr1` varchar(300) DEFAULT NULL,
  `attr2` varchar(300) DEFAULT NULL,
  `attr3` varchar(300) DEFAULT NULL,
  `attr4` varchar(300) DEFAULT NULL,
  `attr5` varchar(300) DEFAULT NULL,
  UNIQUE KEY `gl_balance_id_IDX` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for industry
-- ----------------------------
DROP TABLE IF EXISTS `industry`;
CREATE TABLE `industry` (
  `id` varchar(128) NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `english_name` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for input_ap_invoice
-- ----------------------------
DROP TABLE IF EXISTS `input_ap_invoice`;
CREATE TABLE `input_ap_invoice` (
  `id` bigint(18) NOT NULL,
  `operation_unit_id` int(11) NOT NULL DEFAULT '0',
  `operation_name` varchar(240) NOT NULL DEFAULT '',
  `invoice_type_lookup_code` varchar(240) NOT NULL DEFAULT '',
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `invoice_num` varchar(50) NOT NULL DEFAULT '',
  `vendor_id` int(11) NOT NULL DEFAULT '0',
  `vendor_number` varchar(30) NOT NULL DEFAULT '',
  `vendor_name` varchar(240) NOT NULL DEFAULT '',
  `vendor_site_id` int(11) NOT NULL DEFAULT '0',
  `vendor_site_code` varchar(15) NOT NULL DEFAULT '',
  `invoice_date` varchar(10) NOT NULL DEFAULT '',
  `invoice_currency_code` varchar(15) NOT NULL DEFAULT '',
  `invoice_amount` decimal(18,4) NOT NULL DEFAULT '0.0000',
  `total_tax_amount` decimal(18,4) NOT NULL DEFAULT '0.0000',
  `gl_date` varchar(10) NOT NULL DEFAULT '',
  `payment_currency_code` varchar(15) NOT NULL DEFAULT '',
  `payment_cross_rate_date` varchar(10) NOT NULL DEFAULT '',
  `exchange_rate_yype` varchar(30) NOT NULL DEFAULT '',
  `exchange_date` varchar(10) NOT NULL DEFAULT '',
  `exchange_rate` decimal(18,4) NOT NULL DEFAULT '0.0000',
  `description` varchar(240) NOT NULL DEFAULT '',
  `terms_name` varchar(50) NOT NULL DEFAULT '',
  `terms_date` varchar(10) NOT NULL DEFAULT '',
  `payment_method_code` varchar(30) NOT NULL DEFAULT '',
  `taxation_country` varchar(30) NOT NULL DEFAULT '',
  `tax_business_category` varchar(240) NOT NULL DEFAULT '',
  `invoice_status` varchar(240) NOT NULL DEFAULT '',
  `source` varchar(25) NOT NULL DEFAULT '',
  `created_by_name` varchar(240) NOT NULL DEFAULT '',
  `attribute1` varchar(240) NOT NULL DEFAULT '',
  `attribute2` varchar(240) NOT NULL DEFAULT '',
  `attribute3` varchar(240) NOT NULL DEFAULT '',
  `attribute4` varchar(240) NOT NULL DEFAULT '',
  `attribute5` varchar(240) NOT NULL DEFAULT '',
  `attribute6` varchar(240) NOT NULL DEFAULT '',
  `attribute7` varchar(240) NOT NULL DEFAULT '',
  `attribute8` varchar(240) NOT NULL DEFAULT '',
  `attribute9` varchar(240) NOT NULL DEFAULT '',
  `attribute10` varchar(240) NOT NULL DEFAULT '',
  `attribute11` varchar(240) NOT NULL DEFAULT '',
  `attribute12` varchar(240) NOT NULL DEFAULT '',
  `attribute13` varchar(240) NOT NULL DEFAULT '',
  `attribute14` varchar(240) NOT NULL DEFAULT '',
  `attribute15` varchar(240) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `attr4` varchar(240) NOT NULL DEFAULT '',
  `attr5` varchar(240) NOT NULL DEFAULT '',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for input_invoice
-- ----------------------------
DROP TABLE IF EXISTS `input_invoice`;
CREATE TABLE `input_invoice` (
  `ID` varchar(255) NOT NULL,
  `BLYY` varchar(255) DEFAULT NULL,
  `BZ` varchar(255) DEFAULT NULL,
  `CJSJ` varchar(255) DEFAULT NULL,
  `COMPANYID` varchar(255) DEFAULT NULL,
  `CYZT` varchar(255) DEFAULT NULL,
  `DZDH` varchar(255) DEFAULT NULL,
  `FHR` varchar(255) DEFAULT NULL,
  `FPDM` varchar(255) DEFAULT NULL,
  `FPHM` varchar(255) DEFAULT NULL,
  `FPLC` varchar(255) DEFAULT NULL,
  `FPLX` varchar(255) DEFAULT NULL,
  `FPYX` varchar(255) DEFAULT NULL,
  `FPZT` varchar(255) DEFAULT NULL,
  `GFDZDH` varchar(255) DEFAULT NULL,
  `GFMC` varchar(255) DEFAULT NULL,
  `GFSH` varchar(255) DEFAULT NULL,
  `GFYHZH` varchar(255) DEFAULT NULL,
  `HJJE` varchar(255) DEFAULT NULL,
  `HJSE` varchar(255) DEFAULT NULL,
  `JQBH` varchar(255) DEFAULT NULL,
  `JSHJ` varchar(255) DEFAULT NULL,
  `JYM` varchar(255) DEFAULT NULL,
  `KPR` varchar(255) DEFAULT NULL,
  `KPRQ` varchar(255) DEFAULT NULL,
  `LCBH` varchar(255) DEFAULT NULL,
  `LRRQ` varchar(255) DEFAULT NULL,
  `MWQ` varchar(255) DEFAULT NULL,
  `PZH` varchar(255) DEFAULT NULL,
  `RZJG` varchar(255) DEFAULT NULL,
  `RZJGMS` varchar(255) DEFAULT NULL,
  `RZSJ` varchar(255) DEFAULT NULL,
  `RZSQ` varchar(255) DEFAULT NULL,
  `RZZT` varchar(255) DEFAULT NULL,
  `SKR` varchar(255) DEFAULT NULL,
  `XFDZDH` varchar(255) DEFAULT NULL,
  `XFMC` varchar(255) DEFAULT NULL,
  `XFSH` varchar(255) DEFAULT NULL,
  `XFYHZH` varchar(255) DEFAULT NULL,
  `XTLY` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for input_material_item
-- ----------------------------
DROP TABLE IF EXISTS `input_material_item`;
CREATE TABLE `input_material_item` (
  `id` bigint(18) NOT NULL,
  `org_code` varchar(10) NOT NULL DEFAULT '',
  `item_number` varchar(40) NOT NULL DEFAULT '',
  `item_desc_zhs` varchar(240) NOT NULL DEFAULT '',
  `item_desc_us` varchar(240) NOT NULL DEFAULT '',
  `item_long_desc_zhs` varchar(4000) NOT NULL DEFAULT '',
  `item_long_desc_us` varchar(4000) NOT NULL DEFAULT '',
  `primary_unit_of_measure` varchar(10) NOT NULL DEFAULT '',
  `unit_of_measure` varchar(10) NOT NULL DEFAULT '',
  `lot_control` varchar(5) NOT NULL DEFAULT '',
  `shelflife_days` int(11) NOT NULL DEFAULT '0',
  `item_status` varchar(10) NOT NULL DEFAULT '',
  `stock_enable_flag` varchar(5) NOT NULL DEFAULT '',
  `purchasing_enable_flag` varchar(5) NOT NULL DEFAULT '',
  `must_approve_vendor` varchar(5) NOT NULL DEFAULT '',
  `default_buyer_num` varchar(30) NOT NULL DEFAULT '',
  `default_buyer` varchar(100) NOT NULL DEFAULT '',
  `bom_enabled_flag` varchar(5) NOT NULL DEFAULT '',
  `build_in_wip_flag` varchar(5) NOT NULL DEFAULT '',
  `custmoer_order_flag` varchar(5) NOT NULL DEFAULT '',
  `internal_order_flag` varchar(5) NOT NULL DEFAULT '',
  `invoiced_enable_flag` varchar(5) NOT NULL DEFAULT '',
  `transaction_enable_flag` varchar(5) NOT NULL DEFAULT '',
  `receive_routing_id` varchar(5) NOT NULL DEFAULT '',
  `extend_attributes` varchar(4000) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `attr4` varchar(240) NOT NULL DEFAULT '',
  `attr5` varchar(240) NOT NULL DEFAULT '',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `item_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for input_material_item_category
-- ----------------------------
DROP TABLE IF EXISTS `input_material_item_category`;
CREATE TABLE `input_material_item_category` (
  `id` bigint(18) NOT NULL,
  `material_item_id` bigint(18) NOT NULL DEFAULT '0',
  `category_set_code` varchar(30) NOT NULL DEFAULT '',
  `category_set_name_zhs` varchar(240) NOT NULL DEFAULT '',
  `category_set_name_us` varchar(240) NOT NULL DEFAULT '',
  `set_value` varchar(80) NOT NULL DEFAULT '',
  `set_value_desc_zhs` varchar(800) NOT NULL DEFAULT '',
  `set_value_desc_us` varchar(800) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for input_vendor
-- ----------------------------
DROP TABLE IF EXISTS `input_vendor`;
CREATE TABLE `input_vendor` (
  `id` bigint(18) NOT NULL,
  `vendor_id` varchar(60) NOT NULL DEFAULT '',
  `vendor_class` varchar(60) NOT NULL DEFAULT '',
  `vendor_code` varchar(40) NOT NULL DEFAULT '',
  `vendor_name` varchar(240) NOT NULL DEFAULT '',
  `vendor_alt_name` varchar(320) NOT NULL DEFAULT '',
  `vendor_address` varchar(240) NOT NULL DEFAULT '',
  `law_person` varchar(100) NOT NULL DEFAULT '',
  `pay_tax_num` varchar(40) NOT NULL DEFAULT '',
  `payment_term` varchar(80) NOT NULL DEFAULT '',
  `payment_method` varchar(80) NOT NULL DEFAULT '',
  `enable_flag` varchar(10) NOT NULL DEFAULT '',
  `internal_comm_com_code` varchar(60) NOT NULL DEFAULT '',
  `internalc_omm_company` varchar(240) NOT NULL DEFAULT '',
  `origin_vendor_code` varchar(60) NOT NULL DEFAULT '',
  `origin_vendo_name` varchar(240) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `internal_com_tax_ref` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for input_vendor_address
-- ----------------------------
DROP TABLE IF EXISTS `input_vendor_address`;
CREATE TABLE `input_vendor_address` (
  `id` bigint(18) NOT NULL,
  `vendor_id` bigint(18) NOT NULL DEFAULT '0',
  `party_site_id` varchar(60) NOT NULL DEFAULT '',
  `address_name` varchar(40) NOT NULL DEFAULT '',
  `country` varchar(10) NOT NULL DEFAULT '',
  `province` varchar(30) NOT NULL DEFAULT '',
  `city` varchar(80) NOT NULL DEFAULT '',
  `county` varchar(100) NOT NULL DEFAULT '',
  `detail_address` varchar(320) NOT NULL DEFAULT '',
  `purchase_flag` varchar(5) NOT NULL DEFAULT '',
  `payment_flag` varchar(5) NOT NULL DEFAULT '',
  `rfq_only_flag` varchar(5) NOT NULL DEFAULT '',
  `enabled_flag` varchar(10) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for input_vendor_bank_account
-- ----------------------------
DROP TABLE IF EXISTS `input_vendor_bank_account`;
CREATE TABLE `input_vendor_bank_account` (
  `id` bigint(18) NOT NULL,
  `vendor_id` bigint(18) NOT NULL DEFAULT '0',
  `bank_code` varchar(40) NOT NULL DEFAULT '',
  `bank_name` varchar(240) NOT NULL DEFAULT '',
  `branch_bank_code` varchar(40) NOT NULL DEFAULT '',
  `branch_bank_name` varchar(240) NOT NULL DEFAULT '',
  `bank_account_name` varchar(120) NOT NULL DEFAULT '',
  `bank_account_number` varchar(40) NOT NULL DEFAULT '',
  `currency_code` varchar(10) NOT NULL DEFAULT '',
  `primary_bank_account` varchar(10) NOT NULL DEFAULT '',
  `enabled_flag` varchar(10) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for input_vendor_contactor
-- ----------------------------
DROP TABLE IF EXISTS `input_vendor_contactor`;
CREATE TABLE `input_vendor_contactor` (
  `id` bigint(18) NOT NULL,
  `vendor_id` bigint(18) NOT NULL DEFAULT '0',
  `contact_party_id` varchar(60) NOT NULL DEFAULT '',
  `contractor_name` varchar(100) NOT NULL DEFAULT '',
  `phon_number` varchar(30) NOT NULL DEFAULT '',
  `email_address` varchar(40) NOT NULL DEFAULT '',
  `disable_date` varchar(30) NOT NULL DEFAULT '',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for input_vendor_site
-- ----------------------------
DROP TABLE IF EXISTS `input_vendor_site`;
CREATE TABLE `input_vendor_site` (
  `id` bigint(18) NOT NULL,
  `vendor_id` bigint(18) NOT NULL DEFAULT '0',
  `vendor_site_id` varchar(60) NOT NULL DEFAULT '',
  `address_name` varchar(60) NOT NULL DEFAULT '',
  `operate_unit` varchar(30) NOT NULL DEFAULT '',
  `operate_unit_name` varchar(120) NOT NULL DEFAULT '',
  `ship_to_location` varchar(80) NOT NULL DEFAULT '',
  `bill_to_location` varchar(80) NOT NULL DEFAULT '',
  `ship_method` varchar(60) NOT NULL DEFAULT '',
  `payment_method` varchar(60) NOT NULL DEFAULT '',
  `invoice_match_option` varchar(60) NOT NULL DEFAULT '',
  `payment_currency` varchar(10) NOT NULL DEFAULT '',
  `liability_accounts` varchar(80) NOT NULL DEFAULT '',
  `advance_account` varchar(80) NOT NULL DEFAULT '',
  `bill_account` varchar(80) NOT NULL DEFAULT '',
  `disable_date` varchar(30) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for invoice_data
-- ----------------------------
DROP TABLE IF EXISTS `invoice_data`;
CREATE TABLE `invoice_data` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `company_code` varchar(300) NOT NULL DEFAULT '' COMMENT '机构代码',
  `company_name` varchar(300) NOT NULL DEFAULT '' COMMENT '机构名称',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `count_type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '计数类型',
  `special_invoice_amount1` bigint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专票正数发票份数',
  `special_invoice_amount2` bigint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专票负数发票份数',
  `special_invoice_amount3` bigint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专票正数废票份数',
  `special_invoice_amount4` bigint(8) unsigned NOT NULL DEFAULT '0' COMMENT '专票负数废票份数',
  `special_invoice_sales_amount1` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '专票销项正废金额',
  `special_invoice_sales_amount2` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '专票销项正数金额',
  `special_invoice_sales_amount3` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '专票销项负废金额',
  `special_invoice_sales_amount4` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '专票销项负数金额',
  `special_invoice_sales_amount5` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '专票实际销项金额',
  `special_invoice_tax_amount1` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '专票销项正废税额',
  `special_invoice_tax_amount2` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '专票销项正数税额',
  `special_invoice_tax_amount3` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '专票销项负废税额',
  `special_invoice_tax_amount4` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '专票销项负数税额',
  `special_invoice_tax_amount5` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '专票实际销项税额',
  `invoice_amount1` bigint(8) unsigned NOT NULL DEFAULT '0' COMMENT '普票正数发票份数',
  `invoice_amount2` bigint(8) unsigned NOT NULL DEFAULT '0' COMMENT '普票负数发票份数',
  `invoice_amount3` bigint(8) unsigned NOT NULL DEFAULT '0' COMMENT '普票正数废票份数',
  `invoice_amount4` bigint(8) unsigned NOT NULL DEFAULT '0' COMMENT '普票负数废票份数',
  `invoice_sales_amount1` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '普票销项正废金额',
  `invoice_sales_amount2` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '普票销项正数金额',
  `invoice_sales_amount3` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '普票销项负废金额',
  `invoice_sales_amount4` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '普票销项负数金额',
  `invoice_sales_amount5` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '普票实际销项金额',
  `invoice_tax_amount1` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '普票销项正废税额',
  `invoice_tax_amount2` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '普票销项正数税额',
  `invoice_tax_amount3` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '普票销项负废税额',
  `invoice_tax_amount4` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '普票销项负数税额',
  `invoice_tax_amount5` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '普票实际销项税额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='发票资料';

-- ----------------------------
-- Table structure for invoice_record
-- ----------------------------
DROP TABLE IF EXISTS `invoice_record`;
CREATE TABLE `invoice_record` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `seq_no` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '序号',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源',
  `billing_body` varchar(128) NOT NULL DEFAULT '' COMMENT '开票主体',
  `customer_company_name` varchar(128) NOT NULL DEFAULT '' COMMENT '客户公司名称',
  `invoice_type` varchar(128) NOT NULL DEFAULT '' COMMENT '发票类型',
  `billing_content` varchar(128) NOT NULL DEFAULT '' COMMENT '开票内容',
  `invoice_amount` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '开票金额',
  `applicant` varchar(128) NOT NULL DEFAULT '' COMMENT '申请人',
  `oa_application_num` varchar(128) NOT NULL DEFAULT '' COMMENT 'OA申请单号',
  `contract_no` varchar(128) NOT NULL DEFAULT '' COMMENT '合同编号',
  `contract_amount` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '合同金额',
  `department` varchar(128) NOT NULL DEFAULT '' COMMENT '所属部门',
  `application_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '申请日期',
  `billing_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开票日期',
  `billing_month` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开票月份',
  `invoice_code` varchar(128) NOT NULL DEFAULT '' COMMENT '发票代码',
  `invoice_num` varchar(128) NOT NULL DEFAULT '' COMMENT '发票号码',
  `invoices_amount` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '发票张数',
  `customer_company_tax_num` varchar(300) NOT NULL DEFAULT '' COMMENT '客户公司税号',
  `contract_source_system` varchar(300) NOT NULL DEFAULT '' COMMENT '合同来源系统',
  `tax_rate` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '税率',
  `tax_amount` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '税额',
  `invoice_status` varchar(20) NOT NULL DEFAULT '' COMMENT '发票状态',
  `remarks` varchar(500) NOT NULL DEFAULT '' COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='已开增值税发票记录';

-- ----------------------------
-- Table structure for journal_entry
-- ----------------------------
DROP TABLE IF EXISTS `journal_entry`;
CREATE TABLE `journal_entry` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号 系统唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号 对应机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID ',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期 ',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源 GL',
  `ledger_id` varchar(128) NOT NULL DEFAULT '' COMMENT '账套ID ',
  `ledger_name` varchar(300) NOT NULL DEFAULT '' COMMENT '账套名称 ',
  `currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '账套币种 ',
  `status` varchar(10) NOT NULL DEFAULT '' COMMENT '关账标识 Y/N',
  `header_id` varchar(128) NOT NULL DEFAULT '' COMMENT '日记账头ID ',
  `line_num` varchar(300) NOT NULL DEFAULT '' COMMENT '日记账行号 ',
  `approval_status` varchar(20) NOT NULL DEFAULT '' COMMENT '审批状态 ',
  `posted_status` varchar(20) NOT NULL DEFAULT '' COMMENT '过账 ',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '会计期间 yyyymm',
  `accounting_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '凭证日期 ',
  `journal_source` varchar(20) NOT NULL DEFAULT '' COMMENT '日记账来源 ',
  `category` varchar(50) NOT NULL DEFAULT '' COMMENT '日记账类别 ',
  `name` varchar(300) NOT NULL DEFAULT '' COMMENT '日记账名称 ',
  `voucher_num` varchar(128) NOT NULL DEFAULT '' COMMENT '凭证编号 ',
  `description` varchar(500) NOT NULL DEFAULT '' COMMENT '摘要 ',
  `segment1` varchar(300) NOT NULL DEFAULT '' COMMENT '主体代码 ',
  `segment2` varchar(300) NOT NULL DEFAULT '' COMMENT '成本中心 ',
  `segment3` varchar(300) NOT NULL DEFAULT '' COMMENT '科目代码 ',
  `segment4` varchar(300) NOT NULL DEFAULT '' COMMENT '辅助科目 ',
  `segment5` varchar(300) NOT NULL DEFAULT '' COMMENT '利润中心 ',
  `segment6` varchar(300) NOT NULL DEFAULT '' COMMENT '产品 ',
  `segment7` varchar(300) NOT NULL DEFAULT '' COMMENT '项目 ',
  `segment8` varchar(300) NOT NULL DEFAULT '' COMMENT '公司间 ',
  `segment9` varchar(300) NOT NULL DEFAULT '' COMMENT '备用1 ',
  `segment10` varchar(300) NOT NULL DEFAULT '' COMMENT '备用2 ',
  `segment1_name` varchar(300) NOT NULL DEFAULT '' COMMENT '主体说明 ',
  `segment2_name` varchar(300) NOT NULL DEFAULT '' COMMENT '成本中心说明 ',
  `segment3_name` varchar(300) NOT NULL DEFAULT '' COMMENT '科目说明 ',
  `segment4_name` varchar(300) NOT NULL DEFAULT '' COMMENT '辅助科目说明 ',
  `segment5_name` varchar(300) NOT NULL DEFAULT '' COMMENT '利润中心说明 ',
  `segment6_name` varchar(300) NOT NULL DEFAULT '' COMMENT '产品说明 ',
  `segment7_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目说明 ',
  `segment8_name` varchar(300) NOT NULL DEFAULT '' COMMENT '公司间说明 ',
  `segment9_name` varchar(300) NOT NULL DEFAULT '' COMMENT '备用1说明 ',
  `segment10_name` varchar(300) NOT NULL DEFAULT '' COMMENT '备用2说明 ',
  `journal_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '币种 ',
  `sob_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '本位币币种 ',
  `accounted_dr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '借方金额 ',
  `accounted_cr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '贷方金额 ',
  `entered_dr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币借方金额 ',
  `entered_cr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币贷方金额 ',
  `cf_item` varchar(50) DEFAULT '' COMMENT '现金流量表项 ',
  `attribute1` varchar(300) DEFAULT '' COMMENT '城市 ',
  `attribute2` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '交易日期 ',
  `attribute3` varchar(300) DEFAULT '' COMMENT '对方银行账号 ',
  `attribute4` varchar(300) DEFAULT '' COMMENT '银行流水号 ',
  `attribute5` varchar(300) DEFAULT '' COMMENT '供应商编号 ',
  `attribute6` varchar(300) DEFAULT '' COMMENT '交易单号 ',
  `attribute7` varchar(300) DEFAULT '' COMMENT '供应商名称 ',
  `attribute8` varchar(300) DEFAULT '' COMMENT '接收编码 ',
  `attribute9` varchar(300) DEFAULT '' COMMENT '制单人 ',
  `attribute10` varchar(300) DEFAULT '' COMMENT '审核人 ',
  `attribute11` varchar(300) DEFAULT '' COMMENT '成本中心部门描述1 ',
  `attribute12` varchar(300) DEFAULT '' COMMENT '成本中心部门描述2 ',
  `attribute13` varchar(300) DEFAULT '' COMMENT '成本中心部门描述3 ',
  `attribute14` varchar(300) DEFAULT '' COMMENT '成本中心部门描述4 ',
  `attribute15` varchar(300) DEFAULT '' COMMENT '成本中心部门描述5 ',
  `attribute16` varchar(300) DEFAULT '' COMMENT '成本中心部门描述6 ',
  `created_by` varchar(300) NOT NULL DEFAULT '' COMMENT '创建人 ',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期 ',
  `late_updated_by` varchar(300) NOT NULL DEFAULT '' COMMENT '最后更新人 ',
  `late_updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后更新日期 ',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间 ',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间 ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='日记账。月度传送,次月传送上月一个期间数据,13期在关账时传送';

-- ----------------------------
-- Table structure for key_value_config
-- ----------------------------
DROP TABLE IF EXISTS `key_value_config`;
CREATE TABLE `key_value_config` (
  `id` varchar(128) NOT NULL,
  `key_code` varchar(500) NOT NULL DEFAULT '',
  `name` varchar(500) NOT NULL DEFAULT '',
  `key_value_type` int(10) NOT NULL DEFAULT '0',
  `formula` varchar(500) DEFAULT '',
  `is_constant` int(10) NOT NULL DEFAULT '0',
  `calculate_status` int(10) NOT NULL DEFAULT '0',
  `result_type` int(10) NOT NULL DEFAULT '0',
  `service_type_ids` varchar(200) NOT NULL DEFAULT '',
  `industry_ids` varchar(200) NOT NULL DEFAULT '',
  `description` varchar(500) DEFAULT '',
  `creator` varchar(128) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updator` varchar(128) DEFAULT '',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `data_source` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `key_value_config_key_code_IDX` (`key_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for key_value_reference
-- ----------------------------
DROP TABLE IF EXISTS `key_value_reference`;
CREATE TABLE `key_value_reference` (
  `id` varchar(128) NOT NULL,
  `key_value_config_id` varchar(128) NOT NULL DEFAULT '',
  `scope` int(10) NOT NULL DEFAULT '0',
  `cell_template_id` bigint(19) NOT NULL DEFAULT '0',
  `model_id` varchar(128) DEFAULT '',
  `organization_id` varchar(128) DEFAULT '',
  `industry_id` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `key_value_reference_organization_id_IDX` (`organization_id`,`industry_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` varchar(128) NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '',
  `route_state_name` varchar(200) DEFAULT '',
  `navigation_url` varchar(500) DEFAULT '',
  `icon_class_name` varchar(500) DEFAULT '',
  `parent_id` varchar(128) DEFAULT '',
  `order_index` int(10) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `is_visible` tinyint(1) NOT NULL DEFAULT '0',
  `service_type_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menu_name_IDX` (`name`) USING BTREE,
  KEY `menu_parent_id_IDX` (`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for model
-- ----------------------------
DROP TABLE IF EXISTS `model`;
CREATE TABLE `model` (
  `id` varchar(128) NOT NULL,
  `rule_type` int(10) NOT NULL DEFAULT '0',
  `code` varchar(20) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `type` int(10) NOT NULL DEFAULT '0',
  `is_status` int(10) NOT NULL DEFAULT '0',
  `description` varchar(500) DEFAULT '',
  `feature` int(10) NOT NULL DEFAULT '0',
  `is_filter` int(10) NOT NULL DEFAULT '0',
  `month_judge` varchar(200) DEFAULT '',
  `month_explain` varchar(200) DEFAULT '',
  `year_judge` varchar(200) DEFAULT '',
  `year_explain` varchar(200) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for model_category
-- ----------------------------
DROP TABLE IF EXISTS `model_category`;
CREATE TABLE `model_category` (
  `id` varchar(128) NOT NULL,
  `client_code` varchar(50) NOT NULL DEFAULT '',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `category` varchar(10) NOT NULL DEFAULT '',
  `parent_id` varchar(128) NOT NULL DEFAULT '',
  `sort` int(10) NOT NULL DEFAULT '0',
  `quantity` int(10) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `industry_id` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for model_config
-- ----------------------------
DROP TABLE IF EXISTS `model_config`;
CREATE TABLE `model_config` (
  `id` varchar(128) NOT NULL,
  `category_id` varchar(128) NOT NULL DEFAULT '',
  `model_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for model_service_config
-- ----------------------------
DROP TABLE IF EXISTS `model_service_config`;
CREATE TABLE `model_service_config` (
  `id` varchar(128) NOT NULL,
  `model_id` varchar(128) NOT NULL DEFAULT '',
  `service_type_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log
-- ----------------------------
DROP TABLE IF EXISTS `operation_log`;
CREATE TABLE `operation_log` (
  `id` varchar(128) DEFAULT NULL,
  `operation_object` varchar(50) DEFAULT NULL,
  `original_state` varchar(255) DEFAULT NULL,
  `update_state` varchar(255) DEFAULT NULL,
  `operation_description` varchar(255) DEFAULT NULL,
  `operation_by` varchar(128) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `oid` varchar(100) DEFAULT NULL,
  `module_id` bigint(22) DEFAULT NULL,
  `comment` varchar(4000) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log_basic_data
-- ----------------------------
DROP TABLE IF EXISTS `operation_log_basic_data`;
CREATE TABLE `operation_log_basic_data` (
  `id` varchar(128) NOT NULL,
  `operation_content` varchar(255) DEFAULT '',
  `module_name` varchar(255) NOT NULL DEFAULT '',
  `operation_object` varchar(100) NOT NULL DEFAULT '',
  `operation_action` varchar(100) NOT NULL DEFAULT '',
  `original_state` varchar(500) DEFAULT '',
  `update_state` varchar(500) DEFAULT '',
  `operation_user` varchar(50) NOT NULL DEFAULT '',
  `ip` varchar(50) NOT NULL DEFAULT '',
  `comment` varchar(500) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log_enter_prise
-- ----------------------------
DROP TABLE IF EXISTS `operation_log_enter_prise`;
CREATE TABLE `operation_log_enter_prise` (
  `id` varchar(128) NOT NULL,
  `operation_content` varchar(255) NOT NULL DEFAULT '',
  `module_name` varchar(255) NOT NULL DEFAULT '',
  `operation_object` varchar(100) NOT NULL DEFAULT '',
  `operation_action` varchar(100) NOT NULL DEFAULT '',
  `original_state` varchar(500) DEFAULT '',
  `update_state` varchar(500) DEFAULT '',
  `operation_user` varchar(50) NOT NULL DEFAULT '',
  `ip` varchar(50) NOT NULL DEFAULT '',
  `comment` varchar(500) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log_equity
-- ----------------------------
DROP TABLE IF EXISTS `operation_log_equity`;
CREATE TABLE `operation_log_equity` (
  `id` varchar(128) NOT NULL,
  `operation_content` varchar(255) NOT NULL DEFAULT '',
  `module_name` varchar(255) NOT NULL DEFAULT '',
  `operation_object` varchar(100) NOT NULL DEFAULT '',
  `operation_action` varchar(100) NOT NULL DEFAULT '',
  `original_state` varchar(500) DEFAULT '',
  `update_state` varchar(500) DEFAULT '',
  `operation_user` varchar(50) NOT NULL DEFAULT '',
  `ip` varchar(50) NOT NULL DEFAULT '',
  `comment` varchar(500) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log_keyvalue
-- ----------------------------
DROP TABLE IF EXISTS `operation_log_keyvalue`;
CREATE TABLE `operation_log_keyvalue` (
  `id` varchar(128) NOT NULL,
  `operation_content` varchar(255) DEFAULT '',
  `module_name` varchar(255) DEFAULT '',
  `operation_object` varchar(100) DEFAULT '',
  `operation_action` varchar(100) DEFAULT '',
  `original_state` varchar(500) DEFAULT '',
  `update_state` varchar(500) DEFAULT '',
  `operation_user` varchar(50) DEFAULT '',
  `ip` varchar(50) DEFAULT '',
  `comment` varchar(500) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log_organization
-- ----------------------------
DROP TABLE IF EXISTS `operation_log_organization`;
CREATE TABLE `operation_log_organization` (
  `id` varchar(128) NOT NULL,
  `operation_content` varchar(255) NOT NULL DEFAULT '' COMMENT '操作内容',
  `module_name` varchar(255) NOT NULL DEFAULT '' COMMENT '模块名',
  `operation_object` varchar(100) NOT NULL DEFAULT '' COMMENT '被操作对象',
  `operation_action` varchar(100) NOT NULL DEFAULT '' COMMENT '操作动作 eg:new, update',
  `original_state` varchar(500) DEFAULT '' COMMENT '原值',
  `update_state` varchar(500) DEFAULT '' COMMENT '修改的值',
  `operation_user` varchar(50) NOT NULL DEFAULT '' COMMENT '当前操作者',
  `ip` varchar(50) NOT NULL DEFAULT '',
  `comment` varchar(500) DEFAULT '' COMMENT '备注',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log_project
-- ----------------------------
DROP TABLE IF EXISTS `operation_log_project`;
CREATE TABLE `operation_log_project` (
  `id` varchar(128) DEFAULT NULL,
  `operation_content` varchar(2000) DEFAULT NULL,
  `module_name` varchar(255) DEFAULT NULL,
  `operation_object` varchar(100) DEFAULT NULL,
  `operation_action` varchar(100) DEFAULT NULL,
  `original_state` varchar(4000) DEFAULT NULL,
  `update_state` varchar(4000) DEFAULT NULL,
  `operation_user` varchar(50) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `comment` varchar(4000) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log_report
-- ----------------------------
DROP TABLE IF EXISTS `operation_log_report`;
CREATE TABLE `operation_log_report` (
  `id` varchar(128) DEFAULT NULL,
  `operation_content` varchar(255) DEFAULT NULL,
  `module_name` varchar(255) DEFAULT NULL,
  `operation_object` varchar(100) DEFAULT NULL,
  `operation_action` varchar(100) DEFAULT NULL,
  `original_state` varchar(4000) DEFAULT NULL,
  `update_state` varchar(4000) DEFAULT NULL,
  `operation_user` varchar(50) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `comment` varchar(4000) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log_role
-- ----------------------------
DROP TABLE IF EXISTS `operation_log_role`;
CREATE TABLE `operation_log_role` (
  `id` varchar(128) NOT NULL,
  `operation_content` varchar(255) DEFAULT '',
  `module_name` varchar(255) DEFAULT '',
  `operation_object` varchar(100) DEFAULT '',
  `operation_action` varchar(100) DEFAULT '',
  `original_state` varchar(500) DEFAULT '',
  `update_state` varchar(500) DEFAULT '',
  `operation_user` varchar(50) DEFAULT '',
  `ip` varchar(50) DEFAULT '',
  `comment` varchar(500) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log_rule_engine
-- ----------------------------
DROP TABLE IF EXISTS `operation_log_rule_engine`;
CREATE TABLE `operation_log_rule_engine` (
  `id` varchar(128) DEFAULT NULL,
  `operation_content` varchar(255) DEFAULT NULL,
  `module_name` varchar(255) DEFAULT NULL,
  `operation_object` varchar(100) DEFAULT NULL,
  `operation_action` varchar(100) DEFAULT NULL,
  `original_state` varchar(4000) DEFAULT NULL,
  `update_state` varchar(4000) DEFAULT NULL,
  `operation_user` varchar(50) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `comment` varchar(4000) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log_subject
-- ----------------------------
DROP TABLE IF EXISTS `operation_log_subject`;
CREATE TABLE `operation_log_subject` (
  `id` varchar(128) DEFAULT NULL,
  `operation_content` varchar(255) DEFAULT NULL,
  `module_name` varchar(255) DEFAULT NULL,
  `operation_object` varchar(100) DEFAULT NULL,
  `operation_action` varchar(100) DEFAULT NULL,
  `original_state` varchar(4000) DEFAULT NULL,
  `update_state` varchar(4000) DEFAULT NULL,
  `operation_user` varchar(50) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `comment` varchar(4000) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for operation_log_user
-- ----------------------------
DROP TABLE IF EXISTS `operation_log_user`;
CREATE TABLE `operation_log_user` (
  `id` varchar(128) NOT NULL,
  `operation_content` varchar(255) NOT NULL DEFAULT '',
  `module_name` varchar(255) NOT NULL DEFAULT '',
  `operation_object` varchar(100) NOT NULL DEFAULT '',
  `operation_action` varchar(100) NOT NULL DEFAULT '',
  `original_state` varchar(500) DEFAULT '',
  `update_state` varchar(500) DEFAULT '',
  `operation_user` varchar(50) NOT NULL DEFAULT '',
  `ip` varchar(50) NOT NULL DEFAULT '',
  `comment` varchar(500) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for organization
-- ----------------------------
DROP TABLE IF EXISTS `organization`;
CREATE TABLE `organization` (
  `id` varchar(128) NOT NULL,
  `client_code` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL DEFAULT '',
  `code` varchar(50) NOT NULL DEFAULT '',
  `parent_id` varchar(128) DEFAULT '',
  `tax_payer_number` varchar(50) DEFAULT '',
  `region_id` varchar(128) DEFAULT '',
  `structure_id` varchar(128) NOT NULL DEFAULT '',
  `industry_id` varchar(128) DEFAULT '',
  `business_unit_id` varchar(128) DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `p_level` int(10) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `area_id` varchar(128) DEFAULT '',
  `english_name` varchar(500) DEFAULT '',
  `abbreviation` varchar(50) DEFAULT '',
  `invoice_type` varchar(255) DEFAULT '',
  `legal_person_name` varchar(200) DEFAULT '',
  `manufacture_address` varchar(500) DEFAULT '',
  `register_address` varchar(500) DEFAULT '',
  `bank_account_name` varchar(200) DEFAULT '',
  `bank_account_number` varchar(128) DEFAULT '',
  `phone_number` varchar(100) DEFAULT '',
  `registration_type` varchar(200) DEFAULT '',
  `remark` varchar(500) DEFAULT '',
  `vehicle_routing_location` varchar(255) DEFAULT '',
  `ratepayer` varchar(10) DEFAULT '',
  `address` varchar(500) DEFAULT '',
  `foundation_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `registration_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `registration_location` varchar(500) DEFAULT '',
  `registration_capital` varchar(500) DEFAULT '' COMMENT '注册资本',
  `business_allotted_time_from` datetime DEFAULT CURRENT_TIMESTAMP,
  `business_allotted_time_to` datetime DEFAULT CURRENT_TIMESTAMP,
  `legal_code` varchar(500) DEFAULT '',
  `vehicleroutinglocation` varchar(255) DEFAULT '',
  `business_scope` varchar(1000) DEFAULT '' COMMENT '经营范围',
  `architecture_type` varchar(20) DEFAULT '' COMMENT '架构类型',
  `num_of_branches` tinyint(3) DEFAULT NULL COMMENT '分公司数量。税务系统自动计算无法更改,从主数据通过相同的总公司名称抓子公司再count;只有在总公司的时候自动更新数量,分公司则无此字段',
  `api_update_flag` tinyint(1) DEFAULT NULL COMMENT '接口更新标识',
  `effec_time_of_general_taxpayers` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '一般纳税人生效时间。2018年1月3日',
  `registration_location_en` varchar(500) DEFAULT '' COMMENT '注册地址(住所)英文',
  `paid_in_capital` varchar(500) DEFAULT '' COMMENT '实缴资本',
  `general_tax_payer_effective_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '一般纳税人生效时间.2018年1月3日',
  `oversea` tinyint(1) DEFAULT NULL COMMENT '是否为境外企业。0-境内企业,1-境外企业',
  `reg_status` varchar(20) DEFAULT '' COMMENT '工商登记状态.存续/注销中/已注销',
  `national_economic_industry` varchar(10) DEFAULT '' COMMENT '所属国民经济行业(填写代码)',
  `engage_national_prohibit_industry` tinyint(1) DEFAULT NULL COMMENT '从事国家限制或禁止行业',
  `logout_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '注销时间。',
  PRIMARY KEY (`id`),
  KEY `organization_client_code_IDX` (`client_code`,`code`,`parent_id`,`region_id`,`industry_id`,`business_unit_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for organization_accounting_rate
-- ----------------------------
DROP TABLE IF EXISTS `organization_accounting_rate`;
CREATE TABLE `organization_accounting_rate` (
  `id` bigint(22) NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间',
  `convertion_type` varchar(100) DEFAULT '' COMMENT '汇率类型',
  `currency_from` varchar(10) DEFAULT '' COMMENT '货币自',
  `currency_to` varchar(10) DEFAULT '' COMMENT '货币至',
  `start_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '期间始',
  `end_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '期间止.2015-05-02',
  `rate` float DEFAULT '0' COMMENT '入账汇率.6.66',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for organization_approved_levy_info
-- ----------------------------
DROP TABLE IF EXISTS `organization_approved_levy_info`;
CREATE TABLE `organization_approved_levy_info` (
  `id` bigint(22) NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号',
  `approved_levy_project` varchar(1000) DEFAULT '' COMMENT '核定征收项目',
  `approved_validity_period_start_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '核定有效期起',
  `approved_validity_period_end_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '核定有效期止',
  `approved_rate` tinyint(4) DEFAULT '0' COMMENT '核定税率',
  `approved_tax_period` varchar(10) DEFAULT '' COMMENT '核定纳税期限。月、季、年',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for organization_employee
-- ----------------------------
DROP TABLE IF EXISTS `organization_employee`;
CREATE TABLE `organization_employee` (
  `id` bigint(22) NOT NULL DEFAULT '0' COMMENT '系统唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `employees_num_start` int(9) DEFAULT NULL COMMENT '期初雇员人数',
  `employees_num_end` int(9) DEFAULT NULL COMMENT '期末雇员人数',
  `statistical_month` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '统计月份.2019/2',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='机构信息-雇员信息';

-- ----------------------------
-- Table structure for organization_extra
-- ----------------------------
DROP TABLE IF EXISTS `organization_extra`;
CREATE TABLE `organization_extra` (
  `id` bigint(22) NOT NULL COMMENT '系统唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号.对应机构编号',
  `unified_social_credit_code` varchar(50) NOT NULL DEFAULT '' COMMENT '统一社会信用代码.例:XR23T345DFG4562。与纳税人识别号一致,页面用纳税人识别号描述',
  `reg_financial_accounting_type` tinyint(1) DEFAULT NULL COMMENT '登记方式。1-独立 0-非独立',
  `tax_reg_status` varchar(20) DEFAULT '' COMMENT '税务登记状态',
  `tax_credit_rating` varchar(20) DEFAULT '' COMMENT '纳税信用评级.ABCD等等',
  `applicable_accounting_rule` varchar(20) DEFAULT '' COMMENT '适用会计制度.企业会计制度/金融企业会计制度/小企业会计准则/企业会计准则',
  `low_value_consumables_amortization_method` varchar(20) DEFAULT '' COMMENT '低值易耗品摊销方法.一次摊销法/分期摊销法/五五摊销法 ',
  `depreciation_method` varchar(20) DEFAULT '' COMMENT '折旧方法.年限平均法(直线法)/工作量法/年数总和法/双倍余额递减法',
  `accounting_software` varchar(20) DEFAULT '' COMMENT '会计核算软件. Oracle 或其他',
  `complete_record_total_institutions` tinyint(1) DEFAULT NULL COMMENT '是否完成总分机构备案.1-是,0-否',
  `tax_client_person_name` varchar(20) DEFAULT '' COMMENT '办税人姓名',
  `tax_client_person_phone_num` varchar(20) DEFAULT '' COMMENT '办税人电话',
  `tax_client_person_id_num` varchar(20) DEFAULT '' COMMENT '办税人身份证号',
  `ticket_holder_name` varchar(20) DEFAULT '' COMMENT '购票人姓名',
  `ticket_holder_phone_num` varchar(20) DEFAULT '' COMMENT '购票人电话',
  `national_tax_hall_address` varchar(500) DEFAULT '' COMMENT '主管税局地址(原国税)',
  `national_tax_administrator_name` varchar(100) DEFAULT '' COMMENT '主管税局名称(原国税)',
  `national_tax_administrator_phone_num` varchar(100) DEFAULT '' COMMENT '主管税局电话(原国税)',
  `local_tax_hall_address` varchar(500) DEFAULT '' COMMENT '主管税局地址(原地税)',
  `local_tax_administrator_name` varchar(100) DEFAULT '' COMMENT '主管税局名称(原地税)',
  `local_tax_administrator_phone_num` varchar(100) DEFAULT '' COMMENT '主管税局电话(原地税)',
  `eta_website` varchar(500) DEFAULT '' COMMENT '电子税局网址',
  `sign_tripartite_agreement` tinyint(1) DEFAULT NULL COMMENT '三方协议是否签订.1-是,0-否',
  `reporting_currency` varchar(50) DEFAULT '' COMMENT '记账本位币',
  `consolidation_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '并表期间',
  `fiscal_year_deadline` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '财年截止日.(国际化特有字段)',
  `tax_agent` varchar(100) DEFAULT '' COMMENT '税务代理',
  `tax_agent_contact` varchar(20) DEFAULT '' COMMENT '税务代理联系方式',
  `other_facts` varchar(1000) DEFAULT '' COMMENT '其他情况说明.(国际化特有字段)',
  `tax_return_business_type` int(4) DEFAULT NULL COMMENT '纳税申报企业类型.100/210/220/230/311/312(填写代码)',
  `small_meager_profit` tinyint(1) DEFAULT NULL COMMENT '小型微利企业.1是/0否',
  `listed_company` tinyint(1) unsigned DEFAULT NULL COMMENT '上市公司.1是-境内/是   0-境外/否',
  `applicable_accounting_standards_or_accounting_systems` int(4) DEFAULT NULL COMMENT '采用一般企业财务报表格式',
  `tax_payer_number_vat` varchar(50) DEFAULT '' COMMENT '增值税纳税人识别号。仅国际化有',
  `tax_payer_number_cit` varchar(50) DEFAULT '' COMMENT '企业所得税纳税人识别号。仅国际化有',
  `tax_client_person_email_address` varchar(50) DEFAULT '' COMMENT '办税人邮箱。',
  `bank_account_name` varchar(200) DEFAULT '' COMMENT '三方协议开户银行名称.bank_account_name',
  `bank_account_number` varchar(128) DEFAULT '' COMMENT '银行账户号码',
  `legal_person_name` varchar(200) DEFAULT '' COMMENT '法定代表人/负责人姓名.',
  `legal_person_phone_number` varchar(100) DEFAULT '' COMMENT '法定代表人/负责人手机',
  `legal_person_landline_num` varchar(100) DEFAULT '' COMMENT '法定代表人/负责人座机',
  `legal_person_email_address` varchar(100) DEFAULT '' COMMENT '法定代表人/负责人邮箱',
  `reg_financial_officer_name` varchar(200) DEFAULT '' COMMENT '注册登记财务负责人姓名',
  `reg_financial_officer_phone_num` varchar(100) DEFAULT '' COMMENT '注册登记财务负责人电话',
  `reg_financial_officer_landline_num` varchar(100) DEFAULT '' COMMENT '注册登记财务负责人座机',
  `reg_financial_officer_email_address` varchar(100) DEFAULT '' COMMENT '注册登记财务负责人邮箱',
  `secondary_approval_amount` bigint(22) DEFAULT NULL COMMENT '二级审批金额',
  `business_registration_number` varchar(30) DEFAULT '' COMMENT '商业登记号码.Business registration number(国际化特有字段)',
  `par_value` float DEFAULT NULL COMMENT 'Par Value(国际化特有字段).票面价值。票面价值是企业发行的股票上面所标明的金额,有的企业发行的股票上有票面价值,也有的企业发行的股票不标明票面价值。',
  `issued_shares` bigint(22) DEFAULT NULL COMMENT 'Issued shares(国际化特有字段).发行股票',
  `directors` varchar(300) DEFAULT '' COMMENT 'Directors(国际化特有字段).董事。以;间隔',
  `actual_business_address` varchar(300) DEFAULT '' COMMENT '实际经营地址。例:杭州市余杭区九橙西溪创投中心',
  `tax_rule_introduction` varchar(500) DEFAULT '' COMMENT '税制简介',
  `audit_requirements` varchar(300) DEFAULT '' COMMENT '审计要求',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='机构-其他信息';

-- ----------------------------
-- Table structure for organization_invoice
-- ----------------------------
DROP TABLE IF EXISTS `organization_invoice`;
CREATE TABLE `organization_invoice` (
  `id` bigint(22) NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '对应机构编号',
  `invoice_type_name` varchar(200) DEFAULT '' COMMENT '发票种类名称。增值税专用发票/增值税普通发票/机动车销售统一发票/其他票种',
  `unit` varchar(10) DEFAULT '' COMMENT '单位。份、本、其他',
  `single_invoice_max_invoice_amount` bigint(18) DEFAULT '0' COMMENT '单份发票最高开票额',
  `monthly_max_tickets_purchased` bigint(18) DEFAULT '0' COMMENT '每月最高购票数量',
  `single_invoicing_max_limit` bigint(18) DEFAULT '0' COMMENT '单份发票最高开票限额',
  `offline_billing_time_limit` varchar(200) DEFAULT '' COMMENT '离线开票时限',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for organization_return_rate
-- ----------------------------
DROP TABLE IF EXISTS `organization_return_rate`;
CREATE TABLE `organization_return_rate` (
  `id` bigint(22) NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号',
  `group_name` varchar(50) DEFAULT '' COMMENT '税种',
  `return_rate` float DEFAULT '0' COMMENT '返还率',
  `start_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开始时间。2015-05-02',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for organization_service_template_group
-- ----------------------------
DROP TABLE IF EXISTS `organization_service_template_group`;
CREATE TABLE `organization_service_template_group` (
  `id` bigint(19) NOT NULL,
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `service_type_id` varchar(128) NOT NULL DEFAULT '',
  `template_group_id` bigint(19) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `org_service_template_group_organization_id_IDX` (`organization_id`,`service_type_id`,`template_group_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for organization_structure
-- ----------------------------
DROP TABLE IF EXISTS `organization_structure`;
CREATE TABLE `organization_structure` (
  `id` varchar(128) NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `organization_structure_name_IDX` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for organization_tax_officer
-- ----------------------------
DROP TABLE IF EXISTS `organization_tax_officer`;
CREATE TABLE `organization_tax_officer` (
  `id` bigint(22) NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号',
  `tax_officer_name` varchar(20) DEFAULT '' COMMENT '专管员姓名',
  `tax_officer_phone_num` varchar(20) DEFAULT '' COMMENT '专管员电话',
  `remark` varchar(500) DEFAULT '' COMMENT '备注.填写专管员特长等信息',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for organization_tax_rule
-- ----------------------------
DROP TABLE IF EXISTS `organization_tax_rule`;
CREATE TABLE `organization_tax_rule` (
  `id` bigint(22) NOT NULL DEFAULT '0' COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构编号',
  `group_name` varchar(50) DEFAULT '' COMMENT '税种类型',
  `tax_dec_cycle` varchar(10) DEFAULT '' COMMENT '税种申报周期.月度/季度/半年度/年度',
  `tax_dec_type` varchar(50) DEFAULT '' COMMENT '税种申报方式.网报-CA、用户名密码;建议自己把各自负责的公司的网报账号、密码放到系统中,并更新',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for organization_taxpayer_qualification
-- ----------------------------
DROP TABLE IF EXISTS `organization_taxpayer_qualification`;
CREATE TABLE `organization_taxpayer_qualification` (
  `id` bigint(22) DEFAULT '0' COMMENT '唯一编号',
  `organization_id` varchar(128) DEFAULT '' COMMENT '对应机构编号',
  `taxpayer_qualification_type` varchar(30) DEFAULT '' COMMENT '纳税人类型.  一般纳税人等',
  `determination_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '认定日期.到日',
  `validity_start` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '有效期起。到日',
  `validity_end` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '有效期止。到日',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='机构信息-纳税人信息';

-- ----------------------------
-- Table structure for output_ar_invoice
-- ----------------------------
DROP TABLE IF EXISTS `output_ar_invoice`;
CREATE TABLE `output_ar_invoice` (
  `id` bigint(18) NOT NULL,
  `operation_unit_id` int(11) DEFAULT '0',
  `operation_name` varchar(240) DEFAULT '',
  `customer_trx_id` int(11) DEFAULT '0',
  `cust_trx_type_id` int(11) DEFAULT '0',
  `cust_trx_type_name` varchar(20) DEFAULT '',
  `ctt_class` varchar(20) DEFAULT '',
  `batch_source_id` int(11) DEFAULT '0',
  `batch_source_name` varchar(50) DEFAULT '',
  `trx_date` varchar(10) DEFAULT '',
  `gl_date` varchar(10) DEFAULT '',
  `trx_number` varchar(20) DEFAULT '',
  `invoice_currency_code` varchar(15) DEFAULT '',
  `invoice_amount` decimal(19,5) DEFAULT '0.00000',
  `invoice_tax_amount` decimal(19,5) DEFAULT '0.00000',
  `bill_to_customer_id` int(11) DEFAULT '0',
  `bill_to_customer_number` varchar(30) DEFAULT '',
  `bill_to_customer_name` varchar(360) DEFAULT '',
  `ct_reference` varchar(10) DEFAULT '',
  `status_trx` varchar(30) DEFAULT '',
  `description` varchar(240) DEFAULT '',
  `primary_salesrep_id` int(11) DEFAULT '0',
  `primary_salesrep_name` varchar(360) DEFAULT '',
  `terms_name` varchar(50) DEFAULT '',
  `attribute1` varchar(240) DEFAULT '',
  `attribute2` varchar(240) DEFAULT '',
  `attribute3` varchar(240) DEFAULT '',
  `attribute4` varchar(240) DEFAULT '',
  `attribute5` varchar(240) DEFAULT '',
  `attribute6` varchar(240) DEFAULT '',
  `attribute7` varchar(240) DEFAULT '',
  `attribute8` varchar(240) DEFAULT '',
  `attribute9` varchar(240) DEFAULT '',
  `attribute10` varchar(240) DEFAULT '',
  `attribute11` varchar(240) DEFAULT '',
  `attribute12` varchar(240) DEFAULT '',
  `attribute13` varchar(240) DEFAULT '',
  `attribute14` varchar(240) DEFAULT '',
  `attribute15` varchar(240) DEFAULT '',
  `attr1` varchar(240) DEFAULT '',
  `attr2` varchar(240) DEFAULT '',
  `attr3` varchar(240) DEFAULT '',
  `attr4` varchar(240) DEFAULT '',
  `attr5` varchar(240) DEFAULT '',
  `create_by` varchar(128) DEFAULT '',
  `update_by` varchar(128) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `terms_date` varchar(10) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_ar_receivables_trx
-- ----------------------------
DROP TABLE IF EXISTS `output_ar_receivables_trx`;
CREATE TABLE `output_ar_receivables_trx` (
  `id` bigint(18) NOT NULL,
  `org_id` int(11) NOT NULL DEFAULT '0' COMMENT '业务实体ID',
  `type_code` varchar(30) NOT NULL DEFAULT '' COMMENT '收款类别编码',
  `type_name` varchar(50) NOT NULL DEFAULT '' COMMENT '收款类别名称',
  `status` varchar(30) NOT NULL DEFAULT '' COMMENT '是否有效 有效(A)',
  `description` varchar(240) NOT NULL DEFAULT '' COMMENT '备注',
  `company_code` varchar(25) NOT NULL DEFAULT '' COMMENT '活动GL账户-公司段',
  `segment2` varchar(25) NOT NULL DEFAULT '' COMMENT '活动GL账户-成本中心段',
  `segment3` varchar(25) NOT NULL DEFAULT '' COMMENT '活动GL账户-科目段',
  `segment4` varchar(25) NOT NULL DEFAULT '' COMMENT '活动GL账户-区域段',
  `segment5` varchar(25) NOT NULL DEFAULT '' COMMENT '活动GL账户-往来段',
  `segment6` varchar(25) NOT NULL DEFAULT '' COMMENT '活动GL账户-产品段',
  `segment7` varchar(25) NOT NULL DEFAULT '' COMMENT '活动GL账户-备注段',
  `attr1` varchar(240) NOT NULL DEFAULT '' COMMENT '备用字段1',
  `attr2` varchar(240) NOT NULL DEFAULT '' COMMENT '备用字段2',
  `attr3` varchar(240) NOT NULL DEFAULT '' COMMENT '备用字段3',
  `attr4` varchar(240) NOT NULL DEFAULT '' COMMENT '备用字段4',
  `attr5` varchar(240) NOT NULL DEFAULT '' COMMENT '备用字段5',
  `receivables_trx_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_ar_trx_type
-- ----------------------------
DROP TABLE IF EXISTS `output_ar_trx_type`;
CREATE TABLE `output_ar_trx_type` (
  `id` bigint(18) NOT NULL,
  `cust_trx_type_id` int(11) DEFAULT '0',
  `org_id` int(11) DEFAULT '0',
  `name` varchar(20) DEFAULT '',
  `description` varchar(240) DEFAULT '',
  `type` varchar(20) DEFAULT '',
  `creation_sign` varchar(30) DEFAULT '',
  `start_date` varchar(10) DEFAULT '',
  `end_date` varchar(10) DEFAULT '',
  `credit_memo_type_id` int(11) DEFAULT '0',
  `attr1` varchar(240) DEFAULT '',
  `attr2` varchar(240) DEFAULT '',
  `attr3` varchar(240) DEFAULT '',
  `attr4` varchar(240) DEFAULT '',
  `attr5` varchar(240) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_customer
-- ----------------------------
DROP TABLE IF EXISTS `output_customer`;
CREATE TABLE `output_customer` (
  `id` bigint(18) NOT NULL,
  `party_id` int(11) NOT NULL DEFAULT '0',
  `party_name` varchar(360) NOT NULL DEFAULT '',
  `party_number` varchar(30) NOT NULL DEFAULT '',
  `known_as` varchar(240) NOT NULL DEFAULT '',
  `party_type` varchar(30) NOT NULL DEFAULT '',
  `status` varchar(1) NOT NULL DEFAULT '',
  `tax_reference` varchar(50) NOT NULL DEFAULT '',
  `duns_number` int(11) NOT NULL DEFAULT '0',
  `country` varchar(60) NOT NULL DEFAULT '',
  `province` varchar(60) NOT NULL DEFAULT '',
  `city` varchar(60) NOT NULL DEFAULT '',
  `county` varchar(60) NOT NULL DEFAULT '',
  `address1` varchar(240) NOT NULL DEFAULT '',
  `address2` varchar(240) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `attr4` varchar(240) NOT NULL DEFAULT '',
  `attr5` varchar(240) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_customer_account
-- ----------------------------
DROP TABLE IF EXISTS `output_customer_account`;
CREATE TABLE `output_customer_account` (
  `id` bigint(18) NOT NULL,
  `cust_account_id` int(11) NOT NULL DEFAULT '0',
  `party_id` int(11) NOT NULL DEFAULT '0',
  `account_number` varchar(30) NOT NULL DEFAULT '',
  `account_name` varchar(240) NOT NULL DEFAULT '',
  `customer_type` varchar(30) NOT NULL DEFAULT '',
  `status` varchar(1) NOT NULL DEFAULT '',
  `attribute_category` varchar(30) NOT NULL DEFAULT '',
  `attribute1` varchar(150) NOT NULL DEFAULT '',
  `attribute2` varchar(150) NOT NULL DEFAULT '',
  `attribute3` varchar(150) NOT NULL DEFAULT '',
  `attribute4` varchar(150) NOT NULL DEFAULT '',
  `attribute5` varchar(150) NOT NULL DEFAULT '',
  `attribute6` varchar(150) NOT NULL DEFAULT '',
  `attribute7` varchar(150) NOT NULL DEFAULT '',
  `attribute8` varchar(150) NOT NULL DEFAULT '',
  `attribute9` varchar(150) NOT NULL DEFAULT '',
  `attribute10` varchar(150) NOT NULL DEFAULT '',
  `attribute11` varchar(150) NOT NULL DEFAULT '',
  `attribute12` varchar(150) NOT NULL DEFAULT '',
  `attribute13` varchar(150) NOT NULL DEFAULT '',
  `attribute14` varchar(150) NOT NULL DEFAULT '',
  `attribute15` varchar(150) NOT NULL DEFAULT '',
  `attribute16` varchar(150) NOT NULL DEFAULT '',
  `attribute17` varchar(150) NOT NULL DEFAULT '',
  `attribute18` varchar(150) NOT NULL DEFAULT '',
  `attribute19` varchar(150) NOT NULL DEFAULT '',
  `attribute20` varchar(150) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `attr4` varchar(240) NOT NULL DEFAULT '',
  `attr5` varchar(240) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_customer_bank
-- ----------------------------
DROP TABLE IF EXISTS `output_customer_bank`;
CREATE TABLE `output_customer_bank` (
  `id` bigint(18) NOT NULL,
  `ext_payer_id` int(11) NOT NULL DEFAULT '0',
  `cust_account_id` int(11) NOT NULL DEFAULT '0',
  `operation_unit_id` int(11) NOT NULL DEFAULT '0',
  `site_use_id` int(11) NOT NULL DEFAULT '0',
  `country_code` varchar(2) NOT NULL DEFAULT '',
  `currency_code` varchar(15) NOT NULL DEFAULT '',
  `bank_name` varchar(360) NOT NULL DEFAULT '',
  `bank_number` varchar(30) NOT NULL DEFAULT '',
  `bank_branch_name` varchar(360) NOT NULL DEFAULT '',
  `branch_number` varchar(30) NOT NULL DEFAULT '',
  `bank_account_num_electronic` varchar(100) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `attr4` varchar(240) NOT NULL DEFAULT '',
  `attr5` varchar(240) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_customer_contactor
-- ----------------------------
DROP TABLE IF EXISTS `output_customer_contactor`;
CREATE TABLE `output_customer_contactor` (
  `id` bigint(18) NOT NULL,
  `contact_party_id` varchar(60) NOT NULL DEFAULT '',
  `contractor_name` varchar(100) NOT NULL DEFAULT '',
  `phon_number` varchar(30) NOT NULL DEFAULT '',
  `email_address` varchar(40) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `attr4` varchar(240) NOT NULL DEFAULT '',
  `attr5` varchar(240) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_customer_ex
-- ----------------------------
DROP TABLE IF EXISTS `output_customer_ex`;
CREATE TABLE `output_customer_ex` (
  `id` bigint(18) NOT NULL,
  `cust_account_id` int(11) DEFAULT '0',
  `party_number` varchar(30) DEFAULT '',
  `party_name` varchar(360) DEFAULT '',
  `party_class` varchar(150) DEFAULT '',
  `financial_class` varchar(150) DEFAULT '',
  `internal_comm_company` varchar(150) DEFAULT '',
  `payer_class` varchar(150) DEFAULT '',
  `payer_num` varchar(150) DEFAULT '',
  `party_address` varchar(240) DEFAULT '',
  `phone_num` varchar(30) DEFAULT '',
  `bank_name` varchar(360) DEFAULT '',
  `bank_num` varchar(50) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_customer_party_site
-- ----------------------------
DROP TABLE IF EXISTS `output_customer_party_site`;
CREATE TABLE `output_customer_party_site` (
  `id` bigint(18) NOT NULL,
  `party_site_id` varchar(60) NOT NULL DEFAULT '',
  `cust_account_id` int(11) NOT NULL DEFAULT '0',
  `cust_acct_site_id` int(11) NOT NULL DEFAULT '0',
  `location_id` int(11) NOT NULL DEFAULT '0',
  `operation_unit_id` int(11) NOT NULL DEFAULT '0',
  `operation_name` varchar(240) NOT NULL DEFAULT '',
  `status` varchar(1) NOT NULL DEFAULT '',
  `party_site_number` varchar(30) NOT NULL DEFAULT '',
  `party_site_name` varchar(240) NOT NULL DEFAULT '',
  `party_site_status` varchar(1) NOT NULL DEFAULT '',
  `country` varchar(60) NOT NULL DEFAULT '',
  `province` varchar(60) NOT NULL DEFAULT '',
  `city` varchar(60) NOT NULL DEFAULT '',
  `county` varchar(60) NOT NULL DEFAULT '',
  `address1` varchar(240) NOT NULL DEFAULT '',
  `address2` varchar(240) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `attr4` varchar(240) NOT NULL DEFAULT '',
  `attr5` varchar(240) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_customer_site_use
-- ----------------------------
DROP TABLE IF EXISTS `output_customer_site_use`;
CREATE TABLE `output_customer_site_use` (
  `id` bigint(18) NOT NULL,
  `site_use_id` int(11) DEFAULT '0',
  `cust_acct_site_id` int(11) DEFAULT '0',
  `operation_unit_id` int(11) DEFAULT '0',
  `status` varchar(1) DEFAULT '',
  `site_use_code` varchar(30) DEFAULT '',
  `primary_flag` varchar(1) DEFAULT '',
  `location` varchar(40) DEFAULT '',
  `bill_to_site_use_id` int(11) DEFAULT '0',
  `primary_salesrep_id` int(11) DEFAULT '0',
  `primary_salesrep_emp_num` varchar(30) DEFAULT '',
  `territory_id` int(11) DEFAULT '0',
  `territory_name` varchar(51) DEFAULT '',
  `payment_term_id` int(11) DEFAULT '0',
  `payment_term_name_zhs` varchar(15) DEFAULT '',
  `payment_term_name_us` varchar(15) DEFAULT '',
  `attr1` varchar(240) DEFAULT '',
  `attr2` varchar(240) DEFAULT '',
  `attr3` varchar(240) DEFAULT '',
  `attr4` varchar(240) DEFAULT '',
  `attr5` varchar(240) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_flex_value
-- ----------------------------
DROP TABLE IF EXISTS `output_flex_value`;
CREATE TABLE `output_flex_value` (
  `id` int(11) NOT NULL,
  `flex_value_set_id` int(11) NOT NULL DEFAULT '0',
  `flex_value_set_name` varchar(60) NOT NULL DEFAULT '',
  `flex_value_id` int(11) NOT NULL DEFAULT '0',
  `flex_value` varchar(150) NOT NULL DEFAULT '',
  `flex_value_meaning_zhs` varchar(150) NOT NULL DEFAULT '',
  `flex_value_meaning_us` varchar(150) NOT NULL DEFAULT '',
  `description_zhs` varchar(240) NOT NULL DEFAULT '',
  `description_us` varchar(240) NOT NULL DEFAULT '',
  `enabled_flag` varchar(1) NOT NULL DEFAULT '',
  `start_date` varchar(10) NOT NULL DEFAULT '',
  `end_date` varchar(10) NOT NULL DEFAULT '',
  `summary_flag` varchar(1) NOT NULL DEFAULT '',
  `structured_hierarchy_name_zhs` varchar(30) NOT NULL DEFAULT '',
  `structured_hierarchy_name_us` varchar(30) NOT NULL DEFAULT '',
  `hierarchy_level` varchar(30) NOT NULL DEFAULT '',
  `attribute1` varchar(240) NOT NULL DEFAULT '',
  `attribute2` varchar(240) NOT NULL DEFAULT '',
  `attribute3` varchar(240) NOT NULL DEFAULT '',
  `attribute4` varchar(240) NOT NULL DEFAULT '',
  `attribute5` varchar(240) NOT NULL DEFAULT '',
  `attribute6` varchar(240) NOT NULL DEFAULT '',
  `attribute7` varchar(240) NOT NULL DEFAULT '',
  `attribute8` varchar(240) NOT NULL DEFAULT '',
  `attribute9` varchar(240) NOT NULL DEFAULT '',
  `attribute10` varchar(240) NOT NULL DEFAULT '',
  `attribute11` varchar(240) NOT NULL DEFAULT '',
  `attribute12` varchar(240) NOT NULL DEFAULT '',
  `attribute13` varchar(240) NOT NULL DEFAULT '',
  `attribute14` varchar(240) NOT NULL DEFAULT '',
  `attribute15` varchar(240) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `attr4` varchar(240) NOT NULL DEFAULT '',
  `attr5` varchar(240) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_gl_daily_rate
-- ----------------------------
DROP TABLE IF EXISTS `output_gl_daily_rate`;
CREATE TABLE `output_gl_daily_rate` (
  `id` bigint(18) NOT NULL,
  `from_currency` varchar(15) NOT NULL DEFAULT '',
  `to_currency` varchar(15) NOT NULL DEFAULT '',
  `conversion_date` varchar(10) NOT NULL DEFAULT '',
  `conversion_type` varchar(30) NOT NULL DEFAULT '',
  `conversion_rate` int(11) NOT NULL DEFAULT '0',
  `creation_date` varchar(20) NOT NULL DEFAULT '',
  `created_by` varchar(30) NOT NULL DEFAULT '',
  `last_update_date` varchar(20) NOT NULL DEFAULT '',
  `last_updated_by` varchar(30) NOT NULL DEFAULT '',
  `attr1` varchar(240) NOT NULL DEFAULT '',
  `attr2` varchar(240) NOT NULL DEFAULT '',
  `attr3` varchar(240) NOT NULL DEFAULT '',
  `attr4` varchar(240) NOT NULL DEFAULT '',
  `attr5` varchar(240) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_invoice
-- ----------------------------
DROP TABLE IF EXISTS `output_invoice`;
CREATE TABLE `output_invoice` (
  `ID` varchar(255) NOT NULL,
  `BSC` varchar(255) DEFAULT NULL,
  `BSCDM` varchar(255) DEFAULT NULL,
  `BZ` varchar(255) DEFAULT NULL,
  `CJSJ` varchar(255) DEFAULT NULL,
  `DYZT` varchar(255) DEFAULT NULL,
  `EWM` varchar(255) DEFAULT NULL,
  `FHR` varchar(255) DEFAULT NULL,
  `FPDM` varchar(255) DEFAULT NULL,
  `FPHM` varchar(255) DEFAULT NULL,
  `FPLX` varchar(255) DEFAULT NULL,
  `FPLXDM` varchar(255) DEFAULT NULL,
  `FPQQLSH` varchar(255) DEFAULT NULL,
  `FPZT` varchar(255) DEFAULT NULL,
  `GDJLH` varchar(255) DEFAULT NULL,
  `GFDZDH` varchar(255) DEFAULT NULL,
  `GFGSBM` varchar(255) DEFAULT NULL,
  `GFMC` varchar(255) DEFAULT NULL,
  `GFSH` varchar(255) DEFAULT NULL,
  `GFYHZH` varchar(255) DEFAULT NULL,
  `HJJE` varchar(255) DEFAULT NULL,
  `HJSE` varchar(255) DEFAULT NULL,
  `HTBH` varchar(255) DEFAULT NULL,
  `JQBH` varchar(255) DEFAULT NULL,
  `JSFJ` varchar(255) DEFAULT NULL,
  `JSHJ` varchar(255) DEFAULT NULL,
  `JSZT` varchar(255) DEFAULT NULL,
  `JYM` varchar(255) DEFAULT NULL,
  `KDDH` varchar(255) DEFAULT NULL,
  `KDGS` varchar(255) DEFAULT NULL,
  `KDUUID` varchar(255) DEFAULT NULL,
  `KPR` varchar(255) DEFAULT NULL,
  `KPRQ` varchar(255) DEFAULT NULL,
  `KPZT` varchar(255) DEFAULT NULL,
  `QY` varchar(255) DEFAULT NULL,
  `QYDM` varchar(255) DEFAULT NULL,
  `SHZT` varchar(255) DEFAULT NULL,
  `SKR` varchar(255) DEFAULT NULL,
  `SLV` varchar(255) DEFAULT NULL,
  `SPBH` varchar(255) DEFAULT NULL,
  `SQBH` varchar(255) DEFAULT NULL,
  `SQR` varchar(255) DEFAULT NULL,
  `SQRQ` varchar(255) DEFAULT NULL,
  `THKPSQ` varchar(255) DEFAULT NULL,
  `XFDZDH` varchar(255) DEFAULT NULL,
  `XFGSBM` varchar(255) DEFAULT NULL,
  `XFMC` varchar(255) DEFAULT NULL,
  `XFSH` varchar(255) DEFAULT NULL,
  `XFYHZH` varchar(255) DEFAULT NULL,
  `XTLY` varchar(255) DEFAULT NULL,
  `XXBBH` varchar(255) DEFAULT NULL,
  `YFPDM` varchar(255) DEFAULT NULL,
  `YFPHM` varchar(255) DEFAULT NULL,
  `YZRQ` varchar(255) DEFAULT NULL,
  `ZKJE` varchar(255) DEFAULT NULL,
  `ZKJSHJ` varchar(255) DEFAULT NULL,
  `ZKSE` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_operation_unit
-- ----------------------------
DROP TABLE IF EXISTS `output_operation_unit`;
CREATE TABLE `output_operation_unit` (
  `id` bigint(18) NOT NULL,
  `operation_unit_id` int(11) NOT NULL DEFAULT '0',
  `operation_unit_code` varchar(30) NOT NULL DEFAULT '',
  `operation_unit_type_code` varchar(30) NOT NULL DEFAULT '',
  `operation_unit_type_name` varchar(80) NOT NULL DEFAULT '',
  `operation_name` varchar(240) NOT NULL DEFAULT '',
  `start_date` varchar(30) NOT NULL DEFAULT '',
  `end_date` varchar(30) NOT NULL DEFAULT '',
  `location_id` int(11) NOT NULL DEFAULT '0',
  `location_name` varchar(240) NOT NULL DEFAULT '',
  `internal_external` varchar(30) NOT NULL DEFAULT '',
  `company_name` varchar(240) NOT NULL DEFAULT '',
  `object_version_num` int(11) NOT NULL DEFAULT '0',
  `langue_code` varchar(30) NOT NULL DEFAULT '',
  `extend_attributes` varchar(4000) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for output_ra_interface
-- ----------------------------
DROP TABLE IF EXISTS `output_ra_interface`;
CREATE TABLE `output_ra_interface` (
  `id` int(11) NOT NULL,
  `interface_line_id` int(11) DEFAULT '0',
  `interface_line_context` varchar(30) DEFAULT '',
  `interface_line_attribute1` varchar(150) DEFAULT '',
  `interface_line_attribute2` varchar(150) DEFAULT '',
  `interface_line_attribute3` varchar(150) DEFAULT '',
  `interface_line_attribute4` varchar(150) DEFAULT '',
  `interface_line_attribute5` varchar(150) DEFAULT '',
  `interface_line_attribute6` varchar(150) DEFAULT '',
  `interface_line_attribute7` varchar(150) DEFAULT '',
  `interface_line_attribute8` varchar(150) DEFAULT '',
  `interface_line_attribute9` varchar(150) DEFAULT '',
  `interface_line_attribute10` varchar(150) DEFAULT '',
  `interface_line_attribute11` varchar(150) DEFAULT '',
  `interface_line_attribute12` varchar(150) DEFAULT '',
  `interface_line_attribute13` varchar(150) DEFAULT '',
  `interface_line_attribute14` varchar(150) DEFAULT '',
  `interface_line_attribute15` varchar(150) DEFAULT '',
  `link_to_line_context` varchar(30) DEFAULT '',
  `link_to_line_attribute1` varchar(150) DEFAULT '',
  `link_to_line_attribute2` varchar(150) DEFAULT '',
  `link_to_line_attribute3` varchar(150) DEFAULT '',
  `link_to_line_attribute4` varchar(150) DEFAULT '',
  `link_to_line_attribute5` varchar(150) DEFAULT '',
  `link_to_line_attribute6` varchar(150) DEFAULT '',
  `link_to_line_attribute7` varchar(150) DEFAULT '',
  `link_to_line_attribute8` varchar(150) DEFAULT '',
  `link_to_line_attribute9` varchar(150) DEFAULT '',
  `link_to_line_attribute10` varchar(150) DEFAULT '',
  `link_to_line_attribute11` varchar(150) DEFAULT '',
  `link_to_line_attribute12` varchar(150) DEFAULT '',
  `link_to_line_attribute13` varchar(150) DEFAULT '',
  `link_to_line_attribute14` varchar(150) DEFAULT '',
  `link_to_line_attribute15` varchar(150) DEFAULT '',
  `ship_date_actual` varchar(10) DEFAULT '',
  `amount` int(11) DEFAULT '0',
  `batch_source_name` varchar(50) DEFAULT '',
  `conversion_date` varchar(10) DEFAULT '',
  `conversion_rate` int(11) DEFAULT '0',
  `conversion_type` varchar(30) DEFAULT '',
  `currency_code` varchar(15) DEFAULT '',
  `cust_trx_type_id` int(11) DEFAULT '0',
  `description` varchar(240) DEFAULT '',
  `gl_date` varchar(10) DEFAULT '',
  `line_type` varchar(20) DEFAULT '',
  `orig_system_bill_address_id` int(11) DEFAULT '0',
  `orig_system_bill_customer_id` int(11) DEFAULT '0',
  `orig_system_ship_address_id` int(11) DEFAULT '0',
  `orig_system_ship_customer_id` int(11) DEFAULT '0',
  `orig_system_sold_customer_id` int(11) DEFAULT '0',
  `reason_code` varchar(30) DEFAULT '',
  `ship_via` varchar(25) DEFAULT '',
  `way_bill_number` varchar(50) DEFAULT '',
  `walehouse_id` int(11) DEFAULT '0',
  `quantity` int(11) DEFAULT '0',
  `quantity_ordered` int(11) DEFAULT '0',
  `unit_selling_price` int(11) DEFAULT '0',
  `term_id` int(11) DEFAULT '0',
  `taxable_flag` varchar(1) DEFAULT '',
  `amount_includes_tax_flag` varchar(1) DEFAULT '',
  `set_of_books_id` int(11) DEFAULT '0',
  `org_id` int(11) DEFAULT '0',
  `tax_regime_code` varchar(30) DEFAULT '',
  `tax` varchar(30) DEFAULT '',
  `tax_status_code` varchar(30) DEFAULT '',
  `tax_rate_code` varchar(30) DEFAULT '',
  `tax_jurisdiction_code` varchar(30) DEFAULT '',
  `tax_rate` int(11) DEFAULT '0',
  `primary_salesrep_id` int(11) DEFAULT '0',
  `inventory_item_id` int(11) DEFAULT '0',
  `sales_order` varchar(50) DEFAULT '',
  `sales_order_line` varchar(30) DEFAULT '',
  `sales_order_line_type` varchar(150) DEFAULT '',
  `sales_order_date` varchar(30) DEFAULT '',
  `sales_order_source` varchar(50) DEFAULT '',
  `purchase_order` varchar(50) DEFAULT '',
  `uom_code` varchar(30) DEFAULT '',
  `secondary_uom_code` varchar(30) DEFAULT '',
  `quantity_suc` int(11) DEFAULT '0',
  `unit_selling_price_suc` int(11) DEFAULT '0',
  `created_by` int(11) DEFAULT '0',
  `creation_date` varchar(30) DEFAULT '',
  `last_updated_by` int(11) DEFAULT '0',
  `last_update_date` varchar(30) DEFAULT '',
  `last_update_login` int(11) DEFAULT '0',
  `header_attribute_category` varchar(30) DEFAULT '',
  `header_attribute1` varchar(150) DEFAULT '',
  `header_attribute2` varchar(150) DEFAULT '',
  `header_attribute3` varchar(150) DEFAULT '',
  `header_attribute4` varchar(150) DEFAULT '',
  `header_attribute5` varchar(150) DEFAULT '',
  `header_attribute6` varchar(150) DEFAULT '',
  `header_attribute7` varchar(150) DEFAULT '',
  `header_attribute8` varchar(150) DEFAULT '',
  `header_attribute9` varchar(150) DEFAULT '',
  `header_attribute10` varchar(150) DEFAULT '',
  `header_attribute11` varchar(150) DEFAULT '',
  `header_attribute12` varchar(150) DEFAULT '',
  `header_attribute13` varchar(150) DEFAULT '',
  `header_attribute14` varchar(150) DEFAULT '',
  `header_attribute15` varchar(150) DEFAULT '',
  `line_gdf_attr_category` varchar(30) DEFAULT '',
  `line_gdf_attribute1` varchar(150) DEFAULT '',
  `line_gdf_attribute2` varchar(150) DEFAULT '',
  `line_gdf_attribute3` varchar(150) DEFAULT '',
  `line_gdf_attribute4` varchar(150) DEFAULT '',
  `line_gdf_attribute5` varchar(150) DEFAULT '',
  `line_gdf_attribute6` varchar(150) DEFAULT '',
  `line_gdf_attribute7` varchar(150) DEFAULT '',
  `line_gdf_attribute8` varchar(150) DEFAULT '',
  `line_gdf_attribute9` varchar(150) DEFAULT '',
  `line_gdf_attribute10` varchar(150) DEFAULT '',
  `line_gdf_attribute11` varchar(150) DEFAULT '',
  `line_gdf_attribute12` varchar(150) DEFAULT '',
  `line_gdf_attribute13` varchar(150) DEFAULT '',
  `line_gdf_attribute14` varchar(150) DEFAULT '',
  `line_gdf_attribute15` varchar(150) DEFAULT '',
  `line_gdf_attribute16` varchar(150) DEFAULT '',
  `line_gdf_attribute17` varchar(150) DEFAULT '',
  `line_gdf_attribute18` varchar(150) DEFAULT '',
  `line_gdf_attribute19` varchar(150) DEFAULT '',
  `line_gdf_attribute20` varchar(150) DEFAULT '',
  `attribute_category` varchar(30) DEFAULT '',
  `attribute1` varchar(240) DEFAULT '',
  `attribute2` varchar(240) DEFAULT '',
  `attribute3` varchar(240) DEFAULT '',
  `attribute4` varchar(240) DEFAULT '',
  `attribute5` varchar(240) DEFAULT '',
  `attribute6` varchar(240) DEFAULT '',
  `attribute7` varchar(240) DEFAULT '',
  `attribute8` varchar(240) DEFAULT '',
  `attribute9` varchar(240) DEFAULT '',
  `attribute10` varchar(240) DEFAULT '',
  `attribute11` varchar(240) DEFAULT '',
  `attribute12` varchar(240) DEFAULT '',
  `attribute13` varchar(240) DEFAULT '',
  `attribute14` varchar(240) DEFAULT '',
  `attribute15` varchar(240) DEFAULT '',
  `attr1` varchar(240) DEFAULT '',
  `attr2` varchar(240) DEFAULT '',
  `attr3` varchar(240) DEFAULT '',
  `attr4` varchar(240) DEFAULT '',
  `attr5` varchar(240) DEFAULT '',
  `sale_type` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_approve
-- ----------------------------
DROP TABLE IF EXISTS `period_approve`;
CREATE TABLE `period_approve` (
  `id` varchar(255) NOT NULL,
  `project_id` varchar(255) NOT NULL DEFAULT '',
  `period` int(10) NOT NULL DEFAULT '0',
  `report_ids` varchar(500) DEFAULT NULL,
  `report_paths` varchar(500) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `instance_id` varchar(255) DEFAULT NULL,
  `year` int(10) DEFAULT NULL,
  `template_ids` varchar(500) DEFAULT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `approval_by` varchar(255) DEFAULT NULL,
  `approval_time` datetime DEFAULT NULL,
  `approval_resualt` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `period_approve_project_id_IDX` (`project_id`,`period`,`year`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_cell_comment
-- ----------------------------
DROP TABLE IF EXISTS `period_cell_comment`;
CREATE TABLE `period_cell_comment` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `cell_data_id` bigint(19) NOT NULL DEFAULT '0',
  `user_id` varchar(128) NOT NULL DEFAULT '',
  `user_name` varchar(50) NOT NULL DEFAULT '',
  `comment` varchar(1000) NOT NULL DEFAULT '',
  `reply_to_user_name` varchar(50) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `project_id` varchar(128) NOT NULL DEFAULT '',
  `period` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `period_cell_comment_user_id_IDX` (`user_id`,`create_by`,`project_id`,`period`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_cell_data
-- ----------------------------
DROP TABLE IF EXISTS `period_cell_data`;
CREATE TABLE `period_cell_data` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `report_id` bigint(19) NOT NULL DEFAULT '0',
  `cell_template_id` bigint(19) NOT NULL DEFAULT '0',
  `data` varchar(200) DEFAULT '',
  `formula_exp` varchar(1000) NOT NULL DEFAULT '',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `project_id` varchar(128) NOT NULL DEFAULT '',
  `period` int(10) NOT NULL DEFAULT '0',
  `keyin_data` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `CPR` (`cell_template_id`,`project_id`,`period`),
  KEY `period_cell_data_report_id_IDX` (`report_id`,`cell_template_id`,`project_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_cell_data_source
-- ----------------------------
DROP TABLE IF EXISTS `period_cell_data_source`;
CREATE TABLE `period_cell_data_source` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `cell_template_id` bigint(19) NOT NULL DEFAULT '0',
  `cell_data_id` bigint(19) NOT NULL DEFAULT '0',
  `data_source_id` bigint(19) NOT NULL DEFAULT '0',
  `operation_type` bigint(19) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `project_id` varchar(128) NOT NULL DEFAULT '',
  `period` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SYS_C0071279` (`cell_data_id`,`data_source_id`),
  KEY `period_cell_data_source_cell_template_id_IDX` (`cell_template_id`,`cell_data_id`,`project_id`,`period`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_cell_template
-- ----------------------------
DROP TABLE IF EXISTS `period_cell_template`;
CREATE TABLE `period_cell_template` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `period` int(10) NOT NULL DEFAULT '0',
  `report_template_id` bigint(19) NOT NULL DEFAULT '0',
  `row_index` int(10) NOT NULL DEFAULT '0',
  `row_name` varchar(200) DEFAULT '',
  `column_index` int(10) NOT NULL DEFAULT '0',
  `column_name` varchar(200) DEFAULT '',
  `comment` varchar(1000) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cell_template_id` bigint(19) NOT NULL DEFAULT '0',
  `data_type` int(10) NOT NULL DEFAULT '0',
  `is_read_only` int(10) NOT NULL DEFAULT '0',
  `copy_from_id` bigint(19) NOT NULL DEFAULT '0',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `project_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PRCR` (`period`,`row_index`,`column_index`,`project_id`,`report_template_id`),
  KEY `period_cell_template_report_template_id_IDX` (`report_template_id`,`project_id`,`period`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_cell_template_config
-- ----------------------------
DROP TABLE IF EXISTS `period_cell_template_config`;
CREATE TABLE `period_cell_template_config` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `period` int(10) NOT NULL DEFAULT '0',
  `cell_template_id` bigint(19) NOT NULL DEFAULT '0',
  `report_template_id` bigint(19) NOT NULL DEFAULT '0',
  `data_source_type` int(10) NOT NULL DEFAULT '0',
  `formula` varchar(500) NOT NULL DEFAULT '',
  `parsed_formula` varchar(1000) NOT NULL DEFAULT '',
  `formula_description` varchar(1000) DEFAULT '',
  `account_codes` varchar(1000) DEFAULT '',
  `invoice_type` int(10) NOT NULL DEFAULT '0',
  `tax_rate` varchar(50) DEFAULT '',
  `invoice_amount_type` int(10) NOT NULL DEFAULT '0',
  `model_ids` varchar(1000) DEFAULT '',
  `create_by` varchar(128) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(128) DEFAULT '',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `invoice_category` varchar(50) DEFAULT '',
  `formula_data_source` varchar(1000) DEFAULT '',
  `validation` varchar(1000) DEFAULT '',
  `parsed_validation` varchar(1000) DEFAULT '',
  `validation_description` varchar(1000) DEFAULT '',
  `voucher_keyword` varchar(1000) DEFAULT '',
  `cell_template_config_id` bigint(19) DEFAULT '0',
  `key_value_parsed_formula` varchar(1000) DEFAULT '',
  `project_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `period_cell_template_config_project_id_IDX` (`project_id`,`report_template_id`,`period`,`cell_template_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_data_source
-- ----------------------------
DROP TABLE IF EXISTS `period_data_source`;
CREATE TABLE `period_data_source` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `type` int(10) NOT NULL DEFAULT '0',
  `name` varchar(1000) DEFAULT '',
  `amount` decimal(20,4) NOT NULL DEFAULT '0.0000',
  `description` varchar(1000) DEFAULT '',
  `key_value_data_id` varchar(128) DEFAULT '',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `row_name` varchar(1000) DEFAULT '',
  `column_name` varchar(1000) DEFAULT '',
  `row_index` int(10) NOT NULL DEFAULT '0',
  `remap_batch_id` varchar(128) DEFAULT '',
  `column_index` int(10) NOT NULL DEFAULT '0',
  `cell_template_id` bigint(19) NOT NULL DEFAULT '0',
  `period` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `project_id` varchar(128) DEFAULT '',
  `keyin_data` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `period_data_source_period_IDX` (`period`,`project_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_data_source_detail
-- ----------------------------
DROP TABLE IF EXISTS `period_data_source_detail`;
CREATE TABLE `period_data_source_detail` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `data_source_id` bigint(19) NOT NULL DEFAULT '0',
  `data_source_type` int(10) NOT NULL DEFAULT '0',
  `item_value` varchar(500) DEFAULT '',
  `project_id` varchar(128) NOT NULL DEFAULT '',
  `period` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `period_data_source_detail_project_id_IDX` (`project_id`,`period`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_enterprise_account
-- ----------------------------
DROP TABLE IF EXISTS `period_enterprise_account`;
CREATE TABLE `period_enterprise_account` (
  `id` varchar(128) NOT NULL DEFAULT '',
  `acct_code` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `parent_code` varchar(50) DEFAULT '',
  `full_name` varchar(200) DEFAULT '',
  `acct_prop` int(10) DEFAULT '0',
  `sub_prop` int(10) DEFAULT '0',
  `acct_level` int(10) DEFAULT '0',
  `direction` int(10) NOT NULL DEFAULT '0',
  `is_leaf` tinyint(1) DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `english_name` varchar(200) DEFAULT '',
  `std_code` varchar(50) DEFAULT '',
  `enterprise_account_set_id` varchar(128) NOT NULL DEFAULT '',
  `is_dummy` int(10) DEFAULT '0',
  `is_in_voucher` int(10) DEFAULT '0',
  `creator_id` varchar(128) NOT NULL DEFAULT '',
  `updator_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `project_id` varchar(128) NOT NULL DEFAULT '',
  `period` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `period_enterprise_account_acct_code_IDX` (`acct_code`,`parent_code`,`project_id`,`period`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_formula_block
-- ----------------------------
DROP TABLE IF EXISTS `period_formula_block`;
CREATE TABLE `period_formula_block` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `period` int(10) NOT NULL DEFAULT '0',
  `report_id` bigint(19) NOT NULL DEFAULT '0',
  `cell_template_id` bigint(19) NOT NULL DEFAULT '0',
  `formula_expression` varchar(1000) NOT NULL DEFAULT '',
  `data` varchar(200) NOT NULL DEFAULT '',
  `data_source_id` bigint(19) NOT NULL DEFAULT '0',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `project_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `period_formula_block_period_IDX` (`period`,`report_id`,`project_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_info
-- ----------------------------
DROP TABLE IF EXISTS `period_info`;
CREATE TABLE `period_info` (
  `id` varchar(128) NOT NULL,
  `project_id` varchar(128) NOT NULL DEFAULT '',
  `period` int(10) NOT NULL DEFAULT '0',
  `status` int(10) NOT NULL DEFAULT '0',
  `creator_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `project_info` varchar(500) DEFAULT '',
  `import_type` int(10) NOT NULL DEFAULT '0',
  `service_type` int(10) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_job
-- ----------------------------
DROP TABLE IF EXISTS `period_job`;
CREATE TABLE `period_job` (
  `id` varchar(64) NOT NULL,
  `name` varchar(64) DEFAULT NULL,
  `current_step` varchar(64) DEFAULT NULL,
  `project_id` varchar(64) DEFAULT NULL,
  `period` int(10) DEFAULT NULL,
  `steps_code` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `status` varchar(4000) DEFAULT NULL,
  `error_msg` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_modified_report_cell
-- ----------------------------
DROP TABLE IF EXISTS `period_modified_report_cell`;
CREATE TABLE `period_modified_report_cell` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `report_id` bigint(19) NOT NULL DEFAULT '0',
  `row` int(10) NOT NULL DEFAULT '0',
  `col` int(10) NOT NULL DEFAULT '0',
  `original_value` varchar(1000) NOT NULL DEFAULT '',
  `value` varchar(1000) NOT NULL DEFAULT '',
  `related_cell_data_id` bigint(19) NOT NULL DEFAULT '0',
  `comment` varchar(1000) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `project_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_report
-- ----------------------------
DROP TABLE IF EXISTS `period_report`;
CREATE TABLE `period_report` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `template_id` bigint(19) NOT NULL DEFAULT '0',
  `period` int(10) NOT NULL DEFAULT '0',
  `project_id` varchar(128) NOT NULL DEFAULT '',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `period_report_template_id_IDX` (`template_id`,`period`,`project_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_standard_account
-- ----------------------------
DROP TABLE IF EXISTS `period_standard_account`;
CREATE TABLE `period_standard_account` (
  `id` varchar(128) NOT NULL DEFAULT '',
  `code` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `parent_code` varchar(50) DEFAULT '',
  `full_name` varchar(200) DEFAULT '',
  `acct_prop` int(10) DEFAULT '0',
  `sub_prop` int(10) DEFAULT '0',
  `acct_level` int(10) DEFAULT '0',
  `direction` int(10) NOT NULL DEFAULT '0',
  `is_leaf` tinyint(1) NOT NULL DEFAULT '0',
  `rule_type` int(10) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `english_name` varchar(200) DEFAULT '',
  `industry_id` varchar(128) NOT NULL DEFAULT '',
  `project_id` varchar(128) NOT NULL DEFAULT '',
  `period` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_tax_payer_report_rule
-- ----------------------------
DROP TABLE IF EXISTS `period_tax_payer_report_rule`;
CREATE TABLE `period_tax_payer_report_rule` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `is_default` int(10) NOT NULL DEFAULT '0',
  `period` int(10) NOT NULL DEFAULT '0',
  `tax_payer_type` int(10) NOT NULL DEFAULT '0',
  `template_group_id` bigint(19) NOT NULL DEFAULT '0',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tax_payer_report_rule_id` bigint(19) NOT NULL DEFAULT '0',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `project_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_tax_rule_setting
-- ----------------------------
DROP TABLE IF EXISTS `period_tax_rule_setting`;
CREATE TABLE `period_tax_rule_setting` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `is_default` int(10) NOT NULL DEFAULT '0',
  `period` int(10) NOT NULL DEFAULT '0',
  `group_name` varchar(50) NOT NULL DEFAULT '',
  `tax_base` varchar(1000) NOT NULL DEFAULT '',
  `tax_rate` tinyint(4) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tax_rule_setting_id` bigint(19) NOT NULL DEFAULT '0',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `project_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_tax_rule_setting_org
-- ----------------------------
DROP TABLE IF EXISTS `period_tax_rule_setting_org`;
CREATE TABLE `period_tax_rule_setting_org` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `tax_setting_id` bigint(19) NOT NULL DEFAULT '0',
  `period` int(10) NOT NULL DEFAULT '0',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `setting_org_id` bigint(19) NOT NULL DEFAULT '0',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `project_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for period_template
-- ----------------------------
DROP TABLE IF EXISTS `period_template`;
CREATE TABLE `period_template` (
  `id` bigint(19) NOT NULL DEFAULT '0',
  `period` int(10) NOT NULL DEFAULT '0',
  `name` varchar(1000) NOT NULL DEFAULT '',
  `code` varchar(1000) NOT NULL DEFAULT '',
  `path` varchar(1000) NOT NULL DEFAULT '',
  `report_type` int(10) NOT NULL DEFAULT '0',
  `template_group_id` bigint(19) NOT NULL DEFAULT '0',
  `order_index` int(10) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_system_type` tinyint(1) NOT NULL DEFAULT '0',
  `is_active_association` tinyint(1) NOT NULL DEFAULT '0',
  `parent_id` varchar(128) NOT NULL DEFAULT '',
  `template_id` bigint(19) NOT NULL DEFAULT '0',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `project_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PT_PERIOD_TEMPLATE` (`period`,`template_id`,`project_id`),
  KEY `period_template_period_IDX` (`period`,`template_group_id`,`project_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `id` varchar(128) NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `code` varchar(128) DEFAULT '',
  `operation_perm_list` varchar(200) DEFAULT '',
  `parent_id` varchar(128) DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `p_level` smallint(5) NOT NULL DEFAULT '0',
  `rely_on_codes` varchar(500) DEFAULT '',
  `menu_id` varchar(128) DEFAULT '',
  `service_type_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `permission_parent_id_IDX` (`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for profit_loss_statement
-- ----------------------------
DROP TABLE IF EXISTS `profit_loss_statement`;
CREATE TABLE `profit_loss_statement` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间yyyymm',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `status` varchar(10) NOT NULL DEFAULT '' COMMENT '关账标识',
  `ledger_id` varchar(128) NOT NULL DEFAULT '' COMMENT '账套ID',
  `ledger_name` varchar(300) NOT NULL DEFAULT '' COMMENT '账套名称',
  `ledger_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '账套币种',
  `entity_code` varchar(300) NOT NULL DEFAULT '' COMMENT '机构编码',
  `entity_name` varchar(300) NOT NULL DEFAULT '' COMMENT '机构名称',
  `category` varchar(300) NOT NULL DEFAULT '' COMMENT '主体性质',
  `frequency` varchar(300) NOT NULL DEFAULT '' COMMENT '频度',
  `item_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目名称',
  `period_amt` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本期发生额',
  `ytd_amt` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本年累计',
  `prc_flag` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为国外',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='利润表。月度,次月传送上月,全部主体,只传送账套币种即折算后本位币币种金额';

-- ----------------------------
-- Table structure for profit_loss_statement_final
-- ----------------------------
DROP TABLE IF EXISTS `profit_loss_statement_final`;
CREATE TABLE `profit_loss_statement_final` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间yyyymm',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `status` varchar(10) NOT NULL DEFAULT '' COMMENT '关账标识',
  `ledger_id` varchar(128) NOT NULL DEFAULT '' COMMENT '账套ID',
  `ledger_name` varchar(300) NOT NULL DEFAULT '' COMMENT '账套名称',
  `ledger_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '账套币种',
  `entity_code` varchar(300) NOT NULL DEFAULT '' COMMENT '机构编码',
  `entity_name` varchar(300) NOT NULL DEFAULT '' COMMENT '机构名称',
  `category` varchar(300) NOT NULL DEFAULT '' COMMENT '主体性质',
  `frequency` varchar(300) NOT NULL DEFAULT '' COMMENT '频度',
  `item_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目名称',
  `period_amt` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本期发生额',
  `ytd_amt` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本年累计',
  `prc_flag` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为国外',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='利润表。最新版本,与接口导入、excel导入中最新版本一致';

-- ----------------------------
-- Table structure for profit_loss_statement_manual
-- ----------------------------
DROP TABLE IF EXISTS `profit_loss_statement_manual`;
CREATE TABLE `profit_loss_statement_manual` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源',
  `tms_period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '税务系统期间yyyymm',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `status` varchar(10) NOT NULL DEFAULT '' COMMENT '关账标识',
  `ledger_id` varchar(128) NOT NULL DEFAULT '' COMMENT '账套ID',
  `ledger_name` varchar(300) NOT NULL DEFAULT '' COMMENT '账套名称',
  `ledger_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '账套币种',
  `entity_code` varchar(300) NOT NULL DEFAULT '' COMMENT '机构编码',
  `entity_name` varchar(300) NOT NULL DEFAULT '' COMMENT '机构名称',
  `category` varchar(300) NOT NULL DEFAULT '' COMMENT '主体性质',
  `frequency` varchar(300) NOT NULL DEFAULT '' COMMENT '频度',
  `item_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目名称',
  `period_amt` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本期发生额',
  `ytd_amt` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本年累计',
  `prc_flag` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为国外',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='利润表。人工调整,excel导入';

-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
  `id` varchar(128) NOT NULL,
  `code` varchar(50) NOT NULL DEFAULT '',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL DEFAULT '',
  `year` int(10) NOT NULL DEFAULT '0',
  `client_code` varchar(50) NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `region_id` varchar(128) NOT NULL DEFAULT '',
  `industry_id` varchar(128) NOT NULL DEFAULT '',
  `rule_type` int(10) NOT NULL DEFAULT '0',
  `db_name` varchar(64) DEFAULT '',
  `enterprise_account_set_id` varchar(128) DEFAULT '',
  `start_period` int(10) NOT NULL DEFAULT '0',
  `end_period` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for project_client
-- ----------------------------
DROP TABLE IF EXISTS `project_client`;
CREATE TABLE `project_client` (
  `id` varchar(128) NOT NULL,
  `code` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL DEFAULT '',
  `industry_id` varchar(128) NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for project_service_type
-- ----------------------------
DROP TABLE IF EXISTS `project_service_type`;
CREATE TABLE `project_service_type` (
  `id` varchar(128) NOT NULL,
  `project_id` varchar(128) DEFAULT '',
  `service_type_id` varchar(128) DEFAULT '',
  `template_group_id` bigint(19) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for project_status_manage
-- ----------------------------
DROP TABLE IF EXISTS `project_status_manage`;
CREATE TABLE `project_status_manage` (
  `id` varchar(128) NOT NULL,
  `project_id` varchar(128) DEFAULT '',
  `period_id` int(10) DEFAULT '0',
  `status` int(10) DEFAULT '0',
  `creator_id` varchar(128) DEFAULT '',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `db_name` varchar(64) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `project_status_manage_project_id_IDX` (`project_id`,`period_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for pwc_report_attach
-- ----------------------------
DROP TABLE IF EXISTS `pwc_report_attach`;
CREATE TABLE `pwc_report_attach` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `template_id` varchar(64) DEFAULT NULL COMMENT '对应sheet模板ID',
  `col` bigint(20) DEFAULT NULL COMMENT '列',
  `row` bigint(20) DEFAULT NULL COMMENT '行',
  `del_flag` varchar(64) DEFAULT NULL,
  `file_name` varchar(64) DEFAULT NULL,
  `file_url` varchar(200) DEFAULT NULL,
  `upload_user` varchar(64) DEFAULT NULL,
  `size` varchar(64) DEFAULT NULL,
  `remarks` varchar(64) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COMMENT='附件和report单元格关联表';

-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
CREATE TABLE `QRTZ_CALENDARS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(120) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
CREATE TABLE `QRTZ_JOB_DETAILS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
CREATE TABLE `QRTZ_LOCKS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) 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`),
  CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
CREATE TABLE `QRTZ_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for red_letter_info_table
-- ----------------------------
DROP TABLE IF EXISTS `red_letter_info_table`;
CREATE TABLE `red_letter_info_table` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `subject_num` varchar(128) NOT NULL DEFAULT '' COMMENT '主体编号',
  `subject_name` varchar(300) NOT NULL DEFAULT '' COMMENT '主体(购方)名称',
  `red_letter_invoice_info_table_num` varchar(128) NOT NULL DEFAULT '' COMMENT '红字发票信息表编号',
  `fill_in_date` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '填开日期 yyyyMM',
  `sales_tax_number` varchar(128) NOT NULL DEFAULT '' COMMENT '销方税号',
  `salesperson_name` varchar(300) NOT NULL DEFAULT '' COMMENT '销方名称',
  `total_amount` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '合计金额',
  `total_tax_amount` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '合计税额',
  `application_description` varchar(500) NOT NULL DEFAULT '' COMMENT '申请选择(说明)',
  `applicant_manager` varchar(20) NOT NULL DEFAULT '' COMMENT '申请方经办人',
  `invoice_code` varchar(128) NOT NULL DEFAULT '' COMMENT '发票代码',
  `invoice_number` varchar(128) NOT NULL DEFAULT '' COMMENT '发票号码',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='红字信息表';

-- ----------------------------
-- Table structure for region
-- ----------------------------
DROP TABLE IF EXISTS `region`;
CREATE TABLE `region` (
  `id` varchar(128) NOT NULL,
  `parent_id` varchar(128) DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `short_name` varchar(10) NOT NULL DEFAULT '',
  `merger_name` varchar(200) NOT NULL DEFAULT '',
  `level_type` int(10) NOT NULL DEFAULT '0',
  `tel_code` varchar(10) DEFAULT '',
  `zip_code` varchar(11) DEFAULT '',
  `pin_yin` varchar(50) NOT NULL DEFAULT '',
  `longitude` float NOT NULL DEFAULT '0',
  `latitude` float NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parent_id_IDX` (`parent_id`),
  KEY `region_parent_id_IDX` (`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for revenue_config
-- ----------------------------
DROP TABLE IF EXISTS `revenue_config`;
CREATE TABLE `revenue_config` (
  `id` bigint(18) NOT NULL,
  `serial_no` varchar(50) NOT NULL DEFAULT '' COMMENT '序号',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '收入类型名称',
  `org_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构ID',
  `account_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '账载收入类型   0.0值 1.科目 2.手工输入',
  `account_name` varchar(255) NOT NULL DEFAULT '' COMMENT '账载收入名称',
  `tax_rate` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '税率',
  `tax_base` tinyint(4) NOT NULL DEFAULT '0' COMMENT '计税基础  1.账载 2.开票收入 3.手工录入 4.借方发生额 5.贷方发生额',
  `revenue_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '收入类别 0.货物及加工修理修配劳务 1.服务、不动产和无形资产',
  `tax_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '计税方法 0.一般计税 1.简易计税 2.免抵退税 3.免税',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态 0:启用 1:停用',
  `start_date` varchar(10) NOT NULL DEFAULT '' COMMENT '启用日期',
  `end_date` varchar(10) NOT NULL DEFAULT '' COMMENT '终止日期',
  `tb_segment3` varchar(255) NOT NULL DEFAULT '' COMMENT '账载科目代码',
  `tb_segment5` varchar(255) NOT NULL DEFAULT '' COMMENT '账载利润中心代码',
  `tb_segment6` varchar(255) NOT NULL DEFAULT '' COMMENT '账载产品代码',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `base_cr_code` varchar(255) NOT NULL DEFAULT '' COMMENT '计税基础贷方发生额Code',
  `base_dr_code` varchar(255) NOT NULL DEFAULT '' COMMENT '计税基础借方发生额Code',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_org_name` (`org_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收入类型配置表';

-- ----------------------------
-- Table structure for revenue_type_mapping
-- ----------------------------
DROP TABLE IF EXISTS `revenue_type_mapping`;
CREATE TABLE `revenue_type_mapping` (
  `id` bigint(18) NOT NULL,
  `org_id` varchar(128) NOT NULL DEFAULT '' COMMENT '机构ID',
  `ou_name` varchar(255) NOT NULL DEFAULT '' COMMENT '申请部门',
  `content` varchar(255) NOT NULL DEFAULT '' COMMENT '开票内容',
  `tax_rate` decimal(6,4) NOT NULL DEFAULT '0.0000' COMMENT '税率',
  `revenue_type_name` varchar(255) NOT NULL DEFAULT '' COMMENT '收入类型名',
  `start_date` varchar(10) NOT NULL DEFAULT '' COMMENT '启用日期',
  `end_date` varchar(10) NOT NULL DEFAULT '' COMMENT '终止日期',
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='开票与收入类型映射';

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` varchar(128) NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `description` varchar(500) DEFAULT '',
  `role_category_id` varchar(128) NOT NULL DEFAULT '',
  `service_type_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `role_role_category_id_IDX` (`role_category_id`,`service_type_id`) USING BTREE,
  KEY `role_name_IDX` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for role_category
-- ----------------------------
DROP TABLE IF EXISTS `role_category`;
CREATE TABLE `role_category` (
  `id` varchar(128) NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `role_category_name_IDX` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
  `id` varchar(128) NOT NULL,
  `role_id` varchar(128) NOT NULL DEFAULT '',
  `permission_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for service_type
-- ----------------------------
DROP TABLE IF EXISTS `service_type`;
CREATE TABLE `service_type` (
  `id` varchar(128) NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `prefix` varchar(50) NOT NULL DEFAULT '',
  `is_active` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for standard_account
-- ----------------------------
DROP TABLE IF EXISTS `standard_account`;
CREATE TABLE `standard_account` (
  `id` varchar(128) NOT NULL,
  `code` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `parent_code` varchar(50) DEFAULT '',
  `full_name` varchar(200) NOT NULL DEFAULT '',
  `acct_prop` int(10) DEFAULT '0',
  `sub_prop` int(10) DEFAULT '0',
  `acct_level` int(10) DEFAULT '0',
  `direction` int(10) DEFAULT '0',
  `is_leaf` tinyint(1) DEFAULT '0',
  `rule_type` int(10) DEFAULT '0',
  `is_active` tinyint(1) DEFAULT '0',
  `english_name` varchar(200) DEFAULT '',
  `industry_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `standard_account_parent_code_IDX` (`parent_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for statistic_attribute
-- ----------------------------
DROP TABLE IF EXISTS `statistic_attribute`;
CREATE TABLE `statistic_attribute` (
  `id` varchar(128) NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for statistic_attribute_dimension
-- ----------------------------
DROP TABLE IF EXISTS `statistic_attribute_dimension`;
CREATE TABLE `statistic_attribute_dimension` (
  `id` varchar(128) NOT NULL,
  `dimension_id` varchar(128) NOT NULL DEFAULT '',
  `statistics_attribute_id` varchar(128) NOT NULL DEFAULT '',
  `order_index` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for stock
-- ----------------------------
DROP TABLE IF EXISTS `stock`;
CREATE TABLE `stock` (
  `id` varchar(128) NOT NULL,
  `name` varchar(500) NOT NULL DEFAULT '',
  `code` varchar(200) DEFAULT '',
  `stock_amount` tinyint(3) NOT NULL DEFAULT '0',
  `capital_amount` tinyint(3) NOT NULL DEFAULT '0',
  `capital_percent` tinyint(3) NOT NULL DEFAULT '0',
  `effective_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `expired_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `parent_id` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for table_menu
-- ----------------------------
DROP TABLE IF EXISTS `table_menu`;
CREATE TABLE `table_menu` (
  `id` bigint(18) NOT NULL DEFAULT '0' COMMENT '系统唯一标识',
  `menu_name_cn` varchar(100) NOT NULL DEFAULT ' ' COMMENT '菜单中文',
  `menu_name_en` varchar(100) NOT NULL DEFAULT ' ' COMMENT '菜单英文',
  `menu_index` int(1) NOT NULL DEFAULT '0' COMMENT '菜单排序',
  `order_index` int(1) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='一级菜单表';

-- ----------------------------
-- Table structure for table_test
-- ----------------------------
DROP TABLE IF EXISTS `table_test`;
CREATE TABLE `table_test` (
  `id` bigint(18) NOT NULL,
  `stat_period` int(11) NOT NULL DEFAULT '0',
  `test` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`,`stat_period`),
  KEY `table_test_test_index` (`test`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
/*!50100 PARTITION BY RANGE (stat_period)
(PARTITION p_01 VALUES LESS THAN (201902) ENGINE = InnoDB,
 PARTITION p_02 VALUES LESS THAN (201903) ENGINE = InnoDB,
 PARTITION p_03 VALUES LESS THAN (201904) ENGINE = InnoDB,
 PARTITION p_04 VALUES LESS THAN (201905) ENGINE = InnoDB) */;

-- ----------------------------
-- Table structure for tax_payer_report_rule
-- ----------------------------
DROP TABLE IF EXISTS `tax_payer_report_rule`;
CREATE TABLE `tax_payer_report_rule` (
  `id` bigint(19) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `tax_payer_type` int(10) NOT NULL DEFAULT '0',
  `template_group_id` bigint(19) NOT NULL DEFAULT '0',
  `organization_id` varchar(128) DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_by` varchar(128) DEFAULT '',
  `update_by` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `tax_payer_report_rule_template_group_id_IDX` (`template_group_id`,`organization_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for tax_rule_setting
-- ----------------------------
DROP TABLE IF EXISTS `tax_rule_setting`;
CREATE TABLE `tax_rule_setting` (
  `id` bigint(19) NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `group_name` varchar(50) NOT NULL DEFAULT '',
  `tax_base` varchar(1000) NOT NULL DEFAULT '',
  `tax_rate` float NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_by` varchar(128) DEFAULT '',
  `update_by` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for tax_rule_setting_organization
-- ----------------------------
DROP TABLE IF EXISTS `tax_rule_setting_organization`;
CREATE TABLE `tax_rule_setting_organization` (
  `id` bigint(19) NOT NULL,
  `tax_setting_id` bigint(19) NOT NULL DEFAULT '0',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_by` varchar(128) NOT NULL DEFAULT '',
  `update_by` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `tax_rule_setting_organization_tax_setting_id_IDX` (`tax_setting_id`,`organization_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for template
-- ----------------------------
DROP TABLE IF EXISTS `template`;
CREATE TABLE `template` (
  `id` bigint(19) NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `code` varchar(200) NOT NULL DEFAULT '',
  `path` varchar(500) NOT NULL DEFAULT '',
  `report_type` int(10) NOT NULL DEFAULT '0',
  `template_group_id` bigint(19) NOT NULL DEFAULT '0',
  `order_index` int(10) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_system_type` tinyint(1) NOT NULL DEFAULT '0',
  `is_active_association` tinyint(1) NOT NULL DEFAULT '0',
  `parent_id` varchar(128) DEFAULT '',
  `create_by` varchar(128) DEFAULT '',
  `update_by` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `template_template_group_id_IDX` (`template_group_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for template_formula
-- ----------------------------
DROP TABLE IF EXISTS `template_formula`;
CREATE TABLE `template_formula` (
  `id` varchar(128) NOT NULL,
  `row_index` int(10) NOT NULL DEFAULT '0',
  `column_index` int(10) NOT NULL DEFAULT '0',
  `column_end_index` int(10) DEFAULT '0',
  `formula` varchar(500) NOT NULL DEFAULT '',
  `template_id` varchar(128) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_manual_change` tinyint(1) NOT NULL DEFAULT '0',
  `instructions` varchar(500) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for template_group
-- ----------------------------
DROP TABLE IF EXISTS `template_group`;
CREATE TABLE `template_group` (
  `id` bigint(19) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `service_type_id` varchar(128) NOT NULL DEFAULT '',
  `industry_ids` varchar(1000) NOT NULL DEFAULT '',
  `pay_tax_type` int(10) NOT NULL DEFAULT '0',
  `group_type` int(10) NOT NULL DEFAULT '0',
  `copy_from` bigint(19) NOT NULL DEFAULT '0',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_system_type` tinyint(1) NOT NULL DEFAULT '0',
  `create_by` varchar(128) DEFAULT '',
  `update_by` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for trial_balance
-- ----------------------------
DROP TABLE IF EXISTS `trial_balance`;
CREATE TABLE `trial_balance` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `ledger_id` varchar(128) NOT NULL DEFAULT '' COMMENT '账套ID',
  `ledger_name` varchar(300) NOT NULL DEFAULT '' COMMENT '账套名称',
  `currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '账套币种',
  `status` varchar(20) NOT NULL DEFAULT '' COMMENT '关账标识',
  `category` varchar(10) NOT NULL DEFAULT '' COMMENT '主体性质',
  `account_category` varchar(20) NOT NULL DEFAULT '' COMMENT '科目性质',
  `acct_code1` varchar(300) NOT NULL DEFAULT '' COMMENT '一级科目代码',
  `acct_name1` varchar(300) NOT NULL DEFAULT '' COMMENT '一级科目说明',
  `acct_name2` varchar(300) NOT NULL DEFAULT '' COMMENT '二级科目说明',
  `acct_name3` varchar(300) NOT NULL DEFAULT '' COMMENT '三级科目说明',
  `segment1` varchar(300) NOT NULL DEFAULT '' COMMENT '主体代码',
  `segment2` varchar(300) NOT NULL DEFAULT '' COMMENT '成本中心代码',
  `segment3` varchar(300) NOT NULL DEFAULT '' COMMENT '科目代码',
  `segment4` varchar(300) NOT NULL DEFAULT '' COMMENT '辅助科目代码',
  `segment5` varchar(300) NOT NULL DEFAULT '' COMMENT '利润中心代码',
  `segment6` varchar(300) NOT NULL DEFAULT '' COMMENT '产品代码',
  `segment7` varchar(300) NOT NULL DEFAULT '' COMMENT '项目代码',
  `segment8` varchar(300) NOT NULL DEFAULT '' COMMENT '公司间代码',
  `segment9` varchar(300) NOT NULL DEFAULT '' COMMENT '备用1代码',
  `segment10` varchar(300) NOT NULL DEFAULT '' COMMENT '备用2代码',
  `segment1_name` varchar(300) NOT NULL DEFAULT '' COMMENT '主体说明',
  `segment2_name` varchar(300) NOT NULL DEFAULT '' COMMENT '成本中心说明',
  `segment3_name` varchar(300) NOT NULL DEFAULT '' COMMENT '科目说明',
  `segment4_name` varchar(300) NOT NULL DEFAULT '' COMMENT '辅助科目说明',
  `segment5_name` varchar(300) NOT NULL DEFAULT '' COMMENT '利润中心说明',
  `segment6_name` varchar(300) NOT NULL DEFAULT '' COMMENT '产品说明',
  `segment7_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目说明',
  `segment8_name` varchar(300) NOT NULL DEFAULT '' COMMENT '公司间说明',
  `segment9_name` varchar(300) NOT NULL DEFAULT '' COMMENT '备用1说明',
  `segment10_name` varchar(300) NOT NULL DEFAULT '' COMMENT '备用2说明',
  `beg_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本期期初余额',
  `period_dr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本期借方发生额',
  `period_cr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本期贷方发生额',
  `end_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本期期末余额',
  `qtd_dr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本季借方发生额',
  `qtd_cr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本季贷方发生额',
  `ytd_dr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本年借方发生额',
  `ytd_cr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本年贷方发生额',
  `beg_bal_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本期期初余额',
  `period_dr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本期借方发生额',
  `period_cr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本期贷方发生额',
  `end_bal_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本期期末余额',
  `qtd_dr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本季借方发生额',
  `qtd_cr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本季贷方发生额',
  `ytd_dr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本年借方发生额',
  `ytd_cr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本年贷方发生额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='月度科目余额表。月度,次月传送上月,全部主体';

-- ----------------------------
-- Table structure for trial_balance_final
-- ----------------------------
DROP TABLE IF EXISTS `trial_balance_final`;
CREATE TABLE `trial_balance_final` (
  `id` bigint(22) NOT NULL COMMENT '唯一编号',
  `organization_id` varchar(128) NOT NULL COMMENT '机构编号',
  `project_id` varchar(128) NOT NULL DEFAULT '' COMMENT '项目ID',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据日期',
  `source` varchar(20) NOT NULL DEFAULT '' COMMENT '来源',
  `period` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '期间 yyyymm',
  `ledger_id` varchar(128) NOT NULL DEFAULT '' COMMENT '账套ID',
  `ledger_name` varchar(300) NOT NULL DEFAULT '' COMMENT '账套名称',
  `currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '账套币种',
  `status` varchar(20) NOT NULL DEFAULT '' COMMENT '关账标识',
  `category` varchar(10) NOT NULL DEFAULT '' COMMENT '主体性质',
  `account_category` varchar(20) NOT NULL DEFAULT '' COMMENT '科目性质',
  `acct_code1` varchar(300) NOT NULL DEFAULT '' COMMENT '一级科目代码',
  `acct_name1` varchar(300) NOT NULL DEFAULT '' COMMENT '一级科目说明',
  `acct_name2` varchar(300) NOT NULL DEFAULT '' COMMENT '二级科目说明',
  `acct_name3` varchar(300) NOT NULL DEFAULT '' COMMENT '三级科目说明',
  `segment1` varchar(300) NOT NULL DEFAULT '' COMMENT '主体代码',
  `segment2` varchar(300) NOT NULL DEFAULT '' COMMENT '成本中心代码',
  `segment3` varchar(300) NOT NULL DEFAULT '' COMMENT '科目代码',
  `segment4` varchar(300) NOT NULL DEFAULT '' COMMENT '辅助科目代码',
  `segment5` varchar(300) NOT NULL DEFAULT '' COMMENT '利润中心代码',
  `segment6` varchar(300) NOT NULL DEFAULT '' COMMENT '产品代码',
  `segment7` varchar(300) NOT NULL DEFAULT '' COMMENT '项目代码',
  `segment8` varchar(300) NOT NULL DEFAULT '' COMMENT '公司间代码',
  `segment9` varchar(300) NOT NULL DEFAULT '' COMMENT '备用1代码',
  `segment10` varchar(300) NOT NULL DEFAULT '' COMMENT '备用2代码',
  `segment1_name` varchar(300) NOT NULL DEFAULT '' COMMENT '主体说明',
  `segment2_name` varchar(300) NOT NULL DEFAULT '' COMMENT '成本中心说明',
  `segment3_name` varchar(300) NOT NULL DEFAULT '' COMMENT '科目说明',
  `segment4_name` varchar(300) NOT NULL DEFAULT '' COMMENT '辅助科目说明',
  `segment5_name` varchar(300) NOT NULL DEFAULT '' COMMENT '利润中心说明',
  `segment6_name` varchar(300) NOT NULL DEFAULT '' COMMENT '产品说明',
  `segment7_name` varchar(300) NOT NULL DEFAULT '' COMMENT '项目说明',
  `segment8_name` varchar(300) NOT NULL DEFAULT '' COMMENT '公司间说明',
  `segment9_name` varchar(300) NOT NULL DEFAULT '' COMMENT '备用1说明',
  `segment10_name` varchar(300) NOT NULL DEFAULT '' COMMENT '备用2说明',
  `beg_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本期期初余额',
  `period_dr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本期借方发生额',
  `period_cr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本期贷方发生额',
  `end_bal` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本期期末余额',
  `qtd_dr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本季借方发生额',
  `qtd_cr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本季贷方发生额',
  `ytd_dr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本年借方发生额',
  `ytd_cr` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '原币本年贷方发生额',
  `beg_bal_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本期期初余额',
  `period_dr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本期借方发生额',
  `period_cr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本期贷方发生额',
  `end_bal_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本期期末余额',
  `qtd_dr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本季借方发生额',
  `qtd_cr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本季贷方发生额',
  `ytd_dr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本年借方发生额',
  `ytd_cr_beq` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '本位币本年贷方发生额',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='月度科目余额表(汇总)。月度,次月传送上月,全部主体';

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` varchar(128) NOT NULL DEFAULT '',
  `user_name` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(200) DEFAULT '',
  `password` varchar(200) DEFAULT '',
  `login_type` int(10) NOT NULL DEFAULT '0',
  `status` int(10) NOT NULL DEFAULT '0',
  `expiration_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `password_update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `attempt_times` int(10) NOT NULL DEFAULT '0',
  `locked_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `is_super_admin` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_user_name_IDX` (`user_name`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for user_dimension_value
-- ----------------------------
DROP TABLE IF EXISTS `user_dimension_value`;
CREATE TABLE `user_dimension_value` (
  `id` varchar(128) NOT NULL,
  `user_id` varchar(128) NOT NULL DEFAULT ' ',
  `dimension_id` varchar(128) NOT NULL DEFAULT ' ',
  `dimension_value_id` varchar(128) NOT NULL DEFAULT ' ',
  `is_accessible` tinyint(1) NOT NULL DEFAULT '0',
  `has_original_role` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_dimension_value_user_id_IDX` (`user_id`,`dimension_id`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for user_dimension_value_org
-- ----------------------------
DROP TABLE IF EXISTS `user_dimension_value_org`;
CREATE TABLE `user_dimension_value_org` (
  `id` varchar(128) NOT NULL,
  `user_dimension_value_id` varchar(128) NOT NULL DEFAULT '',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `is_heritable` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for user_dimension_value_role
-- ----------------------------
DROP TABLE IF EXISTS `user_dimension_value_role`;
CREATE TABLE `user_dimension_value_role` (
  `id` varchar(128) NOT NULL,
  `user_dimension_value_id` varchar(128) NOT NULL DEFAULT '',
  `role_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for user_historical_password
-- ----------------------------
DROP TABLE IF EXISTS `user_historical_password`;
CREATE TABLE `user_historical_password` (
  `id` varchar(128) NOT NULL,
  `user_id` varchar(128) NOT NULL DEFAULT '',
  `password` varchar(200) NOT NULL DEFAULT '',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for user_organization
-- ----------------------------
DROP TABLE IF EXISTS `user_organization`;
CREATE TABLE `user_organization` (
  `id` varchar(128) NOT NULL,
  `user_id` varchar(128) NOT NULL DEFAULT '',
  `organization_id` varchar(128) NOT NULL DEFAULT '',
  `is_accessible` tinyint(1) DEFAULT '0',
  `has_original_role` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `index_uid` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for user_organization_role
-- ----------------------------
DROP TABLE IF EXISTS `user_organization_role`;
CREATE TABLE `user_organization_role` (
  `id` varchar(128) NOT NULL,
  `user_organization_id` varchar(128) NOT NULL DEFAULT '',
  `role_id` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `id` varchar(128) NOT NULL,
  `user_id` varchar(128) NOT NULL DEFAULT '',
  `role_id` varchar(128) NOT NULL DEFAULT '',
  `project_id` varchar(128) DEFAULT '',
  `service_type_id` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;