开发语言：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;