Products_Options
The table below describes the Products_Options table in the Complete database schema.
This is a virtual table, and is linked to the Products table in the Complete database schema (see Products).
This table contains the following virtual table:
This table contains the following foldable column:
- Sku
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
Options_Index Primary Key |
SQL_INTEGER(unsigned) | False | True |
|
Sku Primary Key Foreign Key linked to column Sku in Products table |
SQL_VARCHAR(255) | True | True |
|
Options_File_Extension |
SQL_VARCHAR(255) | False | True |
|
Options_Image_Size_X |
SQL_INTEGER(unsigned) | False | True |
|
Options_Image_Size_Y |
SQL_INTEGER(unsigned) | False | True |
|
Options_Is_Require |
SQL_BIT | False | True |
|
Options_Max_Characters |
SQL_INTEGER(unsigned) | False | True |
|
Options_Option_Id |
SQL_INTEGER(unsigned) | False | True |
|
Options_Price |
SQL_NUMERIC(12,4) | False | True |
|
Options_Price_Type |
SQL_VARCHAR(255) | False | True |
|
Options_Product_Sku |
SQL_VARCHAR(255) | False | True |
|
Options_Sku |
SQL_VARCHAR(255) | False | True |
|
Options_Sort_Order |
SQL_INTEGER(unsigned) | False | True |
|
Options_Title |
SQL_VARCHAR(255) | False | True |
|
Options_Type |
SQL_VARCHAR(255) | False | True |