tm.product
Fields
| Field | 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<langcode> mlstring | Name for the product |
description<langcode> 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_