You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2339 lines
132 KiB
2339 lines
132 KiB
#### 2021/12/22
|
|
create table ticket_type_mapping
|
|
(
|
|
ID int,
|
|
TICKET_CODE VARCHAR(10) null comment '票种code',
|
|
TITLE VARCHAR(50) null comment '发票title',
|
|
TICKET_CODE_MAPPING VARCHAR(10) null comment '票种mapping',
|
|
ACTIVE BOOLEAN default TRUE null comment '是否可用'
|
|
)
|
|
comment '发票类型匹配表';
|
|
|
|
create unique index ticket_type_mapping_ID_uindex
|
|
on ticket_type_mapping (ID);
|
|
|
|
alter table ticket_type_mapping
|
|
add constraint ticket_type_mapping_pk
|
|
primary key (ID);
|
|
|
|
alter table ticket_type_mapping
|
|
modify ID int auto_increment;
|
|
|
|
alter table user
|
|
add VALID_TYPE int(1) default 0 null comment '验真模式 0 常规 1隐式';
|
|
|
|
alter table company
|
|
add VALID_MODE TINYINT(1) default 0 null comment '验真模式 1 前后都验真 2 前后都不验真 3 前不验真后验真';
|
|
|
|
alter table verified_user
|
|
add VALID_MODE TINYINT(1) default 0 null comment '验真模式 1 前后都验真 2 前后都不验真 3 前不验真后验真';
|
|
|
|
alter table user
|
|
drop column VALID_TYPE;
|
|
|
|
create table account_mapping
|
|
(
|
|
ID int comment '主键ID',
|
|
TYPE VARCHAR(100) null comment '类型',
|
|
DEBIT_ACCOUNT1 varchar(50) null comment '借方科目1',
|
|
CREDIT_SUBJECT1 varchar(50) null comment '贷方科目1',
|
|
DEBIT_ACCOUNT2 varchar(50) null comment '借方科目2',
|
|
CREDIT_SUBJECT2 varchar(50) null comment '贷方科目2'
|
|
)
|
|
comment '费用科目表';
|
|
|
|
create unique index expense_subject_ID_uindex
|
|
on account_mapping (ID);
|
|
|
|
alter table account_mapping
|
|
add constraint expense_subject_pk
|
|
primary key (ID);
|
|
|
|
alter table account_mapping
|
|
modify ID int auto_increment comment '主键ID';
|
|
|
|
alter table corporate_invoice
|
|
add SUBJECT int null comment '科目id';
|
|
|
|
alter table expense_type_active_tt
|
|
add EDITABLE TINYINT(1) default 0 null comment '0 不可编辑 1 可编辑';
|
|
|
|
create table account_object
|
|
(
|
|
ID int,
|
|
CATEGORY VARCHAR(50) null comment '科目类别',
|
|
ACCOUNT VARCHAR(50) null comment '科目',
|
|
DESCRIPTION VARCHAR(255) null comment '描述',
|
|
LEVEL VARCHAR(20) null comment '级别',
|
|
REMARK VARCHAR(255) null comment '备注'
|
|
)
|
|
comment '科目';
|
|
|
|
create unique index account_object_ID_uindex
|
|
on account_object (ID);
|
|
|
|
alter table account_object
|
|
add constraint account_object_pk
|
|
primary key (ID);
|
|
|
|
alter table account_object
|
|
modify ID int auto_increment;
|
|
|
|
create index account_object_ACCOUNT_index
|
|
on account_object (ACCOUNT);
|
|
|
|
drop index invoice_library_INVOICE_NUM_uindex on invoice_library;
|
|
|
|
create unique index invoice_library_INVOICE_NUM_INVOICE_CODE_uindex
|
|
on invoice_library (INVOICE_NUM, INVOICE_CODE);
|
|
|
|
|
|
####PRC HAS UPDATED
|
|
alter table invoice_lines
|
|
add VALID_STATUS BOOLEAN default FALSE null;
|
|
|
|
create table smarttax_infos
|
|
(
|
|
ID BIGINT,
|
|
NAME VARCHAR(30) null comment '接口名',
|
|
PARAM1 VARCHAR(100) null,
|
|
PARAM2 VARCHAR(100) null,
|
|
PARAM3 VARCHAR(100) null,
|
|
PARAM4 VARCHAR(100) null,
|
|
PARAM5 VARCHAR(100) null,
|
|
RESULT TEXT null,
|
|
TYPE VARCHAR(30) null
|
|
)
|
|
comment '慧穗接口信息';
|
|
|
|
create unique index smarttax_infos_ID_uindex
|
|
on smarttax_infos (ID);
|
|
|
|
alter table smarttax_infos
|
|
add constraint smarttax_infos_pk
|
|
primary key (ID);
|
|
|
|
alter table smarttax_infos
|
|
modify ID BIGINT auto_increment;
|
|
|
|
create table smarttax_company
|
|
(
|
|
ID BIGINT,
|
|
NAME VARCHAR(50) null,
|
|
COM_NAME VARCHAR(50) null,
|
|
TAX_NO VARCHAR(50) null,
|
|
ACTIVE BOOLEAN default TRUE null
|
|
)
|
|
comment '慧穗公司白名单';
|
|
|
|
create unique index smarttax_company_ID_uindex
|
|
on smarttax_company (ID);
|
|
|
|
alter table smarttax_company
|
|
add constraint smarttax_company_pk
|
|
primary key (ID);
|
|
|
|
alter table smarttax_company
|
|
modify ID BIGINT auto_increment;
|
|
|
|
create table report_images
|
|
(
|
|
ID BIGINT,
|
|
REPORT_ID VARCHAR(50) not null,
|
|
IMG_URI VARCHAR(200) null
|
|
)
|
|
comment '面单影像';
|
|
|
|
create unique index report_images_ID_uindex
|
|
on report_images (ID);
|
|
|
|
create index report_images_REPORT_ID_index
|
|
on report_images (REPORT_ID);
|
|
|
|
alter table report_images
|
|
add constraint report_images_pk
|
|
primary key (ID);
|
|
|
|
alter table report_images
|
|
modify ID BIGINT auto_increment;
|
|
|
|
alter table invoice_image_files
|
|
add REPORT_ID VARCHAR(50) null;
|
|
|
|
|
|
create table error_report
|
|
(
|
|
ID BIGINT comment '主键ID',
|
|
REPORT_ID VARCHAR(50) not null comment '报告',
|
|
STATUS VARCHAR(50) null comment '状态',
|
|
CREATE_TIME DATETIME null comment '创建时间'
|
|
)
|
|
comment '异常报告';
|
|
|
|
create unique index error_report_ID_uindex
|
|
on error_report (ID);
|
|
|
|
alter table error_report
|
|
add constraint error_report_pk
|
|
primary key (ID);
|
|
|
|
alter table error_report
|
|
modify ID BIGINT auto_increment comment '主键ID';
|
|
|
|
|
|
alter table verified_user
|
|
modify VALID_MODE smallint(1) default 0 null comment '验真模式 1 前后都验真 2 前后都不验真 3 前不验真后验真';
|
|
|
|
alter table verified_user
|
|
modify MANUAL smallint(1) default 0 null;
|
|
|
|
|
|
##### 0207
|
|
create table expense_type_active_tt_list_config
|
|
(
|
|
LIST_NAME VARCHAR(20) not null,
|
|
TYPE VARCHAR(20) not null,
|
|
VALUE VARCHAR(20) null
|
|
)
|
|
comment '动态字段 list 类型配置';
|
|
|
|
create unique index expense_type_active_tt_list_config_LIST_NAME_uindex
|
|
on expense_type_active_tt_list_config (LIST_NAME);
|
|
|
|
alter table expense_type_active_tt_list_config
|
|
add constraint expense_type_active_tt_list_config_pk
|
|
primary key (LIST_NAME);
|
|
|
|
create index value_set_CATEGORY_index
|
|
on value_set (CATEGORY);
|
|
|
|
create index expense_type_active_tt_KIND_PID_index
|
|
on expense_type_active_tt (KIND, PID);
|
|
|
|
create index expense_type_active_tt_IS_DEL_index
|
|
on expense_type_active_tt (IS_DEL);
|
|
|
|
#### updated 20220207
|
|
alter table corporate_invoice_type
|
|
add MATCH_TYPE TINYINT(1) default 0 null comment '匹配类型 0 金额匹配 1 数量匹配';
|
|
|
|
alter table compliance_check
|
|
add ORIGINAL_ID int null;
|
|
|
|
alter table supplier_matching_log
|
|
add PRE_VALUE VARCHAR(255) null;
|
|
|
|
alter table supplier_matching_log
|
|
add AFTER_VALUE VARCHAR(255) null;
|
|
|
|
|
|
|
|
alter table invoice_image_files
|
|
modify ORIGINAL_ID varchar(100) null comment '源ID';
|
|
|
|
create index corporate_invoice_items_PID_index
|
|
on corporate_invoice_items (PID);
|
|
|
|
alter table supplier_matching_log
|
|
modify ID varchar(50) not null;
|
|
|
|
alter table supplier_matching_log
|
|
modify PID varchar(50) not null;
|
|
|
|
alter table customer
|
|
add EXPENSE_TYPE_ACTIVE tinyint(1) default 0 not null comment '费用类型能否修改 0 不可以 1 可以';
|
|
|
|
alter table invoice_image
|
|
add ENTRY_ID VARCHAR(50) null;
|
|
|
|
alter table invoice_image
|
|
add REIMBURSEMENT_AMOUNT varchar(20) null;
|
|
|
|
alter table compliance_check
|
|
add INVOICE_MONEY VARCHAR(20) null comment '发票金额';
|
|
|
|
alter table compliance_check
|
|
add ENTRY_ID VARCHAR(50) null;
|
|
|
|
alter table supplier_order_item_matching
|
|
add PRICE_HAS_UPDATED TINYINT(1) default 0 null;
|
|
|
|
|
|
##### 2022 02 18
|
|
alter table supplier_order_item_matching
|
|
add DIFFERENCE DECIMAL(5, 2) null comment '差异';
|
|
|
|
alter table corporate_invoice_items
|
|
add DIFFERENCE VARCHAR(10) null comment '差异';
|
|
|
|
|
|
#### 0222
|
|
create table concur_image_log
|
|
(
|
|
entry_id varchar(50) not null,
|
|
update_time varchar(20) null
|
|
);
|
|
|
|
create unique index concur_image_log_entry_id_uindex
|
|
on concur_image_log (entry_id);
|
|
|
|
alter table concur_image_log
|
|
add constraint concur_image_log_pk
|
|
primary key (entry_id);
|
|
|
|
create table deduction_company
|
|
(
|
|
id int,
|
|
name varchar(100) null,
|
|
code varchar(100) null
|
|
)
|
|
comment '可抵扣公司';
|
|
|
|
create unique index deduction_company_id_uindex
|
|
on deduction_company (id);
|
|
|
|
alter table deduction_company
|
|
add constraint deduction_company_pk
|
|
primary key (id);
|
|
|
|
alter table deduction_company modify id int auto_increment;
|
|
|
|
#### 0224
|
|
alter table invoice_lines
|
|
add KIND VARCHAR(10) null;
|
|
|
|
alter table corporate_invoice
|
|
add PRICE_TYPE TINYINT(1) default 0 null comment '0 折后 1 折前';
|
|
|
|
alter table corporate_invoice_items
|
|
add ORIGIN_UNIT VARCHAR(50) null;
|
|
|
|
alter table corporate_invoice_items
|
|
add ORIGIN_QUANTITY VARCHAR(50) null;
|
|
|
|
alter table corporate_invoice_items
|
|
add ORIGIN_PRICE VARCHAR(50) null;
|
|
|
|
|
|
#### 0405
|
|
|
|
ALTER TABLE `fees_invoice`.`corporate_invoice` ADD COLUMN `source_id` bigint(20) NOT NULL AFTER `PERIOD`;
|
|
|
|
ALTER TABLE `fees_invoice`.`corporate_invoice` ADD INDEX `source_id`(`source_id`) USING BTREE;
|
|
|
|
ALTER TABLE `fees_invoice`.`corporate_invoice` MODIFY COLUMN `source_id` bigint(20) NOT NULL AUTO_INCREMENT AFTER `PERIOD`;
|
|
|
|
|
|
##### 2022 05 05
|
|
ALTER TABLE `fees_invoice`.`band_config` ADD COLUMN `AREA` VARCHAR(100) DEFAULT NULL AFTER `BAND`;
|
|
ALTER TABLE `fees_invoice`.`band_config` ADD COLUMN `ITEM` VARCHAR(100) DEFAULT NULL AFTER `AREA`;
|
|
ALTER TABLE `fees_invoice`.`band_config` change `MILEAGE` `RATE` varchar(20) DEFAULT NULL;
|
|
alter table `fees_invoice`.`band_config` add unique index(BAND,AREA,ITEM);
|
|
drop table `fees_invoice`.`band_area_config`;
|
|
|
|
##### 2022-05-06
|
|
ALTER TABLE `corp_payment_header` ADD COLUMN `VENDOR_NAME` VARCHAR(150) DEFAULT NULL comment '供应商名称';
|
|
ALTER TABLE `corp_payment_header` ADD COLUMN `VENDOR_CODE` VARCHAR(100) DEFAULT NULL comment '供应商Code';
|
|
ALTER TABLE `corp_payment_header` ADD COLUMN `EMP_ID` VARCHAR(100) DEFAULT NULL comment '员工ID';
|
|
ALTER TABLE `corp_payment_header` ADD COLUMN `REQUEST_ID` VARCHAR(100) DEFAULT NULL comment 'OAID';
|
|
|
|
##### 2022-05-13
|
|
ALTER TABLE sys_user_org MODIFY AUTHORIZED_ORG varchar(2000) DEFAULT NULL comment '授权组织id集合';
|
|
|
|
##### 2022-05-19
|
|
CREATE TABLE `exp_comb_report` (
|
|
`COMB_REPORT_ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`COMB_REPORT_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL comment '报告名称',
|
|
`COMB_START` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL comment '开始日期',
|
|
`COMB_END` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL comment '结束日期',
|
|
`POLICY` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL comment 'POLICY',
|
|
`USER_ID` int(11) NULL DEFAULT NULL COMMENT '用户ID',
|
|
`IS_SEND` int(1) NULL DEFAULT NULL COMMENT '是否传送 0/否 1/是',
|
|
`CONCUR_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL comment 'Concur ID',
|
|
`COMB_TIME` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL comment '报告生成时间',
|
|
`REMARK` varchar(200) NULL DEFAULT NULL comment '备注',
|
|
PRIMARY KEY (`COMB_REPORT_ID`) USING BTREE,
|
|
UNIQUE INDEX `exp_comb_report_ID_uindex`(`COMB_REPORT_ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '报告合并表';
|
|
|
|
CREATE TABLE `exp_comb_report_sub` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`COMB_REPORT_ID` int(11) NULL DEFAULT NULL COMMENT 'exp_comb_report表的ID',
|
|
`EXPENSE_REPROTS_ID` int(11) NULL DEFAULT NULL COMMENT 'expense_reports表的ID',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `exp_comb_report_sub_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '报告合并Sub表';
|
|
|
|
##### 2022-05-23
|
|
CREATE TABLE `invoice_delete` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`ENTRY_ID` varchar(100) NULL DEFAULT NULL COMMENT 'invoice表的ENTRY_ID',
|
|
`REPORT_ID` varchar(255) NULL DEFAULT NULL COMMENT 'expense_reports表的REPORT_KEY',
|
|
`USER_LOGIN` varchar(100) NULL DEFAULT NULL COMMENT 'user表的EMAIL',
|
|
`FLAG` varchar(2) NULL DEFAULT '0' COMMENT '返回标记',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoice_delete_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '发票删除记录表';
|
|
|
|
##### 2022-05-24
|
|
CREATE TABLE `efiles` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`FILE_DATE` varchar(20) NULL DEFAULT NULL COMMENT '',
|
|
`TYPE` varchar(20) NULL DEFAULT NULL COMMENT '类型',
|
|
`USER_ID` varchar(20) NULL DEFAULT NULL COMMENT '用户ID',
|
|
`REQ_ID` varchar(20) NULL DEFAULT '0' COMMENT 'REQ_ID',
|
|
`VERIFIED_DATA` text NULL DEFAULT NULL COMMENT '',
|
|
`STATUS` varchar(2) NULL DEFAULT '0' COMMENT '状态',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `efiles_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '';
|
|
|
|
ALTER TABLE files ADD COLUMN `TYPE` VARCHAR(20) DEFAULT NULL;
|
|
|
|
##### 2022-05-31
|
|
ALTER TABLE invoice ADD COLUMN `expmonth` VARCHAR(50) DEFAULT NULL;
|
|
ALTER TABLE corp_invoice_receive_header ADD COLUMN `TICKET_CODE` VARCHAR(50) DEFAULT NULL AFTER `INVOICE_TYPE`;
|
|
ALTER TABLE corp_invoice_receive_header ADD COLUMN `VERIFIED_CODE` VARCHAR(50) DEFAULT NULL AFTER `TICKET_CODE`;
|
|
|
|
##### 2022-06-07
|
|
ALTER TABLE expense_type ADD COLUMN `NEED_INV` VARCHAR(2) DEFAULT '1' COMMENT '';
|
|
ALTER TABLE t_10_report_main_extension ADD COLUMN `SYNC_STATUS` tinyint(1) DEFAULT 0 COMMENT '0未同步，1已同步',;
|
|
ALTER TABLE t_10_report_main_extension ADD COLUMN `COMMENT` VARCHAR(200) DEFAULT null COMMENT'驳回意见';
|
|
|
|
##### 2022-06-14
|
|
ALTER TABLE invoice_image ADD COLUMN `DATA_JSON` text DEFAULT null COMMENT'json数据';
|
|
|
|
##### 2022-06-16
|
|
ALTER TABLE files ADD COLUMN `AUTO_INSERT` VARCHAR(2) DEFAULT null COMMENT '0-手动，1-自动';
|
|
ALTER TABLE files ADD COLUMN `EFILES_ID` bigint(20) DEFAULT null COMMENT 'efiles_id';
|
|
ALTER TABLE efiles ADD COLUMN `IMG_URL` VARCHAR(300) DEFAULT null COMMENT '图片地址';
|
|
ALTER TABLE efiles ADD COLUMN `REUSE` VARCHAR(2) DEFAULT null COMMENT '0-不可重复使用，1-可以重复使用';
|
|
|
|
##### 2022-06-21
|
|
ALTER TABLE mt_pic ADD COLUMN `IMG_URL` VARCHAR(300) DEFAULT null COMMENT '图片地址';
|
|
|
|
##### 2022-06-27
|
|
ALTER TABLE t_10_report_main ADD COLUMN `custom21` VARCHAR(100) DEFAULT null COMMENT '';
|
|
|
|
drop table if exists `mt_agreement`;
|
|
CREATE TABLE `mt_agreement` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`REQ_ID` varchar(20) NULL DEFAULT NULL COMMENT 'REQ_ID',
|
|
`EXT_ID` varchar(20) NULL DEFAULT NULL COMMENT '讲者ID',
|
|
`AGREEMENT_ID` varchar(30) NULL DEFAULT NULL COMMENT '协议ID',
|
|
`CONTRACT_TITLE` varchar(200) NULL DEFAULT NULL COMMENT '标题',
|
|
`CONTRACT_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '类型',
|
|
`CONTRACT_CUSTOM_ID` varchar(50) NULL DEFAULT NULL COMMENT '公司内部编号',
|
|
`TEMPLATE_ID` varchar(30) NULL DEFAULT NULL COMMENT '模板ID',
|
|
`SIGN_EXPIRE_DAY` varchar(20) NULL DEFAULT NULL COMMENT '签约截止时间',
|
|
`CONTRACT_LIFE_END` varchar(20) NULL DEFAULT NULL COMMENT '协议内容有效期',
|
|
`DESCRIBE` varchar(200) NULL DEFAULT NULL COMMENT '描述',
|
|
`EFILE_URL` varchar(300) NULL DEFAULT NULL COMMENT '附件地址',
|
|
`STATUS` varchar(2) NULL DEFAULT '0' COMMENT '状态:0未发送1已发送2取消',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`CLIENT` int NULL DEFAULT 1 COMMENT '',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT06` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT07` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT08` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT09` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT10` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `mt_agreement_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '';
|
|
|
|
drop table if exists `mt_agree_template`;
|
|
CREATE TABLE `mt_agree_template` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`TEMPLATE_ID` varchar(30) NULL DEFAULT NULL COMMENT '模板ID',
|
|
`TEMPLATE_NAME` varchar(50) NULL DEFAULT NULL COMMENT '模板名称',
|
|
`SIGN_ORDERLY` varchar(2) NULL DEFAULT '1' COMMENT '是否按序签署：0否1是',
|
|
`BIZ_NO` varchar(50) NULL DEFAULT NULL COMMENT 'bizNo',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `mt_agree_template_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '';
|
|
|
|
drop table if exists `mt_agree_router_config`;
|
|
CREATE TABLE `mt_agree_router_config` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`TEMPLATE_ID` varchar(30) NULL DEFAULT NULL COMMENT '模板ID',
|
|
`ROUTER_ID` varchar(20) NULL DEFAULT NULL COMMENT 'RouterID',
|
|
`ORDER` varchar(2) NULL DEFAULT NULL COMMENT '顺序',
|
|
`SIGNER` varchar(20) NULL DEFAULT NULL COMMENT '签署人',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `mt_agree_router_config_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '';
|
|
|
|
drop table if exists `mt_agree_router`;
|
|
CREATE TABLE `mt_agree_router` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`AGREEMENT_ID` varchar(30) NULL DEFAULT NULL COMMENT '协议ID',
|
|
`TEMPLATE_ID` varchar(30) NULL DEFAULT NULL COMMENT '模板ID',
|
|
`ROUTER_ID` varchar(20) NULL DEFAULT NULL COMMENT 'RouterID',
|
|
`ORDER` varchar(2) NULL DEFAULT NULL COMMENT '顺序',
|
|
`ENTERPRISE_NAME` varchar(50) NULL DEFAULT NULL COMMENT '企业名称',
|
|
`SIGN_NAME` varchar(20) NULL DEFAULT NULL COMMENT '签署人',
|
|
`SIGN_ACCOUNT` varchar(30) NULL DEFAULT NULL COMMENT '签署人账号',
|
|
`SIGN_DATE` datetime NULL DEFAULT NULL COMMENT '签署时间',
|
|
`STATUS` varchar(2) NULL DEFAULT '0' COMMENT '状态:0失败1成功',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `mt_agree_router_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '';
|
|
|
|
##### 2022-06-30
|
|
ALTER TABLE supplier_blacklist ADD COLUMN `CREATE_DATE` datetime DEFAULT null COMMENT '创建时间';
|
|
|
|
ALTER TABLE mt_agreement ADD COLUMN `SPEAKER` varchar(20) DEFAULT null COMMENT '讲者' AFTER `EXT_ID`;
|
|
ALTER TABLE mt_agreement ADD COLUMN `SPEAKER_TEL` varchar(20) DEFAULT null COMMENT '讲者手机号' AFTER `SPEAKER`;
|
|
|
|
##### 2022-07-07
|
|
ALTER TABLE mt_agreement ADD COLUMN `SPEAKER_EMAIL` varchar(50) DEFAULT null COMMENT '讲者邮箱' AFTER `SPEAKER_TEL`;
|
|
ALTER TABLE mt_list ADD COLUMN `MEET_FORMAT` varchar(20) DEFAULT null COMMENT '会议形式' AFTER `CITY`;
|
|
|
|
##### 2022-07-08
|
|
ALTER TABLE mt_pic ADD COLUMN `PIC_TYPE` varchar(20) DEFAULT null COMMENT '照片类型' AFTER `REQ_ID`;
|
|
|
|
##### 2022-07-12
|
|
ALTER TABLE mt_checkin ADD COLUMN `ORG_NAME` varchar(50) DEFAULT null COMMENT '组织名称' AFTER `ORG_ID`;
|
|
ALTER TABLE mt_checkin ADD COLUMN `DEPT_NAME` varchar(50) DEFAULT null COMMENT '部门名称' AFTER `DEPT_ID`;
|
|
|
|
##### 2022-07-12
|
|
alter table supplier_order_item_matching
|
|
add matching_id varchar(100) null comment '分摊Id';
|
|
|
|
##### 2022-07-18
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXPENSE_NAME` varchar(50) DEFAULT null COMMENT '费用名称' AFTER `EXT_ID`;
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXPENSE_AMOUNT` varchar(20) DEFAULT null COMMENT '费用金额' AFTER `EXPENSE_NAME`;
|
|
|
|
##### 2022-07-19
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom11` varchar(100) DEFAULT null COMMENT '' AFTER `custom10`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom12` varchar(100) DEFAULT null COMMENT '' AFTER `custom11`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom13` varchar(100) DEFAULT null COMMENT '' AFTER `custom12`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom14` varchar(100) DEFAULT null COMMENT '' AFTER `custom13`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom15` varchar(100) DEFAULT null COMMENT '' AFTER `custom14`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom16` varchar(100) DEFAULT null COMMENT '' AFTER `custom15`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom17` varchar(100) DEFAULT null COMMENT '' AFTER `custom16`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom18` varchar(100) DEFAULT null COMMENT '' AFTER `custom17`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom19` varchar(100) DEFAULT null COMMENT '' AFTER `custom18`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom20` varchar(100) DEFAULT null COMMENT '' AFTER `custom19`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom21` varchar(100) DEFAULT null COMMENT '' AFTER `custom20`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom22` varchar(100) DEFAULT null COMMENT '' AFTER `custom21`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom23` varchar(100) DEFAULT null COMMENT '' AFTER `custom22`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom24` varchar(100) DEFAULT null COMMENT '' AFTER `custom23`;
|
|
ALTER TABLE t_10_attendee ADD COLUMN `custom25` varchar(100) DEFAULT null COMMENT '' AFTER `custom24`;
|
|
|
|
#2022-07-21
|
|
drop table if exists `mt_attendee`;
|
|
CREATE TABLE `mt_attendee` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`REQ_ID` varchar(20) NULL DEFAULT NULL COMMENT 'REQ_ID',
|
|
`ATTENDEE_TYPE_ID` varchar(100) NULL DEFAULT NULL COMMENT '参与人类型id',
|
|
`ATTENDEE_TYPE_CODE` varchar(100) NULL DEFAULT NULL COMMENT '参与人类型',
|
|
`ATTENDEE_NAME` varchar(20) NULL DEFAULT NULL COMMENT '参与人姓名',
|
|
`ATTENDEE_EXT_ID` varchar(100) NULL DEFAULT NULL COMMENT '参与人extid',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `mt_attendee_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会议参与人表';
|
|
|
|
##### 2022-07-25
|
|
ALTER TABLE mt_checkin ADD COLUMN `ID_CARD` varchar(30) DEFAULT null COMMENT '身份证号码' AFTER `MOBILE`;
|
|
|
|
CREATE TABLE `mt_attendee_type` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`GROUP` varchar(100) NULL DEFAULT NULL COMMENT 'GROUP',
|
|
`ACCESS_TYPE` varchar(20) NULL DEFAULT NULL COMMENT '类型',
|
|
`ALLOW_GROUP` varchar(100) NULL DEFAULT NULL COMMENT '类型名称',
|
|
`GROUP_CODE` varchar(100) NULL DEFAULT NULL COMMENT '类型code',
|
|
`ATTENDEE_TYPE_ID` varchar(100) NULL DEFAULT NULL COMMENT '参与人类型id',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `mt_attendee_type_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会议参与人类型表';
|
|
|
|
|
|
##### 2022-07-26
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-07-27
|
|
ALTER TABLE expense_type ADD COLUMN `MESG` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE expense_type ADD COLUMN `MESG_EN` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
ALTER TABLE mt_pic ADD COLUMN `EXPENSE_NAME` varchar(100) DEFAULT null COMMENT '费用名称' AFTER `PIC_TYPE`;
|
|
ALTER TABLE mt_pic ADD COLUMN `EXT_ID` varchar(100) DEFAULT null COMMENT '讲者extId' AFTER `EXPENSE_NAME`;
|
|
ALTER TABLE mt_pic ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_pic ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_pic ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_pic ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_pic ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
ALTER TABLE efiles ADD COLUMN `EXPENSE_NAME` varchar(100) DEFAULT null COMMENT '费用名称' AFTER `REQ_ID`;
|
|
ALTER TABLE efiles ADD COLUMN `EXT_ID` varchar(100) DEFAULT null COMMENT '讲者extId' AFTER `EXPENSE_NAME`;
|
|
ALTER TABLE efiles ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE efiles ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE efiles ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE efiles ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE efiles ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-07-29
|
|
ALTER TABLE mt_agreement ADD COLUMN `BASE64` LONGTEXT DEFAULT null COMMENT '';
|
|
|
|
##### 2022-08-01
|
|
ALTER TABLE invoice ADD COLUMN `REQ_ID` varchar(20) DEFAULT null COMMENT 'REQ_ID';
|
|
|
|
##### 2022-08-02
|
|
CREATE TABLE `invoice_channel` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`ORDER` varchar(2) NULL DEFAULT NULL COMMENT '排序',
|
|
`NAME` varchar(100) NULL DEFAULT NULL COMMENT '名称',
|
|
`NAME_EN` varchar(100) NULL DEFAULT NULL COMMENT '名称_EN',
|
|
`ICON` varchar(200) NULL DEFAULT NULL COMMENT '图片地址',
|
|
`IS_VISIBLE` varchar(2) NULL DEFAULT '1' COMMENT '是否可见:1可见0不可见',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoice_channel_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '';
|
|
|
|
##### 2022-08-04
|
|
ALTER TABLE verified_user ADD COLUMN `IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '';
|
|
|
|
##### 2022-08-05
|
|
ALTER TABLE invoice_tmp ADD COLUMN `REQ_ID` varchar(20) DEFAULT null COMMENT 'REQ_ID';
|
|
|
|
# 2022-08-11
|
|
|
|
ALTER TABLE company ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE company ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE company ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE company ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE company ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-08-11
|
|
ALTER TABLE files_ocr ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE files_ocr ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE files_ocr ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE files_ocr ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE files_ocr ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-08-12
|
|
ALTER TABLE invoice ADD COLUMN `EXT_ID` varchar(100) DEFAULT null COMMENT '讲者extId';
|
|
ALTER TABLE invoice ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
ALTER TABLE invoice_tmp ADD COLUMN `EXT_ID` varchar(100) DEFAULT null COMMENT '讲者extId';
|
|
ALTER TABLE invoice_tmp ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_tmp ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_tmp ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_tmp ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_tmp ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-08-15
|
|
ALTER TABLE rule ADD COLUMN `REMARK` varchar(255) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-08-16
|
|
ALTER TABLE corporate_invoice ADD COLUMN `NUMBER_BACKUP` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE corporate_invoice ADD COLUMN `NUMBER_CONFIRM` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE corporate_invoice ADD COLUMN `COMPANY_SEAL` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
CREATE TABLE `t_10_attendee_ext` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`EXT_ID` varchar(20) NULL DEFAULT NULL COMMENT 'extId',
|
|
`SPEAKER` varchar(20) NULL DEFAULT NULL COMMENT '讲者',
|
|
`SPEAKER_TEL` varchar(20) NULL DEFAULT NULL COMMENT '电话',
|
|
`SPEAKER_EMAIL` varchar(50) NULL DEFAULT NULL COMMENT '邮箱',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`EXT01` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `t_10_attendee_ext_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '';
|
|
|
|
##### 2022-08-17
|
|
CREATE TABLE `user_pc` (
|
|
`USER_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户的唯一标识自增id',
|
|
`OPENID` varchar(100) NULL DEFAULT NULL COMMENT '用户对应的微信openID',
|
|
`USERNAME` varchar(30) NULL DEFAULT NULL COMMENT '用户姓名',
|
|
`PWD` varchar(100) NULL DEFAULT NULL COMMENT '用户密码',
|
|
`AGE` varchar(10) NULL DEFAULT NULL COMMENT '用户年龄',
|
|
`EMAIL` varchar(255) NULL DEFAULT NULL COMMENT '用户邮箱',
|
|
`TEL` varchar(255) NULL DEFAULT NULL COMMENT '用户电话',
|
|
`IS_DEL` varchar(1) NOT NULL DEFAULT '0' COMMENT '0为未删除，1为已删除，默认为0',
|
|
`CREATE_TIME` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_TIME` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`LANGUAGE_TYPE` varchar(10) NULL DEFAULT 'en' COMMENT '用户的语言状态（比如cn=中文，en=英语）',
|
|
`VERIFICATION_CODE` int(11) NULL DEFAULT NULL COMMENT '验证码',
|
|
`VERIFY_TIME` varchar(30) NULL DEFAULT NULL COMMENT '验证时间',
|
|
`COMPANY_ID` int(11) NULL DEFAULT NULL COMMENT '所属公司ID',
|
|
`CLIENT` int(11) NULL DEFAULT NULL COMMENT '',
|
|
`IS_CHECKED` varchar(1) NULL DEFAULT '0' COMMENT '0/未验证 1/已验证',
|
|
PRIMARY KEY (`USER_ID`) USING BTREE,
|
|
INDEX `openId`(`OPENID`) USING BTREE,
|
|
INDEX `email`(`EMAIL`) USING BTREE,
|
|
INDEX `tel`(`TEL`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '';
|
|
|
|
##### 2022-08-16
|
|
ALTER TABLE mileage ADD COLUMN `source` varchar(10) DEFAULT 'GPS' COMMENT '来源';
|
|
|
|
##### 2022-08-22
|
|
ALTER TABLE corp_invoice_receive_header ADD COLUMN `BUYER_CODE` varchar(50) DEFAULT null COMMENT '购方税号' AFTER `BUYER`;
|
|
ALTER TABLE corp_invoice_receive_header ADD COLUMN `SELLER_CODE` varchar(50) DEFAULT null COMMENT '销方税号' AFTER `SELLER`;
|
|
ALTER TABLE corp_invoice_receive_header ADD COLUMN `INVOICE_REMARK` varchar(500) DEFAULT null COMMENT '发票备注';
|
|
|
|
##### 2022-08-24
|
|
CREATE TABLE `sys_logo` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`SYS_NAME` varchar(50) NULL DEFAULT NULL COMMENT '系统名称',
|
|
`PC_LOGO` varchar(255) NULL DEFAULT NULL COMMENT 'PC的logo',
|
|
`APP_BASE` varchar(255) NULL DEFAULT NULL COMMENT '小程序底图',
|
|
`APP_LOGO` varchar(255) NULL DEFAULT NULL COMMENT '小程序的logo',
|
|
`IS_DEL` varchar(1) NOT NULL DEFAULT '0' COMMENT '0为未删除，1为已删除，默认为0',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `sys_logo_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '';
|
|
|
|
|
|
CREATE TABLE `mt_modify_log` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`REQ_ID` varchar(50) NULL DEFAULT NULL COMMENT 'reqId',
|
|
`MODULE` varchar(50) NULL DEFAULT NULL COMMENT '模块',
|
|
`METHODS` varchar(50) NULL DEFAULT NULL COMMENT '方法',
|
|
`REASON` varchar(255) NULL DEFAULT NULL COMMENT '说明',
|
|
`IS_SEND` varchar(1) NULL DEFAULT '0' COMMENT '是否已发送：0否1是',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `mt_modify_log_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '活动内容修改日志';
|
|
|
|
|
|
##### 2022-08-26
|
|
ALTER TABLE corp_invoice_receive_header ADD COLUMN `IMG_URL` varchar(255) DEFAULT null COMMENT '附件路径';
|
|
ALTER TABLE corp_invoice_receive_header ADD COLUMN `SEND_STATUS` varchar(2) DEFAULT '1' COMMENT '发送状态';
|
|
|
|
ALTER TABLE mt_checkin ADD COLUMN `LONGITUDE` varchar(50) DEFAULT NULL COMMENT '';
|
|
ALTER TABLE mt_checkin ADD COLUMN `LATITUDE` varchar(50) DEFAULT NULL COMMENT '';
|
|
ALTER TABLE mt_checkin ADD COLUMN `MEET_FORMAT` varchar(50) DEFAULT NULL COMMENT '';
|
|
|
|
##### 2022-9-2
|
|
ALTER TABLE mt_checkin ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_checkin ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_checkin ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_checkin ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_checkin ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-9-5
|
|
CREATE TABLE `attend_org` (
|
|
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
|
`PID` int(11) NULL DEFAULT NULL COMMENT '父id',
|
|
`ORG_CODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '组织CODE',
|
|
`ORG_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织名称',
|
|
`IS_DEL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0',
|
|
`EXT01` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`EXT02` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`EXT03` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`EXT04` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`EXT05` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`CREATE_BY` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `attend_org_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组织表' ROW_FORMAT = Dynamic;
|
|
|
|
ALTER TABLE mt_list ADD COLUMN `AUTHORIZED_DATE` varchar(50) DEFAULT null COMMENT '审批时间' AFTER `CLIENT`;
|
|
ALTER TABLE mt_list ADD COLUMN `SUBMIT_DATE` varchar(50) DEFAULT null COMMENT '提交时间' AFTER `AUTHORIZED_DATE`;
|
|
ALTER TABLE mt_list ADD COLUMN `LIST_FLAG` varchar(2) DEFAULT null COMMENT '会议标识：0正常1新增2修改' AFTER `SUBMIT_DATE`;
|
|
|
|
##### 2022-9-7
|
|
CREATE TABLE `invoice_lines_log` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`INVOICE_ID` varchar(50) NULL DEFAULT NULL COMMENT 'invoiceId',
|
|
`INVOICE_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '发票类型',
|
|
`INVOICE_DATE` varchar(50) NULL DEFAULT NULL COMMENT '发票日期',
|
|
`INVOICE_CODE` varchar(50) NULL DEFAULT NULL COMMENT '发票代码',
|
|
`INVOICE_NUMBER` varchar(50) NULL DEFAULT NULL COMMENT '发票号码',
|
|
`TOTAL` varchar(20) NULL DEFAULT NULL COMMENT '',
|
|
`VALID_STATUS` varchar(2) NULL DEFAULT '0' COMMENT '有效状态：0有效1无效',
|
|
`USER_ID` varchar(20) NULL DEFAULT NULL COMMENT '',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoice_lines_log_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '发票行日志';
|
|
|
|
ALTER TABLE sys_org ADD COLUMN `TAX_NO` varchar(50) DEFAULT null COMMENT '税号';
|
|
ALTER TABLE sys_org ADD COLUMN `REMARK` varchar(255) DEFAULT null COMMENT '备注';
|
|
|
|
##### 2022-9-16
|
|
ALTER TABLE mt_list ADD COLUMN `UPDATE_DATE` datetime NULL DEFAULT null COMMENT '更新日期';
|
|
|
|
##### 2022-9-17
|
|
ALTER TABLE value_set ADD COLUMN `EXT06` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE value_set ADD COLUMN `EXT07` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE value_set ADD COLUMN `EXT08` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE value_set ADD COLUMN `EXT09` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE value_set ADD COLUMN `EXT010` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-9-19
|
|
ALTER TABLE sys_user ADD COLUMN `PWD_FLAG` varchar(5) DEFAULT '2' COMMENT '1代表强制修改2代码不修改';
|
|
ALTER TABLE LAST_UPDATE_TIME ADD COLUMN `EXT07` varchar(30) COMMENT '最后更新密码时间';
|
|
|
|
##### 2022-9-23
|
|
ALTER TABLE invoice_item_mileage ADD COLUMN `REC_MILEAGE` decimal(10,2) DEFAULT null COMMENT '推荐里程';
|
|
ALTER TABLE invoice_item_mileage ADD COLUMN `REMARK` varchar(255) DEFAULT null COMMENT '备注';
|
|
ALTER TABLE invoice_item_mileage ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_item_mileage ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_item_mileage ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_item_mileage ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_item_mileage ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-9-28
|
|
ALTER TABLE invoice_lines ADD COLUMN `SELLER_CODE` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `BUYER` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `BUYER_CODE` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `ITEM_NAMES` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-9-30
|
|
alter table invoice_image_files_ocr modify INV_DATE varchar(50);
|
|
|
|
##### 2022-10-11
|
|
ALTER TABLE invoice ADD COLUMN `TICKET_ID` varchar(20) DEFAULT null COMMENT 'ticketId' AFTER `EXT_ID`;
|
|
ALTER TABLE invoice_tmp ADD COLUMN `TICKET_ID` varchar(20) DEFAULT null COMMENT 'ticketId' AFTER `EXT_ID`;
|
|
|
|
##### 2022-10-17
|
|
CREATE TABLE `invoice_files_log` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`TABLE_NAME` varchar(50) NULL DEFAULT NULL COMMENT '表名',
|
|
`METHODS` varchar(50) NULL DEFAULT NULL COMMENT '操作方法：新增或编辑',
|
|
`INVOICE_ID` varchar(100) NULL DEFAULT NULL COMMENT 'invoiceId',
|
|
`ENTRY_ID` varchar(100) NULL DEFAULT NULL COMMENT 'entryId',
|
|
`IMAGE_PATH` varchar(200) NULL DEFAULT NULL COMMENT '附件地址：多个合并成pdf',
|
|
`IMAGE_ID` varchar(100) NULL DEFAULT NULL COMMENT 'imageId',
|
|
`STATUS` varchar(2) NULL DEFAULT NULL COMMENT '0 - 新建 1- 已发送 2. 报告已提交 9. 已修改',
|
|
`EXECUTE_DATE` datetime NULL DEFAULT NULL COMMENT '执行时间',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoice_files_log_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '报销附件日志';
|
|
|
|
ALTER TABLE files ADD COLUMN `STATUS` varchar(1) DEFAULT '0' COMMENT '状态：0草稿1确认';
|
|
ALTER TABLE files ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE files ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE files ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE files ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE files ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-10-21
|
|
ALTER TABLE invoice ADD COLUMN `PAYMENT_TYPE` varchar(100) DEFAULT null COMMENT '支付方式';
|
|
ALTER TABLE invoice_tmp ADD COLUMN `PAYMENT_TYPE` varchar(100) DEFAULT null COMMENT '支付方式';
|
|
|
|
##### 2022-10-26
|
|
alter table mt_attendee modify ATTENDEE_NAME varchar(100);
|
|
|
|
##### 2022-11-1
|
|
ALTER TABLE invoice_delete ADD COLUMN `INVOICE_ID` varchar(100) DEFAULT null COMMENT 'INVOICE_ID' AFTER `ID`;
|
|
ALTER TABLE invoice_delete ADD COLUMN `EXT01` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_delete ADD COLUMN `EXT02` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_delete ADD COLUMN `EXT03` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_delete ADD COLUMN `EXT04` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_delete ADD COLUMN `EXT05` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
CREATE TABLE `invoice_log` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`URL` varchar(200) NULL DEFAULT NULL COMMENT '请求的接口地址',
|
|
`INVOICE_ID` varchar(100) NULL DEFAULT NULL COMMENT 'invoiceId',
|
|
`DATA_JSON` text NULL DEFAULT NULL COMMENT 'entryId',
|
|
`STATUS` varchar(2) NULL DEFAULT NULL COMMENT '0 - 新建 1- 已发送 2. 报告已提交 9. 已修改',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoice_log_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'invoice日志表';
|
|
|
|
##### 2022-11-8
|
|
ALTER TABLE post_box ADD COLUMN `INVOICE_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '发票类型（出租车票，飞机票。。。）';
|
|
ALTER TABLE post_box ADD COLUMN `CONSUME_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '消费类型';
|
|
ALTER TABLE post_box ADD COLUMN `CURRENCY` varchar(30) NULL DEFAULT NULL COMMENT '币种';
|
|
ALTER TABLE post_box ADD COLUMN `TRADE_DATE` varchar(30) NULL DEFAULT NULL COMMENT '交易日期';
|
|
ALTER TABLE post_box ADD COLUMN `CITY` varchar(30) NULL DEFAULT NULL COMMENT '城市';
|
|
ALTER TABLE post_box ADD COLUMN `SUPPLIER` varchar(255) NULL DEFAULT NULL COMMENT '供应商';
|
|
ALTER TABLE post_box ADD COLUMN `INVOICE_CODE` varchar(200) NULL DEFAULT NULL COMMENT '发票代码';
|
|
ALTER TABLE post_box ADD COLUMN `GET_ON_TIME` varchar(30) NULL DEFAULT NULL COMMENT '上车时间（出租车才有）';
|
|
ALTER TABLE post_box ADD COLUMN `DEBUS_TIME` varchar(30) NULL DEFAULT NULL COMMENT '下车时间（出租车才有）';
|
|
ALTER TABLE post_box ADD COLUMN `DESCR` varchar(300) NULL DEFAULT NULL COMMENT '备注说明';
|
|
ALTER TABLE post_box ADD COLUMN `IMG_PATH` varchar(200) NULL DEFAULT NULL COMMENT '扫描时所扫描的图片路径';
|
|
ALTER TABLE post_box ADD COLUMN `CLIENT` int(11) NULL DEFAULT NULL COMMENT '用户所对应的客户ID(每个用户有自己所属的公司，所属的公司有所属的客户，一个客户下面可以有多个公司)';
|
|
ALTER TABLE post_box ADD COLUMN `CHECK_CODE` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `TAX` varchar(20) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `DATA_JSON` text NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `PRE_TAX` varchar(20) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `TAX_RATE` varchar(10) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `NEED_VALID` tinyint(1) NULL DEFAULT 0 COMMENT '0 否 1 是 是否需要验真';
|
|
ALTER TABLE post_box ADD COLUMN `VALID_STATUS` tinyint(1) NULL DEFAULT 0 COMMENT '0 否 1 是 验真状态';
|
|
ALTER TABLE post_box ADD COLUMN `VALID_COUNT` tinyint(4) NULL DEFAULT 0 COMMENT '验真次数';
|
|
ALTER TABLE post_box ADD COLUMN `VALID_DAY_COUNT` tinyint(4) NULL DEFAULT 0 COMMENT '当日验真次数';
|
|
ALTER TABLE post_box ADD COLUMN `LOGIN_ID` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `EXT01` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `EXT02` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `EXT03` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `EXT04` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `EXT05` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `OTHER_FIELDS` text NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `INVOICE_STATUS` varchar(20) NULL DEFAULT NULL;
|
|
|
|
##### 2022-11-18
|
|
ALTER TABLE mt_list ADD COLUMN `EXT11` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT12` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT13` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT14` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT15` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT16` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT17` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT18` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT19` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT20` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXT06` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXT07` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXT08` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXT09` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_speaker ADD COLUMN `EXT10` varchar(100) DEFAULT null COMMENT '';
|
|
|
|
##### 2022-11-23
|
|
CREATE TABLE `invoice_kind_mapping` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`CONTENT` varchar(100) NULL DEFAULT NULL COMMENT '内容',
|
|
`KIND` varchar(50) NULL DEFAULT NULL COMMENT '类型',
|
|
`LEVEL` varchar(10) NULL DEFAULT NULL COMMENT '等级:值越大越高',
|
|
`ACTIVE` varchar(2) NULL DEFAULT '1' COMMENT '1：有效，0：无效',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoice_kind_mapping_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'invoice类型对照表';
|
|
|
|
##### 2022-12-1
|
|
ALTER TABLE expense_type ADD COLUMN `FILES_TYPE` varchar(100) NULL DEFAULT NULL COMMENT '识别附件类型';
|
|
ALTER TABLE expense_type ADD COLUMN `EXT01` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_type ADD COLUMN `EXT02` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_type ADD COLUMN `EXT03` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_type ADD COLUMN `EXT04` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_type ADD COLUMN `EXT05` varchar(100) NULL DEFAULT NULL;
|
|
|
|
##### 2022-12-2
|
|
ALTER TABLE mt_list ADD UNIQUE (`REQ_ID`);
|
|
ALTER TABLE mt_pic ADD INDEX mt_pic_reqID(`REQ_ID`);
|
|
ALTER TABLE mt_agreement ADD INDEX mt_agreement_reqID(`REQ_ID`);
|
|
ALTER TABLE mt_speaker ADD INDEX mt_speaker_reqID(`REQ_ID`);
|
|
|
|
##### 2022-12-13
|
|
ALTER TABLE files_config ADD COLUMN `ORDER` varchar(10) NULL DEFAULT NULL COMMENT '排序';
|
|
|
|
##### 2023-1-11
|
|
CREATE TABLE `supplier_order_header` (
|
|
`BILL_ID` varchar(50) NOT NULL DEFAULT '' COMMENT '唯一主键',
|
|
`BILL_NUMBER` varchar(50) NULL DEFAULT NULL COMMENT '单据编号',
|
|
`BILL_NAME` varchar(50) NULL DEFAULT NULL COMMENT '单据名称',
|
|
`INVOICE_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '发票类型',
|
|
`BUSINESS_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '业务类型',
|
|
`COMPANY_CODE` varchar(50) NULL DEFAULT NULL COMMENT '所属公司Code',
|
|
`COMPANY_NAME` varchar(100) NULL DEFAULT NULL COMMENT '所属公司',
|
|
`ORG_CODE` varchar(50) NULL DEFAULT NULL COMMENT '成本中心Code',
|
|
`ORG_NAME` varchar(100) NULL DEFAULT NULL COMMENT '成本中心',
|
|
`CURRENCY` varchar(20) NULL DEFAULT NULL COMMENT '币种',
|
|
`PAY_AMOUNT` decimal(20, 5) NULL DEFAULT NULL COMMENT '付款金额',
|
|
`PAY_DATE` varchar(20) NULL DEFAULT NULL COMMENT '约定/计划付款时间',
|
|
`APPLY_MAN` varchar(20) NULL DEFAULT NULL COMMENT '申请人',
|
|
`GS_NUM` varchar(100) NULL DEFAULT NULL COMMENT 'GS项目批号',
|
|
`OA_NUM` varchar(100) NULL DEFAULT NULL COMMENT 'OA通用项目批号',
|
|
`SUPPLIER_CODE` varchar(50) NULL DEFAULT NULL COMMENT '供应商Code',
|
|
`SUPPLIER_NAME` varchar(100) NULL DEFAULT NULL COMMENT '供应商名称',
|
|
`BRANCH_BANK` varchar(100) NULL DEFAULT NULL COMMENT '开户行分行',
|
|
`ACCOUNT_INFO` varchar(100) NULL DEFAULT NULL COMMENT '账户信息',
|
|
`PAY_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '付款类型',
|
|
`NON_PURCHASE` varchar(50) NULL DEFAULT NULL COMMENT '援引源引非经营性采购流程',
|
|
`PURCHASE` varchar(50) NULL DEFAULT NULL COMMENT '源引采购下单流程',
|
|
`CONTRACT` varchar(50) NULL DEFAULT NULL COMMENT '源引相关合同流程',
|
|
`BRAND` varchar(50) NULL DEFAULT NULL COMMENT '主流程品牌市场',
|
|
`STAKEHOLDER` varchar(10) NULL DEFAULT NULL COMMENT '抄送干系人',
|
|
`APPROVAL_COMMENT` varchar(200) NULL DEFAULT NULL COMMENT '审批意见',
|
|
`SUBMIT_DATE` varchar(50) NULL DEFAULT NULL COMMENT '提交日期',
|
|
`IS_COLLECT` varchar(2) NULL DEFAULT '0' COMMENT '是否收票：0否，1是',
|
|
`IS_MATCH` varchar(2) NULL DEFAULT '0' COMMENT '是否匹配完成：0否，1是',
|
|
`STATUS` varchar(10) NULL DEFAULT NULL COMMENT '状态: 0-草稿 2-上级审批 4-财务节点2 6-出纳付款 8-发票匹配 10-财务节点3 12-归档 99-撤销',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`OWNER` varchar(10) NULL DEFAULT NULL COMMENT '所属人',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT06` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT07` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT08` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT09` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT10` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`BILL_ID`) USING BTREE,
|
|
UNIQUE INDEX `supplier_order_header_uindex`(`BILL_ID`) USING BTREE,
|
|
INDEX `bill_number`(`BILL_NUMBER`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'supplier_order_header';
|
|
|
|
##### 2023-1-16
|
|
ALTER TABLE sys_user ADD COLUMN `JOB_NO` varchar(30) NULL DEFAULT NULL COMMENT '工号';
|
|
ALTER TABLE supplier ADD COLUMN `BRANCH_BANK` varchar(100) NULL DEFAULT NULL COMMENT '开户行分行';
|
|
ALTER TABLE supplier ADD COLUMN `ACCOUNT_INFO` varchar(100) NULL DEFAULT NULL COMMENT '账户信息';
|
|
|
|
##### 2023-2-15
|
|
CREATE TABLE `payment_type` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`CODE` varchar(50) NULL DEFAULT NULL COMMENT '代码',
|
|
`NAME` varchar(50) NULL DEFAULT NULL COMMENT '名称',
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `payment_type_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '付款类型信息表';
|
|
|
|
CREATE TABLE `material` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`CODE` varchar(50) NULL DEFAULT NULL COMMENT '代码',
|
|
`MATERIAL` varchar(50) NULL DEFAULT NULL COMMENT '名称',
|
|
`DESCRIPTION` varchar(255) NULL DEFAULT NULL COMMENT '描述',
|
|
`TYPE` varchar(50) NULL DEFAULT NULL COMMENT '类型',
|
|
`STATUS` varchar(2) NULL DEFAULT NULL COMMENT '状态',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `material_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '';
|
|
|
|
##### 2023-2-16
|
|
CREATE TABLE `invoice_libarary_line` (
|
|
`ID` varchar(40) NOT NULL COMMENT 'uuid',
|
|
`PID` varchar(40) NOT NULL COMMENT 'library表的ID',
|
|
`NAME` varchar(100) NULL DEFAULT NULL COMMENT '名称',
|
|
`UNIT` varchar(50) NULL DEFAULT NULL COMMENT '单位',
|
|
`QUANTITY` varchar(50) NULL DEFAULT NULL COMMENT '数量',
|
|
`PRICE` varchar(50) NULL DEFAULT NULL COMMENT '单价',
|
|
`TOTAL` varchar(50) NULL DEFAULT NULL COMMENT '金额',
|
|
`SPECIFICATION` varchar(50) NULL DEFAULT NULL COMMENT '规格型号',
|
|
`TAX_RATE` varchar(30) NULL DEFAULT NULL COMMENT '税率',
|
|
`TAX` varchar(50) NULL DEFAULT NULL COMMENT '税额',
|
|
`DEDUCTION_AMOUNT` varchar(30) NULL DEFAULT NULL COMMENT '抵扣金额',
|
|
`DEDUCTION_TAX_RATE` varchar(30) NULL DEFAULT NULL COMMENT '抵扣税率',
|
|
`DEDUCTION_TAX` varchar(30) NULL DEFAULT NULL COMMENT '抵扣税额',
|
|
`IS_DEL` tinyint(1) NULL DEFAULT 0 COMMENT '',
|
|
`DIFFERENCE` varchar(100) NULL DEFAULT NULL COMMENT '差异',
|
|
`ORIGIN_UNIT` varchar(50) NULL DEFAULT NULL COMMENT '原-单位',
|
|
`ORIGIN_QUANTITY` varchar(50) NULL DEFAULT NULL COMMENT '原-数量',
|
|
`ORIGIN_PRICE` varchar(50) NULL DEFAULT NULL COMMENT '原-单价',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
INDEX `invoice_libarary_line_PID_index`(`PID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '';
|
|
|
|
##### 2023-2-20
|
|
CREATE TABLE `invoke_contract` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`CLASSIFY` varchar(100) NOT NULL COMMENT '分类',
|
|
`PROCESS_NO` varchar(100) NULL DEFAULT NULL COMMENT '流程编号',
|
|
`PROCESS_TITLE` varchar(100) NULL DEFAULT NULL COMMENT '流程标题',
|
|
`APPLY_MAN` varchar(50) NULL DEFAULT NULL COMMENT '申请人',
|
|
`CONTRACT_NAME` varchar(255) NULL DEFAULT NULL COMMENT '合同名称',
|
|
`CONTRACT_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '合同类型',
|
|
`CONTRACT_TYPE2` varchar(50) NULL DEFAULT NULL COMMENT '合同类型2',
|
|
`OUR_SIGN_COMPANY` varchar(100) NULL DEFAULT NULL COMMENT '我方签约公司名称',
|
|
`OTHER_SIGN_COMPANY` varchar(100) NULL DEFAULT NULL COMMENT '对方签约公司名称',
|
|
`CONTRACT_START_TIME` varchar(20) NULL DEFAULT NULL COMMENT '合同开始时间',
|
|
`CONTRACT_END_TIME` varchar(20) NULL DEFAULT NULL COMMENT '合同到期时间',
|
|
`SIGN_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '签订类型',
|
|
`AFFIX_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '签署类型',
|
|
`CURRENCY` varchar(30) NULL DEFAULT NULL COMMENT '币种',
|
|
`CONTRACT_TERM` varchar(30) NULL DEFAULT NULL COMMENT '合同期限',
|
|
`IS_NON_PURCHASE` varchar(10) NULL DEFAULT NULL COMMENT '是否为非经营性采购',
|
|
`OWNER` varchar(255) NULL DEFAULT NULL COMMENT 'owner',
|
|
`IS_DEL` tinyint(1) NULL DEFAULT 0 COMMENT '',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT06` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT07` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT08` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT09` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT10` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoke_contract_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '援引合同表';
|
|
|
|
##### 2023-2-24
|
|
ALTER TABLE supplier_order_header ADD COLUMN `BILL_NAME_REMARK` varchar(255) NULL DEFAULT NULL COMMENT '标题特殊备注' AFTER `BILL_NAME`;
|
|
ALTER TABLE supplier_order_header ADD COLUMN `ALIPAY` varchar(100) NULL DEFAULT NULL COMMENT '店铺支付宝账户' AFTER `STAKEHOLDER`;
|
|
ALTER TABLE supplier_order_header ADD COLUMN `ACTIVITY_START_TIME` varchar(20) NULL DEFAULT NULL COMMENT '活动开始时间' AFTER `ALIPAY`;
|
|
ALTER TABLE supplier_order_header ADD COLUMN `ACTIVITY_END_TIME` varchar(20) NULL DEFAULT NULL COMMENT '活动结束时间' AFTER `ACTIVITY_START_TIME`;
|
|
ALTER TABLE supplier_order_header ADD COLUMN `FREEZE_START_TIME` varchar(20) NULL DEFAULT NULL COMMENT '保证金冻结开始时间' AFTER `ACTIVITY_END_TIME`;
|
|
ALTER TABLE supplier_order_header ADD COLUMN `FREEZE_END_TIME` varchar(20) NULL DEFAULT NULL COMMENT '保证金冻结结束时间' AFTER `FREEZE_START_TIME`;
|
|
ALTER TABLE supplier_order_header ADD COLUMN `IS_DIGITAL_MARKET` varchar(2) NULL DEFAULT NULL COMMENT '是否为数字营销：0-是 1-否' AFTER `FREEZE_END_TIME`;
|
|
ALTER TABLE supplier_order_header ADD COLUMN `IS_INNER_PAY` varchar(2) NULL DEFAULT NULL COMMENT '是否为内部员工工资付款：0-是 1-否' AFTER `IS_DIGITAL_MARKET`;
|
|
ALTER TABLE supplier_order_header ADD COLUMN `IS_ABROAD_PAY` varchar(2) NULL DEFAULT NULL COMMENT '是否为境内（不包括港澳台地区）公司对境外公司（包括港澳台地区）的付款：0-是 1-否' AFTER `IS_INNER_PAY`;
|
|
|
|
ALTER TABLE supplier_order ADD COLUMN `IS_SERVICE_FEE` varchar(2) NULL DEFAULT NULL COMMENT '是否为劳务费:0-是 1-否';
|
|
ALTER TABLE supplier_order ADD COLUMN `CODE_ID` varchar(10) NULL DEFAULT NULL COMMENT 'CODE id';
|
|
ALTER TABLE supplier_order ADD COLUMN `CODE_NAME` varchar(50) NULL DEFAULT NULL COMMENT 'CODE name';
|
|
ALTER TABLE supplier_order ADD COLUMN `GS_NUMBER` varchar(100) NULL DEFAULT NULL COMMENT 'GS项目批号（原项目批号A，限TIC/EIC）';
|
|
ALTER TABLE supplier_order ADD COLUMN `OA_NUMBER` varchar(100) NULL DEFAULT NULL COMMENT 'OA通用项目批号（原项目批号B）';
|
|
ALTER TABLE supplier_order ADD COLUMN `COLLECT_AMOUNT` decimal(20,5) NULL DEFAULT NULL COMMENT '向品牌收取的金额（没有填0）';
|
|
|
|
##### 2023-2-27
|
|
CREATE TABLE `invoke_purchase` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`PURCHASE_NUMBER` varchar(100) NULL DEFAULT NULL COMMENT '采购下单流程编号',
|
|
`PURCHASE` varchar(200) NULL DEFAULT NULL COMMENT '源引采购下单流程',
|
|
`NON_PURCHASE_NUMBER` varchar(100) NULL DEFAULT NULL COMMENT '非经营性采购流程编号',
|
|
`NON_PURCHASE` varchar(200) NULL DEFAULT NULL COMMENT '源引非经营性采购流程',
|
|
`CONTRACT_NUMBER` varchar(100) NULL DEFAULT NULL COMMENT '相关合同流程编号',
|
|
`CONTRACT` varchar(200) NULL DEFAULT NULL COMMENT '源引相关合同流程',
|
|
`ORG_CODE` varchar(50) NULL DEFAULT NULL COMMENT '成本中心Code',
|
|
`ORG_NAME` varchar(100) NULL DEFAULT NULL COMMENT '成本中心',
|
|
`GS_NUM` varchar(100) NULL DEFAULT NULL COMMENT 'GS项目批号（原项目批号A，限TIC/EIC）',
|
|
`OA_NUM` varchar(100) NULL DEFAULT NULL COMMENT 'OA通用项目批号（原项目批号B）',
|
|
`OTHER_SIGN_COMPANY` varchar(100) NULL DEFAULT NULL COMMENT '合同流程中对方签约公司名称',
|
|
`CONTRACT_START_TIME` varchar(20) NULL DEFAULT NULL COMMENT '合同开始日期',
|
|
`CONTRACT_END_TIME` varchar(20) NULL DEFAULT NULL COMMENT '合同结束日期',
|
|
`AMOUNT` decimal(20,5) NULL DEFAULT NULL COMMENT '金额',
|
|
`FINANCE_TERMS` varchar(255) NULL DEFAULT NULL COMMENT '合同中财务结算条款',
|
|
`CHECK_PROCESS` varchar(255) NULL DEFAULT NULL COMMENT '源引收货/验收流程-多流程',
|
|
`IS_CHANGE` varchar(2) NULL DEFAULT NULL COMMENT '是否修改明细行成本中心:0-是 1-否',
|
|
`HIGH_APPROVER` varchar(20) NULL DEFAULT NULL COMMENT '采购部上级审批人（实习生专用）',
|
|
`IS_DEL` tinyint(1) NULL DEFAULT 0 COMMENT '',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT06` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT07` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT08` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT09` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT10` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoke_purchase_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '援引采购表';
|
|
|
|
##### 2023-3-1
|
|
CREATE TABLE `sys_emp` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`USER_ID` varchar(20) NOT NULL COMMENT '用户id',
|
|
`WORK_CODE` varchar(30) NULL DEFAULT NULL COMMENT '编号-工号',
|
|
`LAST_NAME` varchar(50) NULL DEFAULT NULL COMMENT '姓名',
|
|
`JOB_LEVEL` varchar(50) NULL DEFAULT NULL COMMENT '职级',
|
|
`SUB_COMPANY_ID` varchar(50) NULL DEFAULT NULL COMMENT '分部ID',
|
|
`SUB_COMPANY` varchar(100) NULL DEFAULT NULL COMMENT '分部',
|
|
`DEPARTMAENT_ID` varchar(50) NULL DEFAULT NULL COMMENT '部门ID',
|
|
`DEPARTMAENT` varchar(100) NULL DEFAULT NULL COMMENT '部门',
|
|
`SUB_DEPARTMAENT_ID` varchar(50) NULL DEFAULT NULL COMMENT '所属行业ID',
|
|
`SUB_DEPARTMAENT` varchar(100) NULL DEFAULT NULL COMMENT '所属行业',
|
|
`IS_DEL` tinyint(1) NULL DEFAULT 0 COMMENT '',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `sys_emp_uindex`(`ID`) USING BTREE,
|
|
UNIQUE `sys_emp_WORK_CODE`(`WORK_CODE`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'OA人员信息表';
|
|
|
|
##### 2023-3-6
|
|
ALTER TABLE mt_speaker ADD INDEX mt_speaker_ext06(`EXT06`);
|
|
ALTER TABLE t_10_attendee ADD INDEX t_10_attendee_extId(`external_id`);
|
|
|
|
##### 2023-3-9
|
|
ALTER TABLE t_10_report_main_extension ADD COLUMN `PROCESSOR` varchar(100) NULL DEFAULT NULL COMMENT '处理人';
|
|
ALTER TABLE t_10_report_main_extension ADD COLUMN `IS_DEL` tinyint(1) NULL DEFAULT 0 COMMENT '';
|
|
ALTER TABLE t_10_report_main_extension ADD COLUMN `EXT01` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE t_10_report_main_extension ADD COLUMN `EXT02` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE t_10_report_main_extension ADD COLUMN `EXT03` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE t_10_report_main_extension ADD COLUMN `EXT04` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE t_10_report_main_extension ADD COLUMN `EXT05` varchar(100) NULL DEFAULT NULL;
|
|
|
|
##### 2023-3-22
|
|
CREATE TABLE `mt_spk_rate` (
|
|
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
|
`SPK_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '讲者类型',
|
|
`TIME_FROM` varchar(20) NOT NULL COMMENT '开始时长',
|
|
`TIME_TO` varchar(20) NOT NULL DEFAULT 0 COMMENT '结束时长',
|
|
`AMOUNT` varchar(20) NOT NULL DEFAULT 0 COMMENT '费用',
|
|
`RATE` varchar(20) NOT NULL DEFAULT 0 COMMENT '费率',
|
|
`TYPE` varchar(20) NULL DEFAULT NULL COMMENT '类型：AMOUTN、RATE',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `mt_spk_rate_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '讲者费用时长对照表';
|
|
|
|
|
|
##### 2023-3-22
|
|
ALTER TABLE corporate_invoice ADD COLUMN `DEDUCTION_AMOUNT` varchar(50) NULL DEFAULT NULL COMMENT '抵扣金额';
|
|
ALTER TABLE corporate_invoice ADD COLUMN `EXT01` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE corporate_invoice ADD COLUMN `EXT02` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE corporate_invoice ADD COLUMN `EXT03` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE corporate_invoice ADD COLUMN `EXT04` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE corporate_invoice ADD COLUMN `EXT05` varchar(100) NULL DEFAULT NULL;
|
|
|
|
##### 2023-3-23
|
|
ALTER TABLE invoke_purchase ADD COLUMN `APPLY_MAN` varchar(50) NULL DEFAULT NULL COMMENT '申请人';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `ABUTMENT_NO` varchar(50) NULL DEFAULT NULL COMMENT '对接单号';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `COMPANY_CODE` varchar(50) NULL DEFAULT NULL COMMENT '所属公司Code';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `COMPANY_NAME` varchar(100) NULL DEFAULT NULL COMMENT '所属公司';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `CURRENCY` varchar(20) NULL DEFAULT NULL COMMENT '币种';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `SUPPLIER_CODE` varchar(50) NULL DEFAULT NULL COMMENT '供应商Code';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `SUPPLIER_NAME` varchar(100) NULL DEFAULT NULL COMMENT '供应商';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `BRANCH_BANK` varchar(100) NULL DEFAULT NULL COMMENT '开户行分行';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `ACCOUNT_INFO` varchar(100) NULL DEFAULT NULL COMMENT '账户信息';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `STAKEHOLDER` varchar(100) NULL DEFAULT NULL COMMENT '抄送干系人ID';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `STAKEHOLDER_NAME` varchar(100) NULL DEFAULT NULL COMMENT '抄送干系人';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `IS_ADVANCE_PAY` varchar(10) NULL DEFAULT '1' COMMENT '是否预付款0是, 1否';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `IS_OTHER_SOURCE` varchar(10) NULL DEFAULT '1' COMMENT '是否外部来源0是, 1否';
|
|
ALTER TABLE invoke_purchase ADD COLUMN `OA_CREATE_TIME` varchar(20) NULL DEFAULT DEFAULT COMMENT 'OA创建时间';
|
|
|
|
##### 2023-3-30
|
|
CREATE TABLE `invoke_receive` (
|
|
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
|
`RECEIVE_NUMBER` varchar(100) NULL DEFAULT NULL COMMENT '收货流程编号',
|
|
`RECEIVE_TITLE` varchar(200) NULL COMMENT '收货流程标题',
|
|
`OA_CREATE_BY` varchar(20) NULL DEFAULT NULL COMMENT 'OA创建人',
|
|
`OA_CREATE_TIME` varchar(20) NULL DEFAULT NULL COMMENT 'OA创建时间',
|
|
`ABUTMENT_NO` varchar(50) NULL DEFAULT NULL COMMENT '对接单号',
|
|
`IS_DEL` tinyint(1) NULL DEFAULT 0 COMMENT '',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT 'requestId',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT06` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT07` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT08` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT09` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT10` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoke_receive_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '援引收货验收';
|
|
|
|
##### 2023-4-4
|
|
ALTER TABLE supplier_order_header ADD COLUMN `RECEIVED` varchar(50) NULL DEFAULT NULL COMMENT '援引收货流程';
|
|
ALTER TABLE supplier_order_header ADD COLUMN `HAV_CONTRACT` varchar(2) NULL DEFAULT NULL COMMENT '是否有相关合同流程：0-是 1-否';
|
|
ALTER TABLE supplier_order_header ADD COLUMN `HAV_INVOICE` varchar(2) NULL DEFAULT NULL COMMENT '是否有发票照片:0-是 1-否';
|
|
ALTER TABLE supplier_order_header ADD COLUMN `KOL_NAME` varchar(20) NULL DEFAULT NULL COMMENT 'Kol名字';
|
|
ALTER TABLE supplier_order_header ADD COLUMN `KOL_FULL_NAME` varchar(20) NULL DEFAULT NULL COMMENT '姓名';
|
|
ALTER TABLE supplier_order_header ADD COLUMN `UID` varchar(50) NULL DEFAULT NULL COMMENT '身份证号码';
|
|
ALTER TABLE supplier_order_header ADD COLUMN `SUPPLIER_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '供应商类型:0-企业 1-个人';
|
|
ALTER TABLE supplier_order_header ADD COLUMN `IS_WHITE_LIST` varchar(2) NULL DEFAULT NULL COMMENT '是否白名单:0-是 1-否';
|
|
ALTER TABLE supplier_order_header ADD COLUMN `WHITE_COMPANY` varchar(255) NULL DEFAULT NULL COMMENT '白名单公司';
|
|
ALTER TABLE supplier_order_header ADD COLUMN `OTHER_COMPANY` varchar(255) NULL DEFAULT NULL COMMENT '其他公司';
|
|
|
|
ALTER TABLE supplier_order ADD COLUMN `PLAT_FORM` varchar(50) NULL DEFAULT NULL COMMENT '平台类型';
|
|
ALTER TABLE supplier_order ADD COLUMN `CHARGE_CHANNEL` varchar(50) NULL DEFAULT NULL COMMENT '充值渠道';
|
|
ALTER TABLE supplier_order ADD COLUMN `CHANNEL_REMARK` varchar(255) NULL DEFAULT NULL COMMENT '渠道备注';
|
|
ALTER TABLE supplier_order ADD COLUMN `EXT06` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_order ADD COLUMN `EXT07` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_order ADD COLUMN `EXT08` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_order ADD COLUMN `EXT09` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_order ADD COLUMN `EXT10` varchar(255) NULL DEFAULT NULL;
|
|
|
|
CREATE TABLE `invoke_brand` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`FLOW_ID` varchar(50) NULL DEFAULT NULL COMMENT 'flowId',
|
|
`MAIN_PROCESS_NUMBER` varchar(100) NULL DEFAULT NULL COMMENT '主流程编号-流水号',
|
|
`MAIN_PROCESS` varchar(200) NULL DEFAULT NULL COMMENT '主流程(品牌/市场)-标题',
|
|
`COMPANY_CODE` varchar(50) NULL DEFAULT NULL COMMENT '所属公司Code',
|
|
`COMPANY_NAME` varchar(100) NULL DEFAULT NULL COMMENT '所属公司',
|
|
`ORG_CODE` varchar(50) NULL DEFAULT NULL COMMENT '成本中心Code',
|
|
`ORG_NAME` varchar(100) NULL DEFAULT NULL COMMENT '成本中心',
|
|
`IS_DIGITAL_MARKET` varchar(2) NULL DEFAULT NULL COMMENT '是否为数字营销:0-是 1-否',
|
|
`CURRENCY` varchar(20) NULL DEFAULT NULL COMMENT '币种',
|
|
`SUPPLIER_CODE` varchar(10) NULL DEFAULT NULL COMMENT '供应商Code',
|
|
`SUPPLIER_NAME` varchar(200) NULL DEFAULT NULL COMMENT '供应商名称',
|
|
`PAY_TYPE` varchar(50) NULL DEFAULT NULL COMMENT '付款类型',
|
|
`APPLY_MAN` varchar(50) NULL DEFAULT NULL COMMENT '申请人',
|
|
`IS_DEL` tinyint(1) NULL DEFAULT 0 COMMENT '',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT 'requestId',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT06` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT07` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT08` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT09` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT10` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoke_brand_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '援引品牌表';
|
|
|
|
##### 2023-4-6
|
|
CREATE TABLE `sys_oa_dept` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`CODE` varchar(200 NULL DEFAULT NULL COMMENT '',
|
|
`DEPARTMAENT_ID` varchar(20) NULL DEFAULT NULL COMMENT '类型',
|
|
`SUB_COMPANY_ID` varchar(20) NULL DEFAULT NULL COMMENT '用户ID',
|
|
`SUB_DEPARTMAENT_ID` varchar(20) NULL DEFAULT '0' COMMENT 'REQ_ID',
|
|
`IS_DEL` tinyint(1) NULL DEFAULT 0 COMMENT '',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `sys_oa_dept_ID_uindex`(`ID`) USING BTREE,
|
|
INDEX `sys_oa_dept_DEPARTMAENT_ID_uindex`(`DEPARTMAENT_ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'OA部门表';
|
|
|
|
|
|
##### 2023-4-18
|
|
ALTER TABLE files_config ADD COLUMN `EXT01` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE files_config ADD COLUMN `EXT02` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE files_config ADD COLUMN `EXT03` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE files_config ADD COLUMN `EXT04` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE files_config ADD COLUMN `EXT05` varchar(100) NULL DEFAULT NULL;
|
|
|
|
##### 2023-4-19
|
|
ALTER TABLE expense_reports ADD COLUMN `INVOICE_ID` varchar(100) NULL DEFAULT NULL COMMENT 'reportTempID';
|
|
ALTER TABLE expense_reports ADD COLUMN `REQ_ID` varchar(50) NULL DEFAULT NULL COMMENT '活动编号';
|
|
ALTER TABLE expense_reports ADD COLUMN `EXT01` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_reports ADD COLUMN `EXT02` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_reports ADD COLUMN `EXT03` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_reports ADD COLUMN `EXT04` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_reports ADD COLUMN `EXT05` varchar(100) NULL DEFAULT NULL;
|
|
|
|
ALTER TABLE expense_use ADD COLUMN `MESG` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_use ADD COLUMN `MESG_EN` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_use ADD COLUMN `EXT01` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_use ADD COLUMN `EXT02` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_use ADD COLUMN `EXT03` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_use ADD COLUMN `EXT04` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_use ADD COLUMN `EXT05` varchar(100) NULL DEFAULT NULL;
|
|
|
|
|
|
##### 2023-5-4
|
|
CREATE TABLE `invoke_internal` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`FLOW_ID` varchar(50) NULL DEFAULT NULL COMMENT 'flowId',
|
|
`PROCESS_NUMBER` varchar(100) NULL DEFAULT NULL COMMENT '流程编码',
|
|
`PROCESS_TITLE` varchar(200) NULL DEFAULT NULL COMMENT '流程标题',
|
|
`COLLECT_ORG_CODE` varchar(50) NULL DEFAULT NULL COMMENT '收款方成本中心Code',
|
|
`COLLECT_ORG_NAME` varchar(100) NULL DEFAULT NULL COMMENT '收款方成本中心',
|
|
`APPLY_MAN` varchar(50) NULL DEFAULT NULL COMMENT '申请人',
|
|
`OA_CREATE_TIME` varchar(20) NULL DEFAULT NULL COMMENT 'OA创建时间',
|
|
`PAY_COMPANY_CODE` varchar(50) NULL DEFAULT NULL COMMENT '付款方所属公司Code',
|
|
`PAY_COMPANY_NAME` varchar(100) NULL DEFAULT NULL COMMENT '付款方所属公司',
|
|
`COLLECT_COMPANY_CODE` varchar(50) NULL DEFAULT NULL COMMENT '收款方所属公司Code',
|
|
`COLLECT_COMPANY_NAME` varchar(100) NULL DEFAULT NULL COMMENT '收款方所属公司',
|
|
`IS_DEL` tinyint(1) NULL DEFAULT 0 COMMENT '',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT 'requestId',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT06` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT07` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT08` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT09` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT10` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoke_internal_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '援引内结流程表';
|
|
|
|
ALTER TABLE invoke_contract ADD COLUMN `OUR_SIGN_COMPANY_NAME` VARCHAR(100) DEFAULT NULL AFTER `OUR_SIGN_COMPANY`;
|
|
ALTER TABLE invoke_contract ADD COLUMN `OTHER_SIGN_COMPANY_NAME` VARCHAR(100) DEFAULT NULL AFTER `OTHER_SIGN_COMPANY`;
|
|
ALTER TABLE supplier_order_header ADD COLUMN `INTERNAL` varchar(50) NULL DEFAULT NULL COMMENT '援引内结流程' AFTER `RECEIVED`;
|
|
ALTER TABLE invoke_internal ADD COLUMN `OWNER` varchar(100) NULL DEFAULT NULL COMMENT 'owner' AFTER `COLLECT_COMPANY_NAME`;
|
|
|
|
##### 2023-5-12
|
|
ALTER TABLE supplier_order_item_matching ADD COLUMN `CREATE_BY` varchar(100) NULL DEFAULT NULL COMMENT '操作人';
|
|
ALTER TABLE supplier_order_item_matching ADD COLUMN `CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '操作时间';
|
|
ALTER TABLE supplier_order_item_matching ADD COLUMN `EXT01` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_order_item_matching ADD COLUMN `EXT02` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_order_item_matching ADD COLUMN `EXT03` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_order_item_matching ADD COLUMN `EXT04` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_order_item_matching ADD COLUMN `EXT05` varchar(100) NULL DEFAULT NULL;
|
|
|
|
##### 2023-5-31
|
|
ALTER TABLE supplier ADD COLUMN `IS_DIGITAL` varchar(2) NULL DEFAULT NULL COMMENT '是否为数字营销:0-否 1-是';
|
|
ALTER TABLE supplier ADD COLUMN `EXT01` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier ADD COLUMN `EXT02` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier ADD COLUMN `EXT03` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier ADD COLUMN `EXT04` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier ADD COLUMN `EXT05` varchar(100) NULL DEFAULT NULL;
|
|
|
|
##### 2023-6-7
|
|
ALTER TABLE mt_checkin ADD COLUMN `EXT06` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE mt_checkin ADD COLUMN `EXT07` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE mt_checkin ADD COLUMN `EXT08` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE mt_checkin ADD COLUMN `EXT09` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE mt_checkin ADD COLUMN `EXT10` varchar(100) NULL DEFAULT NULL;
|
|
|
|
##### 2023-6-9
|
|
CREATE TABLE `mt_type` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`VALUE` varchar(200) NULL DEFAULT NULL COMMENT '',
|
|
`PID` bigint(20) NULL DEFAULT NULL COMMENT '',
|
|
`LANGUAGE` varchar(200) NULL DEFAULT NULL COMMENT '',
|
|
`IS_DEL` tinyint(1) NULL DEFAULT 0 COMMENT '',
|
|
`EXT01` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `mt_type_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会议类型配置表';
|
|
|
|
##### 2023-6-14
|
|
CREATE TABLE `supplier_owner_transfer` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`LAST_ID` bigint(20) NULL DEFAULT NULL COMMENT '上一次转办ID',
|
|
`BILL_ID` varchar(50) NULL DEFAULT NULL COMMENT '单据ID',
|
|
`OWNER` varchar(100) NULL DEFAULT NULL COMMENT '所有者',
|
|
`CREATOR` varchar(10) NULL DEFAULT NULL COMMENT '原始创建者',
|
|
`CURRENT` varchar(100) NULL DEFAULT NULL COMMENT '原有审批人from',
|
|
`TARGET` varchar(100) NULL DEFAULT NULL COMMENT '目标审批人to',
|
|
`STATUS` varchar(2) NULL DEFAULT '1' COMMENT '状态：0-无效 1-有效 2-撤销',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `supplier_owner_transfer_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '申请单转办记录表';
|
|
|
|
##### 2023-6-19
|
|
ALTER TABLE corporate_invoice ADD COLUMN `EXT06` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE corporate_invoice ADD COLUMN `EXT07` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE corporate_invoice ADD COLUMN `EXT08` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE corporate_invoice ADD COLUMN `EXT09` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE corporate_invoice ADD COLUMN `EXT10` varchar(100) NULL DEFAULT NULL;
|
|
|
|
CREATE TABLE `invoice_package` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`PACKAGE_DATE` varchar(20) NULL DEFAULT NULL COMMENT '快递日期',
|
|
`PACKAGE_NUMBER` varchar(50) NULL DEFAULT NULL COMMENT '快递编号',
|
|
`AMOUNT` varchar(10) NULL DEFAULT NULL COMMENT '发票数量',
|
|
`RECEIVER` varchar(10) NULL DEFAULT NULL COMMENT '接收人',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoice_package_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '发票快递';
|
|
|
|
CREATE TABLE `invoice_package_label` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`PACKAGE_NUMBER` varchar(50) NULL DEFAULT NULL COMMENT '快递编号',
|
|
`LABEL_NUMBER` varchar(10) NULL DEFAULT NULL COMMENT '标签号',
|
|
`IS_PRINT` varchar(2) NULL DEFAULT '0' COMMENT '是否打印：0否1是',
|
|
`PRINT_DATE` varchar(20) NULL DEFAULT NULL COMMENT '打印日期',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoice_package_label_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '发票快递标签';
|
|
|
|
##### 2023-6-30
|
|
CREATE TABLE `sys_user_approve` (
|
|
`USER_ID` int(11) NOT NULL,
|
|
`AUTHORIZED_ORG` varchar(2000) NULL DEFAULT NULL COMMENT '授权组织id集合',
|
|
`COR_INV_TYPE` varchar(100) NULL DEFAULT NULL COMMENT '授权的发票类型ID',
|
|
`DATA_AUTH_TYPE` tinyint(1) NULL DEFAULT 0 COMMENT '数据权限 0 All,1 by org,2 by owner',
|
|
PRIMARY KEY (`USER_ID`) USING BTREE,
|
|
UNIQUE INDEX `sys_user_approve_USER_ID_uindex`(`USER_ID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员组织授权表';
|
|
|
|
##### 2023-7-3
|
|
CREATE TABLE `invoice_sys_image` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`VIEW_PATH` varchar(255) NULL DEFAULT NULL COMMENT '图片view地址',
|
|
`FILE_PATH` varchar(255) NULL DEFAULT NULL COMMENT '图片file地址',
|
|
`USER_ID` int(11) NOT NULL,
|
|
`REMARK` varchar(255) NULL DEFAULT NULL COMMENT '备注',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UPDATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '更新人',
|
|
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
|
`EXT01` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoice_sys_image_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统图库';
|
|
|
|
##### 2023-8-15
|
|
CREATE TABLE `rule_type` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`CODE` varchar(20) NULL DEFAULT NULL COMMENT 'code',
|
|
`NAME` varchar(50) NULL DEFAULT NULL COMMENT 'name',
|
|
`EXT01` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `rule_type_ID_uindex`(`ID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '规则类型';
|
|
|
|
##### 2023-8-22
|
|
CREATE VIEW view_t_mdm_dept AS SELECT * FROM ics.t_mdm_dept;
|
|
|
|
##### 2023-8-24
|
|
ALTER TABLE mt_pic ADD COLUMN `EXT06` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE mt_pic ADD COLUMN `EXT07` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE mt_pic ADD COLUMN `EXT08` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE mt_pic ADD COLUMN `EXT09` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE mt_pic ADD COLUMN `EXT10` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE mt_pic ADD COLUMN `CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人';
|
|
ALTER TABLE mt_pic ADD COLUMN `CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间';
|
|
|
|
ALTER TABLE mt_checkin ADD COLUMN `CREATE_BY` varchar(10) NULL DEFAULT NULL COMMENT '创建人';
|
|
ALTER TABLE mt_checkin ADD COLUMN `CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间';
|
|
|
|
##### 2023-9-6
|
|
ALTER TABLE expense_type_sub ADD COLUMN `NAME_EN` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_type_sub ADD COLUMN `EXT01` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_type_sub ADD COLUMN `EXT02` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_type_sub ADD COLUMN `EXT03` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_type_sub ADD COLUMN `EXT04` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE expense_type_sub ADD COLUMN `EXT05` varchar(100) NULL DEFAULT NULL;
|
|
|
|
|
|
##### 2023-9-20
|
|
ALTER TABLE invoice_library ADD COLUMN `EXT01` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE invoice_library ADD COLUMN `EXT02` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE invoice_library ADD COLUMN `EXT03` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE invoice_library ADD COLUMN `EXT04` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE invoice_library ADD COLUMN `EXT05` varchar(255) NULL DEFAULT NULL;
|
|
|
|
##### 2023-11-6
|
|
CREATE TABLE `invoice_img` (
|
|
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
|
`ORIGINAL_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '源主键',
|
|
`SOURCE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '来源',
|
|
`CODE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '发票代码',
|
|
`NUMBER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '发票号码',
|
|
`DATE` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开票日期',
|
|
`PRETAX_AMOUNT` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`TOTAL` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`TAX` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`CHECK_CODE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`SELLER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`SELLER_TAX_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`KIND` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '消费类型',
|
|
`BUYER_TAX_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`BUYER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`ITEM_NAMES` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
|
|
`PO` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`CREATE_DATE` datetime(0) NULL DEFAULT NULL,
|
|
`OPERATOR` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '操作人',
|
|
`REPORT_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`REPORT_OWNER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`REPORT_MONEY` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`STATUS` tinyint(1) NULL DEFAULT 0,
|
|
`IMG_URI` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`ORIGINAL_URI` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`CURRENCY` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'CNY',
|
|
`INVOICE_TYPE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`PASSENGER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '乘坐人',
|
|
`SEAT_TYPE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '座位等级',
|
|
`START_STATION` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '起始站',
|
|
`END_STATION` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '终点站',
|
|
`DEDUCT_STATUS` tinyint(1) NULL DEFAULT NULL COMMENT '抵扣状态0/1/2/3\n未抵扣/发送抵扣/确认抵扣/抵扣失败',
|
|
`TAX_RATE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`VALID_STATUS` tinyint(1) NULL DEFAULT NULL COMMENT '验真状态 0 未验真 1 已验真',
|
|
`EXPENSE_TYPE_ID` int(11) NULL DEFAULT NULL COMMENT '费用类型ID',
|
|
`ENTRY_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`REIMBURSEMENT_AMOUNT` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`POSTED_AMOUNT` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`DATA_JSON` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT 'json数据',
|
|
`ORG_NAME` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '组织名称',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
INDEX `num__index`(`NUMBER`) USING BTREE,
|
|
INDEX `invoice_img_REPORT_ID_index`(`REPORT_ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '影像查询主表-非App' ROW_FORMAT = Dynamic;
|
|
|
|
##### 2023-12-21
|
|
ALTER TABLE invoice_lines ADD COLUMN `DATA_JSON` text DEFAULT null COMMENT'json数据';
|
|
|
|
##### 2023-12-29
|
|
ALTER TABLE t_10_report_main ADD COLUMN `custom11` varchar(100) DEFAULT null COMMENT '' AFTER `custom10`;
|
|
ALTER TABLE t_10_report_main ADD COLUMN `custom12` varchar(100) DEFAULT null COMMENT '' AFTER `custom11`;
|
|
ALTER TABLE t_10_report_main ADD COLUMN `custom13` varchar(100) DEFAULT null COMMENT '' AFTER `custom12`;
|
|
ALTER TABLE t_10_report_main ADD COLUMN `custom14` varchar(100) DEFAULT null COMMENT '' AFTER `custom13`;
|
|
ALTER TABLE t_10_report_main ADD COLUMN `custom15` varchar(100) DEFAULT null COMMENT '' AFTER `custom14`;
|
|
ALTER TABLE t_10_report_main ADD COLUMN `custom16` varchar(100) DEFAULT null COMMENT '' AFTER `custom15`;
|
|
ALTER TABLE t_10_report_main ADD COLUMN `custom17` varchar(100) DEFAULT null COMMENT '' AFTER `custom16`;
|
|
ALTER TABLE t_10_report_main ADD COLUMN `custom18` varchar(100) DEFAULT null COMMENT '' AFTER `custom17`;
|
|
ALTER TABLE t_10_report_main ADD COLUMN `custom19` varchar(100) DEFAULT null COMMENT '' AFTER `custom18`;
|
|
ALTER TABLE t_10_report_main ADD COLUMN `custom20` varchar(100) DEFAULT null COMMENT '' AFTER `custom19`;
|
|
|
|
##### 2023-12-29
|
|
ALTER TABLE supplier_po ADD COLUMN `ID` int(11) NOT NULL;
|
|
ALTER TABLE supplier_po ADD COLUMN `company_code` varchar(100) DEFAULT null COMMENT '采购公司Code' AFTER `contract_no`;
|
|
ALTER TABLE supplier_po ADD COLUMN `supplier_name` varchar(100) DEFAULT null COMMENT '供应商名称' AFTER `supplier_code`;
|
|
ALTER TABLE supplier_po ADD COLUMN `net_amount` varchar(50) DEFAULT null COMMENT '金额' AFTER `supplier_name`;
|
|
ALTER TABLE supplier_po ADD COLUMN `currency` varchar(20) DEFAULT null COMMENT '币种' AFTER `net_amount`;
|
|
ALTER TABLE supplier_po ADD COLUMN `cost_center` varchar(100) DEFAULT null COMMENT '成本中心' AFTER `currency`;
|
|
ALTER TABLE supplier_po ADD COLUMN `requesters_name` varchar(50) DEFAULT null COMMENT '下单人' AFTER `cost_center`;
|
|
|
|
ALTER TABLE supplier_po_line ADD COLUMN `ID` int(11) NOT NULL;
|
|
ALTER TABLE supplier_po_line ADD COLUMN `material_desc` varchar(100) DEFAULT null COMMENT '物料描述' AFTER `material_no`;
|
|
ALTER TABLE supplier_po_line ADD COLUMN `discount` varchar(50) DEFAULT null COMMENT '折扣' AFTER `tax`;
|
|
ALTER TABLE supplier_po_line ADD COLUMN `EXT01` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_po_line ADD COLUMN `EXT02` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_po_line ADD COLUMN `EXT03` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_po_line ADD COLUMN `EXT04` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_po_line ADD COLUMN `EXT05` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE supplier_po_line ADD COLUMN `CREATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人';
|
|
ALTER TABLE supplier_po_line ADD COLUMN `CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间';
|
|
ALTER TABLE supplier_po_line ADD COLUMN `UPDATE_BY` varchar(50) NULL DEFAULT NULL COMMENT '创建人';
|
|
ALTER TABLE supplier_po_line ADD COLUMN `UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间';
|
|
ALTER TABLE supplier_po_line ADD COLUMN `IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '';
|
|
|
|
ALTER TABLE supplier_po_line CHANGE price unit_price VARCHAR(20) DEFAULT null COMMENT '单价';
|
|
ALTER TABLE supplier_po_line CHANGE amount net_line_amount VARCHAR(20) DEFAULT null COMMENT 'po行总额';
|
|
|
|
|
|
##### 2024-1-17
|
|
ALTER TABLE invoice_items ADD COLUMN `REPORTS_ID` varchar(50) DEFAULT null COMMENT 'REPORTS_ID';
|
|
ALTER TABLE invoice_items ADD COLUMN `EXT01` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE invoice_items ADD COLUMN `EXT02` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE invoice_items ADD COLUMN `EXT03` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE invoice_items ADD COLUMN `EXT04` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE invoice_items ADD COLUMN `EXT05` varchar(255) NULL DEFAULT NULL;
|
|
|
|
##### 2024-2-18
|
|
ALTER TABLE rule ADD COLUMN `SORT` varchar(20) DEFAULT null COMMENT '排序';
|
|
ALTER TABLE rule ADD COLUMN `EXT01` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE rule ADD COLUMN `EXT02` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE rule ADD COLUMN `EXT03` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE rule ADD COLUMN `EXT04` varchar(255) NULL DEFAULT NULL;
|
|
ALTER TABLE rule ADD COLUMN `EXT05` varchar(255) NULL DEFAULT NULL;
|
|
|
|
##### 2024-2-23
|
|
ALTER TABLE mt_list ADD COLUMN `EXT21` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT22` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT23` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT24` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT25` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT26` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT27` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT28` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT29` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE mt_list ADD COLUMN `EXT30` varchar(255) DEFAULT null COMMENT '';
|
|
|
|
##### 2024-2-23
|
|
ALTER TABLE post_box ADD COLUMN `RECEIPT_ID` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `IS_SEND` varchar(2) NULL DEFAULT '0' COMMENT '是否发送concur:0否1是';
|
|
ALTER TABLE post_box ADD COLUMN `EXT06` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `EXT07` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `EXT08` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `EXT09` varchar(100) NULL DEFAULT NULL;
|
|
ALTER TABLE post_box ADD COLUMN `EXT10` varchar(100) NULL DEFAULT NULL;
|
|
|
|
CREATE TABLE `invoice_credit_excel` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`Bayer_Group` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Company_Code` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Employee` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Employee_ID` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Name_onCard` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Last_FourAccount` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Company_Code2` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Payment_Type` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Card_Type` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Transaction_Status` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Transaction_Status_Value` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Transaction_Type` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Merchant` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Merchant_Code` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Default_Expense_Type` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Posted_Date` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Transaction_Date` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Download_Date` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Billing_Date` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Posted_Amount` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Currency` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Reference_Number` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`Company_Code3` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`TRAN_DATE` varchar(20) NULL DEFAULT NULL COMMENT 'Transaction_Date转换后的日期',
|
|
`VERIFIED_DATA` text NULL DEFAULT NULL COMMENT '',
|
|
`IS_DEL` varchar(2) NULL DEFAULT '0' COMMENT '',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`UUID` varchar(100) NULL DEFAULT NULL COMMENT '记录本次的uuid',
|
|
`EXT01` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT06` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT07` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT08` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT09` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT10` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `invoice_credit_excel_ID_uindex`(`ID`) USING BTREE,
|
|
INDEX `UUID_index`(`UUID`) USING BTREE,
|
|
INDEX `Reference_Number_index`(`Reference_Number`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '信用卡excel数据';
|
|
|
|
ALTER TABLE efiles ADD COLUMN `EXT06` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE efiles ADD COLUMN `EXT07` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE efiles ADD COLUMN `EXT08` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE efiles ADD COLUMN `EXT09` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE efiles ADD COLUMN `EXT10` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE efiles ADD COLUMN `Reference_Number` varchar(100) DEFAULT null COMMENT '';
|
|
ALTER TABLE efiles ADD COLUMN `Company_Code` varchar(20) DEFAULT null COMMENT '';
|
|
ALTER TABLE efiles ADD COLUMN `CREATE_DATE` varchar(20) DEFAULT null COMMENT '';
|
|
|
|
##### 2024-5-28
|
|
ALTER TABLE invoice_lines ADD COLUMN `VALID_COUNT` int(4) DEFAULT 0 COMMENT '验真次数' AFTER `VALID_STATUS`;
|
|
ALTER TABLE invoice_lines ADD COLUMN `VALID_DAY_COUNT` int(4) DEFAULT 0 COMMENT '当日验真次数' AFTER `VALID_COUNT`;
|
|
ALTER TABLE invoice_lines ADD COLUMN `CREATE_DATE` datetime DEFAULT null COMMENT '创建时间' AFTER `VALID_DAY_COUNT`;
|
|
ALTER TABLE invoice_lines ADD COLUMN `EXT06` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `EXT07` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `EXT08` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `EXT09` varchar(255) DEFAULT null COMMENT '';
|
|
ALTER TABLE invoice_lines ADD COLUMN `EXT10` varchar(255) DEFAULT null COMMENT '';
|
|
|
|
ALTER TABLE t_10_report_main_extension ADD COLUMN `CREATE_DATE` datetime DEFAULT null COMMENT '创建时间';
|
|
|
|
|
|
##### 2024-07-01
|
|
CREATE TABLE `signin_meet` (
|
|
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
|
`SIGNIN_ID` int(11) NULL DEFAULT NULL COMMENT 'SIGNIN表ID',
|
|
`REQ_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ReqId',
|
|
`MEET_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会议唯一ID',
|
|
`MEET_CODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '会议号码',
|
|
`SUBJECT` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '主题',
|
|
`STATR_TIME` datetime NULL DEFAULT NULL COMMENT '预定会议开始时间',
|
|
`END_TIME` datetime NULL DEFAULT NULL COMMENT '预定会议结束时间',
|
|
`TOTAL_COUNT` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前参会总人次',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT06` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT07` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT08` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT09` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT10` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '腾讯会议信息表';
|
|
|
|
CREATE TABLE `signin_meet_attend` (
|
|
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
|
`PID` int(11) NOT NULL COMMENT 'signin_meet表ID',
|
|
`USER_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参会者用户ID',
|
|
`MS_OPEN_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '当场会议的用户临时ID',
|
|
`UUID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户的身份 ID',
|
|
`OPEN_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '已授权用户的 ID',
|
|
`USER_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入会用户名',
|
|
`IS_IN_USER` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否是企业内部成员',
|
|
`PHONE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参会者手机号',
|
|
`JOIN_TIME` datetime NULL DEFAULT NULL COMMENT '参会者加入会议时间',
|
|
`LEFT_TIME` datetime NULL DEFAULT NULL COMMENT '参会者加入离开时间',
|
|
`INSTANCE_ID` int(2) NULL DEFAULT NULL COMMENT '用户的终端设备类型',
|
|
`USER_ROLE` int(2) NULL DEFAULT NULL COMMENT '用户角色',
|
|
`IP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户IP',
|
|
`LOCATION` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户地理位置',
|
|
`LINK_TYPE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户连接方式',
|
|
`JOIN_TYPE` int(2) NULL DEFAULT NULL COMMENT '入会方式',
|
|
`NET` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '网络类型',
|
|
`APP_VERSION` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端版本',
|
|
`AUDIO_STATE` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '麦克风状态',
|
|
`AVIDEO_STATE` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '摄像头状态',
|
|
`SCREEN_SHARED_STATE` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '屏幕共享状态',
|
|
`CUSTOMER_DATA` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专属字段',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`EXT01` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT06` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT07` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT08` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT09` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
`EXT10` varchar(255) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '腾讯会议参加人员信息表';
|
|
|
|
##### 2024-9-5
|
|
CREATE TABLE `mt_txuser` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`userid` varchar(50) NULL DEFAULT NULL COMMENT 'userid',
|
|
`uuid` varchar(50) NULL DEFAULT NULL COMMENT '用户身份 ID',
|
|
`username` varchar(50) NULL DEFAULT NULL COMMENT '用户姓名',
|
|
`area` varchar(10) NULL DEFAULT NULL COMMENT '手机区号',
|
|
`update_time` varchar(50) NULL DEFAULT NULL COMMENT '更新时间',
|
|
`avatar_url` varchar(200) NULL DEFAULT NULL COMMENT '用户图像地址',
|
|
`phone` varchar(20) NULL DEFAULT NULL COMMENT '手机号',
|
|
`email` varchar(50) NULL DEFAULT NULL COMMENT '邮箱',
|
|
`status` varchar(2) NULL DEFAULT NULL COMMENT '账号状态：1：正常2：注销3：未激活4：禁用5：预注册',
|
|
`job_title` varchar(50) NULL DEFAULT NULL COMMENT '员工职位',
|
|
`staff_id` varchar(50) NULL DEFAULT NULL COMMENT '员工工号',
|
|
`entry_time` varchar(50) NULL DEFAULT NULL COMMENT '入职时间',
|
|
`role_name` varchar(50) NULL DEFAULT NULL COMMENT '角色名称',
|
|
`role_code` varchar(50) NULL DEFAULT NULL COMMENT '角色类型',
|
|
`department_list` text NULL DEFAULT NULL COMMENT '部门信息',
|
|
`user_account_type` int(2) NULL DEFAULT NULL COMMENT '账号类型',
|
|
`account_version` int(2) NULL DEFAULT NULL COMMENT '账号版本',
|
|
`enable_ai_account` int(1) NULL DEFAULT NULL COMMENT '是否有 AI 账号能力。true：有 false：无',
|
|
`ai_account_type` int(2) NULL DEFAULT NULL COMMENT 'AI 账号类型',
|
|
`phone_status` int(2) NULL DEFAULT NULL COMMENT '手机号验证状态',
|
|
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
|
`EXT01` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT02` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT03` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT04` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT05` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT06` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT07` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT08` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT09` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
`EXT10` varchar(100) NULL DEFAULT NULL COMMENT '',
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
UNIQUE INDEX `mt_txuser_ID_uindex`(`ID`) USING BTREE,
|
|
INDEX `uuid_index`(`uuid`) USING BTREE,
|
|
INDEX `staff_id_index`(`staff_id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会议-腾讯同步用户';
|
|
|
|
##### 2024-12-9
|
|
ALTER TABLE invoice_library ADD COLUMN `DATA_JSON` text DEFAULT null COMMENT'json数据';
|
|
|
|
ALTER TABLE expense_reports ADD COLUMN `inv_num` int(20) NULL DEFAULT 0 COMMENT '费用行个数';
|
|
ALTER TABLE expense_reports ADD COLUMN `reimburse_json` varchar(500) NULL DEFAULT NULL COMMENT '报销金额json';
|
|
ALTER TABLE expense_reports ADD COLUMN `item_amount_json` varchar(500) NULL DEFAULT NULL COMMENT '个人消费json';
|
|
ALTER TABLE expense_reports ADD COLUMN `inv_send` varchar(2) NULL DEFAULT '0' COMMENT '费用行发送标记';
|
|
ALTER TABLE expense_reports ADD COLUMN `files_send` varchar(2) NULL DEFAULT '0' COMMENT '附件发送标记';
|
|
|
|
##### 2025-5-22
|
|
ALTER TABLE user ADD COLUMN `UNIONID` varchar(50) NULL DEFAULT NULL COMMENT 'UNIONID' AFTER `OPENID`;
|
|
|
|
ALTER TABLE mt_list ADD COLUMN `EXPENSE_USE` varchar(300) NULL DEFAULT NULL COMMENT '费用用途';
|
|
ALTER TABLE mt_list ADD COLUMN `OPEN_ID` varchar(50) NULL DEFAULT NULL COMMENT 'OPEN_ID';
|
|
ALTER TABLE mt_list ADD COLUMN `POLICY_ID` int NULL DEFAULT NULL COMMENT 'POLICY_ID';
|
|
ALTER TABLE mt_list ADD COLUMN `POLICY_FIELDS` longtext NULL DEFAULT NULL COMMENT 'POLICY_FIELDS';
|
|
|
|
ALTER TABLE mt_expense ADD COLUMN `OPEN_ID` varchar(50) NULL DEFAULT NULL COMMENT 'OPEN_ID';
|
|
ALTER TABLE mt_expense ADD COLUMN `EXPENSE_TYPE_ID` int NULL DEFAULT NULL COMMENT '费用类型ID';
|
|
ALTER TABLE mt_expense ADD COLUMN `EXPENSE_FIELDS` mediumtext NULL DEFAULT NULL COMMENT '费用类型扩展字段';
|
|
ALTER TABLE mt_expense ADD COLUMN `TRADE_DATE` varchar(30) NULL DEFAULT NULL COMMENT '交易日期';
|
|
ALTER TABLE mt_expense ADD COLUMN `CITY` varchar(30) NULL DEFAULT NULL COMMENT '城市';
|
|
|
|
ALTER TABLE mt_expense ADD COLUMN `EXT01` varchar(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE mt_expense ADD COLUMN `EXT02` varchar(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE mt_expense ADD COLUMN `EXT03` varchar(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE mt_expense ADD COLUMN `EXT04` varchar(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE mt_expense ADD COLUMN `EXT05` varchar(200) NULL DEFAULT NULL COMMENT '';
|
|
|
|
##### 2025-7-7
|
|
ALTER TABLE t_10_attendee ADD COLUMN `active` varchar(10) NULL DEFAULT NULL COMMENT '是否激活' AFTER `currency_code`;
|
|
|
|
ALTER TABLE files_config ADD COLUMN `EXT06` varchar(100) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE files_config ADD COLUMN `EXT07` varchar(100) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE files_config ADD COLUMN `EXT08` varchar(100) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE files_config ADD COLUMN `EXT09` varchar(100) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE files_config ADD COLUMN `EXT10` varchar(100) NULL DEFAULT NULL COMMENT '';
|
|
|
|
##### 2025-8-5
|
|
ALTER TABLE invoice_img ADD COLUMN `EXT01` varchar(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE invoice_img ADD COLUMN `EXT02` varchar(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE invoice_img ADD COLUMN `EXT03` varchar(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE invoice_img ADD COLUMN `EXT04` varchar(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE invoice_img ADD COLUMN `EXT05` varchar(200) NULL DEFAULT NULL COMMENT '';
|
|
|
|
##### 2025-8-28
|
|
ALTER TABLE invoice_image_deduction ADD COLUMN `EXT01` VARCHAR(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE invoice_image_deduction ADD COLUMN `EXT02` VARCHAR(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE invoice_image_deduction ADD COLUMN `EXT03` VARCHAR(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE invoice_image_deduction ADD COLUMN `EXT04` VARCHAR(200) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE invoice_image_deduction ADD COLUMN `EXT05` VARCHAR(200) NULL DEFAULT NULL COMMENT '';
|
|
|
|
##### 2025-9-3
|
|
ALTER TABLE sys_role ADD COLUMN `HOME_PAGE` VARCHAR(200) NULL DEFAULT NULL COMMENT '默认首页' AFTER `ROLE_TYPE`;
|
|
|
|
ALTER TABLE t_10_employee MODIFY COLUMN update_by VARCHAR(200);
|
|
|
|
##### 2025-9-26
|
|
ALTER TABLE sys_user ADD COLUMN `IN_ACTIVE` int(2) NULL DEFAULT 0 COMMENT '' AFTER `IS_ENABLE`;
|
|
|
|
CREATE TABLE `proxy_sys_user` (
|
|
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
|
`PROXY_ID` int(11) NULL DEFAULT NULL,
|
|
`PROXY_EMAIL` varchar(100) NULL DEFAULT NULL,
|
|
`MAIN_ID` int(11) NULL DEFAULT NULL,
|
|
`MAIN_EMAIL` varchar(100) NULL DEFAULT NULL,
|
|
`PU_ID` int(11) NULL DEFAULT NULL,
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代理设置表'
|
|
|
|
ALTER TABLE mt_list MODIFY COLUMN REMARK VARCHAR(500);
|
|
|
|
ALTER TABLE mt_type ADD COLUMN `EXT06` varchar(100) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE mt_type ADD COLUMN `EXT07` varchar(100) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE mt_type ADD COLUMN `EXT08` varchar(100) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE mt_type ADD COLUMN `EXT09` varchar(100) NULL DEFAULT NULL COMMENT '';
|
|
ALTER TABLE mt_type ADD COLUMN `EXT10` varchar(100) NULL DEFAULT NULL COMMENT '';
|
|
|
|
ALTER TABLE sys_user ADD COLUMN `CLIENT` int(11) NULL DEFAULT 1 COMMENT '';
|
|
|
|
CREATE TABLE `message_mapping` (
|
|
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
|
`MP_SOURCE` varchar(500) NULL DEFAULT NULL,
|
|
`MP_DEST` varchar(500) NULL DEFAULT NULL,
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'mess映射表'
|
|
|
|
#2025-11-3
|
|
ALTER TABLE post_box MODIFY COLUMN EXT08 VARCHAR(1000);
|
|
|
|
ALTER TABLE message_mapping ADD COLUMN `MP_DEST_EN` varchar(500) NULL DEFAULT NULL COMMENT '';
|
|
|
|
#2025-11-26
|
|
#签到系统
|
|
ALTER TABLE signin MODIFY COLUMN EVENT_NAME VARCHAR(200);
|
|
|
|
#2025-12-1
|
|
DROP TABLE IF EXISTS `invoice_arc`;
|
|
CREATE TABLE `invoice_arc` (
|
|
`INVOICE_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发票自增唯一主键(EXP_ID)(expense)',
|
|
`EXPENSE_REPROTS_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '费用报告名称（对应费用报告表中的费用报告名称）',
|
|
`INVOICE_DATE` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票日期(0代表近一周）,1代表发票时间为近一月的范围内,2代表发票时间为近一年的范围内',
|
|
`PRE_ACTIVE` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票日期结束（用来筛选在开票日期区间的发票）',
|
|
`INVOICE_MONEY` decimal(20, 2) NULL DEFAULT 0.00 COMMENT '发票金额',
|
|
`INVOICE_MONEY_MAX` bigint(20) NULL DEFAULT NULL COMMENT '发票金额最高（用来筛选在金额区间内的发票）',
|
|
`INVOICE_TYPE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票类型（出租车票，飞机票。。。）',
|
|
`CONSUME_TYPE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消费类型',
|
|
`EXPENSE_TYPE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '费用类型',
|
|
`BUSINESS_TYPE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手工发票原因',
|
|
`REIMBURSE_MONEY` decimal(20, 5) NULL DEFAULT 0.00000 COMMENT '报销金额',
|
|
`CURRENCY` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '币种',
|
|
`TRADE_DATE` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '交易日期',
|
|
`CITY` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市',
|
|
`SUPPLIER` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商',
|
|
`INVOICE_CODE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票代码',
|
|
`INVOICE_NUM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票号码',
|
|
`INVOICE_STATUS` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '发票状态(0代表无票，1代表普票，2代表税票）',
|
|
`MILEAGE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '里程 （出租车才有）',
|
|
`GET_ON_TIME` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上车时间（出租车才有）',
|
|
`DEBUS_TIME` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '下车时间（出租车才有）',
|
|
`PROJECT_NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
|
|
`DESCR` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注说明',
|
|
`IMG_PATH` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扫描时所扫描的图片路径',
|
|
`EXPENSE_REPROTS_ID` int(11) NULL DEFAULT NULL COMMENT '对应的费用报告id（父id）',
|
|
`IS_DEL` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '0为未删除，1为已删除，默认为0',
|
|
`IS_SEND` int(1) NULL DEFAULT 1 COMMENT '发票是否发送，0（发送）,1（未发送），2（未全部发送）默认未发送（1）',
|
|
`OTHER_FIELDS` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '其他的动态字段拼接而成的json格式的值',
|
|
`FORM_TYPE` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ticketTypeID',
|
|
`OPEN_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '对应用户的openID',
|
|
`CREATE_TIME` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
|
|
`COMPANY_ID` int(11) NULL DEFAULT NULL COMMENT '所属公司ID（每个用户有自己所属的公司）',
|
|
`CLIENT` int(11) NULL DEFAULT NULL COMMENT '用户所对应的客户ID(每个用户有自己所属的公司，所属的公司有所属的客户，一个客户下面可以有多个公司)',
|
|
`IS_VERIFICATION` int(1) NULL DEFAULT 0 COMMENT '0代表为验真，1代表验真，默认0',
|
|
`EXPENSE_FIELDS` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '费用类型扩展字段',
|
|
`ENTRY_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'entry id ',
|
|
`EXPENSE_TYPE_ID` int(11) NULL DEFAULT NULL COMMENT 'EXPENSE REPORT TYPE ID',
|
|
`CHECK_CODE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票校验码',
|
|
`REPORT_FIELDS` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
|
|
`TAX` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税',
|
|
`ORIGINAL_PATH` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '发票原文件',
|
|
`DATA_JSON` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '发票结构化数据',
|
|
`PRE_TAX` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '不含税金额',
|
|
`TAX_RATE` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税率',
|
|
`USER_ID` int(11) NULL DEFAULT NULL COMMENT '用户ID',
|
|
`NEED_VALID` tinyint(1) NULL DEFAULT 0 COMMENT '0 否 1 是 是否需要验真',
|
|
`VALID_STATUS` tinyint(1) NULL DEFAULT 0 COMMENT '0 否 1 是 验真状态',
|
|
`VALID_COUNT` tinyint(4) NULL DEFAULT 0 COMMENT '验真次数',
|
|
`VALID_DAY_COUNT` tinyint(4) NULL DEFAULT 0 COMMENT '当日验真次数',
|
|
`EXT40` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合规检查结果',
|
|
`UPDATED_FLAG` tinyint(1) NULL DEFAULT 0 COMMENT '影像传输Flag 0/已传 1/未传',
|
|
`LOGIN_ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`SECOND_INVOICE_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主报销外键',
|
|
`expmonth` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`REQ_ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'REQ_ID',
|
|
`EXT_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '讲者extId',
|
|
`TICKET_ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ticketId',
|
|
`EXT01` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`EXT02` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录验真Fail的message',
|
|
`EXT03` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建来源：Concur表示从外部认证插入',
|
|
`EXT04` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ticket类型',
|
|
`EXT05` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手工备注更新到EXT40',
|
|
`PAYMENT_TYPE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付方式',
|
|
PRIMARY KEY (`INVOICE_ID`) USING BTREE,
|
|
INDEX `is_del`(`IS_DEL`) USING BTREE,
|
|
INDEX `invoice_type`(`INVOICE_TYPE`) USING BTREE,
|
|
INDEX `expense_reports_id`(`EXPENSE_REPROTS_ID`) USING BTREE,
|
|
INDEX `user_id`(`USER_ID`) USING BTREE,
|
|
INDEX `invoice_num`(`INVOICE_NUM`) USING BTREE,
|
|
INDEX `entry_id`(`ENTRY_ID`) USING BTREE,
|
|
INDEX `invoice_valid_status`(`VALID_STATUS`) USING BTREE,
|
|
INDEX `req_id`(`REQ_ID`) USING BTREE,
|
|
INDEX `expense_type_id`(`EXPENSE_TYPE_ID`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
|
|
DROP TABLE IF EXISTS `invoice_lines_arc`;
|
|
CREATE TABLE `invoice_lines_arc` (
|
|
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`PID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`TYPE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`DATE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`NUMBER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`CODE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`SELLER` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`CURRENCY` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`CHECK_CODE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`PRE_TAX` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`IMG_URI` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`TOTAL` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`VALID_STATUS` tinyint(1) NULL DEFAULT 0,
|
|
`VALID_COUNT` int(4) NULL DEFAULT 0 COMMENT '验真次数',
|
|
`VALID_DAY_COUNT` int(4) NULL DEFAULT 0 COMMENT '当日验真次数',
|
|
`CREATE_DATE` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
|
|
`KIND` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`ORIGINAL_PATH` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`SELLER_CODE` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`BUYER` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`BUYER_CODE` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`ITEM_NAMES` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
|
|
`EXT01` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`EXT02` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`EXT03` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`EXT04` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`EXT05` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`DATA_JSON` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT 'json数据',
|
|
`EXT06` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`EXT07` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`EXT08` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`EXT09` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
`EXT10` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
|
|
PRIMARY KEY (`ID`) USING BTREE,
|
|
INDEX `pid`(`PID`) USING BTREE,
|
|
INDEX `invoice_lines_arc_number_index`(`NUMBER`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;
|
|
|
|
|
|
#2025-12-03
|
|
CREATE TABLE `t_10_report_receive` (
|
|
`uuid` varchar(64) NOT NULL,
|
|
`id` varchar(64) NOT NULL,
|
|
`entry_id` varchar(64) DEFAULT NULL,
|
|
`login_id` varchar(50) DEFAULT NULL,
|
|
`create_by` varchar(255) DEFAULT NULL,
|
|
`bz` varchar(500) DEFAULT NULL COMMENT '备注',
|
|
`fydl` varchar(100) DEFAULT NULL,
|
|
`dd` varchar(100) DEFAULT NULL COMMENT '地点',
|
|
`fyxl` varchar(100) DEFAULT NULL,
|
|
`report_id` varchar(255) DEFAULT NULL COMMENT '报销单id',
|
|
`bsje` varchar(255) DEFAULT NULL COMMENT '报税金额',
|
|
`currency` varchar(255) DEFAULT NULL COMMENT '币种',
|
|
`gys` varchar(255) DEFAULT NULL COMMENT '供应商',
|
|
`tax` varchar(255) DEFAULT NULL COMMENT '税率',
|
|
`type` varchar(255) DEFAULT NULL,
|
|
`ext01` varchar(1000) DEFAULT NULL,
|
|
`ext02` varchar(255) DEFAULT NULL,
|
|
`ext03` text,
|
|
`ext04` varchar(255) DEFAULT NULL,
|
|
`ext05` varchar(255) DEFAULT NULL,
|
|
`ext06` varchar(255) DEFAULT NULL,
|
|
`ext07` varchar(255) DEFAULT NULL,
|
|
`ext08` text,
|
|
`ext09` varchar(255) DEFAULT NULL,
|
|
`ext10` varchar(255) DEFAULT NULL COMMENT '数据是否成功更新到concur 0否1是',
|
|
`ext11` varchar(255) DEFAULT NULL COMMENT 'pdf本地路径',
|
|
`ext12` varchar(255) DEFAULT NULL COMMENT 'pdf是否已成功上传concur 0否1是',
|
|
`ext13` varchar(255) DEFAULT NULL,
|
|
`ext14` varchar(20) DEFAULT NULL,
|
|
`ext15` varchar(20) DEFAULT NULL,
|
|
`ext16` varchar(20) DEFAULT NULL,
|
|
`ext17` varchar(20) DEFAULT NULL,
|
|
`ext18` varchar(20) DEFAULT NULL,
|
|
`ext19` varchar(20) DEFAULT NULL,
|
|
`ext20` varchar(20) DEFAULT NULL,
|
|
`ext21` varchar(20) DEFAULT NULL,
|
|
`ext22` varchar(20) DEFAULT NULL,
|
|
`ext23` varchar(20) DEFAULT NULL,
|
|
`ext24` varchar(20) DEFAULT NULL,
|
|
`ext25` varchar(20) DEFAULT NULL,
|
|
`ext26` varchar(20) DEFAULT NULL,
|
|
`ext27` varchar(20) DEFAULT NULL,
|
|
`ext28` varchar(20) DEFAULT NULL,
|
|
`ext29` varchar(20) DEFAULT NULL,
|
|
`ext30` varchar(20) DEFAULT NULL,
|
|
`ext31` varchar(20) DEFAULT NULL,
|
|
`ext32` varchar(20) DEFAULT NULL,
|
|
`ext33` varchar(20) DEFAULT NULL,
|
|
`ext34` varchar(20) DEFAULT NULL,
|
|
`ext35` varchar(20) DEFAULT NULL,
|
|
`ext36` varchar(20) DEFAULT NULL,
|
|
`ext37` varchar(20) DEFAULT NULL,
|
|
`ext38` varchar(20) DEFAULT NULL,
|
|
`ext39` varchar(20) DEFAULT NULL,
|
|
`ext40` varchar(20) DEFAULT NULL,
|
|
`ext41` varchar(20) DEFAULT NULL,
|
|
`ext42` varchar(20) DEFAULT NULL,
|
|
`ext43` varchar(20) DEFAULT NULL,
|
|
`ext44` varchar(20) DEFAULT NULL,
|
|
`ext45` varchar(20) DEFAULT NULL,
|
|
`ext46` varchar(20) DEFAULT NULL,
|
|
`ext47` varchar(20) DEFAULT NULL,
|
|
`ext48` varchar(20) DEFAULT NULL,
|
|
`ext49` varchar(200) DEFAULT NULL,
|
|
`ext50` varchar(2000) DEFAULT NULL,
|
|
`create_date` datetime DEFAULT CURRENT_TIMESTAMP,
|
|
`receive_status` varchar(10) DEFAULT NULL COMMENT '接收状态',
|
|
`receive_type` varchar(255) DEFAULT '' COMMENT '接收类型 ',
|
|
`pdf_to_local` varchar(10) DEFAULT NULL COMMENT 'pdf是否已下载到本地0否1是',
|
|
`pdf_local_url` varchar(255) DEFAULT NULL COMMENT 'pdf的本地路径地址',
|
|
`fj_to_local` varchar(10) DEFAULT NULL COMMENT 'ext03附件下载',
|
|
`fj_local_url` varchar(255) DEFAULT NULL COMMENT 'ext03附件本地地址',
|
|
`rebuild_pdf_url` varchar(255) DEFAULT NULL COMMENT 'pdf和fj重组后的pdf路径',
|
|
`pdf_to_concur` varchar(10) DEFAULT NULL COMMENT 'pdf是否已上传concur 0否 1是',
|
|
`data_to_concur` varchar(10) DEFAULT NULL,
|
|
`update_date` datetime DEFAULT NULL,
|
|
`update_by` varchar(60) DEFAULT NULL,
|
|
`fyrq` varchar(20) DEFAULT NULL COMMENT '费用日期',
|
|
`purpose` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`uuid`) USING BTREE,
|
|
KEY `data_to_concur` (`data_to_concur`) USING BTREE,
|
|
KEY `receive_status` (`receive_status`) USING BTREE,
|
|
KEY `login_id` (`login_id`) USING BTREE,
|
|
KEY `ext10` (`ext10`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
|
|
ALTER TABLE invoice_item_mileage MODIFY COLUMN EXT01 text;
|
|
|
|
#2026-03-10
|
|
ALTER TABLE currency ADD COLUMN `CODE` varchar(50) NULL DEFAULT NULL COMMENT '';
|
|
|
|
#2026-07-21
|
|
ALTER TABLE expense_reports ADD COLUMN `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间';
|
|
ALTER TABLE expense_reports_arc ADD COLUMN `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间';
|
|
ALTER TABLE invoice ADD COLUMN `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间';
|
|
ALTER TABLE invoice_arc ADD COLUMN `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间';
|
|
ALTER TABLE invoice_item_mileage ADD COLUMN `create_time` datetime NULL DEFAULT NULL COMMENT '新建时间';
|
|
|
|
#2026-08-14
|
|
ALTER TABLE invoice_attendees ADD COLUMN `create_date` datetime NULL DEFAULT NULL COMMENT '新建日期';
|
|
|
|
#2026-08-25
|
|
ALTER TABLE expense_reports MODIFY COLUMN EXT05 text;
|
|
|
|
#2026-09-03
|
|
ALTER TABLE efiles ADD INDEX idx_efiles_type_refnum (TYPE, Reference_Number) USING BTREE;
|