小程序框架：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
--
