pjt-09

Tables (3)

Book (Untitled2)

  • PK (book_id) — INT — Primary key — NOT NULL
  • 필수 (title) — VARCHAR
  • 필수 (author) — VARCHAR
  • 필수 (publisher) — VARCHAR
  • 필수 (image_url) — VARCHAR
  • 필수 (publication_date) — VARCHAR
  • 필수 (description) — VARCHAR

Thread (Untitled3)

  • PK (thread_id) — INT — Primary key — NOT NULL
  • FK (user_id) — INT — Foreign key → User.PK — NOT NULL
  • FK (book_id) — INT — Foreign key → Book.PK — NOT NULL
  • 필수 (content) — VARCHAR

User (Untitled)

  • PK (user_id) — INT — Primary key — NOT NULL
  • 필수 (email) — VARCHAR
  • 필수 (password) — VARCHAR
  • 필수 (nickname) — VARCHAR