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