Movie site data.
Usage: Embedding <object> tag on rhtml by branching with site_id.
| Column | Type | Constraint | Description |
|---|---|---|---|
| shop | TEXT | PRIMARY KEY | Shop ID. (shop.username) |
| product_id | INTEGER | Product ID. (product.id) | |
| index | INTEGER | Index of movies. (0-origin) | |
| site_id | TEXT | NOT NULL | Site ID that possessed a movie. (Domain would be proper.) |
| movie_id | TEXT | NOT NULL | Movie ID. (Format is depending on each site.) |
| alt | TEXT | Alternation text. | |
| disabled | INTEGER | NOT NULL | The movie is disabled or not.
|
CREATE TABLE movie( shop TEXT, product_id INTEGER, index INTEGER, site_id TEXT NOT NULL, movie_id TEXT NOT NULL, alt TEXT, disabled INTEGER NOT NULL, PRIMARY KEY(shop, product_id, index) );