Tag for product.
Mapping of product and tag is stored in item_tag_map.
| Column | Type | Constraint | Description |
|---|---|---|---|
| shop | TEXT | PRIMARY KEY | Shop ID. (shop.username) |
| id | INTEGER | Tag ID. (1-origin.) | |
| disabled | INTEGER | NOT NULL | Tag is disabled or not. |
CREATE TABLE tag(
shop TEXT,
id INTEGER,
disabled INTEGER NOT NULL,
PRIMARY KEY (shop, id));
Multilingualized name and description of tag.
| Column | Type | Constraint | Description |
|---|---|---|---|
| shop | TEXT | PRIMARY KEY | Shop ID. (shop.username) |
| tag_id | INTEGER | Tag ID. (tag.id) | |
| lang | TEXT | Language key. | |
| name | TEXT | NOT NULL | Tag name. |
| description | TEXT | NOT NULL | Tag description. |
CREATE TABLE tag_content(
shop TEXT,
tag_id INTEGER,
lang TEXT,
name TEXT NOT NULL,
description TEXT NOT NULL,
PRIMARY KEY(shop, lang, tag_id));