Data dictionary
1. addresses
Description: User address table
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
customer_id | INT(10) UNSIGNED | Not null | | Customer ID |
name | VARCHAR(191) | Not null | | Name |
phone | VARCHAR(191) | Not null | | Telephone |
country_id | INT(10) UNSIGNED | Not null | | Country ID |
zone_id | INT(10) UNSIGNED | Not null | | Province ID |
zone | VARCHAR(191) | Not null | | Province name |
city_id | INT(10) UNSIGNED | | NULL | City ID |
city | VARCHAR(191) | Not null | | City Name |
zipcode | VARCHAR(191) | Not null | | post code |
address_1 | VARCHAR(191) | Not null | | Address 1 |
address_2 | VARCHAR(191) | Not null | | Address 2 |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
customer_id | customer_id | INDEX | |
country_id | country_id | INDEX | |
zone_id | zone_id | INDEX | |
city_id | city_id | INDEX | |
2. admin_users
Description: Backstage Administrator Table
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
name | VARCHAR(191) | Not null | | username |
email | VARCHAR(191) | Not null | | Email |
password | VARCHAR(191) | Not null | | password |
active | TINYINT(1) | Not null | | Is it enabled? |
locale | VARCHAR(191) | Not null | | language |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
admin_users_email_unique | email | UNIQUE | |
3. attribute_descriptions
Description: Attribute description table
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | |
attribute_id | INT(10) UNSIGNED | Not null | | property ID |
locale | VARCHAR(191) | Not null | | language |
name | VARCHAR(191) | Not null | | name |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
attribute_id_locale | attribute_id, locale | INDEX | |
attribute_id | attribute_id | INDEX | |
4. attribute_group_descriptions
Description: property group describe table
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | |
attribute_group_id | INT(10) UNSIGNED | Not null | | Property Group ID |
locale | VARCHAR(191) | Not null | | language |
name | VARCHAR(191) | Not null | | name |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
attribute_group_id_locale | attribute_group_id, locale | INDEX | |
attribute_group_id | attribute_group_id | INDEX | |
5. attribute_groups
Description: Property Group Table
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | |
sort_order | INT(11) | Not null | | Sorting |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
6. attribute_value_descriptions
Description: Property value describe table
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | |
attribute_value_id | INT(10) UNSIGNED | Not null | | property value ID |
locale | VARCHAR(191) | Not null | | language |
name | VARCHAR(191) | Not null | | name |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
attribute_value_id_locale | attribute_value_id, locale | INDEX | |
attribute_value_id | attribute_value_id | INDEX | |
7. attribute_values
Description: Property value table
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | |
attribute_id | INT(10) UNSIGNED | Not null | | property ID |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
attribute_id | attribute_id | INDEX | |
8. attributes
Description: Property Table
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | |
attribute_group_id | INT(10) UNSIGNED | Not null | | Property Group ID |
sort_order | INT(11) | Not null | | Sorting |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
attribute_group_id | attribute_group_id | INDEX | |
9. brands
Description: Product Brand
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
name | VARCHAR(191) | Not null | | name |
first | CHAR(191) | Not null | | Initials |
logo | VARCHAR(191) | Not null | | icon |
sort_order | INT(11) | Not null | | Sorting |
status | INT(11) | Not null | | state |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
10. cart_products
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
customer_id | INT(11) | Not null | | Customer ID |
session_id | VARCHAR(191) | Not null | | |
selected | TINYINT(1) | Not null | | Is it selected? |
product_id | INT(11) | Not null | | Product ID |
product_sku_id | INT(11) | Not null | | Product SKU ID |
quantity | INT(10) UNSIGNED | Not null | | Purchase quantity |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
customer_id | customer_id | INDEX | |
product_id | product_id | INDEX | |
product_sku_id | product_sku_id | INDEX | |
11. carts
Description: Cart
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
customer_id | INT(11) | Not null | | Customer ID |
session_id | VARCHAR(191) | Not null | | |
shipping_address_id | INT(11) | Not null | | Shipping Address ID |
guest_shipping_address | JSON | | NULL | |
shipping_method_code | VARCHAR(191) | Not null | | Shipping Method Code |
payment_address_id | INT(11) | Not null | | Invoice Address ID |
guest_payment_address | JSON | | NULL | |
payment_method_code | VARCHAR(191) | Not null | | Payment Method Code |
extra | JSON | | NULL | |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
customer_id | customer_id | INDEX | |
shipping_address_id | shipping_address_id | INDEX | |
payment_address_id | payment_address_id | INDEX | |
12. categories
Description: Product Categories
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
parent_id | BIGINT(20) UNSIGNED | Not null | | Parent Category ID |
position | INT(11) | Not null | | Sorting |
active | TINYINT(1) | Not null | | Is it enabled? |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
parent_id | parent_id | INDEX | |
13. category_descriptions
Description:: Product category name, description and other details
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
category_id | BIGINT(20) UNSIGNED | Not null | | Category ID |
locale | VARCHAR(191) | Not null | | language |
name | VARCHAR(191) | Not null | | name |
content | TEXT | Not null | | describe |
meta_title | VARCHAR(191) | Not null | | meta title |
meta_description | VARCHAR(191) | Not null | | meta describe |
meta_keywords | VARCHAR(191) | Not null | | meta keywords |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
category_id | category_id | INDEX | |
14. category_paths
Description: Product classification hierarchy
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
category_id | BIGINT(20) UNSIGNED | Not null | | Category ID |
path_id | BIGINT(20) UNSIGNED | Not null | | Classification Path ID |
level | INT(11) | Not null | | Tiers |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
category_id | category_id | INDEX | |
path_id | path_id | INDEX | |
15. countries
Description: country
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
name | VARCHAR(64) | Not null | | name |
code | VARCHAR(16) | Not null | | code |
sort_order | INT(11) | Not null | | Sorting |
status | TINYINT(4) | Not null | | Is it enabled? |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
16. currencies
Description: currency
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
name | VARCHAR(64) | Not null | | name |
code | VARCHAR(16) | Not null | | code |
symbol_left | VARCHAR(16) | Not null | | Left sign, such as $ ￥ |
symbol_right | VARCHAR(16) | Not null | | Right sign, such as $ ￥ |
decimal_place | CHAR(1) | Not null | | Decimal Places |
value | DOUBLE(15,8) | Not null | | The exchange rate of the default currency relative to the current currency |
status | TINYINT(4) | Not null | | Is it enabled? |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
17. customer_group_descriptions
Description: Customer group name, describe
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
customer_group_id | INT(10) UNSIGNED | Not null | | Customer Group ID |
locale | VARCHAR(10) | Not null | | language |
name | VARCHAR(256) | Not null | | name |
description | TEXT | Not null | | describe |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
customer_group_id | customer_group_id | INDEX | |
18. customer_groups
Description: Customer Group
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
total | DECIMAL(12,4) | Not null | | Minimum spending amount |
reward_point_factor | DECIMAL(12,4) | Not null | | Bonus Points Coefficient |
use_point_factor | DECIMAL(12,4) | Not null | | Using the integration factor |
discount_factor | DECIMAL(12,4) | Not null | | Discount factor |
level | INT(11) | Not null | | grade |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
19. customer_wishlists
Description: Customer Favorites
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
customer_id | INT(10) UNSIGNED | Not null | | Customer ID |
product_id | INT(10) UNSIGNED | Not null | | Product ID |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
customer_id | customer_id | INDEX | |
product_id | product_id | INDEX | |
20. customers
Description: Customer
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
email | VARCHAR(191) | Not null | | Email |
password | VARCHAR(191) | Not null | | password |
name | VARCHAR(191) | Not null | | username |
avatar | VARCHAR(191) | Not null | | avatar |
customer_group_id | INT(10) UNSIGNED | Not null | | User Group ID |
address_id | INT(10) UNSIGNED | Not null | | Default Address ID |
locale | VARCHAR(10) | Not null | | language |
status | TINYINT(4) | Not null | | state |
code | VARCHAR(40) | Not null | | Retrieve password code |
from | VARCHAR(16) | Not null | | Registration Source |
deleted_at | TIMESTAMP | | NULL | Delete time |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
customers_email_unique | email | UNIQUE | |
customer_group_id | customer_group_id | INDEX | |
address_id | address_id | INDEX | |
21. failed_jobs
Description: Queue failed tasks
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | Primary Key ID |
uuid | VARCHAR(191) | Not null | | Unique ID |
connection | TEXT | Not null | | Link |
queue | TEXT | Not null | | queue |
payload | LONGTEXT | Not null | | Execution Data |
exception | LONGTEXT | Not null | | abnormal |
failed_at | TIMESTAMP | Not null | CURRENT_TIMESTAMP | time |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
failed_jobs_uuid_unique | uuid | UNIQUE | |
22. languages
Description: language
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
name | VARCHAR(64) | Not null | | name |
code | VARCHAR(16) | Not null | | code |
locale | VARCHAR(255) | Not null | | Browser language identifier |
image | VARCHAR(255) | Not null | | language icon |
sort_order | INT(11) | Not null | | Sorting |
status | TINYINT(4) | Not null | | Is it enabled? |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
23. migrations
Description:
Fields:
| Fields | type | property | default value | describe |
|---|
id | INT(10) UNSIGNED | Primary, Auto increment, Not null | | |
migration | VARCHAR(191) | Not null | | |
batch | INT(11) | Not null | | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
24. model_has_permissions
Description: Model permissions
Fields:
| Fields | type | property | default value | describe |
|---|
permission_id | BIGINT(20) UNSIGNED | Primary, Not null | | Permission ID |
model_type | VARCHAR(191) | Primary, Not null | | Model type |
model_id | BIGINT(20) UNSIGNED | Primary, Not null | | Model ID |
index:
| name | Fields | type | describe |
|---|
PRIMARY | permission_id, model_id, model_type | PRIMARY | |
model_has_permissions_model_id_model_type_index | model_id, model_type | INDEX | |
25. model_has_roles
Description: Model Role
Fields:
| Fields | type | property | default value | describe |
|---|
role_id | BIGINT(20) UNSIGNED | Primary, Not null | | Role ID |
model_type | VARCHAR(191) | Primary, Not null | | Model type |
model_id | BIGINT(20) UNSIGNED | Primary, Not null | | Model ID |
index:
| name | Fields | type | describe |
|---|
PRIMARY | role_id, model_id, model_type | PRIMARY | |
model_has_roles_model_id_model_type_index | model_id, model_type | INDEX | |
26. notifications
Description:
Fields:
| Fields | type | property | default value | describe |
|---|
id | CHAR(36) | Primary, Not null | | UUID |
type | VARCHAR(191) | Not null | | type |
notifiable_type | VARCHAR(191) | Not null | | |
notifiable_id | BIGINT(20) UNSIGNED | Not null | | |
data | TEXT | Not null | | Notification Data |
read_at | TIMESTAMP | | NULL | Opening time |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
notifications_notifiable_type_notifiable_id_index | notifiable_type, notifiable_id | INDEX | |
27. order_histories
Description: Order Status Change History
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
order_id | INT(11) | Not null | | Order ID |
status | VARCHAR(191) | Not null | | Order change status |
notify | TINYINT(1) | Not null | | Notify |
comment | TEXT | Not null | | Change Notes |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
order_id | order_id | INDEX | |
28. order_products
Description: Order product details
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
order_id | INT(11) | Not null | | Order ID |
product_id | INT(11) | Not null | | Product ID |
order_number | VARCHAR(191) | Not null | | Order Number |
product_sku | VARCHAR(191) | Not null | | Product SKU |
name | VARCHAR(191) | Not null | | Product name |
image | VARCHAR(191) | Not null | | Product images |
quantity | INT(11) | Not null | | Purchase quantity |
price | DECIMAL(16,4) | Not null | | unit price |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
deleted_at | TIMESTAMP | | NULL | Delete time |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
order_id | order_id | INDEX | |
product_id | product_id | INDEX | |
29. order_shipments
Description:
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | |
order_id | INT(11) | Not null | | Order ID |
express_code | VARCHAR(191) | Not null | | Courier company code |
express_company | VARCHAR(191) | Not null | | Courier company name |
express_number | VARCHAR(191) | Not null | | Waybill Number |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
order_id | order_id | INDEX | |
30. order_totals
Description: Order amount composition
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
order_id | INT(11) | Not null | | Order ID |
code | VARCHAR(191) | Not null | | Type Encoding |
value | DECIMAL(8,2) | Not null | | Amount |
title | VARCHAR(191) | Not null | | name |
reference | JSON | Not null | | Additional Information |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
order_id | order_id | INDEX | |
31. orders
Description: Order
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
number | VARCHAR(191) | Not null | | Order Number |
customer_id | INT(11) | Not null | | Customer ID |
customer_group_id | INT(11) | Not null | | Customer Group ID |
shipping_address_id | INT(11) | Not null | | Shipping Address ID |
payment_address_id | INT(11) | Not null | | Invoice Address ID |
customer_name | VARCHAR(191) | Not null | | Customer Name |
email | VARCHAR(191) | Not null | | Customer Email |
calling_code | INT(11) | Not null | | Telephone area code |
telephone | VARCHAR(191) | Not null | | telephone number |
total | DECIMAL(16,4) | Not null | | lump sum |
locale | VARCHAR(191) | Not null | | language |
currency_code | VARCHAR(191) | Not null | | Current Currency |
currency_value | VARCHAR(191) | Not null | | Current exchange rate |
ip | VARCHAR(191) | Not null | | IP when placing an order |
user_agent | TEXT | Not null | | Browser information when placing an order |
status | VARCHAR(191) | Not null | | Order Status |
shipping_method_code | VARCHAR(191) | Not null | | Shipping method code |
shipping_method_name | VARCHAR(191) | Not null | | Shipping method name |
shipping_customer_name | VARCHAR(191) | Not null | | Shipping address name |
shipping_calling_code | VARCHAR(191) | Not null | | Delivery Address Telephone Area Code |
shipping_telephone | VARCHAR(191) | Not null | | Shipping address phone number |
shipping_country | VARCHAR(191) | Not null | | Shipping address country |
shipping_country_id | INT(10) UNSIGNED | Not null | | Country ID |
shipping_zone_id | INT(10) UNSIGNED | Not null | | Province ID |
shipping_zone | VARCHAR(191) | Not null | | Delivery address province |
shipping_city | VARCHAR(191) | Not null | | Delivery Address City |
shipping_address_1 | VARCHAR(191) | Not null | | Delivery address details1 |
shipping_address_2 | VARCHAR(191) | Not null | | Delivery address details2 |
shipping_zipcode | VARCHAR(191) | Not null | | Delivery address postal code |
payment_method_code | VARCHAR(191) | Not null | | Payment method code |
payment_method_name | VARCHAR(191) | Not null | | Payment method name |
payment_customer_name | VARCHAR(191) | Not null | | Invoice Address Name |
payment_calling_code | VARCHAR(191) | Not null | | Invoice Address Telephone Area Code |
payment_telephone | VARCHAR(191) | Not null | | Invoice Address Phone Number |
payment_country | VARCHAR(191) | Not null | | Invoice Address Country |
payment_country_id | INT(10) UNSIGNED | Not null | | Country id |
payment_zone_id | INT(10) UNSIGNED | Not null | | Province ID |
payment_zone | VARCHAR(191) | Not null | | Invoice Address Province |
payment_city | VARCHAR(191) | Not null | | Invoice Address City |
payment_address_1 | VARCHAR(191) | Not null | | Invoice address details1 |
payment_address_2 | VARCHAR(191) | Not null | | Invoice address details2 |
payment_zipcode | VARCHAR(191) | Not null | | Invoice address zip code |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
deleted_at | TIMESTAMP | | NULL | Delete time |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
customer_id | customer_id | INDEX | |
customer_group_id | customer_group_id | INDEX | |
shipping_address_id | shipping_address_id | INDEX | |
payment_address_id | payment_address_id | INDEX | |
32. page_descriptions
Description: single page name, description and other details
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
page_id | INT(11) | Not null | | Single Page ID |
locale | VARCHAR(191) | Not null | | language |
title | VARCHAR(191) | Not null | | title |
content | TEXT | Not null | | content |
meta_title | VARCHAR(191) | Not null | | meta title |
meta_description | VARCHAR(191) | Not null | | meta describe |
meta_keywords | VARCHAR(191) | Not null | | meta keyword |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
page_id | page_id | INDEX | |
33. pages
Description: Single Page
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
position | INT(11) | Not null | | Sorting |
active | TINYINT(1) | Not null | | Is it enabled? |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
34. permissions
Description: Administrator privileges
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
name | VARCHAR(191) | Not null | | Permission Name |
guard_name | VARCHAR(191) | Not null | | Permission group |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
permissions_name_guard_name_unique | name, guard_name | UNIQUE | |
35. plugins
Description: Plugin
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
type | VARCHAR(191) | Not null | | type: shipping, payment |
code | VARCHAR(191) | Not null | | Coding, unique identification |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
36. product_attributes
Description: Product attribute association table
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | |
product_id | INT(10) UNSIGNED | Not null | | Product ID |
attribute_id | INT(10) UNSIGNED | Not null | | property ID |
attribute_value_id | INT(10) UNSIGNED | Not null | | Attribute Value ID |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
product_id_attribute_id | product_id, attribute_id | INDEX | |
product_id | product_id | INDEX | |
attribute_id | attribute_id | INDEX | |
attribute_value_id | attribute_value_id | INDEX | |
37. product_categories
Description: Product Category
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
product_id | BIGINT(20) UNSIGNED | Not null | | Product ID |
category_id | BIGINT(20) UNSIGNED | Not null | | Category ID |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
product_id | product_id | INDEX | |
category_id | category_id | INDEX | |
38. product_descriptions
Description: Product name, description and other details
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
product_id | BIGINT(20) UNSIGNED | Not null | | Product ID |
locale | VARCHAR(191) | Not null | | language |
name | VARCHAR(191) | Not null | | Product Name |
content | TEXT | Not null | | Product Description |
meta_title | VARCHAR(191) | Not null | | meta title |
meta_description | VARCHAR(191) | Not null | | meta describe |
meta_keywords | VARCHAR(191) | Not null | | meta keyword |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
product_id | product_id | INDEX | |
39. product_relations
Description:
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | |
product_id | INT(10) UNSIGNED | Not null | | Product ID |
relation_id | INT(10) UNSIGNED | Not null | | Related product ID |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
product_id | product_id | INDEX | |
relation_id | relation_id | INDEX | |
40. product_skus
Description: Product SKU
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
product_id | BIGINT(20) UNSIGNED | Not null | | Product ID |
variants | JSON | | NULL | SKU Specifications |
position | INT(11) | Not null | | Sorting |
images | JSON | | NULL | picture |
model | VARCHAR(191) | Not null | | Model |
sku | VARCHAR(191) | Not null | | SKU |
price | DOUBLE | Not null | | price |
origin_price | DOUBLE | Not null | | Strike-through price |
cost_price | DOUBLE | Not null | | Cost price |
quantity | INT(11) | Not null | | Inventory |
is_default | TINYINT(1) | Not null | | Is it default |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
product_id | product_id | INDEX | |
41. products
Description: product
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
brand_id | INT(10) UNSIGNED | Not null | | Brand ID |
images | JSON | | NULL | picture |
price | DECIMAL(8,2) | Not null | 0.00 | price |
video | VARCHAR(191) | Not null | | video |
position | INT(11) | Not null | | Sorting |
active | TINYINT(1) | Not null | | Is it enabled? |
variables | JSON | | NULL | Multi-specification data |
tax_class_id | INT(11) | Not null | | Tax Class ID |
sales | INT(11) | Not null | | |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
deleted_at | TIMESTAMP | | NULL | Delete time |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
brand_id | brand_id | INDEX | |
tax_class_id | tax_class_id | INDEX | |
42. region_zones
Description: Table of association between regional groups and countries, provinces, cities and counties
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
region_id | INT(11) | Not null | | Zone Group ID |
country_id | INT(11) | Not null | | country ID |
zone_id | INT(11) | Not null | | Province ID |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
region_id | region_id | INDEX | |
country_id | country_id | INDEX | |
zone_id | zone_id | INDEX | |
43. regions
Description: Regional groups, such as Jiangsu, Zhejiang, Shanghai, and Western China
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
name | VARCHAR(191) | Not null | | Region Group Name |
description | VARCHAR(191) | Not null | | description |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
44. rma_histories
Description: After-sales status record
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
rma_id | INT(10) UNSIGNED | Not null | | After-sales ID |
status | VARCHAR(191) | Not null | | state |
notify | TINYINT(4) | Not null | | Notify |
comment | TEXT | Not null | | Remark |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
rma_id | rma_id | INDEX | |
45. rma_reasons
Description: After-sales reasons
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
name | JSON | Not null | | After-sales reason, example: {"en":"cannot to use","zh_cn":"cannot use"} |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
46. rmas
Description: After-sales table
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
order_id | INT(10) UNSIGNED | Not null | | Order ID |
order_product_id | INT(10) UNSIGNED | Not null | | Order item detail ID |
customer_id | INT(10) UNSIGNED | Not null | | Customer ID |
name | VARCHAR(191) | Not null | | Customer Name |
email | VARCHAR(191) | Not null | | Customer Email |
telephone | VARCHAR(191) | Not null | | Customer Phone |
product_name | VARCHAR(191) | Not null | | Product Name |
sku | VARCHAR(191) | Not null | | SKU |
quantity | INT(11) | Not null | | Return quantity |
opened | TINYINT(4) | Not null | | Has the package been opened? |
rma_reason_id | INT(10) UNSIGNED | Not null | | After-sales reason ID |
type | VARCHAR(191) | Not null | | After-sales service type: return, exchange, repair, reissue, refund only |
status | VARCHAR(191) | Not null | | state |
comment | TEXT | Not null | | Remark |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
order_id | order_id | INDEX | |
order_product_id | order_product_id | INDEX | |
customer_id | customer_id | INDEX | |
rma_reason_id | rma_reason_id | INDEX | |
47. role_has_permissions
Description: Administrator role permissions
Fields:
| Fields | type | property | default value | describe |
|---|
permission_id | BIGINT(20) UNSIGNED | Primary, Not null | | Permission ID |
role_id | BIGINT(20) UNSIGNED | Primary, Not null | | Role ID |
index:
| name | Fields | type | describe |
|---|
PRIMARY | permission_id, role_id | PRIMARY | |
role_has_permissions_role_id_foreign | role_id | INDEX | |
48. roles
Description: Administrator roles
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
name | VARCHAR(191) | Not null | | Role Name |
guard_name | VARCHAR(191) | Not null | | Permission group |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
roles_name_guard_name_unique | name, guard_name | UNIQUE | |
49. settings
Description: System Settings
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
type | VARCHAR(191) | Not null | | Type, including system, plugin |
space | VARCHAR(191) | Not null | | Configuration groups, such as stripe, paypal, flat_shipping |
name | VARCHAR(191) | Not null | | Configuration name, similar to field name |
value | TEXT | Not null | | Configuration Values |
json | TINYINT(1) | Not null | | Is it json? |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
50. tax_classes
Description: Tax
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
title | VARCHAR(191) | Not null | | Tax Class Title |
description | VARCHAR(191) | Not null | | Tax Description |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
51. tax_rates
Description: tax rate
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
region_id | INT(11) | Not null | | Zone Group ID |
name | VARCHAR(191) | Not null | | name |
rate | VARCHAR(191) | Not null | | Tax rate value |
type | ENUM('PERCENT','FLAT') | Not null | | type, percent: percentage, flat: fixed value |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
region_id | region_id | INDEX | |
52. tax_rules
Description: Tax rules
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
tax_class_id | INT(11) | Not null | | Tax Class ID |
tax_rate_id | INT(11) | Not null | | Tax Rate ID |
based | ENUM('STORE','PAYMENT','SHIPPING') | Not null | | Address type |
priority | INT(11) | Not null | | Priority |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
tax_class_id | tax_class_id | INDEX | |
tax_rate_id | tax_rate_id | INDEX | |
53. verify_codes
Description: Verification Code
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
account | VARCHAR(256) | Not null | | account |
code | VARCHAR(16) | Not null | | Verification Code |
deleted_at | TIMESTAMP | | NULL | Delete time |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
54. zones
Description: Province, State
Fields:
| Fields | type | property | default value | describe |
|---|
id | BIGINT(20) UNSIGNED | Primary, Auto increment, Not null | | ID |
country_id | INT(10) UNSIGNED | Not null | | country ID |
name | VARCHAR(64) | Not null | | name |
code | VARCHAR(16) | Not null | | code |
sort_order | INT(11) | Not null | | Sorting |
status | TINYINT(4) | Not null | | Is it enabled? |
created_at | TIMESTAMP | | NULL | |
updated_at | TIMESTAMP | | NULL | |
index:
| name | Fields | type | describe |
|---|
PRIMARY | id | PRIMARY | |
country_id | country_id | INDEX | |