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