Products

The table below describes the Products table in the Minimal database schema.

This table contains the following virtual tables:

This table contains the following foldable columns:

  • Sku
  • Attribute_Set_Id
  • Created_At
  • Name
  • Price
  • Status
  • Type_Id
  • Updated_At
  • Visibility
  • Weight
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

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