毕业设计-考勤系统数据库

E-R图

数据库

/*
Navicat MySQL Data Transfer

Source Server         : jdk
Source Server Version : 80015
Source Host           : localhost:3306
Source Database       : project_database

Target Server Type    : MYSQL
Target Server Version : 80015
File Encoding         : 65001

Date: 2021-06-10 17:33:59
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_account` varchar(10) DEFAULT NULL,
  `admin_password` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Table structure for attend
-- ----------------------------
DROP TABLE IF EXISTS `attend`;
CREATE TABLE `attend` (
  `attend_id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT NULL,
  `attend_start` timestamp NULL DEFAULT NULL,
  `attend_end` timestamp NULL DEFAULT NULL,
  `attend_longitude` double DEFAULT NULL,
  `attend_latitude` double DEFAULT NULL,
  `attend_location` varchar(50) DEFAULT NULL,
  `attend_type` int(1) DEFAULT NULL,
  `attend_gesture` varchar(18) DEFAULT NULL,
  PRIMARY KEY (`attend_id`),
  KEY `FK_Relationship_6` (`course_id`),
  CONSTRAINT `FK_Relationship_6` FOREIGN KEY (`course_id`) REFERENCES `course` (`course_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT