tm.product
Product
Fields
FIELD | TYPE | DESCRIPTION |
|---|---|---|
id | int | ID |
typeid | int | Type id |
createdts | timestamp | Created timestamp |
lastupdatets | timestamp | Last updated timestamp |
isarchived | boolean | Isarchived |
code | string | Unique 12-digit for the product |
name | mlstring | Name for the product |
description | mlstring | Description for the product |
categoryid | int | Category for the product |
properties | json | Definition of possible properties for the product |
instancevalues | json | Definition of the values for an instance of the product. These depend on the properties |
salestartts | timestamp | Start of sales |
saleendts | timestamp | End of the sales |
saleschannels | [int] | Saleschannels where sales active for this product. |
translations | json | Translations for the product properties |
layoutid | int | Layout id |
printtickets | bool | Print the tickets or not |
maxadditionaltickets | int | Max additional tickets that can be purchased with option bundles |
This table can also contain one or more customfields. Each customfield starts with c_