shop

Description

Shop basic information.

Definition

Column Type Constraint Description
username TEXT PRIMARY KEY Username to login and also PRIMARY KEY of each db table. Unchangeable.
password TEXT NOT NULL Password to login to administration page.
zip_code TEXT NOT NULL Zip code.
tel TEXT NOT NULL Telephone number.
fax TEXT FAX number.
mail TEXT NOT NULL Mail address.
url TEXT NOT NULL Site URL.
salt TEXT NOT NULL Salt to encrypt String.

Related tables

Query

CREATE TABLE shop(
username     TEXT,
zip_code     TEXT     NOT NULL,
tel          TEXT     NOT NULL,
fax          TEXT,
mail         TEXT     NOT NULL,
url          TEXT     NOT NULL,
PRIMARY KEY(username)
);

shop_content

Description

Multilingualized name and abbreviated name of sxhop.

Definition

Column Type Constraint Description
shop INTEGER PRIMARY KEY Shop ID. (shop.username)
lang TEXT Language key.
name TEXT NOT NULL Name.
name_abbr TEXT NOT NULL Abbreviated name.

Query

CREATE TABLE shop_content(
shop       TEXT,
lang       TEXT,
name       TEXT  NOT NULL,
name_abbr  TEXT  NOT NULL,
PRIMARY KEY (shop, lang)
);