/*
 Navicat Premium Data Transfer

 Source Server         : mysql_dev
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : 192.168.182.10:3306
 Source Schema         : Student_BE_DB

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 28/12/2021 21:41:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for Student
-- ----------------------------
DROP TABLE IF EXISTS `Student`;
CREATE TABLE `Student`  (
  `sno` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `gender` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `dept` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `position` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `birthday` date NULL DEFAULT NULL,
  `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`sno`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of Student
-- ----------------------------
INSERT INTO `Student` VALUES ('95001', '李晓明', '男', '信息部', '系统工程师', '1999-10-10', '13900991122', 'lixiaoming', '上海市徐汇区漕溪路1112号', NULL);
INSERT INTO `Student` VALUES ('95002', '陈鹏', '男', '信息部', '系统工程师', '1998-09-09', '18809332211', 'chenpeng@abc.com', '上海市闵行区金都路89弄', NULL);
INSERT INTO `Student` VALUES ('95003', '刘向明', '男', '信息部', '网络工程师', '1998-11-09', '15909123443', 'liuxiangmign@abc.com', '南京市溧水区秦淮大道123号', NULL);
INSERT INTO `Student` VALUES ('95004', '朱明清', '男', '市场部', '主管', '1988-03-07', '15011223344', 'zhumignqing@163.com', '南京市鼓楼区湖南路69号', NULL);
INSERT INTO `Student` VALUES ('95005', '胡小芳', '女', '财务部', '主管', '1985-09-21', '13988990077', 'huxiaofang@qq.com', '上海市浦东新区民生路189弄', NULL);
INSERT INTO `Student` VALUES ('95006', '张三', '男', '人力资源部', '主管', '1993-03-03', '15612344433', 'zhangsan@qq.com', '上海市闵行区银都路113弄', NULL);
INSERT INTO `Student` VALUES ('95007', '赵天吉', '男', '信息部', '主管', '1987-04-24', '18809890765', 'zhaotianji@263com', '南京市江宁区吉印大道80号', NULL);
INSERT INTO `Student` VALUES ('95008', '秦小璐', '女', '市场部', '专员', '1998-06-09', '18012332122', 'qinxiaolu@sohu.com', '苏州市解放路58号', NULL);
INSERT INTO `Student` VALUES ('95009', '刘向东', '男', '信息部', '安全工程师', '1993-06-29', '17709090808', 'liuxiangdong@sina.com', '上海市闵行区春申路295号', NULL);
INSERT INTO `Student` VALUES ('95010', '李明博', '男', '财务部', '专员', '1995-03-07', '18932178905', 'limingbo@gmail.com', '上海市徐汇区柳州路101弄', NULL);
INSERT INTO `Student` VALUES ('95011', '王文海', '男', '人力资源部', '专员', '1998-03-09', '18238391838', 'wangwenhai@qq.com', '上海市徐汇区龙漕路102弄', NULL);
INSERT INTO `Student` VALUES ('95012', '刘慧娟', '女', '市场部', '助理', '1997-04-29', '18876068428', 'liuhuijuan@163.com', '上海市闵行区颛兴东路297号', NULL);
INSERT INTO `Student` VALUES ('95013', '陈敏', '女', '财务部', '出纳', '1989-10-30', '13513745019', 'chenming@263.com', '上海市徐汇区桂林路103弄', NULL);
INSERT INTO `Student` VALUES ('95014', '王云', '女', '财务部', '助理', '1994-10-28', '13051421609', 'wangyun@gmail.com', '上海市闵行区开发区大道298号', NULL);

SET FOREIGN_KEY_CHECKS = 1;