운동커뮤니티

테이블 (7)

Untitled (message)

  • Key (message_id) — bigint — 기본 키 — NOT NULL
  • Key (chatroom_id) — bigint — 외래 키 → 메세지.Key — NOT NULL
  • id (send_user_id) — bigint — 외래 키 → 사용자.id — NOT NULL
  • Field (content) — text
  • Field (createdAt) — datetime

Untitled (message_status)

  • Key (status_id) — bigint — 기본 키 — NOT NULL
  • Key (message_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (user_id) — bigint
  • Field (is_read) — boolean

메세지 (chat_room)

  • Key (chatroom_id) — bigint — 기본 키 — NOT NULL
  • Key (meetup_id) — bigint — 외래 키 → 모임.Key — NOT NULL
  • Field (status) — varchar
  • (createdAt) — datetime

모임 (Meetup)

  • Key (meetup_id) — bigint — 기본 키 — NOT NULL
  • id (leader_user_id) — bigint — 외래 키 → 사용자.id — NOT NULL
  • Field (sports_type) — varchar
  • Field2 (meetup_date) — datetime
  • Field (runtime) — int
  • Field (region) — varchar
  • Field (total_man) — int
  • Field (description) — varchar
  • Field (status) — varchar
  • Field (view_count) — bigint
  • Field (deadline) — datetime
  • Field (createdAt) — datetime
  • Field (modifiedAt) — datetime

사용자 (User)

  • id (user_id) — bigint — 기본 키 — NOT NULL
  • email_id — varchar
  • password — varchar
  • name — varchar
  • region — varchar
  • refreshToken — varchar
  • role — varchar
  • createdAt — datetime
  • updatedAt (modifiedAt) — datetime

신청자 (Applicant)

  • Key (applicant_id) — bigint — 기본 키 — NOT NULL
  • Key (meetup_id) — bigint — 외래 키 → 모임.Key — NOT NULL
  • id (user_id) — bigint — 외래 키 → 사용자.id — NOT NULL
  • (status) — varchar
  • Field (createdAt) — datatime
  • Field (modifiedAt) — datetime

알림 (Alarm)

  • Key (alarm_id) — bigint — 기본 키 — NOT NULL
  • id (user_id) — bigint — 외래 키 → 사용자.id — NOT NULL
  • Field (alarm_type) — varchar
  • Field (content) — varchar
  • Field (is_read) — boolean
  • Field (createdAt) — datetime