xfD015De

1SET NAMES utf8mb4;
2SET FOREIGN_KEY_CHECKS = 0;
3
4-- ----------------------------
5-- Table structure for config_credit_card
6-- ----------------------------
7DROP TABLE IF EXISTS `config_credit_card`;
8CREATE TABLE `config_credit_card`  (
9  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'UUID',
10  `cardname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
11  `duedate` int(4) NOT NULL COMMENT '信用卡还款日',
12  `credit` decimal(10, 4) NOT NULL COMMENT '每月消费额度',
13  PRIMARY KEY (`id`) USING BTREE
14) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
15
16-- ----------------------------
17-- Table structure for config_misc
18-- ----------------------------
19DROP TABLE IF EXISTS `config_misc`;
20CREATE TABLE `config_misc`  (
21  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
22  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
23  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
24  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
25  PRIMARY KEY (`id`, `key`) USING BTREE
26) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
27
28-- ----------------------------
29-- Table structure for config_recurring_expense
30-- ----------------------------
31DROP TABLE IF EXISTS `config_recurring_expense`;
32CREATE TABLE `config_recurring_expense`  (
33  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'UUID Prime Key',
34  `amount` decimal(10, 2) NOT NULL COMMENT '支出金额（实际支出类型货币）',
35  `currencytype` enum('CNY','USD','RUB') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'CNY' COMMENT '支付的货币类型',
36  `starttime` datetime(0) NULL DEFAULT NULL COMMENT '周期开始时间（单位为？）',
37  `endtime` datetime(0) NULL DEFAULT NULL COMMENT '周期结束时间（单位为？）',
38  `period` int(255) NULL DEFAULT NULL COMMENT '周期（单位为？）',
39  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
40  PRIMARY KEY (`id`) USING BTREE
41) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '周期性支出配置表' ROW_FORMAT = Dynamic;
42
43-- ----------------------------
44-- Table structure for expense
45-- ----------------------------
46DROP TABLE IF EXISTS `expense`;
47CREATE TABLE `expense`  (
48  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'UUID Prime Key',
49  `amount` decimal(10, 2) NOT NULL COMMENT '支出金额（主货币类型）',
50  `date` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '支出时间',
51  `category` enum('food','traffic','communcation') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '支出分类',
52  `isperiodic` bit(1) NULL DEFAULT b'0' COMMENT '周期性支出',
53  `iscreditcard` bit(1) NULL DEFAULT b'0' COMMENT '来自信用卡支出',
54  `currencytype` enum('CNY','USD','RUB','HKD') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'CNY' COMMENT '支付的货币类型',
55  `acutalamount` decimal(10, 2) NULL DEFAULT NULL COMMENT '以指定类型货币支付金额',
56  `exchangerate` decimal(10, 0) UNSIGNED NULL DEFAULT 1 COMMENT '交易时汇率',
57  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
58  PRIMARY KEY (`id`) USING BTREE
59) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '支出数据表' ROW_FORMAT = Dynamic;
60
61-- ----------------------------
62-- Table structure for income
63-- ----------------------------
64DROP TABLE IF EXISTS `income`;
65CREATE TABLE `income`  (
66  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'UUID prime Key',
67  `amount` decimal(10, 2) NOT NULL COMMENT '收入金额（主货币类型）',
68  `date` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '收入日期',
69  `category` enum('salary','bonus','subsidy') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收入类型',
70  `source` enum('QBCM') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收入来源',
71  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
72  PRIMARY KEY (`id`) USING BTREE
73) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '收入记录表' ROW_FORMAT = Dynamic;
74
75-- ----------------------------
76-- Table structure for liability
77-- ----------------------------
78DROP TABLE IF EXISTS `liability`;
79CREATE TABLE `liability`  (
80  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'UUID Prime Key',
81  `cardid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '信用卡编号',
82  `expenseid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '对应支出记录',
83  `amount` decimal(10, 4) NOT NULL COMMENT '主货币类型支出金额',
84  `date` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '支出时间',
85  PRIMARY KEY (`id`) USING BTREE
86) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
87
88SET FOREIGN_KEY_CHECKS = 1;