product_rss_entry

Description

RSS entry for one product.

Product information and multilingualized remarks are described in item element of RSS entry.

Definition

Column Type Constraint Description
shop TEXT PRIMARY KEY Shop ID. (shop.username)
id INTEGER Identifier. 1-origin.
rss_id INTEGER NOT NULL RSS ID. (product_rss.id)
product_id INTEGER NOT NULL Product ID. (product.id)
posted TIMESTAMP WITH TIME ZONE NOT NULL Time when this entry posted.

Related tables

Query

CREATE TABLE product_rss_entry(
shop        TEXT,
id          INTEGER,
rss_id      INTEGER                   NOT NULL,
product_id  INTEGER                   NOT NULL,
posted      TIMESTAMP WITH TIME ZONE  NOT NULL,
PRIMARY KEY (shop, id)
);

product_rss_entry_content

Description

Multilingualized remarks.

Definition

Column Type Constraint Description
shop TEXT PRIMARY KEY Shop ID. (shop.username)
entry_id INTEGER Entry ID. (product_rss_entry.id)
lang TEXT Language key.
remarks TEXT NOT NULL Remarks.

Query

CREATE TABLE product_rss_entry_content(
shop        TEXT,
entry_id    INTEGER,
lang        TEXT,
remarks     TEXT      NOT NULL,
PRIMARY KEY (shop, entry_id, lang)
);