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