EC-Magento2-customer

Magento customer erd

Tables (22)

customer_address_entity

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • increment_id — varchar(50) — Increment Id
  • parent_id — int(10) — Foreign key → customer_entity.entity_id — Parent Id
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • is_active — smallint(5) — NOT NULL — Is Active
  • city — varchar(255) — NOT NULL — City
  • company — varchar(255) — Company
  • country_id — varchar(255) — NOT NULL — Country
  • fax — varchar(255) — Fax
  • firstname — varchar(255) — NOT NULL — First Name
  • lastname — varchar(255) — NOT NULL — Last Name
  • middlename — varchar(255) — Middle Name
  • postcode — varchar(255) — Zip/Postal Code
  • prefix — varchar(40) — Name Prefix
  • region — varchar(255) — State/Province
  • region_id — int(10) — State/Province
  • street — text — NOT NULL — Street Address
  • suffix — varchar(40) — Name Suffix
  • telephone — varchar(255) — NOT NULL — Phone Number
  • vat_id — varchar(255) — VAT number
  • vat_is_valid — int(10) — VAT number validity
  • vat_request_date — varchar(255) — VAT number validation request date
  • vat_request_id — varchar(255) — VAT number validation request ID
  • vat_request_success — int(10) — VAT number validation request success

customer_address_entity_datetime

  • value_id — int(11) — Primary key — NOT NULL — Value Id
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • entity_id — int(10) — Foreign key → customer_address_entity.entity_id — NOT NULL — Entity Id
  • value — datetime — Value

customer_address_entity_decimal

  • value_id — int(11) — Primary key — NOT NULL — Value Id
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • entity_id — int(10) — Foreign key → customer_address_entity.entity_id — NOT NULL — Entity Id
  • value — decimal(12,4) — NOT NULL — Value

customer_address_entity_int

  • value_id — int(11) — Primary key — NOT NULL — Value Id
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • entity_id — int(10) — Foreign key → customer_address_entity.entity_id — NOT NULL — Entity Id
  • value — int(11) — NOT NULL — Value

customer_address_entity_text

  • value_id — int(11) — Primary key — NOT NULL — Value Id
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • entity_id — int(10) — Foreign key → customer_address_entity.entity_id — NOT NULL — Entity Id
  • value — text — NOT NULL — Value

customer_address_entity_varchar

  • value_id — int(11) — Primary key — NOT NULL — Value Id
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • entity_id — int(10) — Foreign key → customer_address_entity.entity_id — NOT NULL — Entity Id
  • value — varchar(255) — Value

customer_eav_attribute

  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • is_visible — smallint(5) — NOT NULL — Is Visible
  • input_filter — varchar(255) — Input Filter
  • multiline_count — smallint(5) — NOT NULL — Multiline Count
  • validate_rules — text — Validate Rules
  • is_system — smallint(5) — NOT NULL — Is System
  • sort_order — int(10) — NOT NULL — Sort Order
  • data_model — varchar(255) — Data Model
  • is_used_in_grid — smallint(5) — NOT NULL — Is Used in Grid
  • is_visible_in_grid — smallint(5) — NOT NULL — Is Visible in Grid
  • is_filterable_in_grid — smallint(5) — NOT NULL — Is Filterable in Grid
  • is_searchable_in_grid — smallint(5) — NOT NULL — Is Searchable in Grid

customer_eav_attribute_website

  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • website_id — smallint(5) — Foreign key → store_website.website_id — NOT NULL — Website Id
  • is_visible — smallint(5) — Is Visible
  • is_required — smallint(5) — Is Required
  • default_value — text — Default Value
  • multiline_count — smallint(5) — Multiline Count

customer_entity

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • website_id — smallint(5) — Foreign key → store_website.website_id — Website Id
  • email — varchar(255) — Email
  • group_id — smallint(5) — NOT NULL — Group Id
  • increment_id — varchar(50) — Increment Id
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • is_active — smallint(5) — NOT NULL — Is Active
  • disable_auto_group_change — smallint(5) — NOT NULL — Disable automatic group change based on VAT ID
  • created_in — varchar(255) — Created From
  • prefix — varchar(40) — Name Prefix
  • firstname — varchar(255) — First Name
  • middlename — varchar(255) — Middle Name/Initial
  • lastname — varchar(255) — Last Name
  • suffix — varchar(40) — Name Suffix
  • dob — date — Date of Birth
  • password_hash — varchar(128) — Password_hash
  • rp_token — varchar(128) — Reset password token
  • rp_token_created_at — datetime — Reset password token creation time
  • default_billing — int(10) — Default Billing Address
  • default_shipping — int(10) — Default Shipping Address
  • taxvat — varchar(50) — Tax/VAT Number
  • confirmation — varchar(64) — Is Confirmed
  • gender — smallint(5) — Gender
  • failures_num — smallint(6) — Failure Number
  • first_failure — timestamp — First Failure
  • lock_expires — timestamp — Lock Expiration Date

customer_entity_datetime

  • value_id — int(11) — Primary key — NOT NULL — Value Id
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • entity_id — int(10) — Foreign key → customer_entity.entity_id — NOT NULL — Entity Id
  • value — datetime — Value

customer_entity_decimal

  • value_id — int(11) — Primary key — NOT NULL — Value Id
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • entity_id — int(10) — Foreign key → customer_entity.entity_id — NOT NULL — Entity Id
  • value — decimal(12,4) — NOT NULL — Value

customer_entity_int

  • value_id — int(11) — Primary key — NOT NULL — Value Id
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • entity_id — int(10) — Foreign key → customer_entity.entity_id — NOT NULL — Entity Id
  • value — int(11) — NOT NULL — Value

customer_entity_text

  • value_id — int(11) — Primary key — NOT NULL — Value Id
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • entity_id — int(10) — Foreign key → customer_entity.entity_id — NOT NULL — Entity Id
  • value — text — NOT NULL — Value

customer_entity_varchar

  • value_id — int(11) — Primary key — NOT NULL — Value Id
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • entity_id — int(10) — Foreign key → customer_entity.entity_id — NOT NULL — Entity Id
  • value — varchar(255) — Value

customer_form_attribute

  • form_code — varchar(32) — Primary key — NOT NULL — Form Code
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id

customer_grid_flat

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID
  • name — text — Name
  • email — varchar(255) — Email
  • group_id — int(11) — Group_id
  • created_at — timestamp — Created_at
  • website_id — int(11) — Website_id
  • confirmation — varchar(255) — Confirmation
  • created_in — text — Created_in
  • dob — date — Dob
  • gender — int(11) — Gender
  • taxvat — varchar(255) — Taxvat
  • lock_expires — timestamp — Lock_expires
  • shipping_full — text — Shipping_full
  • billing_full — text — Billing_full
  • billing_firstname — varchar(255) — Billing_firstname
  • billing_lastname — varchar(255) — Billing_lastname
  • billing_telephone — varchar(255) — Billing_telephone
  • billing_postcode — varchar(255) — Billing_postcode
  • billing_country_id — varchar(255) — Billing_country_id
  • billing_region — varchar(255) — Billing_region
  • billing_street — varchar(255) — Billing_street
  • billing_city — varchar(255) — Billing_city
  • billing_fax — varchar(255) — Billing_fax
  • billing_vat_id — varchar(255) — Billing_vat_id
  • billing_company — varchar(255) — Billing_company
  • FULLTEXT — KEY

customer_group

  • customer_group_id — int(10) — Primary key — NOT NULL
  • customer_group_code — varchar(32) — NOT NULL — Customer Group Code
  • tax_class_id — int(10) — NOT NULL — Tax Class Id

customer_log

  • log_id — int(11) — Primary key — NOT NULL — Log ID
  • customer_id — int(11) — NOT NULL — Customer ID
  • last_login_at — timestamp — Last Login Time
  • last_logout_at — timestamp — Last Logout Time

customer_visitor

  • visitor_id — bigint(20) — Primary key — NOT NULL — Visitor ID
  • customer_id — int(11) — Customer Id
  • session_id — varchar(64) — Session ID
  • last_visit_at — timestamp — NOT NULL — Last Visit Time

eav_attribute

  • attribute_id — smallint(5) — Primary key — NOT NULL — Attribute Id

store

  • store_id — smallint(5) — Primary key — NOT NULL — Store Id

store_website

  • website_id — smallint(5) — Primary key — NOT NULL — Website Id