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

-- 表 kku_fund_transfer 的创建SQL

DROP TABLE IF EXISTS `kku_fund_transfer`;
CREATE TABLE `kku_fund_transfer` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自增',
  `user_id` int NOT NULL COMMENT '用户id',
  `to_user_id` int NOT NULL COMMENT '转给用户id',
  `remark` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '备注',
  `amount` bigint NOT NULL COMMENT '钱数',
  `fund_id` int NOT NULL COMMENT '来源账户的资金id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='资金 转账记录';