continuous_times.sql 1.0 KB

12345678910111213141516171819
  1. -- ******************************************************************
  2. -- 表 kku_continuous_times 的创建SQL
  3. -- 对应的Model: App\Module\System\Models\ContinuousTimes
  4. -- 警告: 此文件由系统自动生成,禁止修改!
  5. -- ******************************************************************
  6. CREATE TABLE `kku_continuous_times` (
  7. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  8. `user_id` bigint(20) unsigned DEFAULT NULL COMMENT '用户id',
  9. `stype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '产品类型',
  10. `sid` bigint(20) DEFAULT NULL COMMENT '产品id',
  11. `number` bigint(20) DEFAULT NULL COMMENT '计数',
  12. `last_time` bigint(20) DEFAULT NULL COMMENT '最后的时间',
  13. `created_at` timestamp NULL DEFAULT NULL,
  14. `updated_at` timestamp NULL DEFAULT NULL,
  15. `deleted_at` timestamp NULL DEFAULT NULL,
  16. `diff` int(11) DEFAULT NULL,
  17. PRIMARY KEY (`id`) USING BTREE
  18. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='连续次数判定';