TP)ERD

Tables (3)

PURCHASE (Untitled3)

  • purchaseID (Key) — NUM — Primary key — NOT NULL
  • userID (Key2) — VARCHAR2 — Foreign key → USER.userID — NOT NULL
  • productID (Key3) — NUM — Foreign key → Product.productID — NOT NULL
  • time (Field) — TIMESTAMP

Product (Untitled2)

  • productID (Key) — NUM — Primary key — NOT NULL
  • userID (Key2) — VARCHAR2 — Foreign key → USER.userID — NOT NULL
  • productNAME (Field) — VARCHAR2
  • price (Field2) — NUM
  • detail (Field3) — VARCHAR2
  • state (Field4) — boolean
  • viewcount (Field5) — NUM
  • time (Field6) — TIMESTAMP

USER (Untitled)

  • userID (Key) — VARCHAR2 — Primary key — NOT NULL
  • userPW (Field) — VARCHAR2
  • userNAME (Field2) — VARCHAR2