asdf
Tables (12)
book
- id — string — Primary key — NOT NULL — ISBN13
- book_id — string — NOT NULL
- star — int
- reference_category — text — NOT NULL — "post" | "review" | "book_club"
- reference_id — string — NOT NULL
- created_at — string — NOT NULL
book_club
- id — string — Primary key — NOT NULL
- post_id — string — Foreign key → post.id — NOT NULL
- owner_id — string — Foreign key → profile.id — NOT NULL
- info — string — NOT NULL
- created_at — string — NOT NULL
- name — string — NOT NULL
book_club_chat
- id — string — Primary key — NOT NULL
- book_club_id — string — Foreign key → book_club.id — NOT NULL
- user_id — string — Foreign key → profile.id — NOT NULL
- message — string — NOT NULL
- created_at — string — NOT NULL
book_club_member
- id — string — Primary key — NOT NULL
- book_club_id — string — Foreign key → book_club.id — NOT NULL
- user_id — string — Foreign key → profile.id — NOT NULL
- created_at — string — NOT NULL
bookmark
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
comment
- id — string — Primary key — NOT NULL
- post_id — string — Foreign key → post.id — NOT NULL
- user_id — string — Foreign key → profile.id — NOT NULL
- body — string — NOT NULL
- created_at — string — NOT NULL
follow
- id — string — Primary key — NOT NULL
- follower_id — string — Foreign key → profile.id — NOT NULL
- following_id — string — Foreign key → profile.id — NOT NULL
- created_at — string — NOT NULL
like
- id — string — Primary key — NOT NULL
- user_id — string — Foreign key → profile.id — NOT NULL
- reference_category — string — NOT NULL — "post" | "comment" | "review"
- reference_id — string — NOT NULL
- created_at — string — NOT NULL
notification
- id — string — Primary key — NOT NULL
- type — string — NOT NULL — "follow" | "like" | "comment" | "allow"
- user_id — string — Foreign key → profile.id — NOT NULL
- sender_id — string — Foreign key → profile.id — NOT NULL
- is_read — bool — NOT NULL
- object_id — string — NOT NULL
- created_at — string — NOT NULL
post
- id — string — Primary key — NOT NULL
- title — string — NOT NULL
- body — string — NOT NULL
- user_id — string — Foreign key → profile.id — NOT NULL
- category — string — NOT NULL — "독서 다이어리" "자유게시판" "북 클럽"
- image — string
- is_recruiting — bool
- created_at — string — NOT NULL
profile
- id — string — Primary key — NOT NULL
- name — string — NOT NULL
- image — string
- intro — string
- appellation — string
- created_at — string — NOT NULL
review
- id — string — Primary key — NOT NULL
- body — string — NOT NULL
- user_id — string — Foreign key → profile.id — NOT NULL
- created_at — string — NOT NULL