Products_Tier_Prices
The table below describes the Products_Tier_Prices 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 foldable column:
- Sku
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
Sku Primary Key Foreign Key linked to column Sku in Products table |
SQL_VARCHAR(255) | True | True |
|
Tier_Prices_Index Primary Key |
SQL_INTEGER(unsigned) | False | True |
|
Tier_Prices_Customer_Group_Id |
SQL_INTEGER(unsigned) | False | True |
|
Tier_Prices_Qty |
SQL_NUMERIC(12,4) | False | True |
|
Tier_Prices_Value |
SQL_NUMERIC(12,4) | False | True |