53 lines
2.6 KiB
SQL
53 lines
2.6 KiB
SQL
alter table verification ADD COLUMN `bill_remarks` varchar(255) COMMENT '账单备注';
|
|
|
|
alter table business_document_detali
|
|
ADD COLUMN `payment_method` int (1) DEFAULT 0 COMMENT '支付方式 0-挂账 1-即时';
|
|
|
|
alter table verification
|
|
ADD COLUMN `payment_method` int (1) DEFAULT 0 COMMENT '支付方式 0-挂账 1-即时';
|
|
|
|
|
|
alter table business_document_detali
|
|
ADD COLUMN `fuel_card_number` varchar(255) DEFAULT NULL COMMENT '油卡号';
|
|
|
|
alter table verification
|
|
ADD COLUMN `fuel_card_number` varchar(255) DEFAULT NULL COMMENT '油卡号';
|
|
|
|
=====================================截止2025-11-14 正式数据库已同步完成================================
|
|
|
|
|
|
------20251205ncd对接---
|
|
alter table reconciliation ADD COLUMN `synchronous_status` int (1) DEFAULT 0 COMMENT 'nc应收单同步状态 0-未同步 1-已同步';
|
|
|
|
alter table reconciliation ADD COLUMN `synchronous_time` datetime DEFAULT null COMMENT 'nc应收单同步时间';
|
|
alter table reconciliation ADD COLUMN `nc_id` varchar (255) DEFAULT null COMMENT 'nc应收单的唯一标识';
|
|
|
|
alter table reconciliation ADD COLUMN `sk_synchronous_status` int (1) DEFAULT 0 COMMENT 'nc同步状态 0-未同步 1-已同步';
|
|
|
|
alter table reconciliation ADD COLUMN `sk_synchronous_time` datetime DEFAULT null COMMENT 'nc同步时间';
|
|
|
|
|
|
alter table reconciliation ADD COLUMN `sk_nc_id` varchar (255) DEFAULT null COMMENT 'nc的唯一标识';
|
|
alter table tms_receipt ADD COLUMN `synchronous_status` int (1) DEFAULT 0 COMMENT 'nc应收单同步状态 0-未同步 1-已同步';
|
|
|
|
alter table tms_receipt ADD COLUMN `synchronous_time` datetime DEFAULT null COMMENT 'nc应收单同步时间';
|
|
alter table tms_receipt ADD COLUMN `nc_id` varchar (255) DEFAULT null COMMENT 'nc应收单的唯一标识';
|
|
|
|
CREATE TABLE `nc_log` (
|
|
`nc_log_id` bigint NOT NULL AUTO_INCREMENT COMMENT 'nc日志id',
|
|
`type` int DEFAULT '0' COMMENT '类型 0-应收单 1-收款单',
|
|
`order_id` int DEFAULT '0' COMMENT '数据源id',
|
|
`request_body` text COLLATE utf8mb4_general_ci COMMENT '请求报文',
|
|
`respone_body` text COLLATE utf8mb4_general_ci COMMENT '请求报文',
|
|
`del_flag` int DEFAULT '1' COMMENT '删除标记：0-无状态，1-正常，2-已删除',
|
|
`organization_id` bigint DEFAULT NULL COMMENT '组织ID',
|
|
`top_organization_id` bigint DEFAULT NULL COMMENT '一级组织ID',
|
|
`organization_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组织名称',
|
|
PRIMARY KEY (`nc_log_id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
|
|
|
|
|
|
|
|
|