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