my erd

테이블 (10)

book

  • isbn — varchar(13) — 기본 키 — NOT NULL
  • title — varchar(255)
  • author — varchar(255)
  • description — text
  • publisher — varchar(255)
  • publish time(year) (publish_year) — int
  • average star (star_rating) — float
  • cover image (cover_image_url) — varchar(255)
  • genre key (genkey) — int — 외래 키 → 장르.genre key — NOT NULL
  • subgenre — varchar(255)
  • 예상 분량(분) (volume) — int
  • keyword — varchar(15)

community_post

  • post_key (postkey) — int — 기본 키 — NOT NULL
  • user_id (userid) — int — 외래 키 → user.사용자 ID — NOT NULL
  • category_key (categkey) — int — 외래 키 → post_category.category_key — NOT NULL
  • title — varchar(63)
  • content — text
  • likes — int
  • dislikes — int
  • created_at — timestamp
  • updated_at — timestamp
  • views — int
  • announcement (isAnnounce) — boolean

post_category

  • category_key (categkey) — int — 기본 키 — NOT NULL
  • category_name (categname) — varchar(63)
  • created_at — timestamp
  • updated_at — timestamp

post_comments

  • comment_key (commentkey) — int — 기본 키 — NOT NULL
  • user_id (userid) — int — 외래 키 → user.사용자 ID — NOT NULL
  • post_key (postref) — int — 외래 키 → community_post.post_key
  • comment_key (commentref) — int — 외래 키 → post_comments.comment_key — NOT NULL
  • content — text
  • likes — int
  • dislikes — int
  • created_at — timestamp
  • updated_at — timestamp
  • views — int

user

  • 사용자 ID (userid) — int — 기본 키 — NOT NULL
  • username — varchar(32) — NOT NULL
  • id — varchar(32) — NOT NULL
  • password — varchar(32)
  • gender — bit
  • age — int
  • book_count — int
  • 총 독서 시간(분) (total_time) — int — measured in minutes
  • suspension (suspended) — boolean
  • creation date (created_at) — timestamp

독서 기록 (reading_record)

  • record_id (recordid) — int — 기본 키 — NOT NULL
  • user_id (userid) — int — 외래 키 → user.사용자 ID — NOT NULL
  • isbn — varchar(13) — 외래 키 → book.isbn — NOT NULL
  • start_date — timestamp
  • end_date — timestamp
  • status — int
  • time — int

장르 (genre)

  • genre key (genkey) — int — 기본 키 — NOT NULL
  • name — varchar(32)
  • created_at — timestamp
  • updated_at — timestamp

장르 즐겨찾기 (followgen)

  • 사용자 ID (userid) — int — 외래 키 → user.사용자 ID — NOT NULL
  • genre key (genkey) — int — 외래 키 → 장르.genre key — NOT NULL
  • created_at — timestamp

책 리뷰 (book_review)

  • review id (reviewid) — int — 기본 키 — NOT NULL
  • user_id (userid) — int — 외래 키 → user.사용자 ID — NOT NULL
  • isbn — varchar(13) — 외래 키 → book.isbn — NOT NULL
  • content — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • star_rating — float
  • likes — int
  • dislikes — int
  • read_time(min) (read_time) — int
  • views — int
  • spoiler warn (hasSpoiler) — boolean

책 찜하기 (read_later)

  • 사용자 ID (userid) — int — 외래 키 → user.사용자 ID — NOT NULL
  • isbn — varchar(13) — 외래 키 → book.isbn — NOT NULL
  • created_at — timestamp