基于python的社團(tuán)管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開發(fā)語言：Python
框架：django
Python版本：python3.7.7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：PyCharm?
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫：
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 '創(chuàng)建時(shí)間',
? `shetuanzhanghao` varchar(200) DEFAULT NULL COMMENT '社團(tuán)賬號',
? `shetuanmingcheng` varchar(200) DEFAULT NULL COMMENT '社團(tuán)名稱',
? `shetuanleixing` varchar(200) DEFAULT NULL COMMENT '社團(tuán)類型',
? `bumenmingcheng` varchar(200) DEFAULT NULL COMMENT '部門名稱',
? `buzhangzhanghao` varchar(200) DEFAULT NULL COMMENT '部長賬號',
? `buzhangxingming` varchar(200) DEFAULT NULL COMMENT '部長姓名',
? `huodongmingcheng` varchar(200) DEFAULT NULL COMMENT '活動(dòng)名稱',
? `huodongdidian` varchar(200) DEFAULT NULL COMMENT '活動(dòng)地點(diǎn)',
? `baoxiaofeiyong` float DEFAULT NULL COMMENT '報(bào)銷費(fèi)用',
? `baoxiaodanju` longtext COMMENT '報(bào)銷單據(jù)',
? `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 '審核回復(fù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8 COMMENT='報(bào)銷申請';
/*!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','社團(tuán)賬號1','社團(tuán)名稱1','社團(tuán)類型1','部門名稱1','部長賬號1','部長姓名1','活動(dòng)名稱1','活動(dòng)地點(diǎn)1',1,'報(bào)銷單據(jù)1','2022-04-25',1,1,'是',''),(192,'2022-04-25 08:35:09','社團(tuán)賬號2','社團(tuán)名稱2','社團(tuán)類型2','部門名稱2','部長賬號2','部長姓名2','活動(dòng)名稱2','活動(dòng)地點(diǎn)2',2,'報(bào)銷單據(jù)2','2022-04-25',2,2,'是',''),(193,'2022-04-25 08:35:09','社團(tuán)賬號3','社團(tuán)名稱3','社團(tuán)類型3','部門名稱3','部長賬號3','部長姓名3','活動(dòng)名稱3','活動(dòng)地點(diǎn)3',3,'報(bào)銷單據(jù)3','2022-04-25',3,3,'是',''),(194,'2022-04-25 08:35:09','社團(tuán)賬號4','社團(tuán)名稱4','社團(tuán)類型4','部門名稱4','部長賬號4','部長姓名4','活動(dòng)名稱4','活動(dòng)地點(diǎn)4',4,'報(bào)銷單據(jù)4','2022-04-25',4,4,'是',''),(195,'2022-04-25 08:35:09','社團(tuán)賬號5','社團(tuán)名稱5','社團(tuán)類型5','部門名稱5','部長賬號5','部長姓名5','活動(dòng)名稱5','活動(dòng)地點(diǎn)5',5,'報(bào)銷單據(jù)5','2022-04-25',5,5,'是',''),(196,'2022-04-25 08:35:09','社團(tuán)賬號6','社團(tuán)名稱6','社團(tuán)類型6','部門名稱6','部長賬號6','部長姓名6','活動(dòng)名稱6','活動(dòng)地點(diǎn)6',6,'報(bào)銷單據(jù)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 '創(chuàng)建時(shí)間',
? `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 '部長手機(jī)',
? `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','男','773890001@qq.com'),(42,'2022-04-25 08:35:08','部長賬號2','部門名稱2','部長姓名2','123456','13823888882','upload/buzhang_touxiang2.jpg','男','773890002@qq.com'),(43,'2022-04-25 08:35:08','部長賬號3','部門名稱3','部長姓名3','123456','13823888883','upload/buzhang_touxiang3.jpg','男','773890003@qq.com'),(44,'2022-04-25 08:35:08','部長賬號4','部門名稱4','部長姓名4','123456','13823888884','upload/buzhang_touxiang4.jpg','男','773890004@qq.com'),(45,'2022-04-25 08:35:08','部長賬號5','部門名稱5','部長姓名5','123456','13823888885','upload/buzhang_touxiang5.jpg','男','773890005@qq.com'),(46,'2022-04-25 08:35:08','部長賬號6','部門名稱6','部長姓名6','123456','13823888886','upload/buzhang_touxiang6.jpg','男','773890006@qq.com');
/*!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 '創(chuàng)建時(shí)間',
? `changdimingcheng` varchar(200) NOT NULL COMMENT '場地名稱',
? `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
? `rongnarenshu` int(11) NOT NULL COMMENT '容納人數(shù)',
? `weizhi` varchar(200) NOT NULL COMMENT '位置',
? `changdixiangqing` longtext COMMENT '場地詳情',
? `fuzeren` varchar(200) DEFAULT NULL COMMENT '負(fù)責(zé)人',
? `shetuanzhanghao` varchar(200) DEFAULT NULL COMMENT '社團(tuán)賬號',
? `shetuanmingcheng` varchar(200) DEFAULT NULL COMMENT '社團(tuán)名稱',
? `shezhangxingming` varchar(200) DEFAULT NULL COMMENT '社長姓名',
? `shetuanleixing` varchar(200) DEFAULT NULL COMMENT '社團(tuán)類型',
? `shenqingshijian` datetime DEFAULT NULL COMMENT '申請時(shí)間',
? `shenqingneirong` varchar(200) NOT NULL COMMENT '申請內(nèi)容',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? 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','負(fù)責(zé)人1','社團(tuán)賬號1','社團(tuán)名稱1','社長姓名1','社團(tuán)類型1','2022-04-25 16:35:08','申請內(nèi)容1','是',''),(102,'2022-04-25 08:35:08','場地名稱2','13823888882',2,'位置2','場地詳情2','負(fù)責(zé)人2','社團(tuán)賬號2','社團(tuán)名稱2','社長姓名2','社團(tuán)類型2','2022-04-25 16:35:08','申請內(nèi)容2','是',''),(103,'2022-04-25 08:35:08','場地名稱3','13823888883',3,'位置3','場地詳情3','負(fù)責(zé)人3','社團(tuán)賬號3','社團(tuán)名稱3','社長姓名3','社團(tuán)類型3','2022-04-25 16:35:08','申請內(nèi)容3','是',''),(104,'2022-04-25 08:35:08','場地名稱4','13823888884',4,'位置4','場地詳情4','負(fù)責(zé)人4','社團(tuán)賬號4','社團(tuán)名稱4','社長姓名4','社團(tuán)類型4','2022-04-25 16:35:08','申請內(nèi)容4','是',''),(105,'2022-04-25 08:35:08','場地名稱5','13823888885',5,'位置5','場地詳情5','負(fù)責(zé)人5','社團(tuán)賬號5','社團(tuán)名稱5','社長姓名5','社團(tuán)類型5','2022-04-25 16:35:08','申請內(nèi)容5','是',''),(106,'2022-04-25 08:35:08','場地名稱6','13823888886',6,'位置6','場地詳情6','負(fù)責(zé)人6','社團(tuán)賬號6','社團(tuán)名稱6','社長姓名6','社團(tuán)類型6','2022-04-25 16:35:08','申請內(nèi)容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 '創(chuàng)建時(shí)間',
? `changdimingcheng` varchar(200) NOT NULL COMMENT '場地名稱',
? `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
? `rongnarenshu` int(11) NOT NULL COMMENT '容納人數(shù)',
? `weizhi` varchar(200) NOT NULL COMMENT '位置',
? `changdixiangqing` longtext COMMENT '場地詳情',
? `changdizhuangtai` varchar(200) NOT NULL COMMENT '場地狀態(tài)',
? `fuzeren` varchar(200) DEFAULT NULL COMMENT '負(fù)責(zé)人',
? 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','已被申請','負(fù)責(zé)人1'),(92,'2022-04-25 08:35:08','場地名稱2','13823888882',2,'位置2','場地詳情2','已被申請','負(fù)責(zé)人2'),(93,'2022-04-25 08:35:08','場地名稱3','13823888883',3,'位置3','場地詳情3','已被申請','負(fù)責(zé)人3'),(94,'2022-04-25 08:35:08','場地名稱4','13823888884',4,'位置4','場地詳情4','已被申請','負(fù)責(zé)人4'),(95,'2022-04-25 08:35:08','場地名稱5','13823888885',5,'位置5','場地詳情5','已被申請','負(fù)責(zé)人5'),(96,'2022-04-25 08:35:08','場地名稱6','13823888886',6,'位置6','場地詳情6','已被申請','負(fù)責(zé)人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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? 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','評論內(nèi)容1','回復(fù)內(nèi)容1'),(212,'2022-04-25 08:35:09',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(213,'2022-04-25 08:35:09',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(214,'2022-04-25 08:35:09',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(215,'2022-04-25 08:35:09',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(216,'2022-04-25 08:35:09',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容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 '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=227 DEFAULT CHARSET=utf8 COMMENT='討論區(qū)評論表';
/*!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','評論內(nèi)容1','回復(fù)內(nèi)容1'),(222,'2022-04-25 08:35:09',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(223,'2022-04-25 08:35:09',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(224,'2022-04-25 08:35:09',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(225,'2022-04-25 08:35:09',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(226,'2022-04-25 08:35:09',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容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 '創(chuàng)建時(shí)間',
? `biaoti` varchar(200) NOT NULL COMMENT '標(biāo)題',
? `fengmian` varchar(200) NOT NULL COMMENT '封面',
? `riqi` date DEFAULT NULL COMMENT '日期',
? `neirong` longtext NOT NULL COMMENT '內(nèi)容',
? `faburen` varchar(200) NOT NULL COMMENT '發(fā)布人',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? `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','標(biāo)題1','upload/gonggaoxinxi_fengmian1.jpg','2022-04-25','內(nèi)容1','發(fā)布人1','是','',1),(52,'2022-04-25 08:35:08','標(biāo)題2','upload/gonggaoxinxi_fengmian2.jpg','2022-04-25','內(nèi)容2','發(fā)布人2','是','',2),(53,'2022-04-25 08:35:08','標(biāo)題3','upload/gonggaoxinxi_fengmian3.jpg','2022-04-25','內(nèi)容3','發(fā)布人3','是','',3),(54,'2022-04-25 08:35:08','標(biāo)題4','upload/gonggaoxinxi_fengmian4.jpg','2022-04-25','內(nèi)容4','發(fā)布人4','是','',4),(55,'2022-04-25 08:35:08','標(biāo)題5','upload/gonggaoxinxi_fengmian5.jpg','2022-04-25','內(nèi)容5','發(fā)布人5','是','',5),(56,'2022-04-25 08:35:08','標(biāo)題6','upload/gonggaoxinxi_fengmian6.jpg','2022-04-25','內(nèi)容6','發(fā)布人6','是','',6);
/*!40000 ALTER TABLE `gonggaoxinxi` ENABLE KEYS */;
UNLOCK TABLES;
