Data Dictionary
Table List
| No. | Table | Purpose |
|---|
| 1 | addresses | Customer addresses |
| 2 | admin_user_tokens | Administrator tokens |
| 3 | admin_users | Administrators |
| 4 | agent_conversation_messages | AI conversation messages |
| 5 | agent_conversations | AI conversations |
| 6 | ai_audit_logs | AI operation audit logs |
| 7 | ai_mcp_api_keys | AI MCP API keys |
| 8 | ai_metric_aggregations | AI metric aggregations |
| 9 | ai_metrics | AI metrics |
| 10 | ai_prompt_ab_tests | AI prompt A/B tests |
| 11 | ai_prompts | AI prompt versions |
| 12 | ai_providers | AI model providers |
| 13 | ai_traces | AI call traces |
| 14 | ai_user_quotas | AI user quotas |
| 15 | ai_user_settings | AI user settings |
| 16 | ai_workflow_steps | AI workflow steps |
| 17 | ai_workflows | AI workflows |
| 18 | attribute_descriptions | Attribute descriptions |
| 19 | attribute_group_descriptions | Attribute group descriptions |
| 20 | attribute_groups | Attribute groups |
| 21 | attribute_value_descriptions | Attribute value descriptions |
| 22 | attribute_values | Attribute values |
| 23 | attributes | Attributes |
| 24 | brands | Product brands |
| 25 | cart_products | Cart items |
| 26 | carts | Shopping carts |
| 27 | categories | Product categories |
| 28 | category_descriptions | Product category names, descriptions, and details |
| 29 | category_paths | Product category hierarchy |
| 30 | continents | Continents |
| 31 | countries | Countries |
| 32 | currencies | Currencies |
| 33 | customer_group_descriptions | Customer group names and descriptions |
| 34 | customer_groups | Customer groups |
| 35 | customer_wishlists | Customer wishlists |
| 36 | customers | Customers |
| 37 | failed_jobs | Failed queue jobs |
| 38 | jobs | Queue jobs |
| 39 | languages | Languages |
| 40 | mail_logs | Email delivery logs |
| 41 | migrations | Laravel database migration records |
| 42 | model_has_permissions | Model permissions |
| 43 | model_has_roles | Model roles |
| 44 | notifications | Notifications |
| 45 | order_histories | Order status history |
| 46 | order_payments | Order payments |
| 47 | order_products | Order items |
| 48 | order_shipments | Order shipments |
| 49 | order_totals | Order total components |
| 50 | orders | Orders |
| 51 | page_categories | Article categories |
| 52 | page_category_descriptions | Article category descriptions |
| 53 | page_descriptions | Page titles, descriptions, and details |
| 54 | page_products | Article-product associations |
| 55 | pages | Pages |
| 56 | permissions | Administrator permissions |
| 57 | plugins | Plugins |
| 58 | product_attributes | Product-attribute associations |
| 59 | product_categories | Product-category associations |
| 60 | product_descriptions | Product names, descriptions, and details |
| 61 | product_relations | Related products |
| 62 | product_skus | Product SKUs |
| 63 | product_views | Product view records |
| 64 | products | Products |
| 65 | region_zones | Region group associations with countries, states, and cities |
| 66 | regions | Region groups, such as Jiangsu-Zhejiang-Shanghai or western China |
| 67 | rma_histories | After-sales status history |
| 68 | rma_reasons | After-sales reasons |
| 69 | rmas | After-sales requests |
| 70 | role_has_permissions | Administrator role permissions |
| 71 | roles | Administrator roles |
| 72 | settings | System settings |
| 73 | tax_classes | Tax classes |
| 74 | tax_rates | Tax rates |
| 75 | tax_rules | Tax rules |
| 76 | verify_codes | Verification codes |
| 77 | zones | States and provinces |
1. addresses
Description: Customer addresses
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
customer_id | INT UNSIGNED | Not null | None | Customer ID |
name | VARCHAR(191) | Not null | None | Name |
phone | VARCHAR(191) | Not null | None | Phone number |
country_id | INT UNSIGNED | Not null | None | Country ID |
zone_id | INT UNSIGNED | Not null | None | State/province ID |
zone | VARCHAR(191) | Not null | None | State/province name |
city_id | INT UNSIGNED | | NULL | City ID |
city | VARCHAR(191) | Not null | None | City name |
zipcode | VARCHAR(191) | Not null | None | Postal code |
address_1 | VARCHAR(191) | Not null | None | Address line 1 |
address_2 | VARCHAR(191) | Not null | None | Address line 2 |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
addresses_customer_id | customer_id | INDEX |
addresses_country_id | country_id | INDEX |
addresses_zone_id | zone_id | INDEX |
addresses_city_id | city_id | INDEX |
2. admin_user_tokens
Description: Administrator tokens
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
admin_user_id | INT | Not null | None | Administrator ID |
token | VARCHAR(64) | Not null | None | Token |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
3. admin_users
Description: Administrators
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
name | VARCHAR(191) | Not null | None | Username |
email | VARCHAR(191) | Not null | None | Email |
password | VARCHAR(191) | Not null | None | Password |
active | TINYINT(1) | Not null | None | Whether enabled |
locale | VARCHAR(191) | Not null | '' | Languages |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
admin_users_email_unique | email | UNIQUE |
4. agent_conversation_messages
Description: AI conversation messages
The attachments, tool_calls, tool_results, usage, and meta columns use the TEXT type to store serialized data.
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | VARCHAR(36) | Primary, Not null | None | Message ID (string) |
conversation_id | VARCHAR(36) | Not null | None | Conversation ID; references agent_conversations.id |
user_id | BIGINT UNSIGNED | | NULL | User ID |
agent | VARCHAR(191) | Not null | None | Agent identifier |
role | VARCHAR(25) | Not null | None | Message role |
content | TEXT | Not null | None | Content |
attachments | TEXT | Not null | None | Attachment data |
tool_calls | TEXT | Not null | None | Tool call data |
tool_results | TEXT | Not null | None | Tool execution results |
usage | TEXT | Not null | None | Usage data |
meta | TEXT | Not null | None | Metadata |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
conversation_index | conversation_id, user_id, updated_at | INDEX |
agent_conversation_messages_user_id_index | user_id | INDEX |
agent_conversation_messages_conversation_id_index | conversation_id | INDEX |
5. agent_conversations
Description: AI conversations
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | VARCHAR(36) | Primary, Not null | None | Conversation ID (string) |
user_id | BIGINT UNSIGNED | | NULL | User ID |
title | VARCHAR(191) | Not null | None | Title |
scene | VARCHAR(50) | | NULL | Conversation scene |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
agent_conversations_user_id_updated_at_index | user_id, updated_at | INDEX |
agent_conversations_scene_index | scene | INDEX |
6. ai_audit_logs
Description: AI operation audit logs
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
user_id | BIGINT UNSIGNED | | NULL | User ID |
action | VARCHAR(100) | Not null | None | Action identifier |
resource_type | VARCHAR(100) | | NULL | Resource type |
resource_id | VARCHAR(100) | | NULL | Resource ID |
params | JSON | | NULL | Operation parameters |
result | JSON | | NULL | Execution result |
status | VARCHAR(50) | Not null | success | Status |
error | TEXT | | NULL | Error message |
ip_address | VARCHAR(45) | | NULL | IP address |
user_agent | VARCHAR(500) | | NULL | User-Agent |
trace_id | VARCHAR(100) | | NULL | Trace ID |
created_at | TIMESTAMP | Not null | None | Created at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
ai_audit_logs_user_id_action_created_at_index | user_id, action, created_at | INDEX |
ai_audit_logs_resource_type_resource_id_index | resource_type, resource_id | INDEX |
ai_audit_logs_user_id_index | user_id | INDEX |
ai_audit_logs_action_index | action | INDEX |
ai_audit_logs_trace_id_index | trace_id | INDEX |
ai_audit_logs_created_at_index | created_at | INDEX |
7. ai_mcp_api_keys
Description: AI MCP API keys
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
name | VARCHAR(100) | Not null | None | API key name |
key | VARCHAR(64) | Not null | None | API Key |
secret | VARCHAR(128) | | NULL | API Secret |
allowed_tools | JSON | | NULL | List of allowed tools |
rate_limit | INT | Not null | 100 | Request limit per minute |
is_active | TINYINT(1) | Not null | 1 | Whether enabled |
last_used_at | TIMESTAMP | | NULL | Last used at |
expires_at | TIMESTAMP | | NULL | Expires at |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
ai_mcp_api_keys_key_unique | key | UNIQUE |
ai_mcp_api_keys_is_active_index | is_active | INDEX |
8. ai_metric_aggregations
Description: AI metric aggregations
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
name | VARCHAR(255) | Not null | None | Metric name |
type | VARCHAR(50) | Not null | None | Type |
aggregation | VARCHAR(50) | Not null | None | Aggregation method |
value | DOUBLE | Not null | None | Value |
tags | JSON | | NULL | Tags |
period | VARCHAR(50) | Not null | None | Aggregation period |
period_start | TIMESTAMP | | NULL | Period start time |
period_end | TIMESTAMP | | NULL | Period end time |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
ai_metric_aggregations_name_period_period_start_index | name, period, period_start | INDEX |
ai_metric_aggregations_name_index | name | INDEX |
9. ai_metrics
Description: AI metrics
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
name | VARCHAR(255) | Not null | None | Metric name |
type | VARCHAR(50) | Not null | None | Type |
value | DOUBLE | Not null | None | Value |
tags | JSON | | NULL | Tags |
timestamp | TIMESTAMP | Not null | None | Metric timestamp |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
ai_metrics_name_timestamp_index | name, timestamp | INDEX |
ai_metrics_name_type_index | name, type | INDEX |
ai_metrics_name_index | name | INDEX |
ai_metrics_timestamp_index | timestamp | INDEX |
10. ai_prompt_ab_tests
Description: AI prompt A/B tests
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
experiment_id | VARCHAR(100) | Not null | None | Unique experiment identifier |
prompt_name | VARCHAR(255) | Not null | None | Prompt name |
variant_a_version | VARCHAR(50) | Not null | None | Variant A version |
variant_b_version | VARCHAR(50) | Not null | None | Variant B version |
traffic_split | DOUBLE | Not null | 0.5 | Traffic share for variant A |
status | VARCHAR(50) | Not null | running | Status |
winner | VARCHAR(10) | | NULL | Winning variant |
metrics | JSON | | NULL | Experiment metrics |
started_at | TIMESTAMP | Not null | None | Start time |
ended_at | TIMESTAMP | | NULL | End time |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
ai_prompt_ab_tests_experiment_id_unique | experiment_id | UNIQUE |
ai_prompt_ab_tests_prompt_name_status_index | prompt_name, status | INDEX |
ai_prompt_ab_tests_prompt_name_index | prompt_name | INDEX |
11. ai_prompts
Description: AI prompt versions
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
name | VARCHAR(255) | Not null | None | Name |
version | VARCHAR(50) | Not null | None | Version |
content | TEXT | Not null | None | Prompt template content |
variables | JSON | | NULL | Variable definitions |
metadata | JSON | | NULL | Metadata |
is_active | TINYINT(1) | Not null | 1 | Whether enabled |
created_by | BIGINT UNSIGNED | | NULL | Creator user ID |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
ai_prompts_name_version_unique | name, version | UNIQUE |
ai_prompts_name_is_active_index | name, is_active | INDEX |
ai_prompts_name_index | name | INDEX |
12. ai_providers
Description: AI model providers
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
key | VARCHAR(50) | Not null | None | Unique provider identifier, such as qwen/ollama |
name | VARCHAR(100) | Not null | None | Provider display name |
driver | VARCHAR(50) | Not null | openai | Driver type, such as openai/ollama/anthropic/gemini |
protocol | VARCHAR(80) | Not null | openai_chat_completions | API protocol |
api_key | VARCHAR(500) | | NULL | API key (stored encrypted) |
api_url | VARCHAR(500) | | NULL | API base URL |
enabled | TINYINT(1) | Not null | 1 | Whether enabled |
sort_order | INT | Not null | 0 | Sort weight |
models | JSON | | NULL | Available models: {"model_key":"Model Label"} |
extra | JSON | | NULL | Additional configuration parameters |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
ai_providers_key_unique | key | UNIQUE |
ai_providers_enabled_sort_idx | enabled, sort_order | INDEX |
13. ai_traces
Description: AI call traces
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
trace_id | CHAR(36) | Not null | None | Trace ID |
span_id | CHAR(36) | Not null | None | Span ID |
parent_span_id | CHAR(36) | | NULL | Parent span ID |
operation | VARCHAR(255) | Not null | None | Operation name |
attributes | JSON | | NULL | Trace attributes |
events | JSON | | NULL | Trace events |
start_time | DOUBLE | Not null | None | Numeric start time |
end_time | DOUBLE | | NULL | Numeric end time |
duration_ms | DOUBLE | | NULL | Duration (milliseconds) |
status | VARCHAR(50) | Not null | ok | Status |
status_message | TEXT | | NULL | Status message |
created_at | TIMESTAMP | Not null | None | Created at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
ai_traces_trace_id_span_id_index | trace_id, span_id | INDEX |
ai_traces_trace_id_parent_span_id_index | trace_id, parent_span_id | INDEX |
ai_traces_operation_created_at_index | operation, created_at | INDEX |
ai_traces_trace_id_index | trace_id | INDEX |
14. ai_user_quotas
Description: AI user quotas
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
user_id | BIGINT UNSIGNED | Not null | None | User ID |
type | VARCHAR(50) | Not null | None | Type |
resource | VARCHAR(50) | Not null | default | Quota resource |
limit | INT | Not null | 1000 | Quota limit |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
uk_user_type_resource | user_id, type, resource | UNIQUE |
idx_type_resource | type, resource | INDEX |
15. ai_user_settings
Description: AI user settings
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
user_id | BIGINT UNSIGNED | Not null | None | User ID |
user_type | VARCHAR(20) | Not null | admin | User type: admin/admin_user |
key | VARCHAR(100) | Not null | None | Setting key |
value | JSON | | NULL | Setting value |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
ai_settings_user_key_unique | user_id, user_type, key | UNIQUE |
ai_settings_user_idx | user_id, user_type | INDEX |
16. ai_workflow_steps
Description: AI workflow steps
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
workflow_id | BIGINT UNSIGNED | Not null | None | Workflow record ID; references ai_workflows.id |
step_id | VARCHAR(100) | Not null | None | Step identifier |
agent_id | VARCHAR(255) | Not null | None | Agent identifier |
status | VARCHAR(50) | Not null | pending | Status |
input | JSON | | NULL | Input data |
output | JSON | | NULL | Output data |
error | TEXT | | NULL | Error message |
retry_count | INT | Not null | 0 | Retry count |
duration_ms | DOUBLE | | NULL | Duration (milliseconds) |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
ai_workflow_steps_workflow_id_step_id_index | workflow_id, step_id | INDEX |
ai_workflow_steps_workflow_id_status_index | workflow_id, status | INDEX |
Foreign Keys
| Name | Field | References | On delete |
|---|
ai_workflow_steps_workflow_id_foreign | workflow_id | ai_workflows (id) | CASCADE |
17. ai_workflows
Description: AI workflows
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
workflow_id | VARCHAR(100) | Not null | None | Unique workflow business identifier |
name | VARCHAR(255) | Not null | None | Name |
definition | JSON | Not null | None | Workflow definition |
status | VARCHAR(50) | Not null | pending | Status |
result | JSON | | NULL | Execution result |
context | JSON | | NULL | Execution context |
user_id | BIGINT UNSIGNED | | NULL | User ID |
trace_id | VARCHAR(100) | | NULL | Trace ID |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
ai_workflows_workflow_id_unique | workflow_id | UNIQUE |
ai_workflows_status_created_at_index | status, created_at | INDEX |
ai_workflows_updated_at_index | updated_at | INDEX |
ai_workflows_status_index | status | INDEX |
ai_workflows_user_id_index | user_id | INDEX |
ai_workflows_trace_id_index | trace_id | INDEX |
18. attribute_descriptions
Description: Attribute descriptions
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
attribute_id | INT UNSIGNED | Not null | None | Attribute ID |
locale | VARCHAR(191) | Not null | '' | Languages |
name | VARCHAR(191) | Not null | '' | Name |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
attribute_id_locale | attribute_id, locale | INDEX |
attribute_descriptions_attribute_id | attribute_id | INDEX |
19. attribute_group_descriptions
Description: Attribute group descriptions
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
attribute_group_id | INT UNSIGNED | Not null | None | Attribute group ID |
locale | VARCHAR(191) | Not null | '' | Languages |
name | VARCHAR(191) | Not null | '' | Name |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
attribute_group_id_locale | attribute_group_id, locale | INDEX |
attribute_group_descriptions_attribute_group_id | attribute_group_id | INDEX |
20. attribute_groups
Description: Attribute groups
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
sort_order | INT | Not null | None | Sort order |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
21. attribute_value_descriptions
Description: Attribute value descriptions
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
attribute_value_id | INT UNSIGNED | Not null | None | Attribute value ID |
locale | VARCHAR(191) | Not null | '' | Languages |
name | VARCHAR(191) | Not null | '' | Name |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
attribute_value_id_locale | attribute_value_id, locale | INDEX |
attribute_value_descriptions_attribute_value_id | attribute_value_id | INDEX |
22. attribute_values
Description: Attribute values
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
attribute_id | INT UNSIGNED | Not null | None | Attribute ID |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
attribute_values_attribute_id | attribute_id | INDEX |
23. attributes
Description: Attributes
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
attribute_group_id | INT UNSIGNED | Not null | None | Attribute group ID |
sort_order | INT | Not null | None | Sort order |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
attributes_attribute_group_id | attribute_group_id | INDEX |
24. brands
Description: Product brands
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
name | VARCHAR(191) | Not null | None | Name |
first | CHAR(191) | Not null | None | Initial letter |
logo | VARCHAR(191) | Not null | None | Icon |
sort_order | INT | Not null | None | Sort order |
active | INT | Not null | 1 | Whether enabled |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
25. cart_products
Description: Cart items
The product_sku column stores the SKU code and references product_skus.sku, replacing the legacy product_sku_id column.
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
customer_id | INT | Not null | None | Customer ID |
session_id | VARCHAR(191) | Not null | '' | Current user session ID |
selected | TINYINT(1) | Not null | None | Whether selected |
product_id | INT | Not null | None | Product ID |
product_sku | VARCHAR(32) | Not null | None | SKU code; references product_skus.sku |
quantity | INT UNSIGNED | Not null | None | Purchase quantity |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
cart_products_customer_id | customer_id | INDEX |
cart_products_product_id | product_id | INDEX |
cart_products_product_sku_id | product_sku | INDEX |
idx_cart_products_stats | created_at, customer_id, session_id | INDEX |
26. carts
Description: Shopping carts
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
customer_id | INT | Not null | None | Customer ID |
session_id | VARCHAR(191) | Not null | '' | Current user session ID |
shipping_address_id | INT | Not null | None | Shipping address ID |
guest_shipping_address | JSON | | NULL | Guest shipping address |
shipping_method_code | VARCHAR(191) | Not null | None | Shipping method code |
payment_address_id | INT | Not null | None | Billing address ID |
guest_payment_address | JSON | | NULL | Guest billing address |
payment_method_code | VARCHAR(191) | Not null | None | Payment method code |
extra | JSON | | NULL | Additional information |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
carts_customer_id | customer_id | INDEX |
carts_shipping_address_id | shipping_address_id | INDEX |
carts_payment_address_id | payment_address_id | INDEX |
27. categories
Description: Product categories
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
parent_id | BIGINT UNSIGNED | Not null | 0 | Parent category ID |
image | VARCHAR(191) | Not null | '' | Images |
position | INT | Not null | 0 | Sort order |
active | TINYINT(1) | Not null | None | Whether enabled |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
categories_parent_id | parent_id | INDEX |
28. category_descriptions
Description: Product category names, descriptions, and details
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
category_id | BIGINT UNSIGNED | Not null | None | Category ID |
locale | VARCHAR(191) | Not null | None | Languages |
name | VARCHAR(255) | Not null | None | Name |
content | TEXT | Not null | None | Description |
meta_title | VARCHAR(255) | Not null | None | SEO title |
meta_description | VARCHAR(500) | Not null | None | SEO description |
meta_keywords | VARCHAR(255) | Not null | None | SEO keywords |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
category_descriptions_category_id | category_id | INDEX |
29. category_paths
Description: Product category hierarchy
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
category_id | BIGINT UNSIGNED | Not null | None | Category ID |
path_id | BIGINT UNSIGNED | Not null | None | Category path ID |
level | INT | Not null | None | Hierarchy level |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
category_paths_category_id | category_id | INDEX |
category_paths_path_id | path_id | INDEX |
30. continents
Description: Continents
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
name | VARCHAR(64) | Not null | None | Name |
code | VARCHAR(16) | Not null | None | Code |
sort_order | INT UNSIGNED | Not null | 0 | Sort order |
active | TINYINT(1) | Not null | 1 | Whether enabled |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
continents_code_unique | code | UNIQUE |
31. countries
Description: Countries
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
name | VARCHAR(64) | Not null | None | Name |
code | VARCHAR(16) | Not null | None | Code |
continent | VARCHAR(191) | Not null | '' | Continent |
sort_order | INT | Not null | None | Sort order |
active | TINYINT | Not null | 1 | Whether enabled |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
32. currencies
Description: Currencies
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
name | VARCHAR(64) | Not null | None | Name |
code | VARCHAR(16) | Not null | None | Code |
symbol_left | VARCHAR(16) | Not null | None | Currency symbol prefix, such as $ or ¥ |
symbol_right | VARCHAR(16) | Not null | None | Currency symbol suffix, such as $ or ¥ |
decimal_place | CHAR(1) | Not null | None | Decimal places |
value | DOUBLE | Not null | None | Exchange rate from the default currency to this currency |
active | TINYINT | Not null | 1 | Whether enabled |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
33. customer_group_descriptions
Description: Customer group names and descriptions
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
customer_group_id | INT UNSIGNED | Not null | None | Customer group ID |
locale | VARCHAR(10) | Not null | None | Languages |
name | VARCHAR(256) | Not null | None | Name |
description | TEXT | Not null | None | Description |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
customer_group_descriptions_customer_group_id | customer_group_id | INDEX |
34. customer_groups
Description: Customer groups
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
total | DECIMAL(12,4) | Not null | None | Minimum spending amount |
reward_point_factor | DECIMAL(12,4) | Not null | None | Reward point factor |
use_point_factor | DECIMAL(12,4) | Not null | None | Point redemption factor |
discount_factor | DECIMAL(12,4) | Not null | None | Discount factor |
level | INT | Not null | None | Level |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
35. customer_wishlists
Description: Customer wishlists
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
customer_id | INT UNSIGNED | Not null | None | Customer ID |
product_id | INT UNSIGNED | Not null | None | Product ID |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
customer_wishlists_customer_id | customer_id | INDEX |
customer_wishlists_product_id | product_id | INDEX |
36. customers
Description: Customers
The active column indicates whether the customer is enabled. The status column represents the approval status and defaults to approved.
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
cid | VARCHAR(255) | | NULL | App push notification ID |
email | VARCHAR(191) | Not null | None | Email |
password | VARCHAR(191) | Not null | None | Password |
name | VARCHAR(191) | Not null | None | Username |
avatar | VARCHAR(191) | Not null | '' | Avatar |
status | VARCHAR(191) | Not null | approved | Approval status |
customer_group_id | INT UNSIGNED | Not null | None | Customer group ID |
address_id | INT UNSIGNED | Not null | 0 | Default address ID |
locale | VARCHAR(10) | Not null | None | Languages |
active | TINYINT | Not null | 0 | Status |
code | VARCHAR(40) | Not null | '' | Password reset code |
from | VARCHAR(16) | Not null | '' | Registration source |
ip | VARCHAR(45) | Not null | '' | Registration IP address |
user_agent | TEXT | | NULL | Registration User-Agent |
deleted_at | TIMESTAMP | | NULL | Deleted at |
last_password_changed_at | TIMESTAMP | | NULL | Password last changed at |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
customers_email_unique | email | UNIQUE |
customers_customer_group_id | customer_group_id | INDEX |
customers_address_id | address_id | INDEX |
37. failed_jobs
Description: Failed queue jobs
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
uuid | VARCHAR(191) | Not null | None | Unique ID |
connection | TEXT | Not null | None | Connection |
queue | TEXT | Not null | None | Queue |
payload | LONGTEXT | Not null | None | Job payload |
exception | LONGTEXT | Not null | None | Exception |
failed_at | TIMESTAMP | Not null | CURRENT_TIMESTAMP | Timestamp |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
failed_jobs_uuid_unique | uuid | UNIQUE |
38. jobs
Description: Queue jobs
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
queue | VARCHAR(191) | Not null | None | Queue |
payload | LONGTEXT | Not null | None | Payload |
attempts | TINYINT UNSIGNED | Not null | None | Attempt count |
reserved_at | INT UNSIGNED | | NULL | Reserved at |
available_at | INT UNSIGNED | Not null | None | Available at |
created_at | INT UNSIGNED | Not null | None | Created at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
jobs_queue_index | queue | INDEX |
39. languages
Description: Languages
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
name | VARCHAR(64) | Not null | None | Name |
code | VARCHAR(16) | Not null | None | Code |
locale | VARCHAR(255) | Not null | None | Browser language identifier |
image | VARCHAR(255) | Not null | None | Language icon |
sort_order | INT | Not null | None | Sort order |
active | TINYINT | Not null | 1 | Whether enabled |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
40. mail_logs
Description: Email delivery logs
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
to_email | VARCHAR(191) | Not null | None | Recipient email address |
to_name | VARCHAR(191) | | NULL | Recipient name |
from_email | VARCHAR(191) | | NULL | Sender email address |
from_name | VARCHAR(191) | | NULL | Sender name |
subject | VARCHAR(191) | Not null | None | Email subject |
content | LONGTEXT | | NULL | Email content |
mail_type | VARCHAR(191) | | NULL | Email type |
transport | VARCHAR(50) | | NULL | Mail transport |
status | ENUM('pending','sent','failed') | Not null | pending | Delivery status |
error_message | TEXT | | NULL | Error message |
headers | JSON | | NULL | Email headers |
attachments | JSON | | NULL | Attachment information |
sent_at | TIMESTAMP | | NULL | Sent at |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
mail_logs_to_email_created_at_index | to_email, created_at | INDEX |
mail_logs_status_created_at_index | status, created_at | INDEX |
mail_logs_mail_type_index | mail_type | INDEX |
41. migrations
Description: Laravel database migration records
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | INT UNSIGNED | Primary, Auto increment, Not null | None | Primary key ID |
migration | VARCHAR(191) | Not null | None | Migration filename (without .php) |
batch | INT | Not null | None | Migration batch |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
42. model_has_permissions
Description: Model permissions
Fields
| Field | Type | Attributes | Default | Description |
|---|
permission_id | BIGINT UNSIGNED | Primary, Not null | None | Permission ID |
model_type | VARCHAR(191) | Primary, Not null | None | Model type |
model_id | BIGINT UNSIGNED | Primary, Not null | None | Model ID |
Indexes
| Name | Field | Type |
|---|
PRIMARY | permission_id, model_id, model_type | PRIMARY |
model_has_permissions_model_id_model_type_index | model_id, model_type | INDEX |
Foreign Keys
| Name | Field | References | On delete |
|---|
model_has_permissions_permission_id_foreign | permission_id | permissions (id) | CASCADE |
43. model_has_roles
Description: Model roles
Fields
| Field | Type | Attributes | Default | Description |
|---|
role_id | BIGINT UNSIGNED | Primary, Not null | None | Role ID |
model_type | VARCHAR(191) | Primary, Not null | None | Model type |
model_id | BIGINT UNSIGNED | Primary, Not null | None | Model ID |
Indexes
| Name | Field | Type |
|---|
PRIMARY | role_id, model_id, model_type | PRIMARY |
model_has_roles_model_id_model_type_index | model_id, model_type | INDEX |
Foreign Keys
| Name | Field | References | On delete |
|---|
model_has_roles_role_id_foreign | role_id | roles (id) | CASCADE |
44. notifications
Description: Notifications
The notifiable_id_new and migrated columns are helper fields retained by the core migrations. The current migrations do not remove them.
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | CHAR(36) | Primary, Not null | None | UUID |
type | VARCHAR(191) | Not null | None | Type |
notifiable_type | VARCHAR(191) | Not null | None | Notifiable model type |
notifiable_id | BIGINT | Not null | None | Notifiable model ID |
notifiable_id_new | BIGINT | | NULL | Shadow column for migrating the notifiable model ID |
migrated | TINYINT(1) | Not null | 0 | Data migration status flag |
data | TEXT | Not null | None | Notification data |
read_at | TIMESTAMP | | NULL | Read at |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
idx_notifiable_id_new | notifiable_id_new | INDEX |
idx_migrated | migrated | INDEX |
45. order_histories
Description: Order status history
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
order_id | INT | Not null | None | Order ID |
status | VARCHAR(191) | Not null | None | New order status |
notify | TINYINT(1) | Not null | None | Whether to notify |
comment | TEXT | Not null | None | Status change comment |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
order_histories_order_id | order_id | INDEX |
46. order_payments
Description: Order payments
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
order_id | INT | Not null | None | Order ID |
transaction_id | VARCHAR(191) | | NULL | Transaction ID |
request | TEXT | | NULL | Request data |
response | TEXT | | NULL | Response data |
callback | TEXT | | NULL | Callback data |
receipt | TEXT | | NULL | Receipt |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
47. order_products
Description: Order items
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
order_id | INT | Not null | None | Order ID |
product_id | INT | Not null | None | Product ID |
order_number | VARCHAR(191) | Not null | None | Order number |
product_sku | VARCHAR(191) | Not null | None | Product SKU |
name | VARCHAR(500) | Not null | None | Product name at the time of purchase |
image | VARCHAR(191) | Not null | None | Product image |
quantity | INT | Not null | None | Purchase quantity |
price | DECIMAL(16,4) | Not null | None | Unit price |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
deleted_at | TIMESTAMP | | NULL | Deleted at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
order_products_order_id | order_id | INDEX |
order_products_product_id | product_id | INDEX |
idx_order_products_ranking | product_id, order_id | INDEX |
48. order_shipments
Description: Order shipments
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
order_id | INT | Not null | None | Order ID |
express_code | VARCHAR(191) | Not null | None | Carrier code |
express_company | VARCHAR(191) | Not null | None | Carrier name |
express_number | VARCHAR(191) | Not null | None | Tracking number |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
order_id | order_id | INDEX |
49. order_totals
Description: Order total components
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
order_id | INT | Not null | None | Order ID |
code | VARCHAR(191) | Not null | None | Type code |
value | DECIMAL(20,2) | Not null | None | Amount |
title | VARCHAR(191) | Not null | None | Name |
reference | JSON | Not null | None | Additional information |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
order_totals_order_id | order_id | INDEX |
50. orders
Description: Orders
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
number | VARCHAR(191) | Not null | None | Order number |
customer_id | INT | Not null | None | Customer ID |
customer_group_id | INT | Not null | None | Customer group ID |
shipping_address_id | INT | Not null | None | Shipping address ID |
payment_address_id | INT | Not null | None | Billing address ID |
customer_name | VARCHAR(191) | Not null | None | Customer name |
email | VARCHAR(191) | Not null | None | Customer email |
calling_code | INT | Not null | None | Calling code |
telephone | VARCHAR(191) | Not null | None | Phone number |
total | DECIMAL(16,4) | Not null | None | Total amount |
locale | VARCHAR(191) | Not null | None | Languages |
currency_code | VARCHAR(191) | Not null | None | Current currency |
currency_value | VARCHAR(191) | Not null | None | Current exchange rate |
ip | VARCHAR(191) | Not null | None | IP address at checkout |
user_agent | TEXT | Not null | None | Browser information at checkout |
comment | VARCHAR(191) | Not null | '' | Customer comment |
status | VARCHAR(191) | Not null | None | Order status |
shipping_method_code | VARCHAR(191) | Not null | None | Shipping method code |
shipping_method_name | VARCHAR(191) | Not null | None | Shipping method name |
shipping_customer_name | VARCHAR(191) | Not null | None | Shipping recipient name |
shipping_calling_code | VARCHAR(191) | Not null | None | Shipping address calling code |
shipping_telephone | VARCHAR(191) | Not null | None | Shipping address phone number |
shipping_country | VARCHAR(191) | Not null | None | Shipping country |
shipping_country_id | INT UNSIGNED | Not null | None | Country ID |
shipping_zone_id | INT UNSIGNED | Not null | None | State/province ID |
shipping_zone | VARCHAR(191) | Not null | None | Shipping state/province |
shipping_city | VARCHAR(191) | Not null | None | Shipping city |
shipping_address_1 | VARCHAR(191) | Not null | None | Shipping address line 1 |
shipping_address_2 | VARCHAR(191) | Not null | None | Shipping address line 2 |
shipping_zipcode | VARCHAR(191) | Not null | None | Shipping postal code |
payment_method_code | VARCHAR(191) | Not null | None | Payment method code |
payment_method_name | VARCHAR(191) | Not null | None | Payment method name |
payment_customer_name | VARCHAR(191) | Not null | None | Billing name |
payment_calling_code | VARCHAR(191) | Not null | None | Billing address calling code |
payment_telephone | VARCHAR(191) | Not null | None | Billing address phone number |
payment_country | VARCHAR(191) | Not null | None | Billing country |
payment_country_id | INT UNSIGNED | Not null | None | Country ID |
payment_zone_id | INT UNSIGNED | Not null | None | State/province ID |
payment_zone | VARCHAR(191) | Not null | None | Billing state/province |
payment_city | VARCHAR(191) | Not null | None | Billing city |
payment_address_1 | VARCHAR(191) | Not null | None | Billing address line 1 |
payment_address_2 | VARCHAR(191) | Not null | None | Billing address line 1 |
payment_zipcode | VARCHAR(191) | Not null | None | Billing postal code |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
deleted_at | TIMESTAMP | | NULL | Deleted at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
orders_customer_id | customer_id | INDEX |
orders_customer_group_id | customer_group_id | INDEX |
orders_shipping_address_id | shipping_address_id | INDEX |
orders_payment_address_id | payment_address_id | INDEX |
idx_orders_stats | created_at, status | INDEX |
idx_orders_payment_stats | created_at, status | INDEX |
51. page_categories
Description: Article categories
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
parent_id | INT | Not null | None | Parent category |
position | INT | Not null | None | Sort order |
active | TINYINT(1) | Not null | None | Whether enabled |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
52. page_category_descriptions
Description: Article category descriptions
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
page_category_id | INT | Not null | None | Category ID |
locale | VARCHAR(191) | Not null | None | Languages |
title | VARCHAR(255) | Not null | None | Title |
summary | TEXT | Not null | None | Category summary |
meta_title | VARCHAR(255) | Not null | None | SEO title |
meta_description | VARCHAR(500) | Not null | None | SEO description |
meta_keywords | VARCHAR(255) | Not null | None | SEO keywords |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
page_category_descriptions_page_category_id | page_category_id | INDEX |
53. page_descriptions
Description: Page titles, descriptions, and details
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
page_id | INT | Not null | None | Page ID |
locale | VARCHAR(191) | Not null | None | Languages |
title | VARCHAR(255) | Not null | None | Title |
summary | VARCHAR(500) | Not null | None | Article summary |
content | LONGTEXT | Not null | None | Article content |
meta_title | VARCHAR(255) | Not null | None | SEO title |
meta_description | VARCHAR(500) | Not null | None | SEO description |
meta_keywords | VARCHAR(255) | Not null | None | SEO keywords |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
page_descriptions_page_id | page_id | INDEX |
54. page_products
Description: Article-product associations
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
page_id | INT | Not null | None | Article ID |
product_id | INT | Not null | None | Product ID |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
page_products_page_id | page_id | INDEX |
page_products_product_id | product_id | INDEX |
55. pages
Description: Pages
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
page_category_id | INT | Not null | None | Article category ID |
image | VARCHAR(191) | Not null | '' | Cover image |
position | INT | Not null | None | Sort order |
views | INT | Not null | None | View count |
author | VARCHAR(191) | Not null | None | Author |
active | TINYINT(1) | Not null | None | Whether enabled |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
pages_page_category_id | page_category_id | INDEX |
56. permissions
Description: Administrator permissions
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
name | VARCHAR(191) | Not null | None | Permission name |
guard_name | VARCHAR(191) | Not null | None | Permission guard name |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
permissions_name_guard_name_unique | name, guard_name | UNIQUE |
57. plugins
Description: Plugins
This plugin registry table is part of the core system. This dictionary excludes tables created by plugins.
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
type | VARCHAR(191) | Not null | None | Type: shipping, payment |
code | VARCHAR(191) | Not null | None | Code (unique identifier) |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
58. product_attributes
Description: Product-attribute associations
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
product_id | INT UNSIGNED | Not null | None | Product ID |
attribute_id | INT UNSIGNED | Not null | None | Attribute ID |
attribute_value_id | INT UNSIGNED | Not null | None | Attribute value ID |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
product_id_attribute_id | product_id, attribute_id | INDEX |
product_attributes_product_id | product_id | INDEX |
product_attributes_attribute_id | attribute_id | INDEX |
product_attributes_attribute_value_id | attribute_value_id | INDEX |
59. product_categories
Description: Product-category associations
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
product_id | BIGINT UNSIGNED | Not null | None | Product ID |
category_id | BIGINT UNSIGNED | Not null | None | Category ID |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
product_categories_product_id | product_id | INDEX |
product_categories_category_id | category_id | INDEX |
60. product_descriptions
Description: Product names, descriptions, and details
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
product_id | BIGINT UNSIGNED | Not null | None | Product ID |
locale | VARCHAR(191) | Not null | None | Languages |
name | VARCHAR(255) | Not null | None | Name |
content | LONGTEXT | Not null | None | Product details |
meta_title | VARCHAR(255) | Not null | None | SEO title |
meta_description | VARCHAR(500) | Not null | None | SEO description |
meta_keywords | VARCHAR(255) | Not null | None | SEO keywords |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
product_descriptions_product_id | product_id | INDEX |
idx_product_descriptions_locale | product_id, locale | INDEX |
61. product_relations
Description: Related products
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
product_id | INT UNSIGNED | Not null | None | Product ID |
relation_id | INT UNSIGNED | Not null | None | Related product ID |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
product_id | product_id | INDEX |
relation_id | relation_id | INDEX |
62. product_skus
Description: Product SKUs
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
product_id | BIGINT UNSIGNED | Not null | None | Product ID |
variants | JSON | | NULL | SKU variant options |
position | INT | Not null | 0 | Sort order |
active | TINYINT(1) | Not null | 1 | Status: 1=enabled, 0=disabled |
images | JSON | | NULL | Images |
model | VARCHAR(191) | Not null | '' | Model |
sku | VARCHAR(191) | Not null | '' | SKU |
price | DOUBLE | Not null | 0 | Price |
origin_price | DOUBLE | Not null | 0 | Compare-at price |
cost_price | DOUBLE | Not null | 0 | Cost price |
weight | DOUBLE | | NULL | Weight |
quantity | INT | Not null | 0 | Stock quantity |
is_default | TINYINT(1) | Not null | None | Whether default |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
product_skus_sku_unique | sku | UNIQUE |
product_skus_product_id | product_id | INDEX |
idx_product_skus_default | product_id, is_default | INDEX |
63. product_views
Description: Product view records
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
product_id | INT | | NULL | Product ID |
customer_id | INT | | NULL | Customer ID |
ip | VARCHAR(191) | | NULL | IP |
session_id | VARCHAR(191) | | NULL | Session ID |
referer | VARCHAR(500) | | NULL | Referrer page URL |
user_agent | VARCHAR(500) | | NULL | User-Agent |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
idx_product_views_visitor_stats | created_at, customer_id, session_id, ip | INDEX |
idx_product_views_product_stats | created_at, product_id | INDEX |
idx_product_views_source_analysis | created_at, referer | INDEX |
64. products
Description: Products
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
brand_id | INT UNSIGNED | Not null | None | Brand ID |
images | JSON | | NULL | Images |
price | DECIMAL(8,2) | Not null | 0.00 | Price |
video | TEXT | Not null | None | Product video data (stored as TEXT) |
position | INT | Not null | 0 | Sort order |
shipping | TINYINT(1) | Not null | 1 | Whether shipping is required |
active | TINYINT(1) | Not null | 0 | Whether enabled |
variables | JSON | | NULL | Product variant data |
tax_class_id | INT | Not null | 0 | Tax class ID |
weight | DOUBLE | Not null | 0 | Weight |
weight_class | VARCHAR(191) | Not null | '' | Weight unit |
sales | INT | Not null | 0 | Sales count |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
deleted_at | TIMESTAMP | | NULL | Deleted at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
products_brand_id | brand_id | INDEX |
products_tax_class_id | tax_class_id | INDEX |
idx_products_active_created | active, created_at | INDEX |
65. region_zones
Description: Region group associations with countries, states, and cities
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
region_id | INT | Not null | None | Region group ID |
country_id | INT | Not null | None | Country ID |
zone_id | INT | Not null | None | State/province ID |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
region_zones_region_id | region_id | INDEX |
region_zones_country_id | country_id | INDEX |
region_zones_zone_id | zone_id | INDEX |
66. regions
Description: Region groups, such as Jiangsu-Zhejiang-Shanghai or western China
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
name | VARCHAR(191) | Not null | None | Region group name |
description | VARCHAR(191) | Not null | None | Description |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
67. rma_histories
Description: After-sales status history
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
rma_id | INT UNSIGNED | Not null | None | After-sales request ID |
status | VARCHAR(191) | Not null | None | Status |
notify | TINYINT | Not null | None | Whether to notify |
comment | TEXT | Not null | None | Comment |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
rma_histories_rma_id | rma_id | INDEX |
68. rma_reasons
Description: After-sales reasons
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
name | JSON | Not null | None | After-sales reason, e.g. {"en":"Cannot be used"} |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
69. rmas
Description: After-sales requests
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
order_id | INT UNSIGNED | Not null | None | Order ID |
order_product_id | INT UNSIGNED | Not null | None | Order item ID |
customer_id | INT UNSIGNED | Not null | None | Customer ID |
name | VARCHAR(191) | Not null | None | Customer name |
email | VARCHAR(191) | Not null | None | Customer email |
telephone | VARCHAR(191) | Not null | None | Customer phone number |
product_name | VARCHAR(191) | Not null | None | Product name |
sku | VARCHAR(191) | Not null | None | SKU |
quantity | INT | Not null | None | Return quantity |
images | JSON | Not null | None | After-sales request attachment images |
opened | TINYINT | Not null | None | Whether the packaging has been opened |
rma_reason_id | INT UNSIGNED | Not null | None | After-sales reason ID |
type | VARCHAR(191) | Not null | None | After-sales service type: return, exchange, repair, replacement shipment, or refund only |
status | VARCHAR(191) | Not null | None | Status |
comment | TEXT | Not null | None | Comment |
express_com | VARCHAR(191) | | NULL | Carrier name |
express_no | VARCHAR(191) | | NULL | Tracking number |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
rmas_order_id | order_id | INDEX |
rmas_order_product_id | order_product_id | INDEX |
rmas_customer_id | customer_id | INDEX |
rmas_rma_reason_id | rma_reason_id | INDEX |
70. role_has_permissions
Description: Administrator role permissions
Fields
| Field | Type | Attributes | Default | Description |
|---|
permission_id | BIGINT UNSIGNED | Primary, Not null | None | Permission ID |
role_id | BIGINT UNSIGNED | Primary, Not null | None | Role ID |
Indexes
| Name | Field | Type |
|---|
PRIMARY | permission_id, role_id | PRIMARY |
role_has_permissions_role_id_foreign | role_id | INDEX |
Foreign Keys
| Name | Field | References | On delete |
|---|
role_has_permissions_permission_id_foreign | permission_id | permissions (id) | CASCADE |
role_has_permissions_role_id_foreign | role_id | roles (id) | CASCADE |
71. roles
Description: Administrator roles
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
name | VARCHAR(191) | Not null | None | Role name |
guard_name | VARCHAR(191) | Not null | None | Guard name |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
roles_name_guard_name_unique | name, guard_name | UNIQUE |
72. settings
Description: System settings
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
type | VARCHAR(191) | Not null | None | Type: system or plugin |
space | VARCHAR(191) | Not null | None | Configuration group, such as stripe, paypal, or flat_shipping |
name | VARCHAR(191) | Not null | None | Configuration name (similar to a field name) |
value | LONGTEXT | Not null | None | Configuration value |
json | TINYINT(1) | Not null | 0 | Whether the value is JSON |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
73. tax_classes
Description: Tax classes
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
title | VARCHAR(191) | Not null | None | Tax class title |
description | VARCHAR(191) | Not null | None | Tax class description |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
74. tax_rates
Description: Tax rates
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
region_id | INT | Not null | None | Region group ID |
name | VARCHAR(191) | Not null | None | Name |
rate | VARCHAR(191) | Not null | None | Tax rate value |
type | ENUM('percent','flat') | Not null | None | Type: percent (percentage) or flat (fixed amount) |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
tax_rates_region_id | region_id | INDEX |
75. tax_rules
Description: Tax rules
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
tax_class_id | INT | Not null | None | Tax class ID |
tax_rate_id | INT | Not null | None | Tax rate ID |
based | ENUM('store','payment','shipping') | Not null | None | Address type |
priority | INT | Not null | None | Priority |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
tax_rules_tax_class_id | tax_class_id | INDEX |
tax_rules_tax_rate_id | tax_rate_id | INDEX |
76. verify_codes
Description: Verification codes
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
account | VARCHAR(256) | Not null | None | Account |
code | VARCHAR(16) | Not null | None | Verification codes |
deleted_at | TIMESTAMP | | NULL | Deleted at |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
77. zones
Description: States and provinces
Fields
| Field | Type | Attributes | Default | Description |
|---|
id | BIGINT UNSIGNED | Primary, Auto increment, Not null | None | ID |
country_id | INT UNSIGNED | Not null | None | Country ID |
name | VARCHAR(64) | Not null | None | Name |
code | VARCHAR(16) | Not null | None | Code |
sort_order | INT | Not null | None | Sort order |
active | TINYINT | Not null | 1 | Whether enabled |
created_at | TIMESTAMP | | NULL | Created at |
updated_at | TIMESTAMP | | NULL | Updated at |
Indexes
| Name | Field | Type |
|---|
PRIMARY | id | PRIMARY |
zones_country_id | country_id | INDEX |