drop table if exists tt_info;
CREATE TABLE `tt_info` (
`tt_info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id(自增主键)',
`tt_info_serial_no` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '交易号',
`serial_no` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '流水号',
`account_amt` decimal(18,4) DEFAULT '0.0000' COMMENT '金额',
`created_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
`updated_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`version_val` int(11) DEFAULT NULL COMMENT '版本',
`record_ind` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '逻辑删除标志',
PRIMARY KEY (`tt_info_id`) USING BTREE,
UNIQUE KEY `idx_tt_info_serial_no` (`tt_info_serial_no`),
KEY `idx_aai_serial_no` (`serial_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT COMMENT='tt表';