중고책

테이블 (6)

BOOK (Untitled2)

  • book_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • title (Field) — NOT NULL
  • author (Field2) — NOT NULL
  • price (Field3) — NOT NULL
  • publisher (Field4) — NOT NULL
  • enroll (Field5) — NOT NULL

CUSTOMER (Untitled)

  • user_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • user_type (Field) — NOT NULL

ORDER (Untitled5)

  • user_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • book_id (Key2) — NOT NULL — 기본 키 — NOT NULL

SELLER (untitled)

  • user_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • user_type (Field) — NOT NULL

SHOPPING CART (Untitled4)

  • cart_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • user_id (Key2) — NOT NULL — 기본 키 — NOT NULL

USER (Untitled3)

  • user_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • nickname (Field) — NOT NULL
  • email (Field2) — NOT NULL
  • password (Field3) — NOT NULL
  • address (Field4) — NOT NULL