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