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,
password     TEXT     NOT NULL,
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.
signature TEXT Signature to attach end of mail. If NULL, nothing will be attached.

Query

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