mxys_backend/db/insert_241023.sql

DROP TABLE IF EXISTS `rider_bank_card_info`;
CREATE TABLE `rider_bank_card_info`
(
    `id`        bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    `user_id`   bigint(20) NOT NULL COMMENT '用户id',
    `card_no`   varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '卡号',
    `open_bank` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '开户行',
    `real_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '户主名称',
    `bank_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行名称',
    `del_flag`  varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL DEFAULT '0' COMMENT '删除标识;1 是 0否',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;