开发语言:Python
框架:django
Python版本:python3.7.7
数据库:mysql 5.7(一定要5.7版本)
数据库工具:Navicat11
开发软件:PyCharm
浏览器:谷歌浏览器
数据库:
DROP TABLE IF EXISTS `baoxiaoshenqing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `baoxiaoshenqing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shetuanzhanghao` varchar(200) DEFAULT NULL COMMENT '社团账号',
`shetuanmingcheng` varchar(200) DEFAULT NULL COMMENT '社团名称',
`shetuanleixing` varchar(200) DEFAULT NULL COMMENT '社团类型',
`bumenmingcheng` varchar(200) DEFAULT NULL COMMENT '部门名称',
`buzhangzhanghao` varchar(200) DEFAULT NULL COMMENT '部长账号',
`buzhangxingming` varchar(200) DEFAULT NULL COMMENT '部长姓名',
`huodongmingcheng` varchar(200) DEFAULT NULL COMMENT '活动名称',
`huodongdidian` varchar(200) DEFAULT NULL COMMENT '活动地点',
`baoxiaofeiyong` float DEFAULT NULL COMMENT '报销费用',
`baoxiaodanju` longtext COMMENT '报销单据',
`tijiaoriqi` date DEFAULT NULL COMMENT '提交日期',
`crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
`crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8 COMMENT='报销申请';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `baoxiaoshenqing`
--
LOCK TABLES `baoxiaoshenqing` WRITE;
/*!40000 ALTER TABLE `baoxiaoshenqing` DISABLE KEYS */;
INSERT INTO `baoxiaoshenqing` VALUES (191,'2022-04-25 08:35:09','社团账号1','社团名称1','社团类型1','部门名称1','部长账号1','部长姓名1','活动名称1','活动地点1',1,'报销单据1','2022-04-25',1,1,'是',''),(192,'2022-04-25 08:35:09','社团账号2','社团名称2','社团类型2','部门名称2','部长账号2','部长姓名2','活动名称2','活动地点2',2,'报销单据2','2022-04-25',2,2,'是',''),(193,'2022-04-25 08:35:09','社团账号3','社团名称3','社团类型3','部门名称3','部长账号3','部长姓名3','活动名称3','活动地点3',3,'报销单据3','2022-04-25',3,3,'是',''),(194,'2022-04-25 08:35:09','社团账号4','社团名称4','社团类型4','部门名称4','部长账号4','部长姓名4','活动名称4','活动地点4',4,'报销单据4','2022-04-25',4,4,'是',''),(195,'2022-04-25 08:35:09','社团账号5','社团名称5','社团类型5','部门名称5','部长账号5','部长姓名5','活动名称5','活动地点5',5,'报销单据5','2022-04-25',5,5,'是',''),(196,'2022-04-25 08:35:09','社团账号6','社团名称6','社团类型6','部门名称6','部长账号6','部长姓名6','活动名称6','活动地点6',6,'报销单据6','2022-04-25',6,6,'是','');
/*!40000 ALTER TABLE `baoxiaoshenqing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `buzhang`
--
DROP TABLE IF EXISTS `buzhang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `buzhang` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`buzhangzhanghao` varchar(200) NOT NULL COMMENT '部长账号',
`bumenmingcheng` varchar(200) DEFAULT NULL COMMENT '部门名称',
`buzhangxingming` varchar(200) NOT NULL COMMENT '部长姓名',
`mima` varchar(200) NOT NULL COMMENT '密码',
`buzhangshouji` varchar(200) DEFAULT NULL COMMENT '部长手机',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='部长';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `buzhang`
--
LOCK TABLES `buzhang` WRITE;
/*!40000 ALTER TABLE `buzhang` DISABLE KEYS */;
INSERT INTO `buzhang` VALUES (41,'2022-04-25 08:35:08','部长账号1','部门名称1','部长姓名1','123456','13823888881','upload/buzhang_touxiang1.jpg','男','[email protected]'),(42,'2022-04-25 08:35:08','部长账号2','部门名称2','部长姓名2','123456','13823888882','upload/buzhang_touxiang2.jpg','男','[email protected]'),(43,'2022-04-25 08:35:08','部长账号3','部门名称3','部长姓名3','123456','13823888883','upload/buzhang_touxiang3.jpg','男','[email protected]'),(44,'2022-04-25 08:35:08','部长账号4','部门名称4','部长姓名4','123456','13823888884','upload/buzhang_touxiang4.jpg','男','[email protected]'),(45,'2022-04-25 08:35:08','部长账号5','部门名称5','部长姓名5','123456','13823888885','upload/buzhang_touxiang5.jpg','男','[email protected]'),(46,'2022-04-25 08:35:08','部长账号6','部门名称6','部长姓名6','123456','13823888886','upload/buzhang_touxiang6.jpg','男','[email protected]');
/*!40000 ALTER TABLE `buzhang` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `changdishenqing`
--
DROP TABLE IF EXISTS `changdishenqing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `changdishenqing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`changdimingcheng` varchar(200) NOT NULL COMMENT '场地名称',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`rongnarenshu` int(11) NOT NULL COMMENT '容纳人数',
`weizhi` varchar(200) NOT NULL COMMENT '位置',
`changdixiangqing` longtext COMMENT '场地详情',
`fuzeren` varchar(200) DEFAULT NULL COMMENT '负责人',
`shetuanzhanghao` varchar(200) DEFAULT NULL COMMENT '社团账号',
`shetuanmingcheng` varchar(200) DEFAULT NULL COMMENT '社团名称',
`shezhangxingming` varchar(200) DEFAULT NULL COMMENT '社长姓名',
`shetuanleixing` varchar(200) DEFAULT NULL COMMENT '社团类型',
`shenqingshijian` datetime DEFAULT NULL COMMENT '申请时间',
`shenqingneirong` varchar(200) NOT NULL COMMENT '申请内容',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='场地申请';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `changdishenqing`
--
LOCK TABLES `changdishenqing` WRITE;
/*!40000 ALTER TABLE `changdishenqing` DISABLE KEYS */;
INSERT INTO `changdishenqing` VALUES (101,'2022-04-25 08:35:08','场地名称1','13823888881',1,'位置1','场地详情1','负责人1','社团账号1','社团名称1','社长姓名1','社团类型1','2022-04-25 16:35:08','申请内容1','是',''),(102,'2022-04-25 08:35:08','场地名称2','13823888882',2,'位置2','场地详情2','负责人2','社团账号2','社团名称2','社长姓名2','社团类型2','2022-04-25 16:35:08','申请内容2','是',''),(103,'2022-04-25 08:35:08','场地名称3','13823888883',3,'位置3','场地详情3','负责人3','社团账号3','社团名称3','社长姓名3','社团类型3','2022-04-25 16:35:08','申请内容3','是',''),(104,'2022-04-25 08:35:08','场地名称4','13823888884',4,'位置4','场地详情4','负责人4','社团账号4','社团名称4','社长姓名4','社团类型4','2022-04-25 16:35:08','申请内容4','是',''),(105,'2022-04-25 08:35:08','场地名称5','13823888885',5,'位置5','场地详情5','负责人5','社团账号5','社团名称5','社长姓名5','社团类型5','2022-04-25 16:35:08','申请内容5','是',''),(106,'2022-04-25 08:35:08','场地名称6','13823888886',6,'位置6','场地详情6','负责人6','社团账号6','社团名称6','社长姓名6','社团类型6','2022-04-25 16:35:08','申请内容6','是','');
/*!40000 ALTER TABLE `changdishenqing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `changdixinxi`
--
DROP TABLE IF EXISTS `changdixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `changdixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`changdimingcheng` varchar(200) NOT NULL COMMENT '场地名称',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`rongnarenshu` int(11) NOT NULL COMMENT '容纳人数',
`weizhi` varchar(200) NOT NULL COMMENT '位置',
`changdixiangqing` longtext COMMENT '场地详情',
`changdizhuangtai` varchar(200) NOT NULL COMMENT '场地状态',
`fuzeren` varchar(200) DEFAULT NULL COMMENT '负责人',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='场地信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `changdixinxi`
--
LOCK TABLES `changdixinxi` WRITE;
/*!40000 ALTER TABLE `changdixinxi` DISABLE KEYS */;
INSERT INTO `changdixinxi` VALUES (91,'2022-04-25 08:35:08','场地名称1','13823888881',1,'位置1','场地详情1','已被申请','负责人1'),(92,'2022-04-25 08:35:08','场地名称2','13823888882',2,'位置2','场地详情2','已被申请','负责人2'),(93,'2022-04-25 08:35:08','场地名称3','13823888883',3,'位置3','场地详情3','已被申请','负责人3'),(94,'2022-04-25 08:35:08','场地名称4','13823888884',4,'位置4','场地详情4','已被申请','负责人4'),(95,'2022-04-25 08:35:08','场地名称5','13823888885',5,'位置5','场地详情5','已被申请','负责人5'),(96,'2022-04-25 08:35:08','场地名称6','13823888886',6,'位置6','场地详情6','已被申请','负责人6');
/*!40000 ALTER TABLE `changdixinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussgonggaoxinxi`
--
DROP TABLE IF EXISTS `discussgonggaoxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussgonggaoxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8 COMMENT='公告信息评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussgonggaoxinxi`
--
LOCK TABLES `discussgonggaoxinxi` WRITE;
/*!40000 ALTER TABLE `discussgonggaoxinxi` DISABLE KEYS */;
INSERT INTO `discussgonggaoxinxi` VALUES (211,'2022-04-25 08:35:09',1,1,'用户名1','评论内容1','回复内容1'),(212,'2022-04-25 08:35:09',2,2,'用户名2','评论内容2','回复内容2'),(213,'2022-04-25 08:35:09',3,3,'用户名3','评论内容3','回复内容3'),(214,'2022-04-25 08:35:09',4,4,'用户名4','评论内容4','回复内容4'),(215,'2022-04-25 08:35:09',5,5,'用户名5','评论内容5','回复内容5'),(216,'2022-04-25 08:35:09',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discussgonggaoxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusstaolunqu`
--
DROP TABLE IF EXISTS `discusstaolunqu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusstaolunqu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=227 DEFAULT CHARSET=utf8 COMMENT='讨论区评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discusstaolunqu`
--
LOCK TABLES `discusstaolunqu` WRITE;
/*!40000 ALTER TABLE `discusstaolunqu` DISABLE KEYS */;
INSERT INTO `discusstaolunqu` VALUES (221,'2022-04-25 08:35:09',1,1,'用户名1','评论内容1','回复内容1'),(222,'2022-04-25 08:35:09',2,2,'用户名2','评论内容2','回复内容2'),(223,'2022-04-25 08:35:09',3,3,'用户名3','评论内容3','回复内容3'),(224,'2022-04-25 08:35:09',4,4,'用户名4','评论内容4','回复内容4'),(225,'2022-04-25 08:35:09',5,5,'用户名5','评论内容5','回复内容5'),(226,'2022-04-25 08:35:09',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discusstaolunqu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gonggaoxinxi`
--
DROP TABLE IF EXISTS `gonggaoxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gonggaoxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`biaoti` varchar(200) NOT NULL COMMENT '标题',
`fengmian` varchar(200) NOT NULL COMMENT '封面',
`riqi` date DEFAULT NULL COMMENT '日期',
`neirong` longtext NOT NULL COMMENT '内容',
`faburen` varchar(200) NOT NULL COMMENT '发布人',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='公告信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gonggaoxinxi`
--
LOCK TABLES `gonggaoxinxi` WRITE;
/*!40000 ALTER TABLE `gonggaoxinxi` DISABLE KEYS */;
INSERT INTO `gonggaoxinxi` VALUES (51,'2022-04-25 08:35:08','标题1','upload/gonggaoxinxi_fengmian1.jpg','2022-04-25','内容1','发布人1','是','',1),(52,'2022-04-25 08:35:08','标题2','upload/gonggaoxinxi_fengmian2.jpg','2022-04-25','内容2','发布人2','是','',2),(53,'2022-04-25 08:35:08','标题3','upload/gonggaoxinxi_fengmian3.jpg','2022-04-25','内容3','发布人3','是','',3),(54,'2022-04-25 08:35:08','标题4','upload/gonggaoxinxi_fengmian4.jpg','2022-04-25','内容4','发布人4','是','',4),(55,'2022-04-25 08:35:08','标题5','upload/gonggaoxinxi_fengmian5.jpg','2022-04-25','内容5','发布人5','是','',5),(56,'2022-04-25 08:35:08','标题6','upload/gonggaoxinxi_fengmian6.jpg','2022-04-25','内容6','发布人6','是','',6);
/*!40000 ALTER TABLE `gonggaoxinxi` ENABLE KEYS */;
UNLOCK TABLES;