SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for config_credit_card
-- ----------------------------
DROP TABLE IF EXISTS `config_credit_card`;
CREATE TABLE `config_credit_card`  (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'UUID',
  `cardname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
  `duedate` int(4) NOT NULL COMMENT '信用卡还款日',
  `credit` decimal(10, 4) NOT NULL COMMENT '每月消费额度',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for config_misc
-- ----------------------------
DROP TABLE IF EXISTS `config_misc`;
CREATE TABLE `config_misc`  (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`, `key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for config_recurring_expense
-- ----------------------------
DROP TABLE IF EXISTS `config_recurring_expense`;
CREATE TABLE `config_recurring_expense`  (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'UUID Prime Key',
  `amount` decimal(10, 2) NOT NULL COMMENT '支出金额（实际支出类型货币）',
  `currencytype` enum('CNY','USD','RUB') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'CNY' COMMENT '支付的货币类型',
  `starttime` datetime(0) NULL DEFAULT NULL COMMENT '周期开始时间（单位为？）',
  `endtime` datetime(0) NULL DEFAULT NULL COMMENT '周期结束时间（单位为？）',
  `period` int(255) NULL DEFAULT NULL COMMENT '周期（单位为？）',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '周期性支出配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for expense
-- ----------------------------
DROP TABLE IF EXISTS `expense`;
CREATE TABLE `expense`  (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'UUID Prime Key',
  `amount` decimal(10, 2) NOT NULL COMMENT '支出金额（主货币类型）',
  `date` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '支出时间',
  `category` enum('food','traffic','communcation') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '支出分类',
  `isperiodic` bit(1) NULL DEFAULT b'0' COMMENT '周期性支出',
  `iscreditcard` bit(1) NULL DEFAULT b'0' COMMENT '来自信用卡支出',
  `currencytype` enum('CNY','USD','RUB','HKD') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'CNY' COMMENT '支付的货币类型',
  `acutalamount` decimal(10, 2) NULL DEFAULT NULL COMMENT '以指定类型货币支付金额',
  `exchangerate` decimal(10, 0) UNSIGNED NULL DEFAULT 1 COMMENT '交易时汇率',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '支出数据表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for income
-- ----------------------------
DROP TABLE IF EXISTS `income`;
CREATE TABLE `income`  (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'UUID prime Key',
  `amount` decimal(10, 2) NOT NULL COMMENT '收入金额（主货币类型）',
  `date` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '收入日期',
  `category` enum('salary','bonus','subsidy') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收入类型',
  `source` enum('QBCM') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收入来源',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '收入记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for liability
-- ----------------------------
DROP TABLE IF EXISTS `liability`;
CREATE TABLE `liability`  (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'UUID Prime Key',
  `cardid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '信用卡编号',
  `expenseid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '对应支出记录',
  `amount` decimal(10, 4) NOT NULL COMMENT '主货币类型支出金额',
  `date` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '支出时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;