러닝메이트_매칭_DB과제
테이블 (12)
Badge
- badge_id — INT — 기본 키 — NOT NULL
- badge_name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- condition_value — INT — NOT NULL
- image_url — VARCHAR(255)
ChatMessage
- message_id — INT — 기본 키 — NOT NULL
- room_id — INT — 외래 키 → ChatRoom.room_id — NOT NULL
- sender_id — INT — 외래 키 → User.user_id — NOT NULL
- message_content — TEXT — NOT NULL
- sent_at — DATETIME
ChatRoom
- room_id — INT — 기본 키 — NOT NULL
- match_id — INT — 외래 키 → RunningMatch.match_id — NOT NULL
- created_at — DATETIME
- room_status — VARCHAR(20)
- last_message_at — DATETIME
CommunityPost
- post_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- created_at — DATETIME
MateInteraction
- interaction_id — INT — 기본 키 — NOT NULL
- sender_id — INT — 외래 키 → User.user_id — NOT NULL
- receiver_id — INT — 외래 키 → User.user_id — NOT NULL
- interaction_type — VARCHAR(10)
- created_at — DATETIME
PostComment
- comment_id — INT — 기본 키 — NOT NULL
- post_id — INT — 외래 키 → CommunityPost.post_id — NOT NULL
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- content — VARCHAR(500) — NOT NULL
- created_at — DATETIME
RunningMatch
- match_id — INT — 기본 키 — NOT NULL
- user1_id — INT — 외래 키 → User.user_id — NOT NULL
- user2_id — INT — 외래 키 → User.user_id — NOT NULL
- matched_at — DATETIME
- match_status — VARCHAR(20)
RunningProfile
- profile_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- preferred_pace — VARCHAR(20)
- preferred_distance — FLOAT
- activity_region — VARCHAR(100)
- preferred_time — VARCHAR(20)
RunningRecord
- record_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- distance — FLOAT — NOT NULL
- duration — TIME — NOT NULL
- average_pace — VARCHAR(20)
- run_date — DATETIME — NOT NULL
User
- user_id — INT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- gender — CHAR(1)
- created_at — DATETIME
UserBadge
- user_badge_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- badge_id — INT — 외래 키 → Badge.badge_id — NOT NULL
- earned_at — DATETIME
- is_main_badge — BOOLEAN
UserReport
- report_id — INT — 기본 키 — NOT NULL
- reporter_id — INT — 외래 키 → User.user_id — NOT NULL
- reported_id — INT — 외래 키 → User.user_id — NOT NULL
- report_reason — VARCHAR(255) — NOT NULL
- report_status — VARCHAR(20)
- created_at — DATETIME