mail_setting

Description

Configuration of mail.

If a column that takes mail template id is 0, that will not be mailed.

Definition

Column Type Constraint Description
shop TEXT PRIMARY KEY Shop ID. (shop.username)
signature TEXT NOT NULL Signature of mail. It would be written down on the end of each mail.
ordered INTEGER NOT NULL Mail template ID for ordered information mail. It is mailed when a customer made order. (mail_template.id)
delivered INTEGER NOT NULL Mail template ID for shipping information mail. It is mailed when a shopkeeper changed order.state to "delivered." (mail_template.id)
transfer_info INTEGER NOT NULL Mail template ID for transfer information mail. It is mailed when a shopkeeper changed order.state to "wayting for a transfer." (mail_template.id)
canceling INTEGER NOT NULL Mail template ID for cancel request information mail. It is mailed when a customer requested cancellation. (mail_template.id)
canceled INTEGER NOT NULL Mail template ID for canceled information mail. It is mailed when a shopkeeper changed order.state to "canceled." (mail_template.id)

Related tables

Query

CREATE TABLE mail_setting (
shop          TEXT     PRIMARY KEY,
signature     TEXT     NOT NULL,
ordered       INTEGER  NOT NULL,
delivered     INTEGER  NOT NULL,
transfer_info INTEGER  NOT NULL,
canceling     INTEGER  NOT NULL,
canceled      INTEGER  NOT NULL
);