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