fund_currency.sql 1.0 KB

1234567891011121314151617
  1. -- ******************************************************************
  2. -- 表 kku_fund_currency 的创建SQL
  3. -- 对应的Model: App\Module\Fund\Models\FundCurrencyModel
  4. -- 警告: 此文件由系统自动生成,禁止修改!
  5. -- ******************************************************************
  6. CREATE TABLE `kku_fund_currency` (
  7. `id` int NOT NULL AUTO_INCREMENT COMMENT '自增',
  8. `identification` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '资金标识',
  9. `icon` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '资金标识',
  10. `name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '资金名字',
  11. `data1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT '数据',
  12. `display_attributes` json DEFAULT NULL COMMENT '显示属性,如图标、颜色等',
  13. `create_time` int NOT NULL,
  14. `update_time` int NOT NULL COMMENT '更新时间',
  15. PRIMARY KEY (`id`) USING BTREE
  16. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='货币 设置';