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