Trackback data for product.
| Column | Type | Constraint | Description |
|---|---|---|---|
| shop | TEXT | PRIMARY KEY | Shop ID. (shop.username) |
| product_id | INTEGER | Product ID. (product.id) | |
| url | TEXT | Source URL. | |
| title | TEXT | NOT NULL | Optional. Source title. |
| excerpt | TEXT | NOT NULL | Optional. Source description. |
| site_name | TEXT | NOT NULL | Optional. Source site name. (It corresponds to "blog_name" from trackback specification.) |
| posted | TIMESTAMP | NOT NULL | Time that the trackback posted. |
CREATE TABLE trackback(
shop TEXT,
product_id INTEGER,
url TEXT,
title TEXT NOT NULL,
excerpt TEXT NOT NULL,
site_name TEXT NOT NULL,
posted TIMESTAMP NOT NULL,
PRIMARY KEY (shop, product_id, url)
);
CGI requires "product_id" parameter to receive trackback. If some blogging service just append trackback parameters by "?" to the end of trackback ping URL, the URL like "http://.../trackback.cgi?product_id=8" is not appropriate.
URL like "http://.../trackback.cgi/8", which the prefix digit is "product_id", can cope with that situtation. It looks not so good, but we have not found another better strategy yet at Mar 24, 2008.