You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.
/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 80022
Source Host : localhost:3306
Source Schema : nstocks
Target Server Type : MySQL
Target Server Version : 80022
File Encoding : 65001
Date: 29 / 12 / 2021 23:43:04
*/
SET NAMES utf8mb4 ;
SET FOREIGN_KEY_CHECKS = 0 ;
-- ----------------------------
-- Table structure for industries
-- ----------------------------
DROP TABLE IF EXISTS ` industries ` ;
CREATE TABLE ` industries ` (
` id ` double NOT NULL AUTO_INCREMENT ,
` name ` varchar ( 45 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ,
` trade_day ` date NULL DEFAULT NULL COMMENT ' 交易日期 ' ,
` stocks_count ` int ( 0 ) NULL DEFAULT - 1 COMMENT ' 个股数量 ' ,
` type ` varchar ( 45 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ' 类型（ ） ' ,
PRIMARY KEY ( ` id ` ) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ' 所属东财行业2级每日数据 ' ROW_FORMAT = Dynamic ;
SET FOREIGN_KEY_CHECKS = 1 ;
