Options_Values
The table below describes the Options_Values table in the Complete database schema.
This is a virtual table, and is linked to the Products_Options table in the Complete database schema (see Products_Options).
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 Foreign Key linked to column Options_Index in Products_Options table |
SQL_INTEGER(unsigned) | False | True |
|
Sku Primary Key Foreign Key linked to column Sku in Products_Options table |
SQL_VARCHAR(255) | True | True |
|
Values_Index Primary Key |
SQL_INTEGER(unsigned) | False | True |
|
Values_Option_Type_Id |
SQL_INTEGER(unsigned) | False | True |
|
Values_Price |
SQL_NUMERIC(12,4) | False | True |
|
Values_Price_Type |
SQL_VARCHAR(255) | False | True |
|
Values_Sku |
SQL_VARCHAR(255) | False | True |
|
Values_Sort_Order |
SQL_INTEGER(unsigned) | False | True |
|
Values_Title |
SQL_VARCHAR(255) | False | True |