/*

Navicat Premium Data Transfer

Source Server : localhost

Source Server Type : MySQL

Source Server Version : 80026

Source Host : localhost:3306

Source Schema : our

Target Server Type : MySQL

Target Server Version : 80026

File Encoding : 65001

Date: 08/03/2022 21:26:36

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------

-- Table structure for student

-- ----------------------------

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (

`id` int NOT NULL AUTO_INCREMENT,

`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

`sex` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,

`birth` datetime DEFAULT NULL,

`department` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,

`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------

-- Records of student

-- ----------------------------

BEGIN;

COMMIT;

SET FOREIGN_KEY_CHECKS = 1;