book/therad
Tables (10)
Book (책)
- id (book_id) — Type — Primary key — NOT NULL — Comment
- 제목 (title) — varchar(200) — NOT NULL
- 작가 (author) — varchar(200) — NOT NULL
- 출판일 (pub_date) — date — NOT NULL
- 설명 (description) — text
- isbn — char(20) — NOT NULL
- 책 사진 (cover_image) — URL
- 알라딘 링크 (aladin_link) — URL — NOT NULL
- 출판사 (publisher) — varchar(200)
- 평점 (customr_review_rank)
- id (category_id) — Foreign key → Category.id — NOT NULL
Category (카테고리)
- id (category_id) — Primary key — NOT NULL
- 카테고리명 (name) — NOT NULL
Comment (댓글)
- id (comment_id) — Primary key — NOT NULL
- id (user_id) — Foreign key → User.id — NOT NULL
- id (thread_id) — Foreign key → Thread.id — NOT NULL
- 댓글 (content) — Char(250) — NOT NULL
- 작성일 (created_at) — DateTime — NOT NULL
- 수정 (updated_at) — DateTime — NOT NULL
Favorite (좋아하는 책)
- Key — Primary key — NOT NULL
- id (book_id) — Type — Foreign key → Book.id — NOT NULL — Comment
- id (user_id) — Foreign key → User.id — NOT NULL
Follow (팔로우)
- Key — Primary key — NOT NULL
InterestedCategories (관심분야)
- id (interested_category_id) — Primary key — NOT NULL
- id (user_id) — Foreign key → User.id — NOT NULL
- id (category_id2) — Foreign key → Category.id — NOT NULL
Liked (Thread 좋아요)
- id (liked_id) — Primary key — NOT NULL
- Key (thread_id) — Foreign key → Thread.id — NOT NULL
- id (user_id) — Foreign key → User.id — NOT NULL
Thread (쓰레드)
- id (thread_id) — Primary key — NOT NULL
- 제목 (title) — Char(200)
- 내용 (content) — Text
- 책 읽은 날 (read_date) — Date
- 생성일 (created_at) — DateTime
- 수정일 (updated_at) — DateTime
- 스레드 이미지 (thread_cover) — url
- id (user_id) — Foreign key → User.id — NOT NULL
- id (book_id) — Type — Foreign key → Book.id — NOT NULL — Comment
Token (토큰(dj-rest-auth))
- Key — Primary key — NOT NULL
- 생성일 (created) — datetime
- id (user_id) — Foreign key → User.id — NOT NULL
User (유저)
- id (user_id) — Primary key — NOT NULL
- Field (password) — varchar(128)
- Field2 (last_login) — datetime
- Field3 (is_superuser) — bool
- Field4 (first_name) — varchar(150)
- Field5 (last_name) — varchar(150)
- Field6 (is_staff) — bool
- Field (is_active) — bool
- Field2 (date_joined) — datetime
- 나이 (age) — Positive Integer — NOT NULL