모임 플랫폼 서비스 We Go

테이블 (13)

모임 (v2_groups)

  • max_participants — int — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • end_time — datetime(6)
  • group_id — bigint
  • host_id — bigint — NOT NULL
  • start_time — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • title — varchar(50) — NOT NULL
  • location — varchar(100) — NOT NULL
  • description — varchar(300) — NOT NULL
  • location_detail — varchar(255)
  • group_status — enum — NOT NULL
  • join_policy — enum — NOT NULL

모임 이미지 (v2_group_images)

  • sort_order — int — NOT NULL
  • group_id — bigint — NOT NULL
  • group_image_id — bigint
  • image_key — varchar(36) — NOT NULL

모임 이미지 속성 (v2_group_image_variants)

  • group_image_id — bigint — NOT NULL
  • variant_id — bigint
  • image_url — varchar(500) — NOT NULL
  • image_format — enum — NOT NULL
  • variant_type — enum — NOT NULL

모임 태그 (v2_group_tags)

  • created_at — datetime(6)
  • group_id — bigint — NOT NULL
  • group_tag_id — bigint
  • tag_id — bigint — NOT NULL
  • updated_at — datetime(6)

모임 회원 (v2_group_users)

  • created_at — datetime(6)
  • group_id — bigint — NOT NULL
  • id — bigint
  • joined_at — datetime(6) — NOT NULL
  • left_at — datetime(6)
  • updated_at — datetime(6)
  • user_id — bigint — NOT NULL
  • join_request_message — varchar(300)
  • group_role — enum — NOT NULL
  • group_user_status — enum — NOT NULL

알림 (notifications)

  • actor_id — bigint
  • created_at — datetime(6)
  • notification_id — bigint
  • read_at — datetime(6)
  • receiver — bigint
  • related_id — bigint
  • updated_at — datetime(6)
  • related_type — varchar(20)
  • redirect_url — varchar(500)
  • message — varchar(255) — NOT NULL
  • type — enum — NOT NULL

채팅 메시지 (chat_message)

  • chat_room_id — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • message_id — bigint
  • sender_id — bigint
  • content — text — NOT NULL
  • message_type — enum — NOT NULL

채팅방 (chat_room)

  • chat_room_id — bigint
  • created_at — datetime(6)
  • expires_at — datetime(6)
  • group_id — bigint
  • updated_at — datetime(6)
  • chat_type — enum — NOT NULL

채팅방 회원 (chat_participant)

  • chat_room_id — bigint — NOT NULL
  • joined_at — datetime(6) — NOT NULL
  • last_read_message_id — bigint
  • participant_id — bigint
  • updated_at — datetime(6) — NOT NULL
  • user_id — bigint — NOT NULL
  • join_type — enum — NOT NULL
  • status — enum — NOT NULL

태그 (v1_tags)

  • created_at — datetime(6)
  • tag_id — bigint
  • updated_at — datetime(6)
  • name — varchar(50) — NOT NULL

팔로우 (follows)

  • created_at — datetime(6)
  • followee_id — bigint
  • follower_id — bigint
  • id — bigint
  • updated_at — datetime(6)

회원 (users)

  • followee_count — int
  • follower_count — int
  • group_created_count — int
  • group_joined_count — int
  • is_deleted — bit — NOT NULL
  • notification_enabled — bit — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • user_id — bigint
  • mbti — varchar(10)
  • nick_name — varchar(50) — NOT NULL
  • password — varchar(60)
  • email — varchar(100) — NOT NULL
  • profile_image — varchar(500)
  • profile_message — varchar(500)
  • provider_id — varchar(255)
  • provider — enum
  • role — enum — NOT NULL

회원 카운터 (user_counter)

  • id — int
  • counter — bigint — NOT NULL
  • version — bigint