게시판, 퀘스트

테이블 (10)

bookmark

  • b_no — bigint
  • user_id — text — 외래 키 → user.user_id
  • b_folder_name — varchar
  • b_folder_img — text

bookmark_post

  • id — bigint
  • user_id — text
  • folder_no — bigint — 외래 키 → bookmark.b_no
  • post_id — uuid — 외래 키 → post.post_id
  • created_at — timestamptz

comment

  • id — int2
  • post_id — uuid — 외래 키 → post.post_id
  • user_id — text — 외래 키 → user.user_id
  • comment — text
  • like_cnt — int4
  • is_deleted — bool
  • created_at — timestamp

comment_like

  • id — uuid
  • comment_id — int2 — 외래 키 → comment.id
  • user_id — text — 외래 키 → user.user_id
  • created_at — timestamp

mypage

  • mp_No — bigint
  • user_id — text — 외래 키 → user.user_id
  • mp_Name — varchar
  • profileimg — text

post

  • post_id — uuid
  • user_id — text — 외래 키 → user.user_id
  • content — text
  • image_url — varchar
  • like_cnt — int4
  • comment_cnt — int4
  • view_count — int8
  • created_at — timestamp
  • updated_at — timestamp

post_like

  • id — uuid
  • post_id — uuid — 외래 키 → post.post_id
  • user_id — text — 외래 키 → user.user_id
  • created_at — timestamptz

quest_progress_daily

  • no — bigint
  • quest_no — bigint — 외래 키 → quests.no
  • user_id — text — 외래 키 → user.user_id
  • current_count — int4
  • quest_date — date
  • is_cleared — bool
  • is_received — bool
  • created_at — timestamptz
  • claimed_at — timestamptz

quests

  • no — bigint
  • name — text
  • goal_count — int4
  • reward_coin — int4

user

  • user_id — text
  • name — varchar
  • nickname — varchar
  • birth_date — timestamp
  • password — varchar
  • phone_num — varchar
  • email — varchar
  • profile_image — varchar
  • created_at — timestamptz
  • updated_at — timestamp
  • categories — text