2024年最新Web项目乐淘（LeTao）数据库设计(1)，如何系统全面性学习前端语言

最后

资料过多，篇幅有限

开源分享：【大厂前端面试题解析+核心总结学习笔记+真实项目实战+最新讲解视频】

自古成功在尝试。不尝试永远都不会成功。勇敢的尝试是成功的一半。

–

DROP TABLE IF EXISTS comment;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE comment (

comment_id bigint NOT NULL AUTO_INCREMENT,

uid bigint NOT NULL,

gid bigint NOT NULL,

text varchar(150) NOT NULL,

time datetime DEFAULT NULL,

PRIMARY KEY (comment_id),

UNIQUE KEY comment_id_UNIQUE (comment_id)

) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

–

– Table structure for table goods

–

DROP TABLE IF EXISTS goods;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE goods (

gid bigint NOT NULL AUTO_INCREMENT,

gname varchar(45) NOT NULL,

description varchar(350) DEFAULT NULL,

area varchar(20) DEFAULT NULL,

price double NOT NULL,

kind varchar(45) DEFAULT NULL,

uid bigint NOT NULL,

time datetime DEFAULT NULL,

PRIMARY KEY (gid),

UNIQUE KEY gid_UNIQUE (gid)

) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

–

– Table structure for table goods_images

–

DROP TABLE IF EXISTS goods_images;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE goods_images (

idgoods_images bigint NOT NULL AUTO_INCREMENT,

gid bigint NOT NULL,

img_url varchar(255) NOT NULL,

PRIMARY KEY (idgoods_images)

) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

–

– Table structure for table order

–

DROP TABLE IF EXISTS order;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE order (

time datetime NOT NULL,

buyer_id bigint NOT NULL,

seller_id bigint NOT NULL,

gid bigint NOT NULL,

PRIMARY KEY (time,buyer_id,seller_id,gid)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

–

– Table structure for table shop_car

–

DROP TABLE IF EXISTS shop_car;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE shop_car (

uid bigint NOT NULL,

gid bigint NOT NULL,

PRIMARY KEY (uid,gid)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

–

– Table structure for table user

–

DROP TABLE IF EXISTS user;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE user (

uid bigint NOT NULL,

pwd varchar(20) NOT NULL,

nickname varchar(20) DEFAULT NULL,

phone varchar(20) DEFAULT NULL,

area varchar(20) DEFAULT NULL,

head_url varchar(200) DEFAULT NULL,

PRIMARY KEY (uid),

UNIQUE KEY uid_UNIQUE (uid)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

– Dump completed on 2020-12-22 21:41:35

最后

整理面试题，不是让大家去只刷面试题，而是熟悉目前实际面试中常见的考察方式和知识点，做到心中有数，也可以用来自查及完善知识体系。

开源分享：【大厂前端面试题解析+核心总结学习笔记+真实项目实战+最新讲解视频】

《前端基础面试题》，《前端校招面试题精编解析大全》，《前端面试题宝典》，《前端面试题：常用算法》

ps://bbs.csdn.net/forums/4304bb5a486d4c3ab8389e65ecb71ac0)**

《前端基础面试题》，《前端校招面试题精编解析大全》，《前端面试题宝典》，《前端面试题：常用算法》

[外链图片转存中…(img-hcZEmSzK-1715717590936)]

[外链图片转存中…(img-FIGOWjmp-1715717590936)]

[外链图片转存中…(img-hxv0b7eL-1715717590937)]