책배달

테이블 (5)

Books

  • book_id — INT — 기본 키 — NOT NULL
  • image_url — VARCHAR(255)
  • book_name — VARCHAR(255) — NOT NULL
  • price — INT — NOT NULL
  • bookstore_id — INT — 외래 키 → Bookstores.bookstore_id — NOT NULL

Bookstores

  • bookstore_id — INT — 기본 키 — NOT NULL
  • owner_id — INT
  • name — VARCHAR(255) — NOT NULL

Orders

  • order_id — INT
  • customer_id — INT — 외래 키 → Users.user_id
  • book_id — INT — 외래 키 → Books.book_id
  • order_status — VARCHAR(20)
  • shipping_address — VARCHAR(255)

Reviews

  • review_id — INT
  • customer_id — INT — 외래 키 → Users.user_id
  • bookstore_id — INT — 외래 키 → Bookstores.bookstore_id
  • review_text — TEXT
  • rating — INT

Users

  • user_id — INT — 기본 키 — NOT NULL
  • user_type — VARCHAR(10) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • points — INT
  • address — VARCHAR(255)