MO:ri

테이블 (26)

1:1 메세지 (direct_messages)

  • message_id — uuid
  • chat_id — uuid
  • sender_id — uuid
  • content — text — NOT NULL
  • created_at — timestamptz
  • updated_at — timestamptz

1:1 채팅 (direct_chats)

  • chat_id — uuid
  • group_id — uuid
  • host_id — uuid
  • member_id — uuid
  • created_by — uuid
  • created_at — timestamptz
  • updated_at — timestamptz

1:1 채팅 알림 (direct_participants)

  • chat_id — uuid
  • user_id — uuid
  • joined_at — timestamptz
  • left_at — timestamptz
  • last_read_at — timestamptz

group_favorites

  • id — uuid
  • user_id — uuid
  • group_id — uuid
  • favorite — boolean
  • created_at — timestamptz
  • updated_at — timestamptz

group_members

  • member_id — uuid
  • user_id — uuid
  • group_id — uuid
  • member_status — text
  • member_role — text
  • member_joined_at — timestamptz

group_review_tags

  • review_id — uuid
  • tag_code — text

group_reviews

  • review_id — uuid
  • group_id — uuid
  • author_id — uuid
  • rating — int
  • pros_text — text
  • created_at — timestamptz
  • updated_at — timestamptz

notifications

  • id — uuid
  • user_id — uuid
  • type — text — NOT NULL
  • title — text
  • message — text
  • group_id — uuid
  • target_id — uuid
  • created_at — timestamptz
  • is_read — boolean

post_reports

  • report_id — uuid
  • user_id — uuid
  • post_id — uuid
  • report_reason — text
  • report_detail_etc — text
  • report_avatar_url — text
  • report_status — text
  • report_created_at — timestamptz
  • report_reviewed_at — timestamptz

review_likes

  • review_id — uuid
  • user_id — uuid
  • created_at — timestamptz

review_tag_dict

  • tag_code — text
  • label — text — NOT NULL

user_inquiries

  • inquiry_id — uuid
  • user_id — uuid
  • inquiry_main_type — varchar — NOT NULL
  • inquiry_sub_type — varchar — NOT NULL
  • inquiry_detail — text — NOT NULL
  • inquiry_answer — text
  • inquiry_file_urls — jsonb
  • inquiry_status — text
  • inquiry_created_at — timestamptz
  • inquiry_answered_at — timestamptz

user_notifications_cleared

  • user_id — uuid — 기본 키 — NOT NULL
  • cleared_at — timestamp

게시판 (group_posts)

  • post_id — uuid
  • user_id — uuid
  • group_id — uuid
  • board_type — text
  • post_title — varchar — NOT NULL
  • post_body_md — text
  • post_created_at — timestamptz
  • view_count — bigint

게시판 좋아요 (group_post_likes)

  • post_id — uuid
  • user_id — uuid
  • created_at — timestamptz

관심사 (user_interests)

  • interest_id — uuid
  • user_id — uuid
  • category_sub_id — uuid
  • created_at — timestamptz

그룹 (groups)

  • group_id — uuid
  • group_title — varchar — NOT NULL
  • group_region — varchar
  • created_by — uuid
  • group_short_intro — varchar
  • group_content — text
  • group_start_day — date — NOT NULL
  • group_end_day — date — NOT NULL
  • status — text
  • group_capacity — int
  • group_region_any — boolean
  • group_created_at — timestamptz
  • group_updated_at — timestamptz
  • group_slug — text
  • image_urls — text
  • curriculum — jsonb
  • major_id — uuid
  • sub_id — uuid
  • favorite — boolean
  • approved — boolean

대분류 (categories_major)

  • major_id — uuid
  • category_major_name — varchar — NOT NULL
  • category_major_slug — varchar — NOT NULL

모일 일상 조회수 (group_daily_reads)

  • post_id — uuid
  • user_id — uuid
  • read_at — timestamptz

모임 공지사항 조회수 (group_post_reads)

  • post_id — uuid
  • user_id — uuid
  • read_at — timestamptz

모임 스케쥴 (group_schedule)

  • schedule_id — uuid
  • user_id — uuid
  • group_id — uuid
  • schedule_place_name — varchar
  • schedule_start_at — timestamptz
  • schedule_end_at — timestamptz
  • schedule_created_at — timestamptz
  • schedule_title — varchar

보드 타입 (board_type)

  • board_type — text
  • allow_host — boolean
  • allow_member — boolean

유저 프로필 (user_profiles)

  • user_id — uuid
  • name — varchar — NOT NULL
  • nickname — varchar — NOT NULL
  • email — varchar — NOT NULL
  • avatar_url — text
  • is_active — boolean
  • agree_email — boolean
  • agree_sms — boolean
  • agree_push — boolean
  • created_at — timestamptz
  • agree_updated_at — timestamptz

중분류 (categories_sub)

  • sub_id — uuid
  • major_id — uuid
  • category_sub_name — varchar — NOT NULL
  • category_sub_slug — varchar — NOT NULL

커리어 (user_careers)

  • career_id — uuid
  • profile_id — uuid
  • company_name — varchar — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL
  • career_image_url — text
  • created_at — timestamptz
  • updated_at — timestamptz
  • original_file_name — text

탈퇴 (user_delete_logs)

  • delete_id — uuid
  • user_id — uuid
  • ip_addr — inet
  • delete_reason — text
  • delete_feedback — text
  • user_agent — text
  • log_key — text
  • deleted_at — timestamptz