12 lines
882 B
SQL
12 lines
882 B
SQL
CREATE TABLE `la_withdraw_commission_applyfor` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`distributor_id` bigint(20) NULL DEFAULT NULL COMMENT '分销商id',
|
||
`withdraw_money` decimal(10, 2) NOT NULL COMMENT '提现金额',
|
||
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
|
||
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '处理时间',
|
||
`status` int(11) NOT NULL COMMENT '提现状态：0-提现中 1提现成功 2提现失败',
|
||
`is_delete` int(11) NOT NULL DEFAULT 0 COMMENT '是否删除：0-未删除 1已删除',
|
||
`fail_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拒绝理由',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分销商提现申请表' ROW_FORMAT = Dynamic;
|