/*
Navicat Premium Dump SQL
Source Server : rds_d8d_appcontainer_user_prd
Source Server Type : MySQL
Source Server Version : 80036 (8.0.36)
Source Host : rm-2ze1b1zbmp79qy2835o.mysql.rds.aliyuncs.com:3306
Source Schema : d8d_appcontainer_user_dev
Target Server Type : MySQL
Target Server Version : 80036 (8.0.36)
File Encoding : 65001
Date: 11/07/2025 09:38:08
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for classroom_data
-- ----------------------------
DROP TABLE IF EXISTS `classroom_data`;
CREATE TABLE `classroom_data` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '数据ID',
`classroom_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教室号',
`training_date` timestamp NULL DEFAULT NULL COMMENT '训练日期',
`holding_stock` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '持股',
`holding_cash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '持币',
`price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '价格',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '代码',
`status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '状态',
`spare` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备用',
`submit_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '提交用户',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of classroom_data
-- ----------------------------
INSERT INTO `classroom_data` VALUES (1, 'test01', '2025-05-21 08:00:00', NULL, NULL, NULL, '001339', '1', NULL, NULL, '2025-05-21 16:44:36', '2025-05-21 21:22:06');
-- ----------------------------
-- Table structure for date_notes
-- ----------------------------
DROP TABLE IF EXISTS `date_notes`;
CREATE TABLE `date_notes` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '股票代码',
`note_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '备注日期',
`note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '备注内容',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `date_notes_code_note_date_unique`(`code` ASC, `note_date` ASC) USING BTREE,
INDEX `date_notes_code_index`(`code` ASC) USING BTREE,
INDEX `date_notes_note_date_index`(`note_date` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of date_notes
-- ----------------------------
INSERT INTO `date_notes` VALUES (1, '001339', '2024-11-07 08:00:00', 'test01', '2025-05-22 16:17:13', '2025-05-22 16:17:13');
INSERT INTO `date_notes` VALUES (2, '001339', '2024-11-11 08:00:00', 'test02', '2025-05-22 16:18:05', '2025-05-22 16:18:05');
-- ----------------------------
-- Table structure for stock_data
-- ----------------------------
DROP TABLE IF EXISTS `stock_data`;
CREATE TABLE `stock_data` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '股票代码',
`data` json NOT NULL COMMENT '股票数据',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `stock_data_code_unique`(`code` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for stock_xunlian_codes
-- ----------------------------
DROP TABLE IF EXISTS `stock_xunlian_codes`;
CREATE TABLE `stock_xunlian_codes` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '股票代码',
`stock_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '股票名称',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '案例名称',
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '案例类型',
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '案例描述',
`trade_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '交易日期',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `stock_xunlian_codes_code_unique`(`code` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of stock_xunlian_codes
-- ----------------------------
INSERT INTO `stock_xunlian_codes` VALUES (1, '001339', 'test01', 'test222', NULL, NULL, '2025-05-21 08:00:00', '2025-05-22 16:58:01', '2025-05-22 17:19:32');
-- ----------------------------
-- Table structure for submission_records
-- ----------------------------
DROP TABLE IF EXISTS `submission_records`;
CREATE TABLE `submission_records` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '数据ID',
`classroom_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教室号',
`user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户id',
`nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '昵称',
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '成绩',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '代码',
`training_date` timestamp NULL DEFAULT NULL COMMENT '训练日期',
`mark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标记',
`status` int NULL DEFAULT NULL COMMENT '状态',
`holding_stock` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '持股',
`holding_cash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '持币',
`price` decimal(10, 2) NULL DEFAULT NULL COMMENT '价格',
`profit_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '收益金额',
`profit_percent` decimal(10, 2) NULL DEFAULT NULL COMMENT '收益率',
`total_profit_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '累计收益金额',
`total_profit_percent` decimal(10, 2) NULL DEFAULT NULL COMMENT '累计收益率',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of submission_records
-- ----------------------------
SET FOREIGN_KEY_CHECKS = 1;
