```sql
/*
 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;

```