RSS information for product.
| Column | Type | Constraint | Description |
|---|---|---|---|
| shop | INTEGER | PRIMARY KEY | Shop ID. (shop.username) |
| id | INTEGER | Identifier. | |
| num | INTEGER | Number of entries. If the value is NULL, all entries will deliver. |
CREATE TABLE product_rss(
shop TEXT,
id INTEGER,
num INTEGER,
PRIMARY KEY (shop, id)
);
Multilingualized title and description of product_rss.
| Column | Type | Constraint | Description |
|---|---|---|---|
| shop | TEXT | PRIMARY KEY | Shop ID. (shop.username) |
| rss_id | INTEGER | RSS ID. | |
| lang | TEXT | Language key. | |
| title | TEXT | NOT NULL | Title. (It corresponds to channel.title.) |
| description | TEXT | NOT NULL | Description. (It corresponds to channel.description.) |
CREATE TABLE product_rss_content(
shop TEXT,
rss_id INTEGER,
lang TEXT,
title TEXT NOT NULL,
description TEXT NOT NULL,
PRIMARY KEY (shop, rss_id, lang)
);