bookwheel

Tables (18)

book_comment_tb

  • idx — INT — Primary key — NOT NULL
  • user_idx — INT — NOT NULL
  • book_idx — INT — NOT NULL
  • highlight_idx — INT — NOT NULL
  • content — VARCHAR — NOT NULL — 코멘트 내용
  • created_at — TIMESTAMP — NOT NULL

book_highlight_tb (book_highlight_tb (미완))

  • idx — INT — Primary key — NOT NULL
  • user_dx — INT — NOT NULL
  • book_idx — INT — NOT NULL
  • cfi_range — TEXT — NOT NULL — 하이라이트 구간의 정확한 위치
  • color_code — VARCHAR — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

book_rating_tb

  • idx — INT — Primary key — NOT NULL
  • user_idx — INT — Primary key — NOT NULL
  • book_idx — INT — NOT NULL
  • rating — INT — NOT NULL — 별점
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

book_review_tb

  • idx — INT — Primary key — NOT NULL
  • book_idx — INT — NOT NULL
  • user_idx — INT — NOT NULL
  • content — VARCHAR — 책 리뷰 내용
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

book_tag_tb (Untitled2)

  • book_idx — INT — Foreign key → book_tb.idx — NOT NULL
  • tag_idx — INT — Foreign key → tag_tb.idx — NOT NULL
  • count — INT

book_tb

  • idx — INT — Primary key — NOT NULL
  • title — VARCHAR
  • author — VARCHAR
  • publication_year — INT — 발행연도
  • description — VARCHAR — 책 소개
  • book_file_path — VARCHAR — NOT NULL — S3에 저장한 EPUB 파일의 URL
  • cover_image_path — VARCHAR — S3에 저장한 책 표지 이미지
  • average_rating — FLOAT
  • ratings_count — INT
  • language_code — VARCHAR
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

friend_tb

  • idx — INT — Primary key — NOT NULL
  • request_uer_idx — INT — NOT NULL — 친구 요청을 보낸 사용자
  • receive_user_idx — INT — NOT NULL — 친구 요청을 받은 사용자
  • status — VARCHAR — NOT NULL — 상태 (PENDING, ACCEPTED, REJECTED)
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

message_tb

  • idx — INT — Primary key — NOT NULL
  • sender_idx — INT — NOT NULL
  • receiver_idx — INT — NOT NULL
  • content — VARCHAR — NOT NULL
  • is_read — BOOLEAN
  • sent_at — DATE — NOT NULL
  • deleted_at — TIMESTAMP

party_member_tb

  • party_idx — INT — NOT NULL
  • user_idx — INT — NOT NULL
  • status — VARCHAR — NOT NULL — INVITED, ACCEPTED, LEFT, REJECTED

party_tb

  • idx — INT — Primary key — NOT NULL
  • host_user_idx — INT — NOT NULL
  • book_idx — INT — NOT NULL
  • title — VARCHAR — NOT NULL — 파티글 제목
  • description — VARCHAR — NOT NULL — 파티글 내용
  • max_members — INT — NOT NULL — 최대 인원 수
  • current_members — INT — NOT NULL — 현재 참여 인원 수
  • status — VARCHAR — NOT NULL — OPEN,CLOSED,IN_PROGRESS,ENDED
  • start_date — DATE — 파티 독서 시작 예정일
  • end_date — DATE — 파티 독서 마감 예정일
  • is_private — BOOLEAN — NOT NULL — 파티 공개/비공개 여부
  • password — INT — 비공개 파티의 비밀번호
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP

survey_option_tb

  • idx — INT — Primary key — NOT NULL
  • question_idx — NOT — NOT NULL
  • content — VARCHAR — '소설'

survey_question_tb

  • idx — INT — Primary key — NOT NULL
  • content — VARCHAR — '주로 어떤 장르의 책에 손이 가시나요?'

survey_response_tb

  • idx — NOT — Primary key — NOT NULL
  • user_idx — INT — Primary key — NOT NULL
  • option_idx — INT — Primary key — NOT NULL — keyword 선택형 질문에 대한 답 idx
  • question_idx — NOT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

tag_tb (Untitled)

  • idx — INT — Primary key — NOT NULL
  • tag_name — VARCHAR

to_read_tb (Untitled3)

  • user_idx — INT — Foreign key → user_tb.idx — NOT NULL
  • book_idx — INT — Foreign key → book_review_tb.idx — NOT NULL
  • marked_at — TIMESTAMP

user_basic_tb

  • user_idx — INT — NOT NULL
  • id — VARCHAR — NOT NULL
  • password — VARCHAR — NOT NULL — 암호화 필요
  • email — VARCHAR — NOT NULL

user_social_tb

  • user_idx — INT — NOT NULL
  • provider_name — VARCHAR — NOT NULL — KAKAO
  • sns_id — VARCHAR — NOT NULL — kakao에서 발급한 고유 id' ) COMMENT '소셜 로그인 (카카

user_tb

  • idx — INT — Primary key — NOT NULL
  • nickname — VARCHAR — NOT NULL
  • profile_image_path — VARCHAR
  • type — VARCHAR — 로그인방식(일반,소셜)
  • age — INT
  • gender — VARCHAR
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP