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