Products
The table below describes the Products table in the Complete database schema.
This table contains the following virtual tables:
- Products_Custom_Attributes
- Products_Extension_Attributes_Bundle_Product_Options
- Products_Media_Gallery_Entries
- Products_Options
- Products_Extension_Attributes_Downloadable_Product_Links
- Products_Product_Links
- Products_Extension_Attributes_Configurable_Product_Options
- Products_Tier_Prices
- Products_Extension_Attributes_Downloadable_Product_Samples
- Products_Extension_Attributes_Configurable_Product_Links
This table contains the following foldable column:
- Sku
| Column Name | SQL Type | Updatable | Nullable | Returnable |
|---|---|---|---|---|
|
Sku Primary Key |
SQL_VARCHAR(255) | True | True | True |
|
Attribute_Set_Id |
SQL_INTEGER(unsigned) | True | True | False |
|
Created_At |
SQL_TIMESTAMP | True | True | False |
|
Extension_Attributes_Stock_Item_Backorders |
SQL_INTEGER(unsigned) | True | True | False |
|
Extension_Attributes_Stock_Item_Enable_Qty_Increments |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Is_Decimal_Divided |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Is_In_Stock |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Is_Qty_Decimal |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Item_Id |
SQL_INTEGER(unsigned) | True | True | False |
|
Extension_Attributes_Stock_Item_Low_Stock_Date |
SQL_VARCHAR(255) | True | True | False |
|
Extension_Attributes_Stock_Item_Manage_Stock |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Max_Sale_Qty |
SQL_NUMERIC(12,4) | True | True | False |
|
Extension_Attributes_Stock_Item_Min_Qty |
SQL_NUMERIC(12,4) | True | True | False |
|
Extension_Attributes_Stock_Item_Min_Sale_Qty |
SQL_NUMERIC(12,4) | True | True | False |
|
Extension_Attributes_Stock_Item_Notify_Stock_Qty |
SQL_NUMERIC(12,4) | True | True | False |
|
Extension_Attributes_Stock_Item_Product_Id |
SQL_INTEGER(signed) | True | True | False |
|
Extension_Attributes_Stock_Item_Qty |
SQL_NUMERIC(12,4) | True | True | False |
|
Extension_Attributes_Stock_Item_Qty_Increments |
SQL_NUMERIC(12,4) | True | True | False |
|
Extension_Attributes_Stock_Item_Show_Default_Notification_Message |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Stock_Id |
SQL_INTEGER(unsigned) | True | True | False |
|
Extension_Attributes_Stock_Item_Stock_Status_Changed_Auto |
SQL_INTEGER(unsigned) | True | True | False |
|
Extension_Attributes_Stock_Item_Use_Config_Backorders |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Use_Config_Enable_Qty_Inc |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Use_Config_Manage_Stock |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Use_Config_Max_Sale_Qty |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Use_Config_Min_Qty |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Use_Config_Min_Sale_Qty |
SQL_INTEGER(unsigned) | True | True | False |
|
Extension_Attributes_Stock_Item_Use_Config_Notify_Stock_Qty |
SQL_BIT | True | True | False |
|
Extension_Attributes_Stock_Item_Use_Config_Qty_Increments |
SQL_BIT | True | True | False |
|
Id |
SQL_VARCHAR(255) | False | False | False |
|
Name |
SQL_VARCHAR(255) | True | True | False |
|
Price |
SQL_NUMERIC(12,4) | True | True | False |
|
Status |
SQL_INTEGER(unsigned) | True | True | False |
|
Type_Id |
SQL_VARCHAR(255) | True | True | False |
|
Updated_At |
SQL_TIMESTAMP | True | True | False |
|
Visibility |
SQL_INTEGER(unsigned) | True | True | False |
|
Weight |
SQL_NUMERIC(12,4) | True | True | False |