kknongchang_2506/app/Module/Fund/Databases/GenerateSql/fund_circulation.sql

-- ******************************************************************
-- 表 kku_fund_circulation 的创建SQL
-- 对应的Model: App\Module\Fund\Models\FundCirculationModel
-- 警告: 此文件由系统自动生成，禁止手动修改！
-- ******************************************************************

DROP TABLE IF EXISTS `kku_fund_circulation`;
CREATE TABLE `kku_fund_circulation` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增',
  `user_id` int NOT NULL COMMENT '用户id',
  `fund_id` int NOT NULL COMMENT '资金ID',
  `to_fund_id` int NOT NULL COMMENT '流向资金账户',
  `re_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '关联类型',
  `re_id` bigint unsigned NOT NULL COMMENT '关联类型',
  `total_fee` bigint NOT NULL COMMENT '充值钱数',
  `create_time` int NOT NULL COMMENT '创建时间',
  `ok_time` int NOT NULL COMMENT '处理时间',
  `remark` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '备注信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=85001 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='资金流转';