Destination data of each account.
| 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. |
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));