首页 最新 热门 推荐

  • 首页
  • 最新
  • 热门
  • 推荐

【最新原创毕设】基于SpringBoot的精准设施农业管理系统+11239(免费领源码)可做计算机毕业设计JAVA、PHP、爬虫、APP、小程序、C#、C++、python、数据可视化、大数据、文案

  • 25-04-24 11:01
  • 4232
  • 10110
blog.csdn.net

摘要

服装购物商城系统小程序,依托Spring Boot框架的强大支持,为用户呈现了一个功能丰富、体验流畅的在线购物平台。该系统不仅涵盖了商品展示、用户注册登录、购物车管理、订单处理、支付集成等核心购物流程,还引入了个性化推荐算法,根据用户的浏览和购买历史,智能推荐相关商品,提升用户购物体验。此外,该系统还集成了物流查询功能,让用户能够实时追踪订单配送状态,确保购物过程的透明与便捷。Spring Boot框架的轻量级特性和快速开发能力,确保了系统的高效运行和稳定性能,为服装电商行业带来了更加高效、便捷的解决方案。

关键词:服装购物商城系统小程序 ;Spring Boot框架;Mysql数据库;

Abstract

The clothing shopping mall system mini program, relying on the powerful support of the Spring Boot framework, presents users with a rich and smooth online shopping platform. The system not only covers core shopping processes such as product display, user registration and login, shopping cart management, order processing, and payment integration, but also introduces personalized recommendation algorithms to intelligently recommend relevant products based on user browsing and purchase history, improving the user's shopping experience. In addition, the system also integrates logistics query function, allowing users to track the delivery status of orders in real time, ensuring transparency and convenience in the shopping process. The lightweight features and rapid development capabilities of the Spring Boot framework ensure the efficient operation and stable performance of the system, bringing more efficient and convenient solutions to the clothing e-commerce industry.

Keywords: clothing shopping mall system mini program; Spring Boot framework; MySQL database;

目录

摘要

Abstract

第1章 引 言

1.1 选题背景及意义

1.2 研究的目标和内容

1.3 论文结构安排

第2章 系统分析

1.1 系统可行性分析

1.1.1 技术可行性分析

1.1.2 经济可行性分析

1.1.3 操作可行性分析

1.2 系统需求分析

1.2.1 功能需求分析

1.2.2 非功能性需求分析

1.3 系统用例分析

1.4 本章小结

第3章 系统设计

1.5 系统架构设计

1.6 系统功能模块设计

1.7 数据库设计

1.7.1 数据库概念结构设计

1.7.2 数据库逻辑结构设计

第4章 关键模块的设计与实现

1.8 登录模块

1.9 注册模块

1.10 订单配送模块

1.11 商品信息模块

1.12 新闻资讯管理模块

1.13 系统用户界面

1.14 订单列表界面

第5章 系统测试

1.15 测试的目的

1.16 系统部分测试

1.17 系统测试结果

第6章 结论

参考文献

致谢

第1章 引 言

1.1选题背景及意义

在当前全球电子商务迅猛发展的时代背景下,消费者对于购物体验的要求日益提高,尤其是在服装购物领域,个性化和便捷性成为了消费者的核心诉求。因此,研究基于Spring Boot框架的服装购物商城系统小程序显得尤为重要。这样的系统不仅能够充分利用Spring Boot框架的轻量级、快速开发以及内置多项功能优势,还能够结合先进的个性化推荐算法和物流查询技术,为用户提供更加精准、个性化的商品推荐和实时的物流信息。

通过研究这样的系统,我们不仅可以深入理解用户的购物行为和需求,还能优化购物流程,提升用户的购物体验和满意度。同时,该系统还能帮助服装电商企业提高运营效率,降低成本,从而在激烈的市场竞争中脱颖而出。因此,这项研究不仅具有理论意义,更具有重要的实践价值,对于推动服装电商行业的持续健康发展具有重要意义。

1.2研究的目标和内容

研究的目标是精心设计和开发一个基于Spring Boot框架的服装购物商城系统小程序,该系统将致力于提供卓越的用户体验、高效稳定的系统性能以及个性化的购物服务。我们需要进行系统的整体架构设计,确保系统的稳定性、可扩展性和可维护性。通过合理的模块划分和组件设计,实现系统功能的清晰划分和高效协作。

关键功能的实现与优化是研究的重点。这包括商品信息的展示与搜索、用户注册与登录、购物车管理、订单处理、支付集成以及物流查询等核心功能的实现。同时,我们还将关注性能优化,通过缓存策略、数据库优化、异步处理等技术手段,提高系统的响应速度和吞吐量。

用户界面的设计与开发也是研究的重要内容。我们将注重界面的简洁、美观和易用性,通过合理的布局和交互设计,提供用户友好的购物体验。同时,我们还将考虑不同用户的个性化需求,如多语言支持、个性化推荐等,以满足不同用户群体的需求。

系统性能的测试与优化也是研究的关键环节。我们将通过模拟真实用户场景和大量数据测试,对系统的稳定性、响应时间、并发处理能力等进行全面评估。根据测试结果,我们将对系统进行针对性的优化,确保系统能够在高并发、大数据量等复杂场景下保持高效稳定的运行。

综上所述,研究的目标和内容旨在打造一个功能完善、性能优越、用户体验出色的服装购物商城系统小程序,以推动服装电商行业的创新发展,满足用户的多样化需求。

1.3论文结构安排

论文主要架构、章节安排如下所示:

第一章:引言,介绍研究背景和动机,概述研究目的和意义,概括国内外研究现状,并提供论文结构概述。

第二章:系统需求分析,通过用户需求分析和功能需求分析,明确用户对系统的需求和系统应具备的功能。

第三章:系统设计,设计系统架构,包括选择合适的架构模式和数据库设计,以及各个模块的详细设计。

第四章:系统实现,选择合适的技术工具和框架,逐一实现各个模块,建立数据库连接并实现前端界面开发。

第五章:系统测试,进行单元测试、集成测试和整体系统测试,确保系统功能的正确性、协调性和稳定性。

第六章,总结,总结研究工作的主要内容和成果,评价系统的优点和不足,并提出改进和进一步研究的建议,强调研究的意义和影响。

第2章 系统分析

2.1系统可行性分析

2.1.1技术可行性分析

服装购物商城系统小程序采用了Spring Boot框架,开发了功能完备、使用简单的前端应用程序,并建立、维护了一个数据完整、安全、稳定性强的后台数据库系统。

系统使用Spring Boot框架和Mysql数据库作为设计工具,可简单易行地学习操作。用户角色之间的相结合开发一套服装购物商城系统小程序是值得尝试的,数据完整性和许多品质为数据的功能分配和管理提供了依据。它也是数据库安全平台的重要组成部分,是提高和增强数据安全性的重要手段。此外,为了提供更平滑,更智能和更有效的基本控制方法,定义了同时构建对安全计算环境的支持所需的步骤,并帮助维护安全性。因为在这两种开发工具中,功能强大且免费且界面良好,所以服装购物商城系统小程序在技术方面是可行的。

2.1.2经济可行性分析

服装购物商城系统小程序管理的开发是由开发者自己开发,不需要购买其他软件或者端口之类的,而且在服装购物商城系统小程序管理的开发之前所做的市场调研及其他的服装购物商城系统小程序,都是没有任何费用的,通过开发者自己的努力,所有的工作的都是自己亲力亲为,在碰到自己比较难以解决的问题,大多是通过同学和指导老师的帮助进行相关信息的解决,所以对于服装购物商城系统小程序的开发在经济上是完全可行的,没有任何费用支出的。

使用Spring Boot框架是比较成熟的技术,所以服装购物商城系统小程序的开发在经济上是没有问题的。

2.1.3操作可行性分析

可操作性主要是对服装购物商城系统小程序系统设计完成后,用户的使用体验度,对于管理员可以通过系统随时管理相关的数据信息,并且对于管理员、普通用户两个用户角色,都可以简单明了的进入到自己的系统界面,通过界面导航菜单可以简单明了地操作功能模块,方便用户信息需求和订单配送管理数据信息,对于系统的操作,不需要专业人员都可以直接进行功能模块的操作管理,所以在系统的可操作性是完全可以的。本系统的操作使用的也是界面窗口进行登录,所以操作人员只要会简单的电脑操作就完全可以的。

2.2系统需求分析

2.2.1功能需求分析

服装购物商城系统小程序我划分为了用户管理模块和管理员模块这两大部分。

普通用户功能:

(1)注册登录:服装购物商城系统小程序前台注册后的用户是可以通过自己的账户名和密码进行登录的,当用户输入完整的自己的账户名和密码后,点击“登录”按钮后,将会首先验证输入的有没有空数据,再次验证输入的账户名+密码和数据库中当前保存的用户信息是否一致,只有在一致后将会登录成功并自动跳转到服装购物商城系统小程序的首页中;否则将会提示相应错误信息。

(2)新闻资讯:用户可以查看服装行业的新闻、资讯、时尚潮流等内容,并进行点赞收藏和评论等操作。

(3)购物车:当用户点击下方导航栏“购物车”这一菜单按钮,会显示所有的购物车详情。

(4)商品信息:当用户点击下方导航栏“商品信息:”这一菜单按钮,会显示管理员在后台发布的所有的商品信息,可以查看详情,进行添加购物车、购买、收藏、评论等。

(5)我的模块:普通用户在前台点击“我的”可以对用户的基本信息、收货地址、收藏、订单、购物车、订单配送等信息进行管理。

管理员端:

(1)系统用户:包括用户账号的添加、编辑和删除操作,可以查看用户信息、修改用户权限、冻结或解冻用户账号等。

(2)资源管理:点击“资源管理”这个菜单,可以查看到所有新闻资讯和新闻分类详情,可以进行增删改查等操作。

(3)系统管理:当管理员点击“系统管理”时,可查看轮播图管理,如需添加新的轮播图,点击右侧“新增”按钮,上传图片,输入标题,点击“确认”按钮进行添加。

(4)商城管理:点击“商城管理”这个菜单,可以查看到所有商品信息、分类列表、订单列表、订单配送等详情,可以进行增删改查等操作。

(5)个人信息:管理员点击“个人信息”按钮,可以对个人的头像、昵称、手机号码等信息进行更新。

(6)修改密码:管理员点击“修改密码”按钮,可以对登录密码进行更改,首先输入原密码,然后再输入新密码和确认密码,当原密码正确,输入两次新密码一致,则修改成功,否则给出错误提示信息。

2.2.2非功能性需求分析

 非功能性分析旨在评估服装购物商城系统小程序的非功能需求和性能要求。通过对性能、可靠性、安全性、可用性和扩展性等方面进行评估,确保平台能够满足用户和系统运行的要求。具体如下3-1表格中:

表2.1  服装购物商城系统小程序非功能需求表

非功能性要求

说明

性能

评估响应时间、并发用户数、吞吐量等指标,以确保平台稳定高效地运行。

可靠性

评估系统的稳定性、容错能力和数据完整性,保障系统在故障情况下正常运行。

安全性

评估用户身份认证、数据加密和访问控制等,保护用户信息和交易的安全。

可用性

评估系统的稳定性、故障处理能力和用户界面友好性,提供良好的用户体验。

扩展性

评估系统的可扩展性和灵活性,以便根据需求进行功能扩展和升级。

2.3系统用例分析

系统用例分析是对服装购物商城系统小程序中各个功能模块的用户需求和行为进行分析,以识别和描述不同的用户用例。通过系统用例分析,可以深入了解用户在平台上的操作流程,为系统设计和开发提供指导,并确保平台能够满足用户的需求和期望。

服装购物商城系统小程序中用户角色用例图如图2.1所示:

图2.1用户角色用例图

 服装购物商城系统小程序中管理员用例图如图2.2所示:

图2.2 管理员用例图

2.4本章小结

在系统分析的章节中,我们通过可行性分析、功能分析和系统用例分析等方法,全面评估了服装购物商城系统小程序的可行性、功能需求以及用户需求。这些分析为后续的系统设计和开发提供了重要的指导和决策依据,确保平台能够满足用户需求,并实现预期目标和效益。

第3章 系统设计

服装购物商城系统小程序总体设计包括系统架构、数据库设计、用户界面设计等方面。通过三层架构模式,确保系统的可靠性和可扩展性。设计规范化的数据库结构,以存储和管理商品信息、用户数据等。同时,注重用户界面的友好性和易用性,提供便捷的功能操作和良好的用户体验。总体设计的目标是实现一个稳定、安全、高效的服装购物商城系统小程序,满足用户的需求。

3.1系统架构设计

在系统架构设计中,我们将确定系统的整体结构和组件之间的关系。这包括选择适当的架构风格,划分系统的层次结构,并定义各个模块的职责和交互方式。架构图如下图所示。

图3-1服装购物商城系统小程序架构设计图

表现层(Presentation Layer):负责与用户进行交互,将系统的功能和数据以易于理解和操作的方式展示给用户。通常包括用户界面、页面设计和用户输入验证等。

业务逻辑层(Business Logic Layer):处理系统的核心业务逻辑,包括对用户请求的处理、业务规则的执行以及数据的处理和转换。它独立于表现层和数据层,实现了业务逻辑的封装和复用。

数据层(Data Layer):负责数据的存储、访问和管理,包括数据库和持久化机制。数据层提供了对数据的增删改查操作,并与业务逻辑层进行交互,使系统能够有效地存储和检索数据。

这三个层次相互独立,通过明确的接口和协议进行通信,实现了系统的模块化和可扩展性。表现层负责将用户的请求传递给业务逻辑层,业务逻辑层处理请求并返回结果,最后数据层负责与数据库交互并提供数据支持。这种分层架构有助于实现系统的可维护性、灵活性和可测试性。

3.2系统功能模块设计

通过整体功能模块设计,我们将根据需求分析的结果,将系统的功能划分为不同的模块。每个模块负责实现特定的功能,并与其他模块进行协作。我们将详细定义每个模块的输入、输出、处理逻辑和相互依赖关系。具体的功能模块图如图3.1所示。

图3.1  服装购物商城系统小程序功能模块图

3.3数据库设计

数据库设计是系统开发中至关重要的一环,它涉及到数据的组织、存储和管理。在数据库设计中,我们将根据系统的需求设计数据库的概念结构和逻辑结构,包括定义实体、属性、关系和约束等。

3.3.1数据库概念结构设计

数据库概念结构设计主要涉及数据库的实体和实体之间的关系。通过实体-关系模型或者其他适当的模型,我们将定义系统中涉及的各个实体以及它们之间的联系。下面是整个服装购物商城系统小程序的总E-R关系图。

图3.2  服装购物商城系统小程序总E-R关系图

3.3.2数据库逻辑结构设计

数据库逻辑结构设计则是在概念结构的基础上,进行具体的数据库表设计。我们将定义每个表的结构、字段和约束,并建立表与表之间的关系。具体如下。

表access_token (登陆访问时长)

编号

名称

数据类型

长度

小数位

允许空值

主键

默认值

说明

1

token_id

int

10

0

N

Y

临时访问牌ID

2

token

varchar

64

0

Y

N

临时访问牌

3

info

text

65535

0

Y

N

4

maxage

int

10

0

N

N

2

最大寿命:默认2小时

5

create_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

创建时间:

6

update_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

更新时间:

7

user_id

int

10

0

N

N

0

用户编号:

表address (收货地址:)

编号

名称

数据类型

长度

小数位

允许空值

主键

默认值

说明

1

address_id

int

10

0

N

Y

收货地址:

2

name

varchar

32

0

Y

N

姓名:

3

phone

varchar

13

0

Y

N

手机:

4

postcode

varchar

8

0

Y

N

邮编:

5

address

varchar

255

0

N

N

地址:

6

user_id

mediumint

8

0

N

N

用户ID:[0,8388607]用户获取其他与用户相关的数据

7

create_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

创建时间:

8

update_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

更新时间:

9

default

bit

1

0

N

N

0

默认判断

表article (文章:用于内容管理系统的文章)

编号

名称

数据类型

长度

小数位

允许空值

主键

默认值

说明

1

article_id

mediumint

8

0

N

Y

文章id:[0,8388607]

2

title

varchar

125

0

N

Y

标题:[0,125]用于文章和html的title标签中

3

type

varchar

64

0

N

N

0

文章分类:[0,1000]用来搜索指定类型的文章

4

hits

int

10

0

N

N

0

点击数:[0,1000000000]访问这篇文章的人次

5

praise_len

int

10

0

N

N

0

点赞数

6

create_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

创建时间:

7

update_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

更新时间:

8

source

varchar

255

0

Y

N

来源:[0,255]文章的出处

9

url

varchar

255

0

Y

N

来源地址:[0,255]用于跳转到发布该文章的网站

10

tag

varchar

255

0

Y

N

标签:[0,255]用于标注文章所属相关内容,多个标签用空格隔开

11

content

longtext

2147483647

0

Y

N

正文:文章的主体内容

12

img

varchar

255

0

Y

N

封面图

13

description

text

65535

0

Y

N

文章描述

表article_type (文章分类)

编号

名称

数据类型

长度

小数位

允许空值

主键

默认值

说明

1

type_id

smallint

5

0

N

Y

分类ID:[0,10000]

2

display

smallint

5

0

N

N

100

显示顺序:[0,1000]决定分类显示的先后顺序

3

name

varchar

16

0

N

N

分类名称:[2,16]

4

father_id

smallint

5

0

N

N

0

上级分类ID:[0,32767]

5

description

varchar

255

0

Y

N

描述:[0,255]描述该分类的作用

6

icon

text

65535

0

Y

N

分类图标:

7

url

varchar

255

0

Y

N

外链地址:[0,255]如果该分类是跳转到其他网站的情况下,就在该URL上设置

8

create_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

创建时间:

9

update_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

更新时间:

表auth (用户权限管理)

编号

名称

数据类型

长度

小数位

允许空值

主键

默认值

说明

1

auth_id

int

10

0

N

Y

授权ID:

2

user_group

varchar

64

0

Y

N

用户组:

3

mod_name

varchar

64

0

Y

N

模块名:

4

table_name

varchar

64

0

Y

N

表名:

5

page_title

varchar

255

0

Y

N

页面标题:

6

path

varchar

255

0

Y

N

路由路径:

7

position

varchar

32

0

Y

N

位置:

8

mode

varchar

32

0

N

N

_blank

跳转方式:

9

add

tinyint

3

0

N

N

1

是否可增加:

10

del

tinyint

3

0

N

N

1

是否可删除:

11

set

tinyint

3

0

N

N

1

是否可修改:

12

get

tinyint

3

0

N

N

1

是否可查看:

13

field_add

text

65535

0

Y

N

添加字段:

14

field_set

text

65535

0

Y

N

修改字段:

15

field_get

text

65535

0

Y

N

查询字段:

16

table_nav_name

varchar

500

0

Y

N

跨表导航名称:

17

table_nav

varchar

500

0

Y

N

跨表导航:

18

option

text

65535

0

Y

N

配置:

19

create_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

创建时间:

20

update_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

更新时间:

表cart (购物车)

编号

名称

数据类型

长度

小数位

允许空值

主键

默认值

说明

1

cart_id

int

10

0

N

Y

购物车ID:

2

title

varchar

64

0

Y

N

标题:

3

img

varchar

255

0

N

N

0

图片:

4

user_id

int

10

0

N

N

0

用户ID:

5

create_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

创建时间:

6

update_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

更新时间:

7

state

int

10

0

N

N

0

状态:使用中,已失效

8

price

double

9

2

N

N

0.00

单价:

9

price_ago

double

9

2

N

N

0.00

原价:

10

price_count

double

11

2

N

N

0.00

总价:

11

num

int

10

0

N

N

1

数量:

12

goods_id

mediumint

8

0

N

N

商品id:[0,8388607]

13

type

varchar

64

0

N

N

未分类

商品分类:

14

description

varchar

255

0

Y

N

描述:[0,255]用于产品规格描述

表collect (收藏)

编号

名称

数据类型

长度

小数位

允许空值

主键

默认值

说明

1

collect_id

int

10

0

N

Y

收藏ID:

2

user_id

int

10

0

N

N

0

收藏人ID:

3

source_table

varchar

255

0

Y

N

来源表:

4

source_field

varchar

255

0

Y

N

来源字段:

5

source_id

int

10

0

N

N

0

来源ID:

6

title

varchar

255

0

Y

N

标题:

7

img

varchar

255

0

Y

N

封面:

8

create_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

创建时间:

9

update_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

更新时间:

表comment (评论)

编号

名称

数据类型

长度

小数位

允许空值

主键

默认值

说明

1

comment_id

int

10

0

N

Y

评论ID:

2

user_id

int

10

0

N

N

0

评论人ID:

3

reply_to_id

int

10

0

N

N

0

回复评论ID:空为0

4

content

longtext

2147483647

0

Y

N

内容:

5

nickname

varchar

255

0

Y

N

昵称:

6

avatar

varchar

255

0

Y

N

头像地址:[0,255]

7

create_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

创建时间:

8

update_time

timestamp

19

0

N

N

CURRENT_TIMESTAMP

更新时间:

9

source_table

varchar

255

0

Y

N

来源表:

10

source_field

varchar

255

0

Y

N

来源字段:

11

source_id

int

10

0

N

N

0

来源ID:

表goods (商品信息)

编号

名称

数据类型

长度

小数位

允许空值

主键

默认值

说明

1

goods_id

mediumint

8

0

N

Y

产品id:[0,8388607]

2

title

varchar

125

0

Y

N

标题:[0,125]用于产品和html的标签中</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>img</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>封面图:用于显示于产品列表页</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>description</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>描述:[0,255]用于产品规格描述</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>price_ago</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>double</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0.00</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>原价:[1]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>price</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>double</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0.00</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>卖价:[1]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>sales</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>销量:[0,1000000000]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>inventory</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品库存</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>9</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>type</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品分类:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>hits</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>点击量:[0,1000000000]访问这篇产品的人次</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>11</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>content</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>longtext</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2147483647</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>正文:产品的主体内容</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>12</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>img_1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>主图1:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>13</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>img_2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>主图2:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>14</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>img_3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>主图3:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>15</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>img_4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>主图4:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>img_5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>主图5:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>17</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>18</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>update_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>更新时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>customize_field</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>自定义字段</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>20</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_table</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源表:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>21</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_field</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源字段:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>22</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源ID:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>23</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>user_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>添加人</p> </td></tr></tbody></table></div> <p><a name="_goods_type"></a>表goods_type (商品类型)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>type_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品分类ID:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>father_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>smallint</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>上级分类ID:[0,32767]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>name</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品名称:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>desc</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>描述:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>icon</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>图标:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_table</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源表:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_field</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源字段:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>9</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>update_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>更新时间:</p> </td></tr></tbody></table></div> <p><a name="_hits"></a>表hits (用户点击)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>hits_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>点赞ID:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>user_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>点赞人:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>update_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>更新时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_table</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源表:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_field</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源字段:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源ID:</p> </td></tr></tbody></table></div> <p><a name="_logistics_delivery"></a>表logistics_delivery (物流配送)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>logistics_delivery_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>物流配送ID</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>order_number</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>订单号</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>product_name</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品名称</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>purchase_quantity</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>购买数量</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>total_transaction_amount</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>double</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>11</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0.00</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>交易总额</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>the_date_of_issuance</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>date</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>发货日期</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>delivery_number</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>30</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>配送订单</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>ordinary_users</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>普通用户</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>9</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>shipping_address</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>收货地址</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>delivery_status</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>配送状态</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>11</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>signing_status</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>签收状态</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>12</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>recommend</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>智能推荐</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>13</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>contact_name</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>联系人名字</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>14</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>merchant_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商家id</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>15</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>datetime</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>update_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>更新时间</p> </td></tr></tbody></table></div> <p><a name="_notice"></a>表notice (公告)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>notice_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>mediumint</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>公告id:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>title</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>125</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>标题:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>content</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>longtext</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2147483647</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>正文:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>update_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>更新时间:</p> </td></tr></tbody></table></div> <p><a name="_order"></a>表order (订单)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>order_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>订单ID:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>order_number</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>订单号:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>goods_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>mediumint</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品id:[0,8388607]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>title</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品标题:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>img</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品图片:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>price</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>double</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0.00</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>价格:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>price_ago</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>double</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0.00</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>原价:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>num</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>数量:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>9</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>price_count</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>double</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0.00</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>总价:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>norms</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>规格:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>11</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>type</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>未分类</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品分类:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>12</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>contact_name</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>32</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>联系人姓名:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>13</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>contact_email</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>125</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>联系人邮箱:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>14</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>contact_phone</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>11</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>联系人手机:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>15</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>contact_address</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>收件地址:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>postal_code</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>9</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>邮政编码:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>17</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>user_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>买家ID:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>18</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>merchant_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>mediumint</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商家ID:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>20</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>update_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>更新时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>21</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>description</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>描述:[0,255]用于产品规格描述</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>22</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>state</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>待付款</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>订单状态:待付款,待发货,待签收,已签收,待退款,已退款,已拒绝,已完成</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>23</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>remark</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>订单备注</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>24</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>delivery_state</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>未配送</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>发货状态:未配送,已配送</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>25</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>vip_discount</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>double</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>11</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0.00</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>折扣</p> </td></tr></tbody></table></div> <p><a name="_praise"></a>表praise (点赞)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>praise_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>点赞ID:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>user_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>点赞人:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>update_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>更新时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_table</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源表:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_field</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源字段:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源ID:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>status</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>bit</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>点赞状态:1为点赞,0已取消</p> </td></tr></tbody></table></div> <p><a name="_product_information"></a>表product_information (商品信息)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>product_information_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品信息ID</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>purchase_notice</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>购买须知</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_title</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>125</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>标题:[0,125]用于产品html的标签中</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_img</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>封面图:用于显示于产品列表页</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_description</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>描述:[0,255]用于产品规格描述</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_price_ago</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>double</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0.00</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>原价:[1]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_price</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>double</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0.00</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>卖价:[1]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_inventory</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品库存</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>9</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_type</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>未分类</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>商品分类:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_content</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>longtext</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2147483647</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>正文:产品的主体内容</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>11</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_img_1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>主图1:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>12</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_img_2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>主图2:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>13</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_img_3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>主图3:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>14</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_img_4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>主图4:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>15</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>cart_img_5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>text</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>65535</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>主图5:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>datetime</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>17</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>update_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>更新时间</p> </td></tr></tbody></table></div> <p><a name="_regular_users"></a>表regular_users (普通用户)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>regular_users_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>普通用户ID</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>user_name</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>用户姓名</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>user_gender</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>用户性别</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>contact_phone_number</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>联系电话</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>examine_state</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>已通过</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>审核状态</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>user_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>用户ID</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>datetime</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>update_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>更新时间</p> </td></tr></tbody></table></div> <p><a name="_slides"></a>表slides (轮播图)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>slides_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>轮播图ID:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>title</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>标题:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>content</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>内容:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>url</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>链接:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>img</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>轮播图:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>hits</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>点击量:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>update_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>更新时间:</p> </td></tr></tbody></table></div> <p><a name="_upload"></a>表upload (文件上传)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>upload_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>上传ID</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>name</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>文件名</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>path</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>访问路径</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>file</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>文件路径</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>display</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>显示顺序</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>father_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>父级ID</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>dir</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>文件夹</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>type</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>32</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>文件类型</p> </td></tr></tbody></table></div> <p><a name="_user"></a>表user (用户账户:用于保存用户登录信息)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>user_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>mediumint</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>用户ID:[0,8388607]用户获取其他与用户相关的数据</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>state</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>smallint</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>账户状态:[0,10](1可用|2异常|3已冻结|4已注销)</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>user_group</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>32</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>所在用户组:[0,32767]决定用户身份和权限</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>login_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>上次登录时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>phone</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>11</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>手机号码:[0,11]用户的手机号码,用于找回密码时或登录时</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>phone_state</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>smallint</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>手机认证:[0,1](0未认证|1审核中|2已认证)</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>username</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>用户名:[0,16]用户登录时所用的账户名称</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>nickname</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>昵称:[0,16]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>9</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>password</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>密码:[0,32]用户登录所需的密码,由6-16位数字或英文组成</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>email</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>64</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>邮箱:[0,64]用户的邮箱,用于找回密码时或登录时</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>11</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>email_state</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>smallint</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>邮箱认证:[0,1](0未认证|1审核中|2已认证)</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>12</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>avatar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>头像地址:[0,255]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>13</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>open_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>针对获取用户信息字段</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>14</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>15</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>vip_level</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>会员等级</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>vip_discount</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>double</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>11</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0.00</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>会员折扣</p> </td></tr></tbody></table></div> <p>表user_group (用户组:用于用户前端身份和鉴权)</p> <div class="table-box"><table align="center" border="1" cellspacing="0" style="width:520.0000pt"><tbody><tr><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6000pt"> <p>编号</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>名称</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>数据类型</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>长度</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>小数位</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>允许空值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>主键</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:57.6500pt"> <p>默认值</p> </td><td style="background-color:#e7e6e6; height:12.5000pt; width:58.8500pt"> <p>说明</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>1</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>group_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>mediumint</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>用户组ID:[0,8388607]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>2</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>display</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>smallint</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>100</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>显示顺序:[0,1000]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>3</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>name</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>16</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>名称:[0,16]</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>4</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>description</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>描述:[0,255]描述该用户组的特点或权限范围</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_table</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源表:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>6</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_field</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>varchar</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>255</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p></p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源字段:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>7</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>source_id</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>int</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>来源ID:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>8</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>register</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>smallint</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>5</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>Y</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>注册位置:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>9</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>create_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>创建时间:</p> </td></tr><tr><td style="height:17.9500pt; vertical-align:top; width:57.6000pt"> <p>10</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>update_time</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>timestamp</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>19</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>0</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>N</p> </td><td style="height:17.9500pt; vertical-align:top; width:57.6500pt"> <p>CURRENT_TIMESTAMP</p> </td><td style="height:17.9500pt; vertical-align:top; width:58.8500pt"> <p>更新时间:</p> </td></tr></tbody></table></div> <h2 style="margin-left:0pt; text-align:center"><a name="t23"></a><a name="_Toc30169"></a><strong><strong><a name="_Toc166697145">第</a></strong></strong><strong><strong>4</strong></strong><strong><strong>章 关键模块的设计与实现</strong></strong></h2> <p style="margin-left:.0001pt; margin-right:0; text-align:justify"><a name="_Toc153315619"></a><a name="_Toc160056409"></a><a name="_Toc159616281"></a><a name="_Toc160743823"></a><a name="_Toc153315580"></a><a name="_Toc159755865"></a><a name="_Toc160131128"></a><a name="_Toc152714685"></a><a name="_Toc159615907"></a><a name="_Toc67526229"></a></p> <h3 style="margin-left:21pt; text-align:left"><a name="t24"></a><a name="_Toc7640"></a><span style="color:#6795b5">4.1</span>登录模块</h3> <p style="text-align:left">用户登录界面用于已注册用户进行账号登录,用户需要输入正确的用户名和密码才能成功登录系统。登录界面应对用户的输入进行验证,并提供密码找回或重新注册的选项。界面如下图所示。其主界面展示如下图4.1所示。</p> <p class="img-center"><img alt="" height="1497" src="https://img1.iyenn.com/thumb02/c4a7c4f8a79ec45d/176217454218957453035.jpeg" width="1009"></p> <p style="margin-left:.0001pt; margin-right:0; text-align:center">图4.1 登录界面图</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">登录代码如下:</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify"><a name="_Toc116663095"></a> /**</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">     * 登录</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">     * @param data</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">     * @param httpServletRequest</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">     * @return</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">     */</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">    @PostMapping("login")</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">    public Map<String, Object> login(@RequestBody Map<String, String> data, HttpServletRequest httpServletRequest) {</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        log.info("[执行登录接口]");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        String username = data.get("username");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        String email = data.get("email");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        String phone = data.get("phone");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        String password = data.get("password");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify"></p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        List resultList = null;</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        Map<String, String> map = new HashMap<>();</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        if(username != null && "".equals(username) == false){</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            map.put("username", username);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            resultList = service.selectBaseList(service.select(map, new HashMap<>()));</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        else if(email != null && "".equals(email) == false){</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            map.put("email", email);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            resultList = service.selectBaseList(service.select(map, new HashMap<>()));</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        else if(phone != null && "".equals(phone) == false){</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            map.put("phone", phone);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            resultList = service.selectBaseList(service.select(map, new HashMap<>()));</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        }else{</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            return error(30000, "账号或密码不能为空");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        if (resultList == null || password == null) {</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            return error(30000, "账号或密码不能为空");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        //判断是否有这个用户</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        if (resultList.size()<=0){</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            return error(30000,"用户不存在");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        User byUsername = (User) resultList.get(0);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        Map<String, String> groupMap = new HashMap<>();</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        groupMap.put("name",byUsername.getUserGroup());</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        List groupList = userGroupService.selectBaseList(userGroupService.select(groupMap, new HashMap<>()));</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        if (groupList.size()<1){</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            return error(30000,"用户组不存在");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        UserGroup userGroup = (UserGroup) groupList.get(0);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        //查询用户审核状态</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        if (!StringUtils.isEmpty(userGroup.getSourceTable())){</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            String res = service.selectExamineState(userGroup.getSourceTable(),byUsername.getUserId());</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            if (res==null){</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">                return error(30000,"用户不存在");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            if (!res.equals("已通过")){</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">                return error(30000,"该用户审核未通过");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        //查询用户状态</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        if (byUsername.getState()!=1){</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            return error(30000,"用户非可用状态,不能登录");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        String md5password = service.encryption(password);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        if (byUsername.getPassword().equals(md5password)) {</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            // 存储Token到数据库</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            AccessToken accessToken = new AccessToken();</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            accessToken.setToken(UUID.randomUUID().toString().replaceAll("-", ""));</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            accessToken.setUser_id(byUsername.getUserId());</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            Duration duration = Duration.ofSeconds(7200L);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            redisTemplate.opsForValue().set(accessToken.getToken(), accessToken,duration);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            // 返回用户信息</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            JSONObject user = JSONObject.parseObject(JSONObject.toJSONString(byUsername));</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            user.put("token", accessToken.getToken());</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            JSONObject ret = new JSONObject();</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            ret.put("obj",user);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            return success(ret);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        } else {</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            return error(30000, "账号或密码不正确");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">    }</p> <h3 style="margin-left:21pt; text-align:left"><a name="t25"></a><a name="_Toc166697147"></a><span style="color:#6795b5">4.2</span>注册模块</h3> <p style="text-align:left">用户注册界面用于新用户进行账号注册,用户需要填写必要的个人信息并选择合适的用户名和密码。注册界面应该进行输入验证和数据格式检查,确保用户提供有效的信息。界面如下图所示。其主界面展示如下图4.2所示。</p> <p class="img-center"><img alt="" height="1508" src="https://img1.iyenn.com/thumb02/c4a7c4f8a79ec45d/942817454218952845.jpeg" width="1008"></p> <p style="margin-left:.0001pt; margin-right:0; text-align:center">图4.2 注册界面图</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">注册代码如下:</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  /**</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">     * 注册</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">     * @param user</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">     * @return</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">     */</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">    @PostMapping("register")</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">    public Map<String, Object> signUp(@RequestBody User user) {</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        // 查询用户</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        Map<String, String> query = new HashMap<>();</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        Map<String,Object> map = JSON.parseObject(JSON.toJSONString(user));</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        query.put("username",user.getUsername());</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        List list = service.selectBaseList(service.select(query, new HashMap<>()));</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        if (list.size()>0){</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">            return error(30000, "用户已存在");</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        }</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        map.put("password",service.encryption(String.valueOf(map.get("password"))));</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        service.insert(map);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">        return success(1);</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">}     </p> <h3 style="margin-left:21pt; text-align:left"><a name="t26"></a><a name="_Toc17423"></a><span style="color:#6795b5">4.3</span>订单配送模块</h3> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">订单配送:当用户点击下方导航栏“订单配送”这一菜单按钮,会显示相关详情,界面如下图所示。</p> <p class="img-center"><img alt="" height="1500" src="https://img1.iyenn.com/thumb02/c4a7c4f8a79ec45d/63031745421895458252.jpeg" width="1009"></p> <p style="margin-left:.0001pt; margin-right:0; text-align:center">图4.3 订单配送查看界面图</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">订单配送管理:管理员点击“订单配送”这个菜单,可以查看到所有订单配送详情,可以进行<span style="color:#000000">增删改查等</span>操作。界面如下图所示。</p> <img alt="" height="1296" src="https://img1.iyenn.com/thumb02/c4a7c4f8a79ec45d/8743174542189558174.jpeg" width="2877"> <p style="margin-left:.0001pt; margin-right:0; text-align:center">图4.4 订单配送添加界面图</p> <h3 style="margin-left:21pt; text-align:left"><a name="t27"></a><a name="_Toc166697149"></a><span style="color:#6795b5">4.4</span>商品信息模块</h3> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">商品信息:当用户点击下方导航栏“商品信息:”这一菜单按钮,会显示管理员在后台发布的所有的商品信息,可以查看详情,进行添加购物车、购买、收藏、评论等。界面如下图所示。</p> <p class="img-center"><img alt="" height="1494" src="https://img1.iyenn.com/thumb02/c4a7c4f8a79ec45d/481317454218953593.jpeg" width="1005"></p> <p style="margin-left:.0001pt; margin-right:0; text-align:center">图4.5 商品信息查看界面图</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">商品信息管理:可以查看到所有商品信息详情,进行查询,添加、删除等操作。界面如下图所示。</p> <img alt="" height="1304" src="https://img1.iyenn.com/thumb02/c4a7c4f8a79ec45d/88261745421895453960.jpeg" width="2875"> <p style="text-align:center">图4.6商品信息管理界面图</p> <h3 style="margin-left:21pt; text-align:left"><a name="t28"></a><a name="_Toc166697150"></a><span style="color:#6795b5">4.5</span>新闻资讯管理模块</h3> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">新闻资讯:点击“新闻资讯”这个菜单,可以查看到所有新闻资讯信息详情,界面如下图所示。</p> <img alt="" height="1504" src="https://img1.iyenn.com/thumb02/c4a7c4f8a79ec45d/239517454218967458567.jpeg" width="1010"> <p class="img-center"><img alt="" height="725" src="https://img1.iyenn.com/thumb02/c4a7c4f8a79ec45d/747917454218964830.jpeg" width="527"></p> <p style="margin-left:.0001pt; margin-right:0; text-align:center">图4.7 新闻资讯界面图</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">资源管理:管理员可以查看和管理新闻资讯和新闻分类详情,进行查询,添加、删除等操作,界面如下图所示。</p> <img alt="" height="1304" src="https://img1.iyenn.com/thumb02/c4a7c4f8a79ec45d/968717454218967459920.jpeg" width="2877"> <p style="margin-left:.0001pt; margin-right:0; text-align:center">图4.8 资源管理界面图</p> <h3 style="margin-left:21pt; text-align:left"><a name="t29"></a><a name="_Toc14422"></a><span style="color:#6795b5">4.6</span>系统用户界面</h3> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">系统用户:包括用户账号的添加、编辑和删除操作,可以查看用户信息、修改用户权限、冻结或解冻用户账号等。界面如下图所示。</p> <img alt="" height="1302" src="https://img1.iyenn.com/thumb02/c4a7c4f8a79ec45d/270917454218967457120.jpeg" width="2879"> <p style="margin-left:.0001pt; margin-right:0; text-align:center">图5.9系统用户界面图</p> <h3 style="margin-left:21pt; text-align:left"><a name="t30"></a><a name="_Toc166697152"></a><span style="color:#6795b5">4.7</span>订单列表界面</h3> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">订单列表:可以查看到订单列表详情,进行查询,添加、删除等操作,界面如下图所示。</p> <img alt="" height="1301" src="https://img1.iyenn.com/thumb02/c4a7c4f8a79ec45d/5213174542189657156.jpeg" width="2880"> <p style="margin-left:.0001pt; margin-right:0; text-align:center">图5.10订单列表界面图</p> <h2 style="margin-left:0.0001pt; margin-right:0px; text-align:center"><a name="t31"></a><strong><strong><a name="_Toc9001">第5章 系统测试</a></strong></strong></h2> <p><a name="_Toc160131136"></a><a name="_Toc160743831"></a><a name="_Toc159616289"></a><a name="_Toc159615915"></a><a name="_Toc152714695"></a><a name="_Toc159755873"></a><a name="_Toc153315589"></a><a name="_Toc153315628"></a><a name="_Toc160056417"></a></p> <h3 style="margin-left:21.0000pt; text-align:left"><a name="t32"></a><a name="_Toc4792"></a><span style="color:#000000"><a name="_Toc166697154">5.1</a></span>测试的目的<a name="_Hlk56761370"></a></h3> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试目的是为了验证系统的功能、性能和稳定性,以确保系统在实际应用中能够达到预期的要求。通过测试,可以发现潜在的问题和缺陷,并及时进行修复和改进。测试还可以评估系统的可靠性、安全性和用户体验,以提供一个高质量和可信赖的产品。此外,测试也有助于验证系统是否满足用户需求和预期,是否符合相应的标准和规范。总之,测试的目的是为了确保系统的质量和可靠性,从而为用户提供良好的使用体验和价值。</p> <h3 style="margin-left:21.0000pt; text-align:left"><a name="t33"></a><a name="_Toc8810"></a><span style="color:#000000"><a name="_Toc166697155"></a><a name="_Hlk56765013">5.2</a></span>系统部分测试</h3> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">表5.1 用户注册测试用例</p> <div class="table-box"><table border="1" cellspacing="0" style="margin-left:-4.3500pt"><tbody><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试编号</p> </td><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试内容</p> </td><td style="background-color:#f4f6f8; width:287.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">预期结果</p> </td></tr><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-001</p> </td><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">输入有效信息</p> </td><td style="background-color:#f4f6f8; width:287.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">注册成功,跳转到登录页面</p> </td></tr><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-002</p> </td><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">输入已存在账号</p> </td><td style="background-color:#f4f6f8; width:287.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示账号已存在的提示信息</p> </td></tr><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-003</p> </td><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">输入无效信息</p> </td><td style="background-color:#f4f6f8; width:287.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示注册失败的提示信息,要求重新输入有效信息</p> </td></tr></tbody></table></div> <p style="margin-left:.0001pt; margin-right:0; text-align:justify"></p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">表5.2 用户登录测试用例</p> <div class="table-box"><table border="1" cellspacing="0" style="margin-left:-4.3500pt"><tbody><tr><td style="background-color:#f4f6f8; width:66.4500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试编号</p> </td><td style="background-color:#f4f6f8; width:120.5000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试内容</p> </td><td style="background-color:#f4f6f8; width:257.7000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">预期结果</p> </td></tr><tr><td style="background-color:#f4f6f8; width:66.4500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-004</p> </td><td style="background-color:#f4f6f8; width:120.5000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">输入正确的账号密码</p> </td><td style="background-color:#f4f6f8; width:257.7000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">登录成功,跳转到个人主页</p> </td></tr><tr><td style="background-color:#f4f6f8; width:66.4500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-005</p> </td><td style="background-color:#f4f6f8; width:120.5000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">输入错误的账号密码</p> </td><td style="background-color:#f4f6f8; width:257.7000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示登录失败的提示信息,要求重新输入正确的账号密码</p> </td></tr></tbody></table></div> <p style="margin-left:.0001pt; margin-right:0; text-align:justify"></p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">表5.3 修改密码测试用例</p> <div class="table-box"><table border="1" cellspacing="0" style="margin-left:-4.3500pt"><tbody><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试编号</p> </td><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试内容</p> </td><td style="background-color:#f4f6f8; width:287.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">预期结果</p> </td></tr><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-006</p> </td><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">输入有效密码</p> </td><td style="background-color:#f4f6f8; width:287.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">密码修改成功,显示修改成功的提示信息</p> </td></tr><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-007</p> </td><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">输入无效密码</p> </td><td style="background-color:#f4f6f8; width:287.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示密码无效的提示信息,要求重新输入有效密码</p> </td></tr><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-008</p> </td><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">输入错误原密码</p> </td><td style="background-color:#f4f6f8; width:287.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示原密码错误的提示信息,要求重新输入正确原密码</p> </td></tr></tbody></table></div> <p style="margin-left:.0001pt; margin-right:0; text-align:justify"></p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">表5.4 商品信息测试用例</p> <div class="table-box"><table border="1" cellspacing="0" style="margin-left:-4.3500pt"><tbody><tr><td style="background-color:#f4f6f8; width:66.4500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试编号</p> </td><td style="background-color:#f4f6f8; width:141.7500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试内容</p> </td><td style="background-color:#f4f6f8; width:236.4500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">预期结果</p> </td></tr><tr><td style="background-color:#f4f6f8; width:66.4500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-009</p> </td><td style="background-color:#f4f6f8; width:141.7500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">输入有效的商品信息信息</p> </td><td style="background-color:#f4f6f8; width:236.4500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">商品信息成功,显示记录成功的提示信息</p> </td></tr><tr><td style="background-color:#f4f6f8; width:66.4500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-010</p> </td><td style="background-color:#f4f6f8; width:141.7500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">输入无效的商品信息信息</p> </td><td style="background-color:#f4f6f8; width:236.4500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示记录失败的提示信息,要求重新输入有效信息</p> </td></tr></tbody></table></div> <p style="margin-left:.0001pt; margin-right:0; text-align:justify"></p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">表5.5 查看订单配送测试用例</p> <div class="table-box"><table border="1" cellspacing="0" style="margin-left:-4.3500pt"><tbody><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试编号</p> </td><td style="background-color:#f4f6f8; width:96.9000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试内容</p> </td><td style="background-color:#f4f6f8; width:283.5000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">预期结果</p> </td></tr><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-011</p> </td><td style="background-color:#f4f6f8; width:96.9000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">点击查看商品</p> </td><td style="background-color:#f4f6f8; width:283.5000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示当日的订单配送</p> </td></tr><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-012</p> </td><td style="background-color:#f4f6f8; width:96.9000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">选择其他日期</p> </td><td style="background-color:#f4f6f8; width:283.5000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示所选日期的订单配送</p> </td></tr><tr><td style="background-color:#f4f6f8"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-013</p> </td><td style="background-color:#f4f6f8; width:96.9000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">无可用商品信息</p> </td><td style="background-color:#f4f6f8; width:283.5000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示暂无商品的提示信息,提醒用户重新选择日期</p> </td></tr></tbody></table></div> <p style="margin-left:.0001pt; margin-right:0; text-align:justify"></p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">表5.6 查看新闻资讯测试用例</p> <div class="table-box"><table border="1" cellspacing="0" style="margin-left:-4.3500pt"><tbody><tr><td style="background-color:#f4f6f8; width:73.5500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试编号</p> </td><td style="background-color:#f4f6f8; width:113.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">测试内容</p> </td><td style="background-color:#f4f6f8; width:257.7000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">预期结果</p> </td></tr><tr><td style="background-color:#f4f6f8; width:73.5500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-014</p> </td><td style="background-color:#f4f6f8; width:113.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">点击查看资讯信息</p> </td><td style="background-color:#f4f6f8; width:257.7000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示新闻资讯页面,展示相关的文章、新闻等内容</p> </td></tr><tr><td style="background-color:#f4f6f8; width:73.5500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-015</p> </td><td style="background-color:#f4f6f8; width:113.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">选择其他分类</p> </td><td style="background-color:#f4f6f8; width:257.7000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示所选分类下的相关文章、新闻等内容</p> </td></tr><tr><td style="background-color:#f4f6f8; width:73.5500pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">TC-016</p> </td><td style="background-color:#f4f6f8; width:113.4000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">无可用新闻资讯信息</p> </td><td style="background-color:#f4f6f8; width:257.7000pt"> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">显示暂无新闻资讯的提示信息,提醒用户重新选择分类</p> </td></tr></tbody></table></div> <p style="margin-left:.0001pt; margin-right:0; text-align:justify"></p> <h3 style="margin-left:21.0000pt; text-align:left"><a name="t34"></a><a name="_Toc166697156"></a><span style="color:#6795b5">5.3</span>系统测试结果</h3> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">综上所述,服装购物商城系统小程序在功能测试中表现良好,通过了所有测试用例。系统提供的用户注册、登录、修改密码、商品信息、查看订单配送和查看新闻资讯等主要功能都能正常运行,并能够给出预期的提示信息和结果。然而,为了确保系统的全面稳定性和质量,仍建议进行更多的综合性测试,包括性能测试、安全性测试和用户体验测试等,以进一步验证和改进系统的功能和性能。</p> <h2 style="margin-left:0.0001pt; margin-right:0px; text-align:center"><a name="t35"></a><strong><strong><a name="_Toc31395">第6章 结论</a></strong></strong></h2> </div> <div> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">在构建基于Spring Boot的服装购物商城系统小程序项目中,我们深刻感受到了Spring Boot框架带来的强大优势和便捷性。Spring Boot的自动化配置、简化的依赖管理和内嵌的服务器等特性,极大地提高了开发效率,使得我们能够更加专注于业务逻辑的实现,而非被繁琐的配置所困扰。同时,Spring Boot的社区资源丰富,提供了大量的开源组件和工具,帮助我们快速解决开发过程中遇到的问题。</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">与此同时,<a href="https://so.csdn.net/so/search?q=%E5%BE%AE%E4%BF%A1%E5%B0%8F%E7%A8%8B%E5%BA%8F&spm=1001.2101.3001.7020" target="_blank" class="hl hl-1" data-report-view='{"spm":"1001.2101.3001.7020","dest":"https://so.csdn.net/so/search?q=%E5%BE%AE%E4%BF%A1%E5%B0%8F%E7%A8%8B%E5%BA%8F&spm=1001.2101.3001.7020","extra":"{\"searchword\":\"微信小程序\"}"}' data-report-click='{"spm":"1001.2101.3001.7020","dest":"https://so.csdn.net/so/search?q=%E5%BE%AE%E4%BF%A1%E5%B0%8F%E7%A8%8B%E5%BA%8F&spm=1001.2101.3001.7020","extra":"{\"searchword\":\"微信小程序\"}"}' data-tit="微信小程序" data-pretit="微信小程序">微信小程序</a>以其轻便、快捷、无需下载安装的特点,为电商业务提供了极佳的用户体验。通过微信小程序,用户能够随时随地浏览商品、下单购买、完成支付,大大提升了购物的便捷性和效率。微信小程序还提供了丰富的API和组件,使得开发者能够轻松地实现各种复杂的功能和交互效果,进一步提升了用户的使用体验。</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">将Spring Boot与微信小程序相结合,我们构建了一个功能完善、性能卓越、用户体验优良的电商平台。后端通过Spring Boot提供稳定的服务支撑,前端通过微信小程序实现流畅的用户交互和便捷的购物体验。这种组合不仅提高了开发效率,降低了维护成本,也为电商业务的发展注入了新的活力。我们相信,随着技术的不断进步和创新,基于Spring Boot的服装购物商城系统小程序将会在未来展现出更加广阔的应用前景。</p> </div> <h2 style="margin-left:0pt; text-align:center"><a name="t36"></a><a name="_Toc16899"></a><strong><strong><a name="_Toc166697158">参考文献</a></strong></strong></h2> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [1]  白花蒲,时谦,张燕,等.  基于微信小程序的院级实验室管理系统的实践    [J].  科技与创新,  2024,    (08):  178-181.  DOI:10.15913/j.cnki.kjycx.2024.08.053.</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [2]  QianJun L ,JingJing Z ,RuiChao Y , et al.  WeChat mini program in laboratory biosafety education among medical students at Guangzhou Medical University: a mixed method study of feasibility and usability    [J].  BMC Medical Education,  2024,  24  (1):  305-305.  </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [3]  陈佳乐.  基于微信小程序的图书馆座位预约系统    [J].  电脑编程技巧与维护,  2024,    (03):  63-65+75.  DOI:10.16184/j.cnki.comprg.2024.03.021.</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [4]  李鹏,高燕,王思源.  基于微信小程序的智能语音家居系统    [J].  微型电脑应用,  2024,  40  (02):  225-228.  </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [5]  孙梦菲,周天源,王天澍.  基于微信小程序的校园社团管理系统设计与实现    [J].  现代信息科技,  2024,  8  (03):  40-44.  DOI:10.19850/j.cnki.2096-4706.2024.03.009.</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [6]  李娇雅,汪济旭,李雨欣,等.  基于微信小程序的远程医疗预约系统设计    [J].  集成电路应用,  2024,  41  (02):  78-79.  DOI:10.19339/j.issn.1674-2583.2024.02.028.</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [7]  贾文琦,滕建,贾萨尔·阿依肯.  基于微信小程序的课程表系统    [J].  电脑编程技巧与维护,  2024,    (01):  61-64+88.  DOI:10.16184/j.cnki.comprg.2024.01.028.</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [8]  Xiao J ,Zhou H ,Lei Q , et al.  Attention-Mechanism-Based Face Feature Extraction Model for WeChat Applet on Mobile Devices    [J].  Electronics,  2024,  13  (1):    </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [9]  Wu J ,Chen N ,Xia H , et al.  Design and application of a game‐based WeChat mini‐program for screening cognitive impairments in Chinese older adults    [J].  Alzheimer's & Dementia,  2023,  19  (S11):    </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [10]  Wu J ,Chen N ,Xia H , et al.  Design and development of the intelligent voice recognition‐based cognitive assessment WeChat mini‐program    [J].  Alzheimer's & Dementia,  2023,  19  (S11):    </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [11]  Junhao S ,Weize L ,Zhiheng Z , et al.  Design and Implementation of the Remote Use of the Table Tennis Ball Recovery and Cleaning Machine Based on Wechat Mini Program    [J].  Academic Journal of Engineering and Technology Science,  2023,  6  (9):    </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [12]  杜雨荃,王晓菊,田立勤.  基于微信小程序的网上购物系统的设计与实现    [J].  网络安全技术与应用,  2022,    (04):  60-62.  </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [13]  陈娇,杨欣,韩艳,等.  基于微信小程序的校园综合服务化线上商城的研究与探索    [J].  中阿科技论坛(中英文),  2022,    (04):  102-106.  </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [14]  姚树乐,顾朝晖,李苇.  基于微信购物平台的用户购买服装意愿研究    [J].  化纤与纺织技术,  2022,  51  (03):  117-119.  </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [15]  李常宝.  基于微信小程序的电子商城的设计与开发    [J].  吕梁教育学院学报,  2021,  38  (03):  133-136.  </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [16]    胡杨林.    基于微服务和小程序的电子商城设计与实现[D].    西北大学,    2021.     DOI:10.27405/d.cnki.gxbdu.2021.000827.   </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [17]  王志烨.  网上购物服装行业的转型创新    [J].  投资与合作,  2021,    (04):  101-102.  </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [18]  马静.  基于微信小程序的购物商城系统的设计与实现    [J].  微型电脑应用,  2021,  37  (03):  31-34.  </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [19]    康娇兰.    基于微信小程序的区块链商城系统的设计与实现[D].    华中科技大学,    2021.     DOI:10.27157/d.cnki.ghzku.2021.004151.   </p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">  [20]    王博.    基于个性化推荐的居舍优品商城的设计与实现[D].    北京交通大学,    2020.     DOI:10.26944/d.cnki.gbfju.2020.000659.   </p> <h2 style="text-align:center"><a name="t37"></a><a name="_Toc12697"></a><strong><a name="_Toc166697159">致谢</a></strong></h2> <p style="margin-left:.0001pt; margin-right:0; text-align:justify"><a name="_Toc357012922"></a>在成功完成基于Spring Boot的服装购物商城系统小程序项目之际,我们由衷地向所有参与和支持本项目的团队成员、合作伙伴以及指导我们的导师表示衷心的感谢。</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">首先,感谢我们的团队成员,是你们的辛勤付出和不懈努力,使得这个项目得以顺利推进并最终完成。每位成员都发挥了自己的专业特长,共同克服了项目中的种种挑战和困难,展现了团队的力量和合作精神。</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">其次,感谢我们的合作伙伴,是你们提供了宝贵的资源和支持,使得我们能够更加顺利地完成项目。无论是技术支持、数据提供还是市场推广,你们都给予了极大的帮助和支持,让我们的项目更加完善和成功。</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">最后,感谢我们的导师和指导老师,是您们的悉心指导和教诲,让我们在项目开发过程中不断学习和成长。您们的专业知识和丰富经验为我们提供了宝贵的参考和启示,使我们能够更好地理解项目需求,优化设计方案,并最终实现项目的成功。</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify">在此,我们再次向所有参与和支持本项目的人员表示衷心的感谢!没有你们的支持和帮助,我们无法完成这个项目。我们将继续努力,不断提升自己的能力和水平,为未来的电商事业贡献更多的力量。</p> <p style="margin-left:.0001pt; margin-right:0; text-align:justify"></p> <blockquote> <h2 style="text-align:center"><a name="t38"></a><span style="color:#fe2c24">免费领取项目源码,请关注❤点赞收藏并私信博主,谢谢-</span></h2> <h2 style="text-align:center"><a name="t39"></a><a name="t44"></a><span style="color:#fe2c24">免费领取项目源码,请关注❤点赞收藏并私信博主,谢谢-</span></h2> <h2 style="text-align:center"><a name="t40"></a><a name="t45"></a><span style="color:#fe2c24">免费领取项目源码,请关注❤点赞收藏并私信博主,谢谢-</span></h2> </blockquote> </div><div data-report-view='{"mod":"1585297308_001","spm":"1001.2101.3001.6548","dest":"https://blog.csdn.net/BS53804/article/details/145769033","extend1":"pc","ab":"new"}'><div></div></div> </div> </article> </div> <div style="margin-top: 5px;color: #828a91;font-size: 12px"> <span>注:本文转载自blog.csdn.net的81330-BS的文章<a href="https://blog.csdn.net/BS53804/article/details/145769033" target="_blank">"https://blog.csdn.net/BS53804/article/details/145769033"</a>。版权归原作者所有,此博客不拥有其著作权,亦不承担相应法律责任。如有侵权,请联系我们删除。</span> </div> <div class="content-footer post-content-footer"> <div class="inner-wrapper-sticky"> <div class="post-content-footer-in"> <div class="content-footer-poster"> <button data-title="去评论" class="mobile-hidden b2tooltipbox comment-span"><a href="#demoAnchor"><i class="b2font b2-chat-2-fill "></i></a></button> <a href="/member/login/"> <button data-title="喜欢" class="mobile-hidden b2tooltipbox comment-span" data-id="1821908"><span class=""><i class="b2font b2-heart-fill "></i><b>4232</b></span></button> </a> <button data-title="分享到脸书" class="mobile-hidden b2tooltipbox comment-span" style="margin-top: 22px"><a href="javascript:fbShare();"> <svg t="1690264724364" class="fenxiang_icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2299" width="24" height="24"> <path d="M933.8 195.213c0-58.296-47.259-105.554-105.554-105.554h-633.12c-58.296 0-105.554 47.258-105.554 105.554v633.12c0 58.295 47.258 105.554 105.554 105.554h633.12c58.295 0 105.554-47.259 105.554-105.554v-633.12zM776.21 300.46H669.787v105.4H776.21v105.401H669.787v317.225h-105.4V511.261H458.985v-105.4h105.4V267.9c0-35.433 39.029-72.84 78.785-72.84H776.21v105.4z" fill="#6C6E72" p-id="2300"></path> </svg> </a> </button> <button data-title="分享到推特" class="mobile-hidden b2tooltipbox comment-span"><a href="javascript:twitterShare();"> <svg t="1690265072794" class="fenxiang_icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2903" width="24" height="24"> <path d="M1024 512c0-282.763636-229.236364-512-512-512C229.236364 0 0 229.236364 0 512s229.236364 512 512 512C794.763636 1024 1024 794.763636 1024 512zM236.311273 693.946182c8.843636 1.117091 17.873455 1.722182 26.996364 1.722182 53.015273 0.093091 101.794909-19.037091 140.474182-51.153455-49.524364-1.163636-91.275636-36.165818-105.658182-84.200727 6.888727 1.442909 14.010182 2.280727 21.271273 2.327273 10.333091 0.046545 20.293818-1.349818 29.789091-4.049455-51.758545-11.450182-90.763636-60.555636-90.763636-119.063273 0-0.512 0-1.024 0-1.536 15.266909 9.216 32.674909 14.801455 51.246545 15.639273C279.365818 431.709091 259.397818 394.472727 259.397818 352.581818c0-22.155636 5.585455-42.821818 15.313455-60.509091 55.808 73.774545 139.170909 122.740364 233.146182 128.837818-1.954909-8.797091-2.932364-17.966545-2.932364-27.322182 0-66.141091 50.641455-118.923636 113.105455-117.899636 32.535273 0.558545 61.952 15.499636 82.571636 38.958545 25.786182-4.933818 49.989818-14.429091 71.819636-27.694545-8.424727 27.601455-26.391273 50.594909-49.757091 64.977455 22.900364-2.56 44.683636-8.610909 64.977455-17.780364-15.173818 23.598545-34.350545 44.218182-56.459636 60.695273 0.232727 5.12 0.325818 10.24 0.325818 15.36 0 157.044364-113.803636 338.152727-321.861818 338.059636C345.832727 748.311273 286.347636 728.296727 236.311273 693.946182z" p-id="2904" fill="#6C6E72"></path> </svg> </a> </button> <button data-title="分享到Whatsapp" class="mobile-hidden b2tooltipbox comment-span"><a href="javascript:whatsApp();"> <svg t="1690265463406" class="fenxiang_icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="4099" id="mx_n_1690265463407" width="24" height="24"> <path d="M512 85.333333a426.666667 426.666667 0 0 0-345.6 676.693334L128 878.933333a20.906667 20.906667 0 0 0 5.12 21.76 21.76 21.76 0 0 0 21.76 5.546667l121.6-39.253333A426.666667 426.666667 0 1 0 512 85.333333z m248.32 602.453334a119.893333 119.893333 0 0 1-85.333333 60.16c-22.186667 4.693333-51.626667 8.533333-149.333334-32a530.346667 530.346667 0 0 1-213.333333-187.733334 242.773333 242.773333 0 0 1-50.773333-128 136.96 136.96 0 0 1 42.666666-104.106666 63.573333 63.573333 0 0 1 42.666667-15.36h14.08c12.373333 0 18.773333 0 27.306667 20.906666s34.986667 85.333333 37.973333 92.16a24.32 24.32 0 0 1 2.133333 23.04 78.933333 78.933333 0 0 1-14.08 19.626667c-5.973333 7.253333-12.373333 12.8-18.346666 20.48a20.053333 20.053333 0 0 0-5.12 26.88 381.44 381.44 0 0 0 69.12 85.333333 313.173333 313.173333 0 0 0 100.266666 61.866667 26.453333 26.453333 0 0 0 29.866667-4.693333 426.666667 426.666667 0 0 0 33.28-42.666667 23.893333 23.893333 0 0 1 30.72-8.96c11.52 3.84 72.533333 34.133333 85.333333 40.106667s20.906667 9.386667 23.893334 14.506666a106.666667 106.666667 0 0 1-2.986667 58.453334z" p-id="4100" fill="#6C6E72"></path> </svg> </a> </button> <!-- <a class="tooltip be-btn-beshare be-btn-link be-btn-link-l use-beshare-link-btn bk dah"--> <!-- rel="external nofollow" onclick="myFunction()" onmouseout="outFunc()">--> <!-- <span class="sharetip bz copytipl">复制链接</span>--> <!-- </a>--> <div> <span class="sharetip bz copytipl">复制链接</span> <button class="btn btn-secondary mobile-hidden b2tooltipbox comment-span copy_button"> <a> <svg t="1690338204788" class="fenxiang_icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="10669" width="24" height="24"> <path d="M512 1024C229.228 1024 0 794.772 0 512S229.228 0 512 0s512 229.228 512 512-229.228 512-512 512z m54.545-565.02l-1.798-1.764a102.207 102.207 0 0 0-11.002-9.523l-35.453 35.442c4.176 2.446 8.078 5.393 11.605 8.92l1.866 1.763a58.277 58.277 0 0 1 0 82.341l-96.904 96.882a58.334 58.334 0 0 1-82.341 0l-1.832-1.798a58.243 58.243 0 0 1 0-82.306l43.816-43.828a149.675 149.675 0 0 1-10.866-58.732l-67.812 67.72c-41.836 41.825-41.836 110.251 0 152.053l1.787 1.798c41.836 41.79 110.228 41.79 152.052 0l96.882-96.916c41.757-41.825 41.757-110.25 0-152.052z m141.38-141.37l-1.82-1.797c-41.802-41.825-110.228-41.825-152.053 0l-96.882 96.916c-41.824 41.79-41.824 110.216 0 152.053l1.798 1.763c3.505 3.425 7.225 6.576 11.002 9.523l35.454-35.476a57.845 57.845 0 0 1-11.583-8.92l-1.798-1.763a58.311 58.311 0 0 1 0-82.375l96.905-96.882a58.197 58.197 0 0 1 82.284 0l1.798 1.797a58.277 58.277 0 0 1 0 82.341l-43.76 43.828c7.612 18.796 11.196 38.81 10.844 58.766l67.789-67.755c41.824-41.79 41.824-110.216 0.022-152.007z" p-id="10670" fill="#6C6E72"></path> </svg> </a> </button> </div> <div class="btn-group "> <button type="button" class="btn btn-secondary dropdown-toggle" data-toggle="dropdown" aria-expanded="false"> <svg t="1690338289501" class="fenxiang_icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="11788" width="24" height="24"> <path d="M960 128H64c-35.3 0-64 28.6-64 64v640c0 35.3 28.7 64 64 64h160c8.8 0 16-7.2 16-16v-12c0-2.2 1.8-4 4-4h151c2.2 0 4 1.8 4 4v12c0 8.8 7.2 16 16 16h193c8.8 0 16-7.2 16-16v-12c0-2.2 1.8-4 4-4h152c2.2 0 4 1.8 4 4v12c0 8.8 7.2 16 16 16h160c35.3 0 64-28.7 64-64V192c0-35.4-28.7-64-64-64zM576 680v-48c0-4.4 3.6-8 8-8h304c4.4 0 8 3.6 8 8v48c0 4.4-3.6 8-8 8H584c-4.4 0-8-3.6-8-8z m0-128v-48c0-4.4 3.6-8 8-8h304c4.4 0 8 3.6 8 8v48c0 4.4-3.6 8-8 8H584c-4.4 0-8-3.6-8-8z m320-128c0 4.4-3.6 8-8 8H584c-4.4 0-8-3.6-8-8v-48c0-4.4 3.6-8 8-8h304c4.4 0 8 3.6 8 8v48zM447.2 736h-288c-8.8 0-16.8-3.6-22.6-9.4-5.8-5.8-9.4-13.8-9.4-22.6 0-57.1 27.2-107.8 69.3-140 4-3.1 4.3-9 0.5-12.3-33-29.3-53.8-72.1-53.8-119.7 0-87.7 70.5-158.9 157.9-160 87.8-1.1 160.7 69.6 162 157.4 0.8 48.6-20.1 92.4-53.7 122.2-3.8 3.4-3.6 9.3 0.5 12.4 21.1 16.1 38.4 36.8 50.4 60.6 12.1 23.8 18.9 50.8 18.9 79.3 0 17.8-14.3 32.1-32 32.1z" p-id="11789" fill="#6C6E72"></path> </svg> </button> <div class="dropdown-menu" style="padding: 5px;box-shadow: 0px 0px 6px 0px #999;"> <div class="menu_img"> <div id="qrcode" style="width:100%; height:100%;"></div> </div> </div> </div> </div> </div> </div> </div> <div style="display: flex;justify-content: space-between;align-items: end;"> <div class="post-tags-meat_news"> <!-- <a class="b2-radius" href="/list_119/">--> <!-- <span class="tag-img"><i class="b2font b2-price-tag-3-line "></i></span>--> <!-- <span class="tag-text"></span>--> <!-- </a>--> </div> </div> <div class="mobile-show"> <div style="display: flex;justify-content: end;flex-wrap: wrap" class="share_mobile"> <a href="javascript:whatsApp();"> <svg t="1690265463406" class="fenxiang_icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="4099" id="mx_n_1690265463407" width="24" height="24"> <path d="M512 85.333333a426.666667 426.666667 0 0 0-345.6 676.693334L128 878.933333a20.906667 20.906667 0 0 0 5.12 21.76 21.76 21.76 0 0 0 21.76 5.546667l121.6-39.253333A426.666667 426.666667 0 1 0 512 85.333333z m248.32 602.453334a119.893333 119.893333 0 0 1-85.333333 60.16c-22.186667 4.693333-51.626667 8.533333-149.333334-32a530.346667 530.346667 0 0 1-213.333333-187.733334 242.773333 242.773333 0 0 1-50.773333-128 136.96 136.96 0 0 1 42.666666-104.106666 63.573333 63.573333 0 0 1 42.666667-15.36h14.08c12.373333 0 18.773333 0 27.306667 20.906666s34.986667 85.333333 37.973333 92.16a24.32 24.32 0 0 1 2.133333 23.04 78.933333 78.933333 0 0 1-14.08 19.626667c-5.973333 7.253333-12.373333 12.8-18.346666 20.48a20.053333 20.053333 0 0 0-5.12 26.88 381.44 381.44 0 0 0 69.12 85.333333 313.173333 313.173333 0 0 0 100.266666 61.866667 26.453333 26.453333 0 0 0 29.866667-4.693333 426.666667 426.666667 0 0 0 33.28-42.666667 23.893333 23.893333 0 0 1 30.72-8.96c11.52 3.84 72.533333 34.133333 85.333333 40.106667s20.906667 9.386667 23.893334 14.506666a106.666667 106.666667 0 0 1-2.986667 58.453334z" p-id="4100" fill="#6C6E72"></path> </svg> </a> <a href="javascript:fbShare();"> <svg t="1690264724364" class="fenxiang_icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2299" width="24" height="24"> <path d="M933.8 195.213c0-58.296-47.259-105.554-105.554-105.554h-633.12c-58.296 0-105.554 47.258-105.554 105.554v633.12c0 58.295 47.258 105.554 105.554 105.554h633.12c58.295 0 105.554-47.259 105.554-105.554v-633.12zM776.21 300.46H669.787v105.4H776.21v105.401H669.787v317.225h-105.4V511.261H458.985v-105.4h105.4V267.9c0-35.433 39.029-72.84 78.785-72.84H776.21v105.4z" fill="#6C6E72" p-id="2300"></path> </svg> </a> <a href="javascript:twitterShare();"> <svg t="1690265072794" class="fenxiang_icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2903" width="24" height="24"> <path d="M1024 512c0-282.763636-229.236364-512-512-512C229.236364 0 0 229.236364 0 512s229.236364 512 512 512C794.763636 1024 1024 794.763636 1024 512zM236.311273 693.946182c8.843636 1.117091 17.873455 1.722182 26.996364 1.722182 53.015273 0.093091 101.794909-19.037091 140.474182-51.153455-49.524364-1.163636-91.275636-36.165818-105.658182-84.200727 6.888727 1.442909 14.010182 2.280727 21.271273 2.327273 10.333091 0.046545 20.293818-1.349818 29.789091-4.049455-51.758545-11.450182-90.763636-60.555636-90.763636-119.063273 0-0.512 0-1.024 0-1.536 15.266909 9.216 32.674909 14.801455 51.246545 15.639273C279.365818 431.709091 259.397818 394.472727 259.397818 352.581818c0-22.155636 5.585455-42.821818 15.313455-60.509091 55.808 73.774545 139.170909 122.740364 233.146182 128.837818-1.954909-8.797091-2.932364-17.966545-2.932364-27.322182 0-66.141091 50.641455-118.923636 113.105455-117.899636 32.535273 0.558545 61.952 15.499636 82.571636 38.958545 25.786182-4.933818 49.989818-14.429091 71.819636-27.694545-8.424727 27.601455-26.391273 50.594909-49.757091 64.977455 22.900364-2.56 44.683636-8.610909 64.977455-17.780364-15.173818 23.598545-34.350545 44.218182-56.459636 60.695273 0.232727 5.12 0.325818 10.24 0.325818 15.36 0 157.044364-113.803636 338.152727-321.861818 338.059636C345.832727 748.311273 286.347636 728.296727 236.311273 693.946182z" p-id="2904" fill="#6C6E72"></path> </svg> </a> <a> <span class="sharetip bz copytipl2">复制链接</span> <button class="copy_button2"> <svg t="1690338204788" class="fenxiang_icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="10669" width="24" height="24"> <path d="M512 1024C229.228 1024 0 794.772 0 512S229.228 0 512 0s512 229.228 512 512-229.228 512-512 512z m54.545-565.02l-1.798-1.764a102.207 102.207 0 0 0-11.002-9.523l-35.453 35.442c4.176 2.446 8.078 5.393 11.605 8.92l1.866 1.763a58.277 58.277 0 0 1 0 82.341l-96.904 96.882a58.334 58.334 0 0 1-82.341 0l-1.832-1.798a58.243 58.243 0 0 1 0-82.306l43.816-43.828a149.675 149.675 0 0 1-10.866-58.732l-67.812 67.72c-41.836 41.825-41.836 110.251 0 152.053l1.787 1.798c41.836 41.79 110.228 41.79 152.052 0l96.882-96.916c41.757-41.825 41.757-110.25 0-152.052z m141.38-141.37l-1.82-1.797c-41.802-41.825-110.228-41.825-152.053 0l-96.882 96.916c-41.824 41.79-41.824 110.216 0 152.053l1.798 1.763c3.505 3.425 7.225 6.576 11.002 9.523l35.454-35.476a57.845 57.845 0 0 1-11.583-8.92l-1.798-1.763a58.311 58.311 0 0 1 0-82.375l96.905-96.882a58.197 58.197 0 0 1 82.284 0l1.798 1.797a58.277 58.277 0 0 1 0 82.341l-43.76 43.828c7.612 18.796 11.196 38.81 10.844 58.766l67.789-67.755c41.824-41.79 41.824-110.216 0.022-152.007z" p-id="10670" fill="#6C6E72"></path> </svg> </button> </a> <a class="dropdown mobile_dropup"> <button type="button" class="btn btn-secondary dropdown-toggle" data-toggle="dropdown" aria-expanded="false"> <svg t="1690338289501" class="fenxiang_icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="11788" width="24" height="24"> <path d="M960 128H64c-35.3 0-64 28.6-64 64v640c0 35.3 28.7 64 64 64h160c8.8 0 16-7.2 16-16v-12c0-2.2 1.8-4 4-4h151c2.2 0 4 1.8 4 4v12c0 8.8 7.2 16 16 16h193c8.8 0 16-7.2 16-16v-12c0-2.2 1.8-4 4-4h152c2.2 0 4 1.8 4 4v12c0 8.8 7.2 16 16 16h160c35.3 0 64-28.7 64-64V192c0-35.4-28.7-64-64-64zM576 680v-48c0-4.4 3.6-8 8-8h304c4.4 0 8 3.6 8 8v48c0 4.4-3.6 8-8 8H584c-4.4 0-8-3.6-8-8z m0-128v-48c0-4.4 3.6-8 8-8h304c4.4 0 8 3.6 8 8v48c0 4.4-3.6 8-8 8H584c-4.4 0-8-3.6-8-8z m320-128c0 4.4-3.6 8-8 8H584c-4.4 0-8-3.6-8-8v-48c0-4.4 3.6-8 8-8h304c4.4 0 8 3.6 8 8v48zM447.2 736h-288c-8.8 0-16.8-3.6-22.6-9.4-5.8-5.8-9.4-13.8-9.4-22.6 0-57.1 27.2-107.8 69.3-140 4-3.1 4.3-9 0.5-12.3-33-29.3-53.8-72.1-53.8-119.7 0-87.7 70.5-158.9 157.9-160 87.8-1.1 160.7 69.6 162 157.4 0.8 48.6-20.1 92.4-53.7 122.2-3.8 3.4-3.6 9.3 0.5 12.4 21.1 16.1 38.4 36.8 50.4 60.6 12.1 23.8 18.9 50.8 18.9 79.3 0 17.8-14.3 32.1-32 32.1z" p-id="11789" fill="#6C6E72"></path> </svg> </button> <div class="dropdown-menu mobile_menu" style="padding: 5px;box-shadow: 0px 0px 6px 0px #999;"> <div class="menu_img"> <div id="qrcode_two" style="width:100%; height:100%;"></div> </div> </div> </a> </div> </div> </article> <div class="related-posts mg-t mg-b box b2-radius"> <div class="related-posts-title">相关推荐</div> <div class="hidden-line"> <div class="related-posts-in"> </div> </div> </div> <div class="comments-box" id="demoAnchor"> <div id="comments" class="comments-area box b2-radius"> <div class="comments-title"> <div class="comment-info"> <span ref="commentCount" class="comment-count"> 发表评论</span> </div> <div id="comment-form" class="comment-form"> <div class="toolbox-left"> <div class="profile-box" style="display: flex"> <a class="profile-href comment-overlay-login"> <!-- <span class="profile-name">发表评论</span>--> <a class="login-info">登录后才能发表评论和回复</a> <a class="text-secondary" href="/member/register/">注册</p> <a class="text-secondary" href="/member/login/">/ 登录</a> </a> </div> </div> </div> </div><!-- .comments-title --> <div class="container" style="padding-bottom: 20px;"> <form class="my-4" onsubmit="return submitcomment(this);" data-action="/comment/add/?contentid=1821908"> <div class="form-group"> <textarea name="comment" id="comment" onblur="if(value.length>200){value=value.substr(0,200)}" class="form-control" placeholder="请输入评论内容(限200字数)" onkeyup="value=value.substr(0,200)"></textarea> </div> <div class="form-group"> <div class="row"> <div class="col-6 col-md-3"> <input type="text" name="checkcode" required id="checkcode" onfocus='updateimg()' class="form-control" placeholder="请输入验证码"> </div> <div class="col-6 col-md-3" id="text"> <img title="点击刷新" style="height:33px;" id="codeimg" src="/core/code.php" onclick="this.src='/core/code.php?'+Math.round(Math.random()*10);"/> </div> </div> </div> <div class="form-group"> <button type="submit" class="btn btn-info mb-2">提交评论</button> </div> </form> <h4>评论记录:</h4> <a name="comment"></a> <!-- 分页 --> <!-- <div class="text-center my-5 text-secondary">未查询到任何数据!</div>--> <div class="tac text-secondary">未查询到任何数据!</div> <!-- 评论回复弹框 --> <div class="modal" tabindex="-1" role="dialog" id="reply"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title">回复评论:</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <form onsubmit="return submitcomment(this);" data-action="" id="replyform"> <div class="modal-body"> <div class="form-group"> <textarea name="comment" id="comment" onblur="if(value.length>200) value=value.substr(0,200)" class="form-control" placeholder="请输入评论内容(限200字数)" onkeyup="value=value.substr(0,200)"></textarea> </div> <div class="form-group"> <div class="row"> <div class="col-6"> <input type="text" name="checkcode" required id="checkcode" class="form-control" placeholder="请输入验证码"> </div> <div class="col-6" id="text"> <img title="点击刷新" style="height:33px;" id="codeimg" src="/core/code.php" onclick="this.src='/core/code.php?'+Math.round(Math.random()*10);"/> </div> </div> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-secondary" data-dismiss="modal"> 关闭 </button> <button type="submit" class="btn btn-info" id="text">提交评论 </button> </div> </form> </div> </div> </div> </div> </div><!-- #comments --> </div> </div> <aside id="secondary" class="widget-area" style="margin-right: 0;margin-left: 16px;margin-bottom: 10px;"> <div class="sidebars"> <div class="inner-wrapper-sticky"> <div class="sidebar-innter widget-ffixed"> <section id="tag_cloud-10" class="widget widget_tag_cloud mg-b box b2-radius mobile-hidden"> <h2 class="widget-title_fenlei">分类栏目</h2> <div class="tagcloud"> <a href="/list_103/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >后端<span class="tag-link-count"> (14832)</span></a> <a href="/list_104/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >前端<span class="tag-link-count"> (14280)</span></a> <a href="/list_105/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >移动开发<span class="tag-link-count"> (3760)</span></a> <a href="/list_106/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >编程语言<span class="tag-link-count"> (3851)</span></a> <a href="/list_107/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >Java<span class="tag-link-count"> (3904)</span></a> <a href="/list_108/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >Python<span class="tag-link-count"> (3298)</span></a> <a href="/list_109/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >人工智能<span class="tag-link-count"> (10119)</span></a> <a href="/list_110/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >AIGC<span class="tag-link-count"> (2810)</span></a> <a href="/list_111/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >大数据<span class="tag-link-count"> (3499)</span></a> <a href="/list_112/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >数据库<span class="tag-link-count"> (3945)</span></a> <a href="/list_113/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >数据结构与算法<span class="tag-link-count"> (3757)</span></a> <a href="/list_114/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >音视频<span class="tag-link-count"> (2669)</span></a> <a href="/list_115/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >云原生<span class="tag-link-count"> (3145)</span></a> <a href="/list_116/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >云平台<span class="tag-link-count"> (2965)</span></a> <a href="/list_117/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >前沿技术<span class="tag-link-count"> (2993)</span></a> <a href="/list_118/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >开源<span class="tag-link-count"> (2160)</span></a> <a href="/list_119/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >小程序<span class="tag-link-count"> (2860)</span></a> <a href="/list_120/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >运维<span class="tag-link-count"> (2533)</span></a> <a href="/list_121/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >服务器<span class="tag-link-count"> (2698)</span></a> <a href="/list_122/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >操作系统<span class="tag-link-count"> (2325)</span></a> <a href="/list_123/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >硬件开发<span class="tag-link-count"> (2492)</span></a> <a href="/list_124/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >嵌入式<span class="tag-link-count"> (2955)</span></a> <a href="/list_125/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >微软技术<span class="tag-link-count"> (2769)</span></a> <a href="/list_126/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >软件工程<span class="tag-link-count"> (2056)</span></a> <a href="/list_127/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >测试<span class="tag-link-count"> (2865)</span></a> <a href="/list_128/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >网络空间安全<span class="tag-link-count"> (2948)</span></a> <a href="/list_129/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >网络与通信<span class="tag-link-count"> (2797)</span></a> <a href="/list_130/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >用户体验设计<span class="tag-link-count"> (2592)</span></a> <a href="/list_131/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >学习和成长<span class="tag-link-count"> (2593)</span></a> <a href="/list_132/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >搜索<span class="tag-link-count"> (2744)</span></a> <a href="/list_133/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >开发工具<span class="tag-link-count"> (7108)</span></a> <a href="/list_134/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >游戏<span class="tag-link-count"> (2829)</span></a> <a href="/list_135/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >HarmonyOS<span class="tag-link-count"> (2935)</span></a> <a href="/list_136/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >区块链<span class="tag-link-count"> (2782)</span></a> <a href="/list_137/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >数学<span class="tag-link-count"> (3112)</span></a> <a href="/list_138/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >3C硬件<span class="tag-link-count"> (2759)</span></a> <a href="/list_139/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >资讯<span class="tag-link-count"> (2909)</span></a> <a href="/list_140/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >Android<span class="tag-link-count"> (4709)</span></a> <a href="/list_141/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >iOS<span class="tag-link-count"> (1850)</span></a> <a href="/list_142/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >代码人生<span class="tag-link-count"> (3043)</span></a> <a href="/list_143/" class="tag-cloud-link tag-link-279 tag-link-position-1" style="font-size: 8pt;" >阅读<span class="tag-link-count"> (2841)</span></a> </div> </section> <section id="b2-widget-hot-4" class="widget b2-widget-hot box b2-radius mobile-hidden"> <div class="b2-widget-title"> <h2 class="widget-title_hot">热门文章</h2> </div> <div class="b2-widget-box"> <ul class="b2-widget-list-ul"> </ul> </div> </section> <div style="display:none;" class="scode">119</div> <div style="display:none;" class="name">小程序</div> </div> </div> </div> </aside> </div> <footer id="colophon" class="footer"> <div class="site-footer-nav"> <div class="wrapper"> <div class="Box-v1-cmoUUM tBcFR"> <span> <a href="/About-us/">关于我们</a> </span> <span> <a href="/Privacy-policy/">隐私政策</a> </span> <span> <a href="/Disclaimer/">免责声明</a> </span> <span> <a href="/Contact-us/">联系我们</a> </span> </div> <div class="footer-bottom"> <div class="footer-bottom-left"> <div class="copyright">Copyright © 2020-2024 蚁人论坛 (iYenn.com) All Rights Reserved.</div> </div> </div> </div> </div> <div class="dmtop" style="bottom: 25px;">Scroll to Top</div> </footer> </div> <script> $(document).ready(function () { jQuery(window).scroll(function () { if (jQuery(this).scrollTop() > 1) { jQuery('.dmtop').css({bottom: "25px"}); } else { jQuery('.dmtop').css({bottom: "-100px"}); } }); jQuery('.dmtop').click(function () { jQuery('html, body').animate({scrollTop: '0px'}, 800); return false; }); }); </script> <style> .site-footer { background-color: #0a0a0a } .site-footer-nav { background-color: #fff; } #bigTriangleColor { background-color: #0a0a0a } </style> </body> </html> <script src="https://cdn.staticfile.org/clipboard.js/2.0.4/clipboard.min.js"></script> <script> $(".copy_button").click(function () { var html = window.location.href; new ClipboardJS('.copy_button', { text: function (trigger, e) { return html; } }).on('success', function (e) { $('.copytipl').replaceWith('<span class="sharetip bz copytipl">复制成功</span>'); $('.copytipl').show() e.clearSelection(); }).on('error', function (e) { $('.copytipl').replaceWith('<span class="sharetip bz copytipl">复制失败</span>'); }); }) $(".copy_button").hover(function () { $('.copytipl').replaceWith('<span class="sharetip bz copytipl">复制链接</span>'); $('.copytipl').show() }, function () { $('.copytipl').hide() }) $(".copy_button2").hover(function () { $('.copytipl2').replaceWith('<span class="sharetip bz copytipl2">复制链接</span>'); $('.copytipl2').show() }, function () { $('.copytipl2').hide() }) $(".copy_button2").click(function () { var html = window.location.href; new ClipboardJS('.copy_button2', { text: function (trigger, e) { return html; } }).on('success', function (e) { $('.copytipl2').replaceWith('<span class="sharetip bz copytipl2">复制成功</span>'); $('.copytipl2').show() setTimeout(function () { $('.copytipl2').hide() }, 1500) e.clearSelection(); }).on('error', function (e) { $('.copytipl2').replaceWith('<span class="sharetip bz copytipl2">复制失败</span>'); }); }) </script> <script type="text/javascript"> var qrcode = new QRCode(document.getElementById("qrcode"), { width: 100, height: 100, text: window.location.href }); var qrcode_two = new QRCode(document.getElementById("qrcode_two"), { width: 100, height: 100, text: window.location.href }); </script> <script> //share facebook function fbShare(contentId) { u = document.getElementsByClassName("share_url")[0].content; t = document.getElementsByClassName("share_title")[0].content; d = document.getElementsByClassName("share_desc")[0].content; i = document.getElementsByClassName("share_img")[0].content; window.open("https://www.facebook.com/sharer/sharer.php?u=" + encodeURIComponent(u) + "&t=" + encodeURIComponent("\n\n" + t) + "&d=" + encodeURIComponent("\n\n" + d) + "&i=" + encodeURIComponent(i), "sharer", "toolbar=0,status=0,width=626,height=436"); "sharer", "toolbar=0,status=0,width=626,height=436" } //share twitter function twitterShare(contentId) { u = document.getElementsByClassName("share_url")[0].content; t = document.getElementsByClassName("share_title")[0].content; d = document.getElementsByClassName("share_desc")[0].content; i = document.getElementsByClassName("share_img")[0].content; window.open("https://twitter.com/intent/tweet?url=" + encodeURIComponent(u) + "&t=" + encodeURIComponent("\n\n" + t) + "&d=" + encodeURIComponent("\n\n" + d) + "&i=" + encodeURIComponent(i), "sharer", "toolbar=0,status=0,width=626,height=436"); } //share whatsapp function whatsApp(contentId) { u = document.getElementsByClassName("share_url")[0].content; t = document.getElementsByClassName("share_title")[0].content; d = document.getElementsByClassName("share_desc")[0].content; i = document.getElementsByClassName("share_img")[0].content; location = "https://web.whatsapp.com/send?text=" + encodeURIComponent(t) + "&u" + encodeURIComponent("\n\n" + u) + "&d=" + encodeURIComponent("\n\n" + d) + "&i=" + encodeURIComponent(i) + "&via=lopscoop"; } </script> <script> $('.entry-content a').click(function () { // var hreF = $(this).attr('href'); // window.open(hreF);//在新窗口打开 $(this).attr("target", "_blank"); }) $(".code-block-extension-copyCodeBtn").click(function () { var html = $(this).parent().parent().siblings(".code-block-extension-codeShowNum").text(); // console.log(html,'1') new ClipboardJS('.code-block-extension-copyCodeBtn', { text: function (trigger, e) { return html; } }).on('success', function (e) { alert("复制成功!"); e.clearSelection(); }).on('error', function (e) { alert('Error!'); }); }) var commentDanger = { alert: function (msg, type) { if (typeof (type) == "undefined") { type = "danger"; } var divElement = $("<div></div>").addClass('alert').addClass('alert-' + type).addClass('alert-dismissible').addClass('col-md-4').addClass('col-md-offset-4'); divElement.css({ "position": "fixed", "top": "80px", "width": "100%", "margin": "0 auto", "left": "0", "right": "0", "z-index": "99999999999" }); divElement.text(msg); var closeBtn = $('<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>'); $(divElement).append(closeBtn); $('.content-area').before(divElement); return divElement; }, message: function (msg, type) { var divElement = commentDanger.alert(msg, type); var isIn = false; divElement.on({ mouseover: function () { isIn = true; }, mouseout: function () { isIn = false; } }); // After a short delay, it rises and disappears setTimeout(function () { var IntervalMS = 20; var floatSpace = 60; var nowTop = divElement.offset().top; var stopTop = nowTop - floatSpace; divElement.fadeOut(IntervalMS * floatSpace); var upFloat = setInterval(function () { if (nowTop >= stopTop) { divElement.css({"top": nowTop--}); } else { clearInterval(upFloat); divElement.remove(); } }, IntervalMS); if (isIn) { clearInterval(upFloat); divElement.stop(); } divElement.hover(function () { clearInterval(upFloat); divElement.stop(); }, function () { divElement.fadeOut(IntervalMS * (nowTop - stopTop)); upFloat = setInterval(function () { if (nowTop >= stopTop) { divElement.css({"top": nowTop--}); } else { clearInterval(upFloat); divElement.remove(); } }, IntervalMS); }); }, 2500); } } var commentSuccess = { alert: function (msg, type) { if (typeof (type) == "undefined") { type = "success"; } var divElement = $("<div></div>").addClass('alert').addClass('alert-' + type).addClass('alert-dismissible').addClass('col-md-4').addClass('col-md-offset-4'); divElement.css({ "position": "fixed", "top": "80px", "width": "100%", "margin": "0 auto", "left": "0", "right": "0", "z-index": "99999999999" }); divElement.text(msg); var closeBtn = $('<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>'); $(divElement).append(closeBtn); $('.content-area').before(divElement); return divElement; }, message: function (msg, type) { var divElement = commentSuccess.alert(msg, type); var isIn = false; divElement.on({ mouseover: function () { isIn = true; }, mouseout: function () { isIn = false; } }); // After a short delay, it rises and disappears setTimeout(function () { var IntervalMS = 20; var floatSpace = 60; var nowTop = divElement.offset().top; var stopTop = nowTop - floatSpace; divElement.fadeOut(IntervalMS * floatSpace); var upFloat = setInterval(function () { if (nowTop >= stopTop) { divElement.css({"top": nowTop--}); } else { clearInterval(upFloat); divElement.remove(); } }, IntervalMS); if (isIn) { clearInterval(upFloat); divElement.stop(); } divElement.hover(function () { clearInterval(upFloat); divElement.stop(); }, function () { divElement.fadeOut(IntervalMS * (nowTop - stopTop)); upFloat = setInterval(function () { if (nowTop >= stopTop) { divElement.css({"top": nowTop--}); } else { clearInterval(upFloat); divElement.remove(); } }, IntervalMS); }); }, 2500); } } var id = $('.likebox').data('id'); if ($.cookie('likes_' + id)) { $('.likebox').find(".b2font").replaceWith('<i class="b2font b2-heart-fill red"></i>'); } $('.likebox').click(function () { var id = $(this).data('id'); if ($.cookie('likes_' + id)) { commentDanger.message("您已点过赞了,请勿重复赞!"); } else { $(this).find('#support_number').text(parseInt($(this).find('#support_number').text()) + 1); // $(this).find(".b2font").addClass('red'); $(this).find(".b2font").replaceWith('<i class="b2font b2-heart-fill red"></i>'); var likeslink = $(this).data('likeslink'); var likes = parseInt($(this).find('.likes').text()) $.ajax({ url: likeslink, data: { 'likes': likes }, success: function (response, status) { commentSuccess.message("点赞!"); window.location.reload(); $(this).find(".b2font").replaceAll('<i class="b2font b2-heart-fill red"></i>'); }, error: function (xhr, status, error) { alert('返回数据异常!'); } }); } ; }) function updateimg() { $('#codeimg').attr('src', '/core/code.php?' + Math.round(Math.random() * 10)); } //评论回复弹框 $('.replybtn').on("click", function () { var url = $(this).data("action"); $("#reply").modal("show"); $("#replyform").data("action", url); }); //提交评论 function submitcomment(obj) { var url = $(obj).data("action"); //console.log(url); var comment = $(obj).find("#comment").val(); //alert(comment.length); var checkcode = $(obj).find("#checkcode").val(); //alert(checkcode); //console.log('2'); if (comment.length > 0 || comment.length > 3) { $.ajax({ type: 'POST', url: url, date: new Date(), cache: true, async: true, dataType: 'json', data: { comment: comment, checkcode: checkcode }, success: function (response, status) { if (response.code) { // alert(response.data); commentSuccess.message(response.data); $(obj)[0].reset(); $(".modal").modal("hide"); } else { commentDanger.message(response.data); if (response.tourl != "") { if (confirm(response.data + '是否立即跳转登录?')) { location.href = response.tourl; } } $('.codeimg').click(); //更新验证码 } }, error: function (xhr, status, error) { alert('返回数据异常!'); } }); } else { alert('請輸入數據!'); } return false; } </script> <script> var Page = 1; var load = false; var scode = jQuery(".scode").text(); var sortname = jQuery(".name").text(); var Dom = jQuery('.related-posts-in'); var List = jQuery('.b2-widget-list-ul'); Page = parseInt(Page); fs(); hot_list(); function fs() { var Num = 4; var url = '/api.php/list/' + scode + '/page/' + Page + '/num/' + Num; load = true; jQuery.ajax({ type: 'POST', url: url, cache: true, async: true, dataType: 'json', data: { appid: 'admin', timestamp: '1747500234', signature: '01f4913927e9095d18613697a3f1da09', }, success: function (response, status) { var Data = response.data; if (response.code) { jQuery.each(Data, function (index, value,) { if (value.ico == null || value.ico == "") { var Html = '<div class="related-posts-item">\n' + ' <div>\n' + ' <div class="related-post-thumb">\n' + ' <a href="' + value.contentlink + '" class="link-block lazy_back"></a>\n' + ' <span class="cat"><a href="' + value.sortlink + '">' + value.sortname + '</a></span><span class="img_title"><a\n' + ' href="' + value.contentlink + '" title="' + value.title + '">' + value.title + '</a></span>\n' + ' </div>\n' + ' <a href="' + value.contentlink + '"><h2 title="' + value.title + '">' + value.title + '</h2></a>\n' + ' <div class="post-excerpt" style="margin:0 0 5px 0">\n' + ' <a href="' + value.contentlink + '" style="color: #797C80 !important;" title="' + value.description + '">' + value.description + '</a>\n' + ' </div>\n' + ' <div class="realte-post-meta">\n' + ' <span>' + value.date.slice(0, 11) + '</span>\n' + ' <span><i class="b2font b2-heart-fill "></i>' + value.likes + '</span>\n' + ' <span><i class="b2font b2-eye-fill "></i>' + value.visits + '</span>\n' + ' </div>\n' + ' </div>\n' + ' </div>'; } else { var Html = '<div class="related-posts-item">\n' + ' <div>\n' + ' <div class="related-post-thumb">\n' + ' <a href="' + value.contentlink + '" class="link-block lazy_back"><img src="' + value.ico + '"></a>\n' + ' <span class="cat"><a href="' + value.sortlink + '">' + value.sortname + '</a></span>\n' + ' </div>\n' + ' <a href="' + value.contentlink + '"><h2 title="' + value.title + '">' + value.title + '</h2></a>\n' + ' <div class="post-excerpt" style="margin:0 0 5px 0">\n' + ' <a href="' + value.contentlink + '" style="color: #797C80 !important;" title="' + value.description + '">' + value.description + '</a>\n' + ' </div>\n' + ' <div class="realte-post-meta">\n' + ' <span>' + value.date.slice(0, 11) + '</span>\n' + ' <span><i class="b2font b2-heart-fill "></i>' + value.likes + '</span>\n' + ' <span><i class="b2font b2-eye-fill "></i>' + value.visits + '</span>\n' + ' </div>\n' + ' </div>\n' + ' </div>'; } Dom.append(Html); }); load = false; return Page += 1; } else { $('.related-posts').hide(); } }, error: function (xhr, status, error) { console.log(error); } }) } function hot_list() { var listNum = []; var number = 0; var nums = 1; var Num = 10; var url = '/api.php/list/' + scode + '/page/' + Page + '/num/' + Num; load = true; jQuery.ajax({ type: 'POST', url: url, cache: true, async: true, dataType: 'json', data: { appid: 'admin', timestamp: '1747500234', signature: '01f4913927e9095d18613697a3f1da09', }, success: function (response, status) { var Data = response.data; for (let i in Data) { listNum.push(Data[i]) } var scrollS = []; var su = number + 10; for (var jj = number; jj < su; jj++) { scrollS.push(listNum[jj]); number = number + 1; } if (response.code) { scrollS.forEach(function (item, index) { var Html = '<li class="b2-widget-box widget-post widget-post-none">\n' + ' <div class="b2-widget-post-order widget-order-'+nums+'"><span\n' + ' class="b2-radius">'+nums+'</span></div>\n' + ' <div class="b2-widget-post-title">\n' + ' <a href="' + item['contentlink'] +'"><h2 title="' + item['title'] +'">' + item['title'] +'</h2></a>\n' + ' </div>\n' + ' </li>'; List.append(Html); nums++; }) // }); load = false; return Page += 1; } else { $('#b2-widget-hot-4').hide(); } }, error: function (xhr, status, error) { console.log(error); } }) } </script>