SSM项目开发中的实体定义以及MySQL表格设计

话不多说，下面表格是项目开发中用到的实体集以及表格Name
实体创建     表格创建

Area 区域

| Area |
| -------- |-------- |-------- |-------- |-------- |-------- |
|实体|areaId|areaName|priority|createTime|lastEditTime|
|表格| area_id| area_name|priority|create_time|last_edit_time|

HeadLine 头条 (用做首页滚动

| HeadLine |
| -------- | -------- |-------- |-------- |-------- |-------- |
|实体|lineId|lineName|lineLink|lineImg|priority|
|表格|line_id|line_name|line_link|line_img|priority|
|实体|enableStatus|createTime|lastEditTime|
|表格|enable_status|create_time|last_edit_time|

PersonInfo 个人信息

| PersonInfo |
| -------- |-------- |-------- |-------- |-------- |-------- |
|实体|userId|name|profileImg|email|gender|
|表格|user_id |name|profile_img |email |gender |
|实体|enableStatus|userType|createTime|lastEditTime|
|表格|enable_status|user_type|create_time|last_edit_time|

LocalAuth 本地用户

| LocalAuth |
| -------- |-------- |-------- |-------- |-------- |
|实体|localAuthId|personInfo|username|password|
|表格|local_auth_id |user_id|username |password |
|实体|createTime|lastEditTime|
|表格|create_time |last_edit_time|

WechatAuth 微信用户

| WechatAuth |
| -------- |-------- |-------- |-------- |-------- |
|实体|wechatAuthId|personInfo|openId|createTime|
|表格|wechat_auth_id |user_id|open_id | create_time |

ShopCategory 店铺类别

| ShopCategory|
| -------- |-------- |-------- |-------- |
|实体|shopCategoryId|shopCategoryName|shopCategoryDesc|
|表格|shop_category_id|shop_category_name|shop_category_desc|
|实体|shopCategoryImg|priority|parent|
|表格|shop_category_img|priority |parent_id|
|实体|createTime|lastEditTime|
|表格|create_time |last_edit_time|

Shop 商铺

| Shop|
| -------- |-------- |-------- |-------- |-------- |-------- |
|实体|shopId|shopName|shopDesc|area|enableStatus|
|表格|shop_id |shop_name|shop_desc|area_id|enable_status|
|实体|shopAddr|phone|shopImg|priority|shopCategory_id|
|表格|shop_addr|phone |shop_img|priority|shop_category_id|
|实体|createTime|lastEditTime|advice|owner|
|表格|create_time |last_edit_time|advice|owner_id|

ProductCategory 商品种类

|商品种类|
| -------- |-------- |-------- |-------- |
|实体|shopId|productCategoryId|productCategoryName|
|表格|shop_id|product_category_id|product_category_name|
|实体|priority|createTime|
|表格|priority|create_time|

Product 商品

|商品|
| -------- |-------- |-------- |-------- |-------- |
|实体|productId|shop|productName|productDesc|
|表格|product_id|shop_id|product_name |product_desc|
|实体|imgAddr|normalPrice|promotionPrice|productCategory|
|表格|img_addr|normal_price|promotion_price|product_category_id|
|实体|priority|createTime|lastEditTime|enableStatus|
|表格|priority|create_time|last_edit_time|enable_status|
|实体|productImgList|
|表格|一对多|

ProductImg 商品图片

|商品|
| -------- |-------- |-------- |-------- |-------- |
|实体|productImgId|productId|imgAddr|imgDesc|
|表格|product_img_id|product_id|img_addr|img_desc |
|实体|priority|createTime|
|表格|priority|create_time|