Simple Magento2-customer MK

Magento customer erd

Tables (8)

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_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_group_id — int(10) — Foreign key → customer_group.customer_group_id — NOT NULL

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_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

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