小程序框架:uniapp
小程序开发软件:HBuilder X
小程序运行软件:微信开发者
数据库:
DROP TABLE IF EXISTS `chujiezhe`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chujiezhe` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`chujiezhanghao` varchar(200) DEFAULT NULL COMMENT '出借账号',
`mima` varchar(200) DEFAULT NULL COMMENT '密码',
`chujiexingming` varchar(200) DEFAULT NULL COMMENT '出借姓名',
`touxiang` longtext COMMENT '头像',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`shidejine` int(11) DEFAULT NULL COMMENT '实得金额',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='出借者';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chujiezhe`
--
LOCK TABLES `chujiezhe` WRITE;
/*!40000 ALTER TABLE `chujiezhe` DISABLE KEYS */;
INSERT INTO `chujiezhe` VALUES (11,'2023-02-24 08:38:34','出借账号1','123456','出借姓名1','upload/chujiezhe_touxiang1.jpg','男','13823888881',1),(12,'2023-02-24 08:38:34','出借账号2','123456','出借姓名2','upload/chujiezhe_touxiang2.jpg','男','13823888882',2),(13,'2023-02-24 08:38:34','出借账号3','123456','出借姓名3','upload/chujiezhe_touxiang3.jpg','男','13823888883',3),(14,'2023-02-24 08:38:34','出借账号4','123456','出借姓名4','upload/chujiezhe_touxiang4.jpg','男','13823888884',4),(15,'2023-02-24 08:38:34','出借账号5','123456','出借姓名5','upload/chujiezhe_touxiang5.jpg','男','13823888885',5),(16,'2023-02-24 08:38:34','出借账号6','123456','出借姓名6','upload/chujiezhe_touxiang6.jpg','男','13823888886',6),(17,'2023-02-24 08:38:34','出借账号7','123456','出借姓名7','upload/chujiezhe_touxiang7.jpg','男','13823888887',7),(18,'2023-02-24 08:38:34','出借账号8','123456','出借姓名8','upload/chujiezhe_touxiang8.jpg','男','13823888888',8);
/*!40000 ALTER TABLE `chujiezhe` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chuzushouru`
--
DROP TABLE IF EXISTS `chuzushouru`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chuzushouru` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhuti` varchar(200) DEFAULT NULL COMMENT '主题',
`chujiezhanghao` varchar(200) DEFAULT NULL COMMENT '出借账号',
`chujiexingming` varchar(200) DEFAULT NULL COMMENT '出借姓名',
`jine` int(11) NOT NULL COMMENT '金额',
`tuihaiyajin` varchar(200) NOT NULL COMMENT '退还压金',
`shidejine` varchar(200) NOT NULL COMMENT '实得金额',
`riqi` date DEFAULT NULL COMMENT '日期',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='出租收入';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chuzushouru`
--
LOCK TABLES `chuzushouru` WRITE;
/*!40000 ALTER TABLE `chuzushouru` DISABLE KEYS */;
INSERT INTO `chuzushouru` VALUES (81,'2023-02-24 08:38:35','出借收入','出借账号1','出借姓名1',1,'退还压金1','实得金额1','2023-02-24'),(82,'2023-02-24 08:38:35','出借收入','出借账号2','出借姓名2',2,'退还压金2','实得金额2','2023-02-24'),(83,'2023-02-24 08:38:35','出借收入','出借账号3','出借姓名3',3,'退还压金3','实得金额3','2023-02-24'),(84,'2023-02-24 08:38:35','出借收入','出借账号4','出借姓名4',4,'退还压金4','实得金额4','2023-02-24'),(85,'2023-02-24 08:38:35','出借收入','出借账号5','出借姓名5',5,'退还压金5','实得金额5','2023-02-24'),(86,'2023-02-24 08:38:35','出借收入','出借账号6','出借姓名6',6,'退还压金6','实得金额6','2023-02-24'),(87,'2023-02-24 08:38:35','出借收入','出借账号7','出借姓名7',7,'退还压金7','实得金额7','2023-02-24'),(88,'2023-02-24 08:38:35','出借收入','出借账号8','出借姓名8',8,'退还压金8','实得金额8','2023-02-24');
/*!40000 ALTER TABLE `chuzushouru` 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 `discusstushuxinxi`
--