러닝메이트_매칭_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