book_story

Tables (3)

Books

  • book_id — INT — Primary key — auto_increment
  • title — VARCHAR(255) — NOT NULL
  • author — VARCHAR(100) — NOT NULL
  • published_date — DATE
  • cover_image — VARCHAR(255)
  • genre — VARCHAR(50)
  • created_at — TIMESTAMP

Reviews

  • review_id — INT — Primary key — auto_increment
  • user_id — INT — NOT NULL
  • book_id — INT — NOT NULL
  • rating — INT
  • review_text — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user

  • id — INT — Primary key — NOT NULL — auto_increment
  • user_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP