bookr_review

Tables (3)

books

  • book_id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • author — VARCHAR(100)
  • publisher — VARCHAR(100)
  • category — VARCHAR(50)
  • description — TEXT
  • cover_url — VARCHAR(300)
  • created_by — BIGINT — Foreign key → users.user_id

reviews

  • review_id — BIGINT
  • user_id — BIGINT — Foreign key → users.user_id
  • book_id — BIGINT — Foreign key → books.book_id
  • rating — INT
  • title — VARCHAR(255)
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • user_id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP