| 12345678910111213141516 |
- -- ******************************************************************
- -- 表 kku_fund_transfer 的创建SQL
- -- 对应的Model: App\Module\Fund\Models\FundTransferModel
- -- 警告: 此文件由系统自动生成,禁止手动修改!
- -- ******************************************************************
- 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='资金 转账记录';
|