Fecmall Mongodb数据库介绍 ¶
Fecmall Mongodb数据库的介绍部分
Fecmall Mongodb数据库 ¶
1.article表
{
"_id": ObjectId("5a17f1b3bfb7ae261d64e956"),
"created_at": NumberInt(1511518643), // 创建时间戳
"created_user_id": NumberInt(1), // 后台创建用户id
"updated_at": NumberInt(1512354840), // 更新时间戳
"url_key": "/about-us-39654914", // url key,也就是在前端显示的自定义urlkey
"title": { // page的标题，下面是各个语言对应的值，
"title_en": "about us",
"title_fr": "",
"title_de": "",
"title_es": "",
"title_ru": "",
"title_pt": "",
"title_zh": "关于我们"
},
"meta_keywords": { // page的meta信息
"meta_keywords_en": "about us",
"meta_keywords_fr": "",
"meta_keywords_de": "",
"meta_keywords_es": "",
"meta_keywords_ru": "",
"meta_keywords_pt": "",
"meta_keywords_zh": ""
},
"meta_description": { // page的meta信息
"meta_description_en": "",
"meta_description_fr": "",
"meta_description_de": "",
"meta_description_es": "",
"meta_description_ru": "",
"meta_description_pt": "",
"meta_description_zh": ""
},
"content": { // page的内容
"content_en": "<p><span id=\"result_box\" lang=\"en\"><span title=\"Fecshop 全称为Fancy ECommerce Shop，是基于php Yii2框架之上开发的一款优秀的开源电商系统， 遵循OSL3.0开源协议，Fecshop支持多语言，多货币，架构上支持pc，手 [...]",
"content_fr": "<span id=\"result_box\" lang=\"fr\"><span title=\"Fecshop 全称为Fancy ECommerce Shop，是基于php Yii2框架之上开发的一款优秀的开源电商系统， 遵循OSL3.0开源协议，Fecshop支持多语言，多货币，架构上支持pc，手机we [...]",
"content_de": "",
"content_es": "",
"content_ru": "",
"content_pt": "",
"content_zh": "Fecshop 全称为Fancy ECommerce Shop，是基于php Yii2框架之上开发的一款优秀的开源电商系统，遵循OSL3.0开源协议，Fecshop支持多语言，多货币，架构上支持pc，手机web，手机app，和erp对接等入口，您可以免费快速的定制和部署属于您的电商系统。预计到201 [...]"
},
"status": NumberInt(1) // page的状态，1代表激活，2代表关闭
}
2.category
分类表
{
"_id": ObjectId("5a1b673ebfb7ae44c26734f2"),
"created_at": NumberInt(1511745342),
"created_user_id": NumberInt(1),
"level": NumberInt(1), // 菜单的级别，一级菜单是1，二级菜单是2，...
"updated_at": NumberInt(1511745342),
"parent_id": "0", // 分类的父分类id，如果是`0`,则代表是一级分类
"name": { // 分类的名字，下面是各个语言对应的名字
"name_en": "Wedding2222",
"name_fr": "",
"name_de": "",
"name_es": "",
"name_ru": "",
"name_pt": "",
"name_zh": "婚礼"
},
"status": NumberInt(1), // 分类的状态
"menu_show": NumberInt(1), // 分类是否在前端菜单中显示，1代表显示，2代表不显示，不显示并不代表关闭状态，通过url还是可以访问的
"url_key": "/wedding-46851137", // 分类自定义urlkey
"filter_product_attr_selected": "style,dresses-length,pattern-type,sleeve-length,collar,color", // 分类侧栏属性过滤添加的属性
"filter_product_attr_unselected": "", // 分类侧栏属性过滤去除的属性
"description": { // 分类的描述
"description_en": "",
"description_fr": "",
"description_de": "",
"description_es": "",
"description_ru": "",
"description_pt": "",
"description_zh": ""
},
"menu_custom": { // 分类自定义html
"menu_custom_en": "<a href=\"//fecshop.appfront.fancyecommerce.com/wedding\"><img alt=\"\" src=\"//img.fancyecommerce.com/custom/menu/what_a.jpg\" width=\"244\" /></a><a style=\" [...]",
"menu_custom_fr": "<a href=\"//fecshop.appfront.fancyecommerce.com/fr/wedding\"><img alt=\"\" src=\"//img.fancyecommerce.com/custom/menu/what_a.jpg\" width=\"244\" /></a><a styl [...]",
"menu_custom_de": "",
"menu_custom_es": "",
"menu_custom_ru": "",
"menu_custom_pt": "",
"menu_custom_zh": ""
},
"title": { // 分类标题
"title_en": "Wedding",
"title_fr": "",
"title_de": "",
"title_es": "",
"title_ru": "",
"title_pt": "",
"title_zh": ""
},
"meta_description": { // 分类meta 信息
"meta_description_en": "",
"meta_description_fr": "",
"meta_description_de": "",
"meta_description_es": "",
"meta_description_ru": "",
"meta_description_pt": "",
"meta_description_zh": ""
},
"meta_keywords": { // 分类 meta 信息
"meta_keywords_en": "",
"meta_keywords_fr": "",
"meta_keywords_de": "",
"meta_keywords_es": "",
"meta_keywords_ru": "",
"meta_keywords_pt": "",
"meta_keywords_zh": ""
}
}
表：error_handler_log
通过Yii2的errorHandle机制，将所有出现错误信息，保存到表中（生产环境）
{
"_id": ObjectId("5a34d9d2bfb7ae0ec26cc9e3"),
"category": "appapi", // 入口名称。
"code": NumberInt(404), // http status ，http状态码
"message": "Page not found.", // 错误信息
"file": "/www/web/develop/fecshop/vendor/yiisoft/yii2/web/Application.php", // 错误文件
"line": NumberInt(114), // 文件所在的行（改行代码执行导致的错误）
"created_at": NumberInt(1513413074),
"ip": "106.11.225.134", // 访问者的id
"name": "Not Found", // 错误名称
"url": "//fecshop.appapi.fancyecommerce.com/", // 访问的url
"request_info": { // request 信息
"ajax": NumberInt(0),
"request_type": "get",
"request_data": [
],
"headers_data": { // header信息。
"accept-encoding": [
"gzip"
],
"user-agent": [
"Mozilla/5.0 (iPad; CPU OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1"
],
"cache-control": [
"no-cache"
],
"pragma": [
"no-cache"
],
"host": [
"fecshop.appapi.fancyecommerce.com"
],
"accept": [
"text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2"
],
"connection": [
"keep-alive"
]
},
"userHost": null,
"userIP": "106.11.225.134"
},
// 错误追踪信息
"trace_string": "#0 /www/web/develop/fecshop/vendor/yiisoft/yii2/base/Application.php(380): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))\n#1 /www/web/dev [...]"
}
表：Favorite
产品收藏信息表
{
"_id": ObjectId("5a31e3cabfb7ae29c040a042"),
"product_id": "580835d0f656f240742f0b7c",
"user_id": NumberInt(383), // customer表的id
"created_at": NumberInt(1513219018),
"updated_at": NumberInt(1513219018),
"store": "fecshop.appfront.fancyecommerce.com/cn" // store的key
}
表：fecshop_service_log 废弃
表：log_product_view 废弃
表：migration，mongodb表的Yii2 migration信息。也就是安装fecshop，以及 升级fecshop数据库部分的信息
表：newsletter
订阅邮件
{
"_id": ObjectId("5a31e0bfbfb7ae332a4228f3"),
"email": "logig618@gmail.com",
"created_at": NumberInt(1513218239),
"status": NumberInt(1)
}
表：review
产品评论
{
"_id": ObjectId("5a3083bbbfb7ae0f2760d422"),
"product_spu": "p10001",
"product_id": "580835d0f656f240742f0b7c",
"rate_star": "5",
"name": "44444 666",
"user_id": NumberInt(46),
"ip": "113.116.126.150",
"summary": "99999999999",
"review_content": "99999999999999999999999",
"review_date": NumberInt(1513128891),
"store": "fecshop.apphtml5.fancyecommerce.com",
"lang_code": "en", // 语言
"status": NumberInt(1), // 评论审核状态 ，10是默认状态，1是审核通过，2是审核拒绝状态
"audit_user": NumberInt(2), // 评论后台审核人
"audit_date": NumberInt(1513129505) // 评论后台审核日志
}
表：static_block
static block 部分，和mysql的 static_block 类似
表：url_rewrite
url重写存储部分，和mysql的url_rewrite类似
表：product_flat
产品信息表，产品表的库存放到了mysql中，其他的信息都在这张表中
{
"_id": ObjectId("5a1c2ae6bfb7ae0ee472ae15"),
"created_at": NumberInt(1511795430),
"created_user_id": NumberInt(1),
"updated_at": NumberInt(1511795430),
"name": { // 产品名称
"name_en": "test computer",
"name_fr": "",
"name_de": "",
"name_es": "",
"name_ru": "",
"name_pt": "",
"name_zh": "测试计算机"
},
"spu": "computer001",
"sku": "computer001-xinghao1-cpu36",
"weight": 0.3, // 产品重量
"score": NumberInt(0), // 产品的评分，这个可以通过销量值填写进去
"status": NumberInt(1), // 产品的状态，1代表激活，2代表下架
"qty": NumberInt(334), // 产品的库存，这个字段已经无效，库存在mysql中
"min_sales_qty": NumberInt(0), // 产品的最小销售个数
"is_in_stock": NumberInt(1), // 产品 的库存状态，1代表有库存，2代表无库存
"category": [ // 产品的分类id。可以多个
"57beb586f656f275313bf57a"
],
"price": 33, // 产品的销售价格
"cost_price": 10, // 产品的成本价格
"tier_price": [ // 产品批发价格
{
"qty": NumberInt(2),
"price": NumberInt(30)
},
{
"qty": NumberInt(4),
"price": NumberInt(28)
}
],
"final_price": 33, // 产品最终价格（这个值是通过脚本批量计算得来，仅仅作为分类搜索页面价格的排序和过滤）
"meta_keywords": { // 产品meta信息
"meta_keywords_en": "sex xx meta keywords",
"meta_keywords_fr": "",
"meta_keywords_de": "",
"meta_keywords_es": "",
"meta_keywords_ru": "",
"meta_keywords_pt": "",
"meta_keywords_zh": ""
},
"meta_description": { // 产品meta信息
"meta_description_en": "sex xx meta keywords sex xx meta keywords sex xx meta keywords",
"meta_description_fr": "",
"meta_description_de": "",
"meta_description_es": "",
"meta_description_ru": "",
"meta_description_pt": "",
"meta_description_zh": ""
},
"image": { // 产品的图片
"main": { // 产品主图
"image": "/1/11/111147807271192428.jpg",
"label": "",
"sort_order": "",
"is_thumbnails": "1", // 产品详情页面：图片是否在橱窗图中显示，1代表显示
"is_detail": "1" // 产品详情页面：图片是否在描述中显示，1代表显示
},
"gallery": [ // 产品的细节图
{
"image": "/2/01/20161024170457_13851.jpg",
"label": "",
"sort_order": ""
},
{
"image": "/2/01/20161024170457_21098.jpg",
"label": "",
"sort_order": ""
},
{
"image": "/2/01/20161101155240_26690.jpg",
"label": "",
"sort_order": ""
},
{
"image": "/2/01/20161101155240_56328.jpg",
"label": "",
"sort_order": ""
},
{
"image": "/2/01/20161101155240_94256.jpg",
"label": "",
"sort_order": ""
}
]
},
"description": { // 产品描述信息
"description_en": "3333",
"description_fr": "",
"description_de": "",
"description_es": "",
"description_ru": "",
"description_pt": "",
"description_zh": ""
},
"short_description": { // 产品短描述信息
"short_description_en": "334343",
"short_description_fr": "",
"short_description_de": "",
"short_description_es": "",
"short_description_ru": "",
"short_description_pt": "",
"short_description_zh": ""
},
"custom_option": { // 产品 custom option部分，也就是淘宝模式的颜色尺码这类属性
"red-s-s2-s3": {
"my_color": "red",
"my_size": "S",
"my_size2": "S2",
"my_size3": "S3",
"sku": "red-s-s2-s3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161024170457_10036.jpg"
},
"red-m-s2-s3": {
"my_color": "red",
"my_size": "M",
"my_size2": "S2",
"my_size3": "S3",
"sku": "red-m-s2-s3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161024170457_10036.jpg"
},
"red-m-m2-s3": {
"my_color": "red",
"my_size": "M",
"my_size2": "M2",
"my_size3": "S3",
"sku": "red-m-m2-s3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161024170457_10036.jpg"
},
"red-m-m2-m3": {
"my_color": "red",
"my_size": "M",
"my_size2": "M2",
"my_size3": "M3",
"sku": "red-m-m2-m3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161024170457_10036.jpg"
},
"red-m-m2-l3": {
"my_color": "red",
"my_size": "M",
"my_size2": "M2",
"my_size3": "L3",
"sku": "red-m-m2-l3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161024170457_10036.jpg"
},
"red-m-l2-l3": {
"my_color": "red",
"my_size": "M",
"my_size2": "L2",
"my_size3": "L3",
"sku": "red-m-l2-l3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161024170457_10036.jpg"
},
"red-m-l2-s3": {
"my_color": "red",
"my_size": "M",
"my_size2": "L2",
"my_size3": "S3",
"sku": "red-m-l2-s3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161024170457_10036.jpg"
},
"red-m-l2-m3": {
"my_color": "red",
"my_size": "M",
"my_size2": "L2",
"my_size3": "M3",
"sku": "red-m-l2-m3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161024170457_10036.jpg"
},
"red-l-l2-m3": {
"my_color": "red",
"my_size": "L",
"my_size2": "L2",
"my_size3": "M3",
"sku": "red-l-l2-m3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161024170457_10036.jpg"
},
"red-l-m2-m3": {
"my_color": "red",
"my_size": "L",
"my_size2": "M2",
"my_size3": "M3",
"sku": "red-l-m2-m3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161024170457_10036.jpg"
},
"red-l-m2-l3": {
"my_color": "red",
"my_size": "L",
"my_size2": "M2",
"my_size3": "L3",
"sku": "red-l-m2-l3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161024170457_10036.jpg"
},
"black-s-s2-s3": {
"my_color": "black",
"my_size": "S",
"my_size2": "S2",
"my_size3": "S3",
"sku": "black-s-s2-s3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161101155240_56328.jpg"
},
"black-s-l2-s3": {
"my_color": "black",
"my_size": "S",
"my_size2": "L2",
"my_size3": "S3",
"sku": "black-s-l2-s3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161101155240_56328.jpg"
},
"black-s-xl2-s3": {
"my_color": "black",
"my_size": "S",
"my_size2": "XL2",
"my_size3": "S3",
"sku": "black-s-xl2-s3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161101155240_56328.jpg"
},
"black-s-s2-l3": {
"my_color": "black",
"my_size": "S",
"my_size2": "S2",
"my_size3": "L3",
"sku": "black-s-s2-l3",
"qty": NumberInt(9999),
"price": NumberInt(0),
"image": "/2/01/20161101155240_56328.jpg"
},
"blue-s-s2-s3": {
"my_color": "blue",
"my_size": "S",
"my_size2": "S2",
"my_size3": "S3",
"sku": "blue-s-s2-s3",
"qty": NumberInt(9999),
"price": 5,
"image": "/2/01/20161101155240_94256.jpg"
}
},
"attr_group": "test_group", // 产品属性组
"relation_sku": "", // 产品相关产品
"buy_also_buy_sku": "", // 产品买了还买
"see_also_see_sku": "", // 产品看了还看
"my_remark": "111", // 下面是属性组中定义的属性，
"my_email": "1111@22.com",
"my_date": "2016-11-03",
"style": "Cute",
"dresses-length": "Mini",
"pattern-type": "Animal",
"sleeve-length": "Sleeveless",
"collar": "Round Neck",
"url_key": "/test-computer-92982496", // 产品urlkey
"reviw_rate_star_average": 5, // 产品平均评分
"review_count": NumberInt(3), // 产品评论个数
"reviw_rate_star_average_lang": { // 产品在各个语言的评分
"reviw_rate_star_average_lang_zh": 5,
"reviw_rate_star_average_lang_en": 4
},
"review_count_lang": { // 产品在各个语言的评论数
"review_count_lang_zh": NumberInt(1),
"review_count_lang_en": NumberInt(2)
}
}