콕찔러보기

테이블 (8)

chatroom

  • chatroom_id — BIGINT — 기본 키 — NOT NULL
  • match_id — BIGINT — 외래 키 → match_info.match_id — NOT NULL
  • created_at — DATETIME — NOT NULL

cook

  • cook_id — BIGINT — 기본 키 — NOT NULL
  • sender_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • receiver_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • match_id — BIGINT — 외래 키 → match_info.match_id
  • status — VARCHAR(20) — NOT NULL
  • sent_at — DATETIME — NOT NULL

match_info

  • match_id — BIGINT — 기본 키 — NOT NULL
  • user_a_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • user_b_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • matched_at — DATETIME — NOT NULL

message

  • message_id — BIGINT — 기본 키 — NOT NULL
  • chatroom_id — BIGINT — 외래 키 → chatroom.chatroom_id — NOT NULL
  • sender_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • sent_at — DATETIME — NOT NULL

mission_progress

  • mission_progress_id — BIGINT — 기본 키 — NOT NULL
  • match_id — BIGINT — 외래 키 → match_info.match_id — NOT NULL
  • current_step — INT — NOT NULL
  • step1_completed_at — DATETIME
  • step1_completed_by — BIGINT — 외래 키 → user.user_id
  • step2_completed_at — DATETIME
  • step2_completed_by — BIGINT — 외래 키 → user.user_id
  • step3_completed_at — DATETIME
  • step3_completed_by — BIGINT — 외래 키 → user.user_id

profile

  • profile_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • age — INT — NOT NULL
  • mbti — VARCHAR(4) — NOT NULL
  • hobby — VARCHAR(255) — NOT NULL
  • blood_type — VARCHAR(5) — NOT NULL
  • department — VARCHAR(100)
  • grade — VARCHAR(20)
  • bio — VARCHAR(500)
  • photo_url — VARCHAR(500)
  • ideal_type — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

report

  • report_id — BIGINT — 기본 키 — NOT NULL
  • reporter_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • reported_user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • reason — VARCHAR(1000) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • reviewed_by — BIGINT — 외래 키 → user.user_id
  • reviewed_at — DATETIME
  • created_at — DATETIME — NOT NULL

user

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • agreed_privacy_at — DATETIME
  • agreed_terms_at — DATETIME
  • last_active_at — DATETIME
  • created_at — DATETIME — NOT NULL