Magento 2
Tables (12)
catalog_product_entity
- entity_id — int(10) — NOT NULL — Entity ID
- attribute_set_id — smallint(5) — NOT NULL — Attribute Set ID
- type_id — varchar(32) — NOT NULL — Type ID
- sku — varchar(64) — SKU
- has_options — smallint(6) — NOT NULL — Has Options
- required_options — smallint(5) — NOT NULL — Required Options
- created_at — timestamp — NOT NULL — Creation Time
- updated_at — timestamp — NOT NULL — Update Time
catalog_product_entity_datetime
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- value — datetime — Value
catalog_product_entity_decimal
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- value — decimal(12, 4) — Value
catalog_product_entity_gallery
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- position — int(11) — NOT NULL — Position
- value — varchar(255) — Value
catalog_product_entity_int
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- value — int(11) — Value
catalog_product_entity_media_gallery
- value_id — int(10) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- value — varchar(255) — Value
- media_type — varchar(32) — NOT NULL — Media entry type
- disabled — smallint(5) — NOT NULL — Visibility status
catalog_product_entity_media_gallery_value
- value_id — int(10) — NOT NULL — Value ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- label — varchar(255) — Label
- position — int(10) — Position
- disabled — smallint(5) — NOT NULL — Is Disabled
- record_id — int(10) — NOT NULL — Record Id
catalog_product_entity_media_gallery_value_to_entity
- value_id — int(10) — NOT NULL — Value media Entry ID
- entity_id — int(10) — NOT NULL — Product entity ID
catalog_product_entity_media_gallery_value_video
- value_id — int(10) — NOT NULL — Media Entity ID
- store_id — smallint(5) — NOT NULL — Store ID
- provider — varchar(32) — Video provider ID
- url — text — Video URL
- title — varchar(255) — Title
- description — text — Page Meta Description
- metadata — text — Video meta data
catalog_product_entity_text
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- value — text — Value
catalog_product_entity_tier_price
- value_id — int(11) — NOT NULL — Value ID
- entity_id — int(10) — NOT NULL — Entity ID
- all_groups — smallint(5) — NOT NULL — Is Applicable To All Customer Groups
- customer_group_id — int(10) — NOT NULL — Customer Group ID
- qty — decimal(12, 4) — NOT NULL — QTY
- value — decimal(12, 4) — NOT NULL — Value
- percentage_value — decimal(5, 2) — Percentage value
- website_id — smallint(5) — NOT NULL — Website ID
catalog_product_entity_varchar
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- value — varchar(255) — Value