운동커뮤니티
테이블 (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