BookBook

Tables (3)

BOOKS

  • 책 ID (id) — BIGINT — NOT NULL
  • 책 제목 (title) — VARCHAR(200) — NOT NULL
  • 저자 (author) — VARCHAR(100) — NOT NULL
  • 출판사 (publisher) — VARCHAR(100) — NOT NULL

READING_RECORDS

  • 독서기록 ID (id) — BIGINT — NOT NULL
  • 책 ID (book_id) — BIGINT — Foreign key → BOOKS.책 ID — NOT NULL
  • 독서 상태 (status) — VARCHAR(20) — NOT NULL
  • 좋았던 문장 (sentences) — VARCHAR(100) — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP
  • 수정일자 (updated_at) — TIMESTAMP

REVIEWS

  • 리뷰 ID (id) — BIGINT — NOT NULL
  • 책 ID (book_id) — BIGINT — Foreign key → BOOKS.책 ID — NOT NULL
  • 평점 (rating) — DOUBLE — NOT NULL
  • 리뷰 글 (content) — TEXT — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP — NOT NULL
  • 수정일자 (updated_at) — TIMESTAMP