下面是表结构：
CREATE TABLE order_center.Untitled (
id bigint(20) NOT NULL AUTO_INCREMENT,
unique_incr_id bigint(20) NOT NULL DEFAULT 0,
transaction_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT ‘’,
source_id bigint(20) NOT NULL,
persist_table tinyint(4) NOT NULL,
order_id varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
order_id_key bigint(20) GENERATED ALWAYS AS (crc32(order_id)) VIRTUAL,
source_app_id smallint(6) NOT NULL,
uid bigint(20) NOT NULL DEFAULT 0,
deviceid varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT ‘’,
order_source tinyint(4) NOT NULL,
order_channel smallint(6) NOT NULL,
app_channel varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
order_status tinyint(4) NOT NULL DEFAULT 1,
order_amount int(11) NOT NULL DEFAULT 0,
pay_time int(11) NOT NULL DEFAULT 0,
order_create_time timestamp(0) NULL DEFAULT NULL,
pay_channel varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
pay_channel_code tinyint(4) NOT NULL DEFAULT 20,
pay_amount int(11) NOT NULL DEFAULT 0,
refund_amount int(11) NOT NULL DEFAULT 0,
refund_time int(11) NOT NULL DEFAULT 0,
transfer tinyint(4) NOT NULL DEFAULT 0,
discount bigint(20) NULL DEFAULT 0,
currency varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
quantity int(11) NOT NULL DEFAULT 1,
product_code varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
product_code_key bigint(20) GENERATED ALWAYS AS (crc32(product_code)) VIRTUAL NULL,
product_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT ‘’,
product_name_key bigint(20) GENERATED ALWAYS AS (crc32(product_name)) VIRTUAL NULL,
product_type tinyint(4) NULL DEFAULT 0,
create_time timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
update_time timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
version int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (id) USING BTREE,
INDEX uid_index(uid) USING BTREE,
INDEX pay_time_index(pay_time) USING BTREE,
INDEX source_id_index(source_id) USING BTREE,
INDEX pck_index(product_code_key) USING BTREE,
INDEX pnk_index(product_name_key) USING BTREE,
UNIQUE INDEX sid_tname_index(source_id, persist_table) USING BTREE,
INDEX order_id_key(order_id_key) USING BTREE,
INDEX idx_did(deviceid) USING BTREE,
INDEX order_ct_idx(order_create_time) USING BTREE,
UNIQUE INDEX unique_idx(unique_incr_id) USING BTREE,
INDEX tid_idx(transaction_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 36589893 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin= ‘主订单表’ ROW_FORMAT = Compact;