CREATE DATABASE IF NOT EXISTS `lost_found` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `lost_found`;
-- MySQL dump 10.13 Distrib 8.0.20, for Win64 (x86_64)
--
-- Host: 127.0.0.1 Database: lost_found
-- ------------------------------------------------------
-- Server version 8.0.20
/*!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 */;
/*!50503 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 `follow`
--
DROP TABLE IF EXISTS `follow`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `follow` (
`id_number` varchar(20) NOT NULL,
`id_category` varchar(20) NOT NULL,
`push_datetime` datetime NOT NULL,
`push_id_number` varchar(20) NOT NULL,
`push_id_category` varchar(20) NOT NULL,
PRIMARY KEY (`id_number`,`id_category`,`push_datetime`,`push_id_number`,`push_id_category`),
KEY `follow_fk2_idx` (`push_datetime`),
KEY `follow_fk3_idx` (`id_category`),
KEY `follow_fk4_idx` (`push_id_number`),
KEY `follow_fk5_idx` (`push_id_category`),
CONSTRAINT `follow_fk1` FOREIGN KEY (`id_number`) REFERENCES `users` (`id_number`),
CONSTRAINT `follow_fk2` FOREIGN KEY (`push_datetime`) REFERENCES `lost_found_info` (`push_datetime`),
CONSTRAINT `follow_fk3` FOREIGN KEY (`id_category`) REFERENCES `users` (`id_category`),
CONSTRAINT `follow_fk4` FOREIGN KEY (`push_id_number`) REFERENCES `lost_found_info` (`id_number`),
CONSTRAINT `follow_fk5` FOREIGN KEY (`push_id_category`) REFERENCES `lost_found_info` (`id_category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='收藏关联表单';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `follow`
--
LOCK TABLES `follow` WRITE;
/*!40000 ALTER TABLE `follow` DISABLE KEYS */;
INSERT INTO `follow` VALUES ('admin','工号','2021-05-05 17:34:34','admin','工号'),('admin','工号','2021-05-05 18:10:26','admin','工号'),('user','学号','2021-05-05 18:10:28','admin','工号'),('admin','工号','2021-05-05 18:59:29','admin','工号'),('admin','工号','2021-05-05 19:00:41','admin','工号'),('admin','工号','2021-05-05 20:00:07','admin','工号'),('admin','工号','2021-05-05 20:19:58','user','学号'),('user1','学号','2021-05-05 20:19:58','user','学号');
/*!40000 ALTER TABLE `follow` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `id_category`
--
DROP TABLE IF EXISTS `id_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `id_category` (
`id_category` varchar(20) NOT NULL,
PRIMARY KEY (`id_category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户ID类别表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `id_category`
--
LOCK TABLES `id_category` WRITE;
/*!40000 ALTER TABLE `id_category` DISABLE KEYS */;
INSERT INTO `id_category` VALUES ('学号'),('工号'),('未知生物'),('身份证');
/*!40000 ALTER TABLE `id_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `lost_found_info`
--
DROP TABLE IF EXISTS `lost_found_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lost_found_info` (
`push_datetime` datetime NOT NULL,
`id_number` varchar(20) NOT NULL,
`id_category` varchar(20) NOT NULL,
`type` enum('失物','招领') NOT NULL,
`name` varchar(30) NOT NULL,
`description` varchar(300) NOT NULL,
`contact` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`solved` enum('未解决','已解决') NOT NULL,
`claimant_id` varchar(20) DEFAULT NULL,
`claimant_idcategory` varchar(20) DEFAULT NULL,
PRIMARY KEY (`push_datetime`,`id_number`,`id_category`),
KEY `info_id_number_idx` (`id_number`),
KEY `info_category_idx` (`id_category`),
CONSTRAINT `info_category` FOREIGN KEY (`id_category`) REFERENCES `users` (`id_category`),
CONSTRAINT `info_id` FOREIGN KEY (`id_number`) REFERENCES `users` (`id_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='失物/招领信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `lost_found_info`
--
LOCK TABLES `lost_found_info` WRITE;
/*!40000 ALTER TABLE `lost_found_info` DISABLE KEYS */;
INSERT INTO `lost_found_info` VALUES ('2021-05-05 18:10:26','admin','工号','失物','1','1得到','111','已解决','admin','工号'),('2021-05-05 18:10:28','admin','工号','失物','1','1得到','111','已解决','admin','工号'),('2021-05-05 20:19:58','user','学号','失物','普通用户的失物招领','得的','得的','已解决','user1','学号'),('2021-05-05 20:20:08','user','学号','招领','普通用户的失物招领11','得的3','得的21','已解决','user1','学号'),('2021-05-10 14:55:51','user123','学号','招领','测试物品','这是一个测试物品','QQ:27669928','未解决',NULL,NULL);
/*!40000 ALTER TABLE `lost_found_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
`id_number` varchar(20) NOT NULL,
`id_category` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`power` enum('管理员','普通用户') NOT NULL,
`name` varchar(20) NOT NULL,
PRIMARY KEY (`id_number`,`id_category`),
KEY `id_category_idx` (`id_category`),
CONSTRAINT `users_fk_id_category` FOREIGN KEY (`id_category`) REFERENCES `id_category` (`id_category`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户资料表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('123','未知生物','123456qq','普通用户','用户'),('admin','工号','12345678','管理员','admin'),('admin1','工号','123456qq','管理员','admin1'),('user','学号','12345678','普通用户','user'),('user1','学号','121596qq','普通用户','用户1'),('user11','身份证','121596qq','普通用户','用户'),('user123','学号','123456qq','普通用户','user123');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2021-05-10 15:05:37
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
基于java的失物招领系统.zip (2个子文件)
lost-and-found-system-master
数据库文件
lost_found.sql 7KB
失物招领系统_程序.zip 2.34MB
共 2 条
- 1
资源评论
- jdkaph2022-06-15用户下载后在一定时间内未进行评价,系统默认好评。
- 2301_766129072023-03-03非常有用的资源,可以直接使用,对我很有用,果断支持!
我慢慢地也过来了
- 粉丝: 6925
- 资源: 4009
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功