콕찔러보기
테이블 (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