magento 2 - ERD
Tables (50)
admin_analytics_usage_version_log
- id — int(10) — Primary key — NOT NULL — Log ID
- last_viewed_in_version — varchar(50) — NOT NULL — Viewer last viewed on product version
admin_passwords
- password_id — int(10) — Primary key — NOT NULL — Password ID
- user_id — int(10) — Foreign key → admin_user.user_id — NOT NULL — User ID
- password_hash — varchar(100) — Password Hash
- expires — int(10) — NOT NULL — Deprecated
- last_updated — int(10) — NOT NULL — Last Updated
admin_system_messages
- identity — varchar(100) — Primary key — NOT NULL — Message ID
- severity — smallint(5) — NOT NULL — Problem type
- created_at — timestamp — NOT NULL — Create date
admin_user
- user_id — int(10) — Primary key — NOT NULL — User ID
- firstname — varchar(32) — User First Name
- lastname — varchar(32) — User Last Name
- email — varchar(128) — User Email
- username — varchar(40) — User Login
- password — varchar(255) — NOT NULL — User Password
- created — timestamp — NOT NULL — User Created Time
- modified — timestamp — NOT NULL — User Modified Time
- logdate — timestamp — User Last Login Time
- lognum — smallint(5) — NOT NULL — User Login Number
- reload_acl_flag — smallint(6) — NOT NULL — Reload ACL
- is_active — smallint(6) — NOT NULL — User Is Active
- extra — text — User Extra Data
- rp_token — text — Reset Password Link Token
- rp_token_created_at — timestamp — Reset Password Link Token Creation Date
- interface_locale — varchar(16) — NOT NULL — Backend interface locale
- failures_num — smallint(6) — Failure Number
- first_failure — timestamp — First Failure
- lock_expires — timestamp — Expiration Lock Dates
- refresh_token — text — Email connector refresh token
admin_user_expiration
- user_id — int(10) — Foreign key → admin_user.user_id — NOT NULL — User ID
- expires_at — timestamp — NOT NULL — User Expiration Date
admin_user_session
- id — int(10) — Primary key — NOT NULL — Entity ID
- session_id — varchar(128) — NOT NULL — Session ID value
- user_id — int(10) — Foreign key → admin_user.user_id — Admin User ID
- status — smallint(5) — NOT NULL — Current Session status
- created_at — timestamp — NOT NULL — Created Time
- updated_at — timestamp — NOT NULL — Update Time
- ip — varchar(15) — NOT NULL — Remote user IP
adminnotification_inbox
- notification_id — int(10) — Primary key — NOT NULL — Notification ID
- severity — smallint(5) — NOT NULL — Problem type
- date_added — timestamp — NOT NULL — Create date
- title — varchar(255) — NOT NULL — Title
- description — text — Description
- url — varchar(255) — Url
- is_read — smallint(5) — NOT NULL — Flag if notification read
- is_remove — smallint(5) — NOT NULL — Flag if notification might be removed
adobe_stock_asset
- id — int(10) — Primary key — NOT NULL — Entity ID
- media_gallery_id — int(10) — Foreign key — Media gallery ID
- category_id — int(10) — Foreign key → adobe_stock_category.id — Category ID
- creator_id — int(10) — Foreign key → adobe_stock_creator.id — Creator ID
- is_licensed — int(10) — NOT NULL — Is Licensed
- creation_date — varchar(255) — Creation Date
adobe_stock_category
- id — int(10) — Primary key — NOT NULL — Entity ID
- name — varchar(255) — Name
adobe_stock_creator
- id — int(10) — Primary key — NOT NULL — ID
- name — varchar(255) — Asset creator's name
adobe_user_profile
- id — int(10) — Primary key — NOT NULL — Entity ID
- admin_user_id — int(10) — Foreign key → admin_user.user_id — NOT NULL — Admin User Id
- name — varchar(255) — NOT NULL — Display Name
- email — varchar(255) — NOT NULL — user profile email
- image — varchar(255) — NOT NULL — user profile avatar
- account_type — varchar(255) — Account Type
- access_token — text — Access Token
- refresh_token — text — Refresh Token
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
- access_token_expires_at — timestamp — NOT NULL — Access Token Expires At
amazon_customer
- entity_id — int(10) — Primary key — NOT NULL — Entity_id
- customer_id — int(10) — Foreign key — NOT NULL — Customer_id
- amazon_id — varchar(255) — NOT NULL — Amazon_id
amazon_pending_authorization
- entity_id — int(10) — Primary key — NOT NULL — Entity_id
- order_id — int(10) — NOT NULL — Order_id
- payment_id — int(10) — NOT NULL — Payment_id
- authorization_id — varchar(255) — Authorization_id
- created_at — datetime — NOT NULL — Created_at
- updated_at — datetime — Updated_at
- processed — smallint(5) — Initial authorization processed
- capture — smallint(5) — Initial authorization has capture
- capture_id — varchar(255) — Initial authorization capture id
amazon_pending_capture
- entity_id — int(10) — Primary key — NOT NULL — Entity_id
- capture_id — varchar(255) — NOT NULL — Capture_id
- created_at — datetime — NOT NULL — Created_at
- order_id — int(10) — NOT NULL — order id
- payment_id — int(10) — NOT NULL — payment id
amazon_pending_refund
- entity_id — int(10) — Primary key — NOT NULL — Entity_id
- refund_id — varchar(255) — NOT NULL — Refund_id
- created_at — datetime — NOT NULL — Created_at
- order_id — int(10) — NOT NULL — Order_id
- payment_id — int(10) — NOT NULL — Payment_id
amazon_quote
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- quote_id — int(10) — Foreign key — NOT NULL — Quote ID
- amazon_order_reference_id — varchar(255) — NOT NULL — Amazon Order Reference ID
- sandbox_simulation_reference — varchar(255) — Sandbox simulation reference
- confirmed — smallint(5) — NOT NULL — Quote confirmed with Amazon
amazon_sales_order
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- order_id — int(10) — Foreign key — NOT NULL — Order ID
- amazon_order_reference_id — varchar(255) — NOT NULL — Amazon Order Reference ID
authorization_role
- role_id — int(10) — Primary key — NOT NULL — Role ID
- parent_id — int(10) — NOT NULL — Parent Role ID
- tree_level — smallint(5) — NOT NULL — Role Tree Level
- sort_order — smallint(5) — NOT NULL — Role Sort Order
- role_type — varchar(1) — NOT NULL — Role Type
- user_id — int(10) — NOT NULL — User ID
- user_type — varchar(16) — User Type
- role_name — varchar(50) — Role Name
authorization_rule
- rule_id — int(10) — Primary key — NOT NULL — Rule ID
- role_id — int(10) — Foreign key → authorization_role.role_id — NOT NULL — Role ID
- resource_id — varchar(255) — Resource ID
- privileges — varchar(20) — Privileges
- permission — varchar(10) — Permission
braintree_credit_prices
- id — int(10) — Primary key — NOT NULL — Row ID
- product_id — int(10) — NOT NULL — Product Id
- term — int(11) — NOT NULL — Credit Term
- monthly_payment — decimal(12, 2) — NOT NULL — Monthly Payment
- instalment_rate — decimal(12, 2) — NOT NULL — Instalment Rate
- cost_of_purchase — decimal(12, 2) — NOT NULL — Cost of purchase
- total_inc_interest — decimal(12, 2) — NOT NULL — Total Inc Interest
braintree_transaction_details
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- order_id — int(10) — Foreign key — NOT NULL — Order Id
- transaction_source — varchar(12) — Transaction Source
cache
- id — varchar(200) — Primary key — NOT NULL — Cache Id
- data — mediumblob — Cache Data
- create_time — int(11) — Cache Creation Time
- update_time — int(11) — Time of Cache Updating
- expire_time — int(11) — Cache Expiration Time
cache_tag
- tag — varchar(100) — Primary key — NOT NULL — Tag
- cache_id — varchar(200) — Primary key — NOT NULL — Cache Id
captcha_log
- type — varchar(32) — Primary key — NOT NULL — Type
- value — varchar(255) — Primary key — NOT NULL — Value
- count — int(10) — NOT NULL — Count
- updated_at — timestamp — Update Time
catalog_category_entity
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- attribute_set_id — smallint(5) — NOT NULL — Attribute Set ID
- parent_id — int(10) — NOT NULL — Parent Category ID
- created_at — timestamp — NOT NULL — Creation Time
- updated_at — timestamp — NOT NULL — Update Time
- path — varchar(255) — NOT NULL — Tree Path
- position — int(11) — NOT NULL — Position
- level — int(11) — NOT NULL — Tree Level
- children_count — int(11) — NOT NULL — Child Count
catalog_category_entity_datetime
- value_id — int(11) — Primary key — NOT NULL — Value ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Entity ID
- value — datetime — Value
catalog_category_entity_decimal
- value_id — int(11) — Primary key — NOT NULL — Value ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Entity ID
- value — decimal(20, 6) — Value
catalog_category_entity_int
- value_id — int(11) — Primary key — NOT NULL — Value ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Entity ID
- value — int(11) — Value
catalog_category_entity_text
- value_id — int(11) — Primary key — NOT NULL — Value ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Entity ID
- value — text — Value
catalog_category_entity_varchar
- value_id — int(11) — Primary key — NOT NULL — Value ID
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- entity_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Entity ID
- value — varchar(255) — Value
catalog_category_product
- entity_id — int(11) — Primary key — NOT NULL — Entity ID
- category_id — int(10) — Foreign key → catalog_category_entity.entity_id — NOT NULL — Category ID
- product_id — int(10) — Foreign key — NOT NULL — Product ID
- position — int(11) — NOT NULL — Position
catalog_category_product_index
- category_id — int(10) — Primary key — NOT NULL — Category ID
- product_id — int(10) — Primary key — NOT NULL — Product ID
- store_id — smallint(5) — Primary key — NOT NULL — Store ID
- position — int(11) — Position
- is_parent — smallint(5) — NOT NULL — Is Parent
- visibility — smallint(5) — NOT NULL — Visibility
catalog_category_product_index_replica
- category_id — int(10) — Primary key — NOT NULL — Category ID
- product_id — int(10) — Primary key — NOT NULL — Product ID
- store_id — smallint(5) — Primary key — NOT NULL — Store ID
- position — int(11) — Position
- is_parent — smallint(5) — NOT NULL — Is Parent
- visibility — smallint(5) — NOT NULL — Visibility
catalog_category_product_index_store1
- category_id — int(10) — Primary key — NOT NULL — Category Id
- product_id — int(10) — Primary key — NOT NULL — Product Id
- store_id — smallint(5) — Primary key — NOT NULL — Store Id
- position — int(11) — Position
- is_parent — smallint(5) — NOT NULL — Is Parent
- visibility — smallint(5) — NOT NULL — Visibility
cataloginventory_stock
- stock_id — smallint(5) — Primary key — NOT NULL — Stock ID
- website_id — smallint(5) — NOT NULL — Website ID
- stock_name — varchar(255) — Stock Name
cataloginventory_stock_item
- item_id — int(10) — Primary key — NOT NULL — Item ID
- product_id — int(10) — Foreign key — NOT NULL — Product ID
- stock_id — smallint(5) — Foreign key → cataloginventory_stock.stock_id — NOT NULL — Stock ID
- qty — decimal(12, 4) — Qty
- min_qty — decimal(12, 4) — NOT NULL — Min Qty
- use_config_min_qty — smallint(5) — NOT NULL — Use Config Min Qty
- is_qty_decimal — smallint(5) — NOT NULL — Is Qty Decimal
- backorders — smallint(5) — NOT NULL — Backorders
- use_config_backorders — smallint(5) — NOT NULL — Use Config Backorders
- min_sale_qty — decimal(12, 4) — NOT NULL — Min Sale Qty
- use_config_min_sale_qty — smallint(5) — NOT NULL — Use Config Min Sale Qty
- max_sale_qty — decimal(12, 4) — NOT NULL — Max Sale Qty
- use_config_max_sale_qty — smallint(5) — NOT NULL — Use Config Max Sale Qty
- is_in_stock — smallint(5) — NOT NULL — Is In Stock
- low_stock_date — timestamp — Low Stock Date
- notify_stock_qty — decimal(12, 4) — Notify Stock Qty
- use_config_notify_stock_qty — smallint(5) — NOT NULL — Use Config Notify Stock Qty
- manage_stock — smallint(5) — NOT NULL — Manage Stock
- use_config_manage_stock — smallint(5) — NOT NULL — Use Config Manage Stock
- stock_status_changed_auto — smallint(5) — NOT NULL — Stock Status Changed Automatically
- use_config_qty_increments — smallint(5) — NOT NULL — Use Config Qty Increments
- qty_increments — decimal(12, 4) — NOT NULL — Qty Increments
- use_config_enable_qty_inc — smallint(5) — NOT NULL — Use Config Enable Qty Increments
- enable_qty_increments — smallint(5) — NOT NULL — Enable Qty Increments
- is_decimal_divided — smallint(5) — NOT NULL — Is Divided into Multiple Boxes for Shipping
- website_id — smallint(5) — NOT NULL — Website ID
cataloginventory_stock_status
- product_id — int(10) — Primary key — NOT NULL — Product ID
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- stock_id — smallint(5) — Primary key — NOT NULL — Stock ID
- qty — decimal(12, 4) — NOT NULL — Qty
- stock_status — smallint(5) — NOT NULL — Stock Status
cataloginventory_stock_status_idx
- product_id — int(10) — Primary key — NOT NULL — Product ID
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- stock_id — smallint(5) — Primary key — NOT NULL — Stock ID
- qty — decimal(12, 4) — NOT NULL — Qty
- stock_status — smallint(5) — NOT NULL — Stock Status
cataloginventory_stock_status_replica
- product_id — int(10) — Primary key — NOT NULL — Product ID
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- stock_id — smallint(5) — Primary key — NOT NULL — Stock ID
- qty — decimal(12, 4) — NOT NULL — Qty
- stock_status — smallint(5) — NOT NULL — Stock Status
cataloginventory_stock_status_tmp
- product_id — int(10) — Primary key — NOT NULL — Product ID
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
- stock_id — smallint(5) — Primary key — NOT NULL — Stock ID
- qty — decimal(12, 4) — NOT NULL — Qty
- stock_status — smallint(5) — NOT NULL — Stock Status
catalogrule
- rule_id — int(10) — Primary key — NOT NULL — Entity ID
- name — varchar(255) — Name
- description — text — Description
- from_date — date — From
- to_date — date — To
- is_active — smallint(6) — NOT NULL — Is Active
- conditions_serialized — mediumtext — Conditions Serialized
- actions_serialized — mediumtext — Actions Serialized
- stop_rules_processing — smallint(6) — NOT NULL — Stop Rules Processing
- sort_order — int(10) — NOT NULL — Sort Order
- simple_action — varchar(32) — Simple Action
- discount_amount — decimal(20, 6) — NOT NULL — Discount Amount
catalogrule_customer_group
- rule_id — int(10) — Foreign key → catalogrule.rule_id — NOT NULL — Rule ID
- customer_group_id — int(10) — Foreign key — NOT NULL — Customer Group ID
catalogrule_group_website
- rule_id — int(10) — Primary key — NOT NULL — Rule ID
- customer_group_id — int(10) — Primary key — NOT NULL — Customer Group ID
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
catalogrule_group_website_replica
- rule_id — int(10) — Primary key — NOT NULL — Rule ID
- customer_group_id — int(10) — Primary key — NOT NULL — Customer Group ID
- website_id — smallint(5) — Primary key — NOT NULL — Website ID
catalogrule_product
- rule_product_id — int(10) — Primary key — NOT NULL — Rule Product ID
- rule_id — int(10) — NOT NULL — Rule ID
- from_time — int(10) — NOT NULL — From Time
- to_time — int(10) — NOT NULL — To time
- customer_group_id — int(11)
- product_id — int(10) — NOT NULL — Product ID
- action_operator — varchar(10) — Action Operator
- action_amount — decimal(20, 6) — NOT NULL — Action Amount
- action_stop — smallint(6) — NOT NULL — Action Stop
- sort_order — int(10) — NOT NULL — Sort Order
- website_id — smallint(5) — NOT NULL — Website ID
catalogrule_product_price
- rule_product_price_id — int(10) — Primary key — NOT NULL — Rule Product PriceId
- rule_date — date — NOT NULL — Rule Date
- customer_group_id — int(11)
- product_id — int(10) — NOT NULL — Product ID
- rule_price — decimal(20, 6) — NOT NULL — Rule Price
- website_id — smallint(5) — NOT NULL — Website ID
- latest_start_date — date — Latest StartDate
- earliest_end_date — date — Earliest EndDate
catalogrule_product_price_replica
- rule_product_price_id — int(10) — Primary key — NOT NULL — Rule Product PriceId
- rule_date — date — NOT NULL — Rule Date
- customer_group_id — int(11)
- product_id — int(10) — NOT NULL — Product ID
- rule_price — decimal(20, 6) — NOT NULL — Rule Price
- website_id — smallint(5) — NOT NULL — Website ID
- latest_start_date — date — Latest StartDate
- earliest_end_date — date — Earliest EndDate
catalogrule_product_replica
- rule_product_id — int(10) — Primary key — NOT NULL — Rule Product ID
- rule_id — int(10) — NOT NULL — Rule ID
- from_time — int(10) — NOT NULL — From Time
- to_time — int(10) — NOT NULL — To time
- customer_group_id — int(11)
- product_id — int(10) — NOT NULL — Product ID
- action_operator — varchar(10) — Action Operator
- action_amount — decimal(20, 6) — NOT NULL — Action Amount
- action_stop — smallint(6) — NOT NULL — Action Stop
- sort_order — int(10) — NOT NULL — Sort Order
- website_id — smallint(5) — NOT NULL — Website ID
catalogrule_website
- rule_id — int(10) — Foreign key → catalogrule.rule_id — NOT NULL — Rule ID
- website_id — smallint(5) — Foreign key — NOT NULL — Website ID
catalogsearch_recommendations
- id — int(10) — Primary key — NOT NULL — ID
- query_id — int(10) — Foreign key — NOT NULL — Query ID
- relation_id — int(10) — Foreign key — NOT NULL — Relation ID