---
title: tm.product
slug: db/tmproduct
createdAt: 2023-12-14T14:12:28.794Z
---

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_`