这个数据库包含多个表，如用户account、商品product、订单order_info、评论comments等，涵盖了用户账户、商品信息、订单历史和物流等多个方面，实现了电子商务平台的数据管理。数据库设计考虑了交易流程中的关键信息，如用户余额、商品价格、订单状态和支付记录等。
answer |
account
article
article_category
comments
contect
demo_product
ewallet
logistics
option_info
option_value
order_history
order_info
order_item
order_option
payment_history
product
product_category
product_image
product_option_info
sequence
sku
user
user_roles
wishlist
| account | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
username | varchar(45) | utf8_general_ci | NO |
| (NULL) |
| select,insert,update,references |
|
amount | double(11,0) | (NULL) | NO |
| (NULL) |
| select,insert,update,references | 账户余额 |
source | varchar(255) | utf8_general_ci | NO |
| (NULL) |
| select,insert,update,references | 财富来源：注册赠送 或者 个人充值 或者 商城消费 |
updtime | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
account | 0 | PRIMARY | 1 | id | A | 51 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| article | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
content | text | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
category | varchar(5) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
update_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
update_user_id | varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
title | varchar(255) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
article | 0 | PRIMARY | 1 | id | A | 8 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| article_category | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
category_id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
category_name | varchar(255) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
update_user_id | varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
update_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
article_category | 0 | PRIMARY | 1 | category_id | A | 14 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| comments | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
user_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
product_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
content | text | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
audit | int(1) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
stars | int(1) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
create_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
comments | 0 | PRIMARY | 1 | id | A | 39 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| contect | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
user_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
name | varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
mobile | varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
contact_flag | int(1) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
address | varchar(255) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
contect | 0 | PRIMARY | 1 | id | A | 16 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| demo_product | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
price | int(11) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
name | varchar(255) | utf8_general_ci | YES |
| (NULL) |
| select,insert,update,references |
|
info | text | utf8_general_ci | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
demo_product | 0 | PRIMARY | 1 | id | A | 6 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| ewallet | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
amount | int(11) | (NULL) | NO |
| 0 |
| select,insert,update,references | 注册用户电子钱包默认金额 |
updtime | datetime | (NULL) | NO |
| (NULL) |
| select,insert,update,references | 更新时间 |
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
ewallet | 0 | PRIMARY | 1 | id | A | 5 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| logistics | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
company_name | varchar(64) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
logistics_num | varchar(32) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
order_num | varchar(20) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
state | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
contact_name | varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
contact_mobile | varchar(20) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
contact_address | varchar(300) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
create_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
logistics | 0 | PRIMARY | 1 | id | A | 15 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| option_info | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
name | varchar(50) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
type | int(2) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
option_info | 0 | PRIMARY | 1 | id | A | 5 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| option_value | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
option_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
name | varchar(50) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
option_value | 0 | PRIMARY | 1 | id | A | 11 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| order_history | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
order_num | varchar(20) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
status | int(2) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
note | varchar(300) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
update_user_id | int(5) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
create_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
order_history | 0 | PRIMARY | 1 | id | A | 74 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| order_info | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
order_num | varchar(20) | utf8_bin | NO | PRI | (NULL) |
| select,insert,update,references |
|
price | varchar(10) | utf8_bin | YES |
| 0 |
| select,insert,update,references |
|
payment_flag | int(1) | (NULL) | NO |
| 0 |
| select,insert,update,references |
|
user_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
contact_name | varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
contact_mobile | varchar(20) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
contact_address | varchar(300) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
message | varchar(300) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
status | int(2) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
type | int(2) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
create_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
order_info | 0 | PRIMARY | 1 | order_num | A | 53 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| order_item | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | varchar(36) | utf8_bin | NO | PRI | (NULL) |
| select,insert,update,references |
|
order_num | varchar(20) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
product_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
price | int(8) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
quantity | int(4) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
user_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
json_data | text | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
sku_id | int(11) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
option_value_key_group | varchar(80) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
order_item | 0 | PRIMARY | 1 | id | A | 81 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| order_option | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
order_Item_Id | varchar(36) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
option_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
option_value_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
option_value_name | varchar(50) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
option_name | varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
option_value_key | varchar(255) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
order_option | 0 | PRIMARY | 1 | id | A | 0 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| payment_history | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
order_num | varchar(20) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
product_price | int(10) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
payment_type | int(2) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
user_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
payment_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
payment_history | 0 | PRIMARY | 1 | id | A | 46 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| product | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
name | varchar(100) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
category_id | int(4) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
explain | text | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
general_explain | varchar(255) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
discount | int(4) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
shop_price | int(8) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
price | int(8) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
external_id | varchar(100) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
quantity | int(8) | (NULL) | YES |
| 0 |
| select,insert,update,references |
|
hot | int(1) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
product_status | int(1) | (NULL) | NO |
| 0 |
| select,insert,update,references |
|
inventory_flag | int(1) | (NULL) | NO |
| 0 |
| select,insert,update,references |
|
default_img | varchar(255) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
update_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
update_user_id | int(5) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
create_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
create_user_id | int(5) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
product | 0 | PRIMARY | 1 | id | A | 65 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| product_category | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(4) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
name | varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
sort_order | int(4) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
description | text | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
image | varchar(255) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
update_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
update_user_id | int(5) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
product_category | 0 | PRIMARY | 1 | id | A | 16 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| product_image | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
product_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
url | varchar(255) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
explain | text | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
update_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
update_user_id | int(5) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
product_image | 0 | PRIMARY | 1 | id | A | 13 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| product_option_info | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
product_id | int(11) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
option_id | int(11) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
product_option_info | 0 | PRIMARY | 1 | id | A | 8 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| sequence | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
type_code | varchar(10) | utf8_bin | NO | PRI |
|
| select,insert,update,references |
|
counter_key | varchar(10) | utf8_bin | NO | PRI |
|
| select,insert,update,references |
|
no_counter | int(9) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
sequence | 0 | PRIMARY | 1 | type_code | A | 2 | (NULL) | (NULL) |
| BTREE |
|
|
sequence | 0 | PRIMARY | 2 | counter_key | A | 34 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| sku | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
sku_json | text | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
product_id | int(11) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
quantity | int(11) | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
price | int(11) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
option_value_key_group | varchar(255) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
sku | 0 | PRIMARY | 1 | id | A | 26 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| user | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
user_name | varchar(50) | utf8_bin | NO | UNI | (NULL) |
| select,insert,update,references |
|
pwd | varchar(100) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
nickname | varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
| |
enabled | int(2) | (NULL) | NO |
| 0 |
| select,insert,update,references |
|
open_id | varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
oauth_type | varchar(50) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
image | varchar(255) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
last_login_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
register_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
user | 0 | PRIMARY | 1 | id | A | 37 | (NULL) | (NULL) |
| BTREE |
|
|
user | 0 | user_name | 1 | user_name | A | 37 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| user_roles | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
user_role_id | int(11) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
username | varchar(45) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
role | varchar(45) | utf8_bin | NO |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
user_roles | 0 | PRIMARY | 1 | user_role_id | A | 37 | (NULL) | (NULL) |
| BTREE |
|
|
Back
| wishlist | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id | int(5) | (NULL) | NO | PRI | (NULL) | auto_increment | select,insert,update,references |
|
product_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
option_value_ids | varchar(255) | utf8_bin | YES |
| (NULL) |
| select,insert,update,references |
|
user_id | int(5) | (NULL) | NO |
| (NULL) |
| select,insert,update,references |
|
mark_time | datetime | (NULL) | YES |
| (NULL) |
| select,insert,update,references |
|
| Indexes |
| Table | Non unique | Key name | Seq in index | Column name | Collation | Cardinality | Sub part | Packed | Null | Index type | Comment | Index comment |
wishlist | 0 | PRIMARY | 1 | id | A | 55 | (NULL) | (NULL) |
| BTREE |
|
|
Back
扫一扫
8341
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
