| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| category_id | char(36) | YES | |||
| title | varchar(500) | YES | |||
| summary | longtext | YES | |||
| content | longtext | YES | |||
| featured_image_url | longtext | YES | |||
| status | longtext | YES | |||
| original_price | decimal(10,2) | YES | |||
| current_price | decimal(10,2) | YES | |||
| stock_quantity | int(11) | YES | |||
| is_on_sale | tinyint(1) | YES | |||
| is_pin | tinyint(1) | YES | |||
| display_order | int(11) | YES | |||
| is_deleted | tinyint(1) | YES | |||
| delete_time | datetime(3) | YES | |||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES | |||
| subtitle | longtext | YES | |||
| spec | varchar(1000) | YES | |||
| member_price | decimal(10,2) | YES | |||
| stock_status | longtext | YES | |||
| sales | int(11) | YES | |||
| brand | varchar(200) | YES | |||
| rating | decimal(2,1) | YES | |||
| store_id | char(36) | YES | |||
| barcode | longtext | YES | |||
| detail_html | longtext | YES | |||
| detail_page | longtext | YES | |||
| cloud_warehouse_price | decimal(10,2) | YES | |||
| purchase_price | decimal(10,2) | YES | |||
| unit | longtext | YES | |||
| supplier | longtext | YES | |||
| shelf_life | longtext | YES | |||
| source | longtext | YES | |||
| merchant_id | char(36) | YES | |||
| remark | longtext | YES | |||
| member_price_mode | longtext | YES | |||
| member_price_rate | decimal(5,4) | YES | |||
| promotion_commission_rate | decimal(5,2) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| id | category_id | title | summary | content | featured_image_url | status | original_price | current_price | stock_quantity | is_on_sale | is_pin |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0000d2f3-1978-4e23-aa87-b47796611b06 | c831b0f2-2310-4cc3-a5af-fe8d62b12c8a | 川至美藤椒酸菜鱼调料378g | NULL | NULL | https://www.laibi888.com/file/pdImages/692… | published | 10.05 | 10.00 | 0 | 1 | 0 |
| 00025b95-27f3-4786-b76f-bf3e9730be52 | c523ae21-9fb3-4376-be1d-66c2826be672 | 习酒国韵优品 | NULL | NULL | https://lel-saas.obs.cn-south-1.myhuaweicl… | published | 254.93 | 238.00 | 0 | 1 | 0 |
| 0003cbbf-9d90-44bc-bdef-b6853b53c44c | 567c50e4-37bb-435c-8d73-223989a69e41 | 洁柔厨房湿巾25片装 | NULL | NULL | https://dbs-saas-pro.obs.cn-south-1.myhuaw… | published | 12.36 | 12.36 | 0 | 1 | 0 |