# Информация о кредитной карточке. CreditCardOwner CHAR(64) NOT NULL, CreditCardNumber CHAR(32) NOT NULL, CreditCardExpiration DATETIME NOT NULL,

# Дополнительная информация о владельце кредитной

# карточки, напечатанная на самой карточке, но не

# закодированная в магнитной полосе. CreditCardVerification CHAR(4),

PRIMARY KEY(ID), INDEX (Invoice),

FOREIGN KEY (Invoice) REFERENCES invoice (ID), FOREIGN KEY (Address) REFERENCES address (ID), FOREIGN KEY (Billing) REFERENCES billing (ID)

** Скидки, применимые к заказу. */

DROP TABLE IF EXISTS invoice coupon;

CREATE TABLE invoice coupon ( Invoice INT NOT NULL, Coupon INT NOT NULL,

PRIMARY KEY (Invoice, Coupon),

FOREIGN KEY (Invoice) REFERENCES invoice FOREIGN KEY (Coupon) REFERENCES coupon (ID)

** Счета, выставленн1е к оплате по сделанн1м заказам.

DROP TABLE IF EXISTS invoice fee;

CREATE TABLE invoice fee ( Invoice INT NOT NULL, Fee INT NOT NULL, Value DECIMAL(11,2) NOT NULL,

INDEX (Invoice), INDEX (Fee),

FOREIGN KEY (Invoice) REFERENCES invoice (ID), FOREIGN KEY (Fee) REFERENCES fee (ID)

/* * *

Состояние заказа.

DROP TABLE IF EXISTS invoice status;

CREATE TABLE invoice status (

ID INT NOT NULL AUTO INCREMENT, Invoice INT NOT NULL, Status INT NOT NULL,

Схема базы данных 605

Created DATETIME NOT NULL, Description CHAR(255),

PRIMARY KEY(ID), INDEX (Invoice),

FOREIGN KEY (Invoice) REFERENCES invoice (ID), FOREIGN KEY (Status) REFERENCES status (ID)

** Адрес доставки заказа. */

DROP TABLE IF EXISTS invoice shipping; CREATE TABLE invoice shipping (

ID INT NOT NULL AUTO INCREMENT,

Invoice INT NOT NULL, Address INT NOT NULL, Shipping INT NOT NULL, Message CHAR(255),

PRIMARY KEY(ID), INDEX (Invoice),

FOREIGN KEY (Invoice) REFERENCES invoice (ID), FOREIGNKEY (Address) REFERENCES address (ID), FOREIGN KEY (Shipping) REFERENCES shipping (ID)

** Перечень товаров, входящкк в заказ. */

DROP TABLE IF EXISTS invoice sku; CREATE TABLE invoice sku (

ID INT NOT NULL AUTO INCREMENT,

Invoice INT NOT NULL,

SKU INT NOT NULL,

Quantity INT NOT NULL,

ExternalSKU CHAR(64) NOT NULL,

Name CHAR(64) NOT NULL,

ListPrice DECIMAL(11,2) NOT NULL,

SalePrice DECIMAL(11,2) NOT NULL,

Freight DECIMAL(11,2) NOT NULL,

Shipping INT NOT NULL,

GiftWrap char(l) NOT NULL DEFAULT N

PRIMARY KEY(ID), INDEX (Invoice), INDEX (SKU), INDEX (ExternalSKU),

FOREIGNKEY (Invoice) REFERENCES invoice (ID), FOREIGN KEY (SKU) REFERENCES sku (ID)

* * Варианты исполнения товаров, входящих в заказ, */

DROP TABLE IF EXISTS invoice sku variation;

CREATE TABLE invoice sku variation ( InvoiceSKU INT NOT NULL, Variation INT NOT NULL, Qualifier CHAR(255),

PRIMARY oiceSKU, Variation)

** Элементы каталога, которые могут быть представлены

** в одном или нескольких вариантах.

DROP TABLE IF EXISTS item; CREATE TABLE item {

ID INT NOT NULL AUTO INCREMENT,

Name CHAR(64) NOT NULL,

Description BLOB,

Keywords VARCHAR(255),

Thumbna i 1 VARCHAR (255) ,

Graphic VARCHAR (255) ,

LargeGraphic VARCHAR(255),

DisplayPrecedence int.

Active ENUMCN, Y) NOT NULL DEFAULT N,

PRIMARY KEY(ID), INDEX (Name) , INDEX (Active)

It *

Произвольные отношения между элементами каталога.

DROP TABLE IF EXISTS item item; CREATE TABLE item item (

Item INT NOT NULL,

Related ltem INT NOT NULL,

Relationship INT NOT NULL,

PRIMARY KEY (Item, Related Item, Relationship),

FOREIGN KEY (Item) REFERENCES item (ID), FOREIGN KEY (Related Item) REFERENCES item (ID), FOREIGN KEY (Relationship) REFERENCES relationship (ID)

** Права пользователей систем:. */

DROP TABLE IF EXISTS permission; CREATE TABLE permission (

ID INT NOT NULL AUTO INCREMENT, Name CHAR(255) NOT NULL,