学生学籍管理系统_数据库设计

最新推荐文章于 2024-03-12 12:49:14 发布

hoho_12

最新推荐文章于 2024-03-12 12:49:14 发布

阅读量9.7k

点赞数 1

分类专栏： Java课程设计文章标签：数据库

本文链接：https://blog.csdn.net/hoho_12/article/details/51980372

版权

Java课程设计专栏收录该内容

11 篇文章 0 订阅

订阅专栏

#
# Structure for table "infor"
#
create database stu;
use stu;


DROP TABLE IF EXISTS `infor`;
CREATE TABLE `infor` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `stuId` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `class` varchar(20) DEFAULT NULL,
  `profess` varchar(20) DEFAULT NULL,
  `depart` varchar(20) DEFAULT NULL,
  `sex` varchar(20) DEFAULT NULL,
  `grade` varchar(20) DEFAULT NULL,
  `bir` datetime DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `QQ` varchar(20) DEFAULT NULL,
  `state` varchar(20) DEFAULT NULL,
  `password` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `stuId` (`stuId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "infor"
#

INSERT INTO `infor` VALUES (1,'1','张三','12班','','','','','1995-02-13 00:00:00','','','','1'),(2,'2','曹操',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2');

#
# Structure for table "operate"
#

DROP TABLE IF EXISTS `operate`;
CREATE TABLE `operate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stuId` varchar(20) DEFAULT NULL,
  `time` datetime,
  `operate` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "operate"
#

INSERT INTO `operate` VALUES (1,'1','2016-07-07 21:22:57','删除操作'),(2,'1','2016-07-07 21:32:36','修改操作'),(3,'1','2016-07-07 21:32:51','删除操作'),(4,'1','2016-07-07 22:28:50','修改操作');