CREATE TABLE `4dkankan_v4`.`t_product` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '单价', `scene_limit_count` int NULL DEFAULT NULL COMMENT '每个场景限购数量', `scene_free_count` int NULL DEFAULT NULL COMMENT '每个场景免费数量', `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'A', `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0), PRIMARY KEY (`id`) );