Maintain #392
進行中準備 中信所需 SQL
100%
概述
smartfds_trans, acqfd_adm 交易相關切 partition
檔案
是由 rock chen 於 30 天 前更新
smartfds_trans - create table 的參考:
CREATE TABLE t_outbound_io (
id bigint NOT NULL AUTO_INCREMENT,
create_datetime datetime(6) NOT NULL,
update_datetime datetime(6) DEFAULT NULL,
inbound_id bigint NOT NULL,
name varchar(20) NOT NULL,
request longblob,
response longblob,
duration int DEFAULT NULL,
PRIMARY KEY (id, create_datetime),
KEY IDX_OUTBOUND_IO_CREATE_DATETIME (create_datetime),
KEY IDX_OUTBOUND_IO_INBOUND_ID (inbound_id)
) ENGINE=InnoDB AUTO_INCREMENT=1
PARTITION BY RANGE COLUMNS (create_datetime) (
PARTITION p202601 VALUES LESS THAN ('2026-02-01 00:00:00'),
PARTITION p202602 VALUES LESS THAN ('2026-03-01 00:00:00'),
PARTITION p202603 VALUES LESS THAN ('2026-04-01 00:00:00'),
PARTITION p202604 VALUES LESS THAN ('2026-05-01 00:00:00'),
PARTITION p202605 VALUES LESS THAN ('2026-06-01 00:00:00'),
PARTITION p202606 VALUES LESS THAN ('2026-07-01 00:00:00'),
PARTITION pmax VALUES LESS THAN MAXVALUE
);
- rule engine 跟交易有關: t_rule_trans, t_rule_trans_field, t_rule_trans_hit
- 參考:
CREATE TABLE t_rule_trans_field (
oid bigint NOT NULL AUTO_INCREMENT,
create_date varchar(8) NOT NULL,
create_time varchar(6) NOT NULL,
update_date varchar(8) DEFAULT NULL,
update_time varchar(8) DEFAULT NULL,
business_type varchar(64) DEFAULT NULL,
create_date_time bigint NOT NULL,
data_code varchar(50) DEFAULT NULL,
field_code varchar(50) DEFAULT NULL,
institute_id varchar(36) NOT NULL,
operator_id varchar(36) NOT NULL,
rule_group_code varchar(40) DEFAULT NULL,
trans_id bigint DEFAULT NULL,
tx_seq_no varchar(100) DEFAULT NULL,
var1 varchar(200) DEFAULT NULL,
PRIMARY KEY (oid, create_date_time),
KEY IDX_RULE_TRANS_FIELD_04 (create_date),
KEY IDX_RULE_TRANS_FIELD_05 (create_date_time),
KEY IDX_RULE_TRANS_FIELD_06 (trans_id),
KEY IDX_RULE_TRANS_FIELD_01 (institute_id,business_type,data_code,field_code,var1,create_date_time) USING BTREE,
KEY IDX_RULE_TRANS_FIELD_02 (institute_id,business_type,data_code,field_code,var1,create_date) USING BTREE,
KEY IDX_RULE_TRANS_FIELD_03 (data_code,field_code,var1,create_date_time) USING BTREE,
KEY IDX_RULE_TRANS_FIELD_07 (trans_id,institute_id,business_type,data_code,field_code,var1,create_date_time) USING BTREE
)
ENGINE=InnoDB AUTO_INCREMENT=1
PARTITION BY RANGE (create_date_time) (
PARTITION p202508 VALUES LESS THAN (20250900000000),
PARTITION p202509 VALUES LESS THAN (20251000000000),
PARTITION p202510 VALUES LESS THAN (20251100000000),
PARTITION p202511 VALUES LESS THAN (20251200000000),
PARTITION p202512 VALUES LESS THAN (20260100000000),
PARTITION p202601 VALUES LESS THAN (20260200000000),
PARTITION p202602 VALUES LESS THAN (20260300000000),
PARTITION p202603 VALUES LESS THAN (20260400000000),
PARTITION p202604 VALUES LESS THAN (20260500000000),
PARTITION p202605 VALUES LESS THAN (20260600000000),
PARTITION p202606 VALUES LESS THAN (20260700000000),
PARTITION pmax VALUES LESS THAN MAXVALUE
);