体操赛事信息管理系统.zip

-- MySQL dump 10.13 Distrib 8.0.15, for macos10.14 (x86_64) -- -- Host: localhost Database: sport -- ------------------------------------------------------ -- Server version 8.0.15 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; SET NAMES utf8 ; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `coach` -- DROP TABLE IF EXISTS `coach`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `coach` ( `idcoach` int(10) unsigned NOT NULL AUTO_INCREMENT, `coach_name` varchar(45) NOT NULL, `coach_idcard` varchar(45) NOT NULL, `coach_teamid` int(10) unsigned NOT NULL, `coach_sex` char(1) NOT NULL, `coach_tel` varchar(45) NOT NULL, PRIMARY KEY (`idcoach`), UNIQUE KEY `idcoach_UNIQUE` (`idcoach`), UNIQUE KEY `coach_idcard_UNIQUE` (`coach_idcard`), UNIQUE KEY `coach_tel_UNIQUE` (`coach_tel`), UNIQUE KEY `coach_teamid_UNIQUE` (`coach_teamid`), CONSTRAINT `coach_team` FOREIGN KEY (`coach_teamid`) REFERENCES `team` (`idteam`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `coach` -- LOCK TABLES `coach` WRITE; /*!40000 ALTER TABLE `coach` DISABLE KEYS */; /*!40000 ALTER TABLE `coach` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `doctor` -- DROP TABLE IF EXISTS `doctor`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `doctor` ( `iddoctor` int(10) unsigned NOT NULL AUTO_INCREMENT, `doctor_name` varchar(45) NOT NULL, `doctor_idcard` varchar(45) NOT NULL, `doctor_teamid` int(10) unsigned NOT NULL, `doctor_tel` varchar(45) NOT NULL, PRIMARY KEY (`iddoctor`,`doctor_teamid`), UNIQUE KEY `iddoctor_UNIQUE` (`iddoctor`), UNIQUE KEY `doctor_idcard_UNIQUE` (`doctor_idcard`), UNIQUE KEY `doctor_tel_UNIQUE` (`doctor_tel`), KEY `doctor_team_idx` (`doctor_teamid`), CONSTRAINT `doctor_team` FOREIGN KEY (`doctor_teamid`) REFERENCES `team` (`idteam`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `doctor` -- LOCK TABLES `doctor` WRITE; /*!40000 ALTER TABLE `doctor` DISABLE KEYS */; INSERT INTO `doctor` VALUES (1,'飒飒','21313324234',1,'3243423513'),(2,'dsf','234213344',2,'4321414325'); /*!40000 ALTER TABLE `doctor` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event` -- DROP TABLE IF EXISTS `event`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `event` ( `idevent` int(10) unsigned NOT NULL AUTO_INCREMENT, `event_name` varchar(45) NOT NULL, `event_sex` char(1) NOT NULL, PRIMARY KEY (`idevent`), UNIQUE KEY `idevent_UNIQUE` (`idevent`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event` -- LOCK TABLES `event` WRITE; /*!40000 ALTER TABLE `event` DISABLE KEYS */; INSERT INTO `event` VALUES (1,'单杠','男'),(2,'双杠','男'),(3,'吊环','男'),(4,'鞍马','男'),(5,'高低杠','女'),(6,'平衡木','女'),(7,'跳马','全'),(8,'自由体操','全'),(9,'蹦床','全'); /*!40000 ALTER TABLE `event` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `game` -- DROP TABLE IF EXISTS `game`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `game` ( `idgame` int(10) unsigned NOT NULL AUTO_INCREMENT, `game_eventid` int(10) unsigned NOT NULL, `game_age` varchar(45) NOT NULL, `game_sex` char(1) NOT NULL, `game_type` varchar(45) NOT NULL, `game_refereeid` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`idgame`), UNIQUE KEY `idgame_UNIQUE` (`idgame`), KEY `game_event_idx` (`game_eventid`), KEY `game_referee_idx` (`game_refereeid`), CONSTRAINT `game_event` FOREIGN KEY (`game_eventid`) REFERENCES `event` (`idevent`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `game_referee` FOREIGN KEY (`game_refereeid`) REFERENCES `referee` (`idreferee`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `game` -- LOCK TABLES `game` WRITE; /*!40000 ALTER TABLE `game` DISABLE KEYS */; INSERT INTO `game` VALUES (1,1,'7-8岁','男','初赛',1),(2,1,'9-10岁','男','初赛',1),(3,1,'11-12岁','男','初赛',2),(4,2,'7-8岁','男','初赛',2),(5,2,'9-10岁','男','初赛',3),(6,2,'11-12岁','男','初赛',1),(7,3,'7-8岁','男','初赛',NULL),(8,3,'9-10岁','男','初赛',NULL),(9,3,'11-12岁','男','初赛',NULL),(10,4,'7-8岁','男','初赛',NULL),(11,4,'9-10岁','男','初赛',NULL),(12,4,'11-12','男','初赛',NULL),(13,5,'7-8岁','女','初赛',NULL),(14,5,'9-10岁','女','初赛',NULL),(15,5,'11-12岁','女','初赛',NULL),(16,6,'7-8岁','女','初赛',NULL),(17,6,'9-10岁','女','初赛',NULL),(18,6,'11-12岁','女','初赛',3); /*!40000 ALTER TABLE `game` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `leader` -- DROP TABLE IF EXISTS `leader`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `leader` ( `idleader` int(10) unsigned NOT NULL AUTO_INCREMENT, `leader_name` varchar(45) NOT NULL, `leader_idcard` varchar(45) NOT NULL, `leader_teamid` int(10) unsigned NOT NULL, `leader_tel` varchar(45) NOT NULL, PRIMARY KEY (`idleader`), UNIQUE KEY `idleader_UNIQUE` (`idleader`), UNIQUE KEY `leader_idcard_UNIQUE` (`leader_idcard`), UNIQUE KEY `leader_tel_UNIQUE` (`leader_tel`), KEY `leader_team_idx` (`leader_teamid`), CONSTRAINT `leader_team` FOREIGN KEY (`leader_teamid`) REFERENCES `team` (`idteam`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `leader` -- LOCK TABLES `leader` WRITE; /*!40000 ALTER TABLE `leader` DISABLE KEYS */; INSERT INTO `leader` VALUES (1,'erwyqej','wqehjda',1,'weqsad'),(2,'erwyqej','wqehjdadas',1,'weqsadads'); /*!40000 ALTER TABLE `leader` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `player` -- DROP TABLE IF EXISTS `player`; /*!40101 SET @saved_cs_client = @@character_set_client */; SET character_set_client = utf8mb4 ; CREATE TABLE `player` ( `idplayer` int(10) unsigned NOT NULL, `player_name` varchar(45) NOT NULL, `player_idcard` varchar(45) NOT NULL, `player_teamid` int(10) unsigned NOT NULL, `player_sex` char(1) NOT NULL, `player_age` int(10) unsigned NOT NULL, `player_score` int(11) DEFAULT NULL, PRIMARY KEY (`idplayer`), UNIQUE KEY `idplayer_UNIQUE` (`idplayer`), UNIQUE KEY `player_idcard_UNIQUE` (`player_idcard`), KEY `player_team_idx` (`player_teamid`), CONSTRAINT `player_team` FOREIGN KEY (`player_teamid`) REFERENCES `team` (`idteam`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `player` -- LOCK TABLES `player` WRITE; /*!40000 ALTER TABLE `playe