모임 플랫폼 서비스 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