destination

Description

Destination data of each account.

Definition

Column Type Constraint Description
shop TEXT PRIMARY KEY Shop ID. (shop.username)
account_id INTEGER Account ID. (account.id)
index INTEGER Index of destinations in each account. 0-origin.
fname TEXT NOT NULL First name.
lname TEXT NOT NULL Last name.
zip_code TEXT NOT NULL Zip code. (ASCII digits and hyphen.)
address1 TEXT NOT NULL Address1.
address2 TEXT Optional. Address2.
city TEXT NOT NULL City.
prefecture INTEGER NOT NULL Prefecture ID. See prefecture.rb.
tel TEXT NOT NULL Telephone number.

Related tables

Query

CREATE TABLE destination(
shop        TEXT,
account_id  INTEGER,
index       INTEGER,
fname       TEXT    NOT NULL,
lname       TEXT    NOT NULL,
zip_code    TEXT    NOT NULL,
address1    TEXT    NOT NULL,
address2    TEXT,
city        TEXT    NOT NULL,
prefecture  INTEGER NOT NULL,
tel         TEXT    NOT NULL,
PRIMARY KEY(shop, account_id, index));