ShoppingMallERD
Tables (7)
CART (DELIVERYINFO)
- Key (DELIVERYNUM) — INT — Primary key — NOT NULL
- Key (ID) — VARCHAR(255) — Foreign key → USER.Key — NOT NULL
- Field (RECIPIENT) — VARHCAR(255)
- Field2 (ADDRESS) — VARHCAR(255)
- Field3 (RECIPIENT_NUMBER) — VARHCAR(255)
DELIVERYINFO (CART)
- Key (ID) — VARCHAR(255) — Foreign key → USER.Key — NOT NULL
- PRODUCTID — VARCHAR(255) — Foreign key → PRODUCT.PRODUCTID — NOT NULL
- Field (CREATEDATE) — DATE
- Field (UPDATEDATE) — DATE
ORDERLIST
- Key (ORDERID) — INT — Foreign key → ORDERS.Key — NOT NULL
- PRODUCTID — VARCHAR(255) — Foreign key → PRODUCT.PRODUCTID — NOT NULL
- Field (PRODUCTCOUNT) — INT
- Field (ORDERSTATUS) — VARHCAR(255)
ORDERS
- Key (ORDERID) — INT — Primary key — NOT NULL
- Key (ID) — VARCHAR(255) — Foreign key → USER.Key — NOT NULL
- Field (TOTALPRICE) — INT
- Field (ORDERDATE) — DATE
PRODUCT
- PRODUCTID — VARCHAR(255) — Primary key — NOT NULL
- PNAME (Field) — VARCHAR(255)
- UNITPRICE (Field2) — INT
- DESCRIPTION (Field3) — STRING
- Field4 (MANUFACTURER) — VARCHAR(255)
- Field5 (CATEGORY) — VARCHAR(255)
- Field4 (UNITSINSTOCK) — INT
- Field4 (COND) — VARCHAR(255)
- Field4 (PRODUCTIMG) — VARCHAR(255)
USER
- Key (ID) — VARCHAR(255) — Primary key — NOT NULL
- Field (PW) — VARCHAR(255)
- Field (NAME) — VARHCAR(255)
- Field (NUMBER) — INT
Untitled (LOCKER)
- Key (ID) — VARCHAR(255) — Foreign key → USER.Key — NOT NULL
- PRODUCTID — VARCHAR(255) — Foreign key → PRODUCT.PRODUCTID — NOT NULL