movie

Description

Movie site data.

Usage: Embedding <object> tag on rhtml by branching with site_id.

Definition

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.
  • 0: enabled
  • 1: disabled

Related tables

Query

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)
);