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