|
|
|
# 传统电商店铺数据表
|
|
|
|
|
|
|
|
```
|
|
|
|
传统电商平台包括淘宝、天猫、1688、京东、苏宁、国美、蘑菇街、聚美优品、网易考拉等
|
|
|
|
```
|
|
|
|
|
|
|
|
### 数据存储
|
|
|
|
|
|
|
|
```
|
|
|
|
阿里云Mysql，tb_ebusiness_shop.company_id 关联的企业信息存储在指南针的应用库，通过指南针的一个接口去查询企业信息
|
|
|
|
```
|
|
|
|
|
|
|
|
- host: bdp-rds-009.mysql.rds.aliyuncs.com
|
|
|
|
- user: ***
|
|
|
|
- password: ***
|
|
|
|
- database: utn_ec
|
|
|
|
- table: tb_ebusiness_shop
|
|
|
|
|
|
|
|
### 数据结构
|
|
|
|
|
|
|
|
```
|
|
|
|
{
|
|
|
|
"shop_id": "自增主键",
|
|
|
|
"platform_name": "平台名称",
|
|
|
|
"shop_name": "店铺名称",
|
|
|
|
"shop_url": "店铺网址",
|
|
|
|
"user_rate_url": "卖家信息页网址",
|
|
|
|
"platform_shop_id": "店铺ID",
|
|
|
|
"unique_shop_id": "店铺唯一标识摘要",
|
|
|
|
"shop_type": "店铺类型",
|
|
|
|
"contactor_id": "卖家ID",
|
|
|
|
"contactor_name": "卖家名称",
|
|
|
|
"shop_create_time": "开店时间",
|
|
|
|
"open_time": "开店时长（年）",
|
|
|
|
"is_dead": "是否下线",
|
|
|
|
"dead_time": "下线时间",
|
|
|
|
"company_id": "企业ID",
|
|
|
|
"company_name": "企业名称",
|
|
|
|
"company_name_digest": "企业名称摘要",
|
|
|
|
"lightup": "是否亮照",
|
|
|
|
"is_self": "是否自营",
|
|
|
|
"category_lv1": "店铺一级分类（淘宝归一）",
|
|
|
|
"category_lv2": "店铺二级分类（淘宝归一）",
|
|
|
|
"category_lv3": "店铺三级分类（淘宝归一）",
|
|
|
|
"platform_category_lv1": "店铺一级分类（平台）",
|
|
|
|
"platform_category_lv2": "店铺二级分类（平台）",
|
|
|
|
"platform_category_lv3": "店铺三级分类（平台）",
|
|
|
|
"province": "省份",
|
|
|
|
"city": "城市",
|
|
|
|
"county": "地区",
|
|
|
|
"total_sold": "总销量",
|
|
|
|
"total_count": "",
|
|
|
|
"fans_count": "粉丝数",
|
|
|
|
"order_num": "",
|
|
|
|
"tel_phone": "联系电话",
|
|
|
|
"delivery_location": "商品发货地",
|
|
|
|
"current_location": "平台标记地区",
|
|
|
|
"area_empty": "",
|
|
|
|
"shop_credit_rate": "",
|
|
|
|
"shop_score": "",
|
|
|
|
"describe_score": "宝贝与描述相符",
|
|
|
|
"describe_compare": "比同行业平均水平（宝贝描述相符）",
|
|
|
|
"service_score": "卖家的服务态度",
|
|
|
|
"service_compare": "比同行业平均水平（卖家服务态度）",
|
|
|
|
"logistics_score": "物流服务的质量",
|
|
|
|
"logistics_compare": "比同行业平均水平（物流服务质量）",
|
|
|
|
"create_time": "创建时间",
|
|
|
|
"update_time": "更新时间"
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
|
|
|
### 数据字典
|
|
|
|
|
|
|
|
| 字段名 | 字段类型 | 注释 |
|
|
|
|
| --------------------- | ----------- | ------------------------------------------------------------ |
|
|
|
|
| platform_name | varchar | 平台名称 |
|
|
|
|
| shop_name | varchar | 店铺名称 |
|
|
|
|
| shop_url | varchar | 店铺网址 |
|
|
|
|
| user_rate_url | varchar | 卖家信息页网址 |
|
|
|
|
| platform_shop_id | varchar | 店铺ID |
|
|
|
|
| unique_shop_id | varchar | 店铺唯一标识摘要，md5(platform_name+platform_shop_id)，其中天猫和淘宝平台统一使用md5(淘宝+platform_shop_id) |
|
|
|
|
| shop_type | tinyint | 店铺类型，1：B店 2: C店 |
|
|
|
|
| contactor_id | varchar | 卖家ID |
|
|
|
|
| contactor_name | varchar | 卖家名称 |
|
|
|
|
| shop_create_time | varchar | 开店时间 |
|
|
|
|
| open_time | varchar | 开店时长（年） |
|
|
|
|
| is_dead | tinyint | 是否下线，0：正常营业 1：店铺已下线 |
|
|
|
|
| dead_time | datetime | 下线时间 |
|
|
|
|
| company_id | int | 企业ID |
|
|
|
|
| company_name | varchar | 企业名称 |
|
|
|
|
| company_name_digest | varchar | 企业名称摘要 |
|
|
|
|
| ~~lightup~~ | ~~tinyint~~ | ~~是否亮照（未更新）~~ |
|
|
|
|
| is_self | tinyint | 是否自营，0：非自营 1：自营（京东平台特有） |
|
|
|
|
| category_lv1 | varchar | 店铺一级分类（淘宝归一） |
|
|
|
|
| category_lv2 | varchar | 店铺二级分类（淘宝归一） |
|
|
|
|
| category_lv3 | varchar | 店铺三级分类（淘宝归一） |
|
|
|
|
| platform_category_lv1 | varchar | 店铺一级分类（平台） |
|
|
|
|
| platform_category_lv2 | varchar | 店铺二级分类（平台） |
|
|
|
|
| platform_category_lv3 | varchar | 店铺三级分类（平台） |
|
|
|
|
| province | varchar | 省份 |
|
|
|
|
| city | varchar | 城市 |
|
|
|
|
| county | varchar | 地区 |
|
|
|
|
| ~~total_sold~~ | ~~bigint~~ | ~~总销量（未更新）~~ |
|
|
|
|
| ~~total_count~~ | ~~int~~ | ~~（未更新）~~ |
|
|
|
|
| ~~fans_count~~ | ~~bigint~~ | ~~粉丝数（未更新）~~ |
|
|
|
|
| ~~order_num~~ | ~~int~~ | ~~（未更新）~~ |
|
|
|
|
| ~~tel_phone~~ | ~~varchar~~ | ~~联系电话（未更新）~~ |
|
|
|
|
| delivery_location | varchar | 商品发货地 |
|
|
|
|
| current_location | varchar | 所在地区（平台卖家信息里标记） |
|
|
|
|
| ~~area_empty~~ | ~~tinyint~~ | ~~（未更新）~~ |
|
|
|
|
| ~~shop_credit_rate~~ | ~~varchar~~ | ~~（未更新）~~ |
|
|
|
|
| ~~shop_score~~ | ~~double~~ | ~~（未更新）~~ |
|
|
|
|
| describe_score | double | 宝贝与描述相符 |
|
|
|
|
| describe_compare | varchar | 比同行业平均水平（宝贝描述相符） |
|
|
|
|
| service_score | double | 卖家的服务态度 |
|
|
|
|
| service_compare | varchar | 比同行业平均水平（卖家服务态度） |
|
|
|
|
| logistics_score | double | 物流服务的质量 |
|
|
|
|
| logistics_compare | varchar | 比同行业平均水平（物流服务质量） |
|
|
|
|
| create_time | datetime | 创建时间 |
|
|
|
|
| update_time | datetime | 更新时间 |
|
|
|
|
|
|
|
|
### 样例
|
|
|
|
|
|
|
|
```
|
|
|
|
{
|
|
|
|
"shop_id": 4958,
|
|
|
|
"platform_name": "天猫",
|
|
|
|
"shop_name": "nike官方旗舰店",
|
|
|
|
"shop_url": "http://shop71955116.taobao.com",
|
|
|
|
"user_rate_url": "https://rate.taobao.com/user-rate-UOmkWMmgyvFg4.htm",
|
|
|
|
"platform_shop_id": "71955116",
|
|
|
|
"unique_shop_id": "574ebea2da1677c1a6fcea73fb1d07ab",
|
|
|
|
"shop_type": 1,
|
|
|
|
"contactor_id": "890482188",
|
|
|
|
"contactor_name": "nike官方旗舰店",
|
|
|
|
"shop_create_time": "2012-05-18 14:00:43",
|
|
|
|
"open_time": "9",
|
|
|
|
"is_dead": 0,
|
|
|
|
"dead_time": null,
|
|
|
|
"company_id": 5453159,
|
|
|
|
"company_name": "耐克商业（中国）有限公司",
|
|
|
|
"company_name_digest": null,
|
|
|
|
"lightup": 1,
|
|
|
|
"is_self": null,
|
|
|
|
"category_lv1": "运动户外",
|
|
|
|
"category_lv2": null,
|
|
|
|
"category_lv3": null,
|
|
|
|
"platform_category_lv1": null,
|
|
|
|
"platform_category_lv2": null,
|
|
|
|
"platform_category_lv3": null,
|
|
|
|
"province": "上海市",
|
|
|
|
"city": "上海市",
|
|
|
|
"county": "杨浦区",
|
|
|
|
"total_sold": 268038,
|
|
|
|
"total_count": 1628,
|
|
|
|
"fans_count": 2363,
|
|
|
|
"order_num": 4,
|
|
|
|
"tel_phone": null,
|
|
|
|
"delivery_location": "上海",
|
|
|
|
"current_location": null,
|
|
|
|
"area_empty": 0,
|
|
|
|
"shop_credit_rate": "5846828",
|
|
|
|
"shop_score": null,
|
|
|
|
"describe_score": 4.7,
|
|
|
|
"describe_compare": "-1.55%",
|
|
|
|
"service_score": 4.8,
|
|
|
|
"service_compare": "-1.08%",
|
|
|
|
"logistics_score": 4.8,
|
|
|
|
"logistics_compare": "0.00%",
|
|
|
|
"create_time": "2019-07-24 11:48:19",
|
|
|
|
"update_time": "2021-06-15 03:04:56"
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
|
|
|
### 说明
|
|
|
|
|
|
|
|
1. 当前表的店铺数据来源：通过各平台的店铺搜索接口、店铺信息接口、资质页面等途径，采集店铺的各项信息
|
|
|
|
2. 当前店铺更新情况
|
|
|
|
- 淘宝、天猫
|
|
|
|
- 店铺新增：已暂停
|
|
|
|
- 店铺下线判断：正常
|
|
|
|
- 店铺B、C店判断：正常
|
|
|
|
- 店铺平台判断：正常
|
|
|
|
- 资质采集：正常（受账号限制）
|
|
|
|
- 1688
|
|
|
|
- 店铺新增：已暂停
|
|
|
|
- 店铺下线判断：已暂停
|
|
|
|
- 店铺其他信息更新：已暂停
|
|
|
|
- 京东
|
|
|
|
- 店铺新增：已暂停
|
|
|
|
- 店铺其他信息更新：正常
|
|
|
|
- 苏宁
|
|
|
|
- 店铺新增：已暂停
|
|
|
|
- 店铺其他信息更新：正常
|
|
|
|
- 国美
|
|
|
|
- 店铺新增：已暂停
|
|
|
|
- 店铺其他信息更新：正常 |
|
|
\ No newline at end of file |
