게시판, 퀘스트
테이블 (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