fund_circulation.sql 1.0 KB

12345678910111213141516171819
  1. -- ******************************************************************
  2. -- 表 kku_fund_circulation 的创建SQL
  3. -- 对应的Model: App\Module\Fund\Models\FundCirculationModel
  4. -- 警告: 此文件由系统自动生成,禁止修改!
  5. -- ******************************************************************
  6. CREATE TABLE `kku_fund_circulation` (
  7. `id` int NOT NULL AUTO_INCREMENT COMMENT '自增',
  8. `user_id` int NOT NULL COMMENT '用户id',
  9. `fund_id` int NOT NULL COMMENT '资金ID',
  10. `to_fund_id` int NOT NULL COMMENT '流向资金账户',
  11. `re_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '关联类型',
  12. `re_id` bigint unsigned NOT NULL COMMENT '关联类型',
  13. `total_fee` bigint NOT NULL COMMENT '充值钱数',
  14. `create_time` int NOT NULL COMMENT '创建时间',
  15. `ok_time` int NOT NULL COMMENT '处理时间',
  16. `remark` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '备注信息',
  17. PRIMARY KEY (`id`) USING BTREE
  18. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='资金流转';