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

来源：互联网发布：校园安全数据编辑：程序博客网时间：2024/04/29 09:41
## 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','修改操作');
0 0