직며듦2

테이블 (22)

auth

  • id — BIGINT — 기본 키 — NOT NULL
  • phone — VARCHAR(20)
  • password — VARCHAR(255)
  • login_type — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

auth_terms_agreements

  • id — BIGINT — 기본 키 — NOT NULL
  • auth_id — BIGINT — 외래 키 → auth.id — NOT NULL
  • terms_id — BIGINT — 외래 키 → terms.id — NOT NULL
  • agreed — BOOLEAN — NOT NULL
  • agreed_at — TIMESTAMP — NOT NULL

chat_messages

  • id — BIGINT — 기본 키 — NOT NULL
  • match_id — BIGINT — 외래 키 → matches.id — NOT NULL
  • sender_id — BIGINT — 외래 키 → members.id — NOT NULL
  • text — VARCHAR(1000) — NOT NULL
  • sent_at — TIMESTAMP — NOT NULL

games

  • id — BIGINT — 기본 키 — NOT NULL
  • league_id — BIGINT — 외래 키 → leagues.id — NOT NULL
  • home_team_id — BIGINT — 외래 키 → teams.id — NOT NULL
  • away_team_id — BIGINT — 외래 키 → teams.id — NOT NULL
  • stadium_id — BIGINT — 외래 키 → stadiums.id — NOT NULL
  • date — DATE — NOT NULL
  • time — TIME — NOT NULL
  • deadline — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • home_score — INTEGER
  • away_score — INTEGER

leagues

  • id — BIGINT — 기본 키 — NOT NULL
  • sport_id — BIGINT — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL

match_applications

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • game_id — BIGINT — 외래 키 → games.id — NOT NULL
  • match_id — BIGINT — 외래 키 → matches.id
  • party_size — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • applied_at — TIMESTAMP — NOT NULL

match_participants

  • match_id — BIGINT — 외래 키 → matches.id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • application_id — BIGINT — 외래 키 → match_applications.id
  • response — VARCHAR(20) — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL

matches

  • id — BIGINT — 기본 키 — NOT NULL
  • game_id — BIGINT — 외래 키 → games.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • matched_at — TIMESTAMP
  • expires_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

member_location_verifications

  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • verified — BOOLEAN — NOT NULL
  • address — VARCHAR(255)
  • latitude — DOUBLE PRECISION
  • longitude — DOUBLE PRECISION
  • verified_at — TIMESTAMP

member_preferences

  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • gender_pref — VARCHAR(20)
  • age_pref — VARCHAR(20)
  • smoking_pref — VARCHAR(20)
  • distance_km — INTEGER — NOT NULL

member_stats

  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • match_count — INTEGER — NOT NULL
  • rating — DOUBLE PRECISION — NOT NULL
  • trust_score — INTEGER — NOT NULL
  • coupon_count — INTEGER — NOT NULL
  • priority_pass_count — INTEGER — NOT NULL

member_styles

  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • favorite_team_id — BIGINT — 외래 키 → teams.id
  • personality — VARCHAR(50)
  • talk_style — VARCHAR(50)
  • smoking_status — VARCHAR(50)

member_watch_styles

  • watch_style — VARCHAR(50) — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL

members

  • id — BIGINT — 기본 키 — NOT NULL
  • auth_id — BIGINT — 외래 키 → auth.id — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • birth_year — INTEGER
  • gender — VARCHAR(20)
  • profile_image_key — VARCHAR(255)
  • bio — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

notification_settings

  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • match_request — BOOLEAN — NOT NULL
  • match_schedule — BOOLEAN — NOT NULL
  • chat — BOOLEAN — NOT NULL
  • review — BOOLEAN — NOT NULL
  • marketing — BOOLEAN — NOT NULL

notifications

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • application_id — BIGINT — 외래 키 → match_applications.id
  • match_id — BIGINT — 외래 키 → matches.id
  • type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • body — VARCHAR(1000)
  • target_kind — VARCHAR(50)
  • read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

reports

  • id — BIGINT — 기본 키 — NOT NULL
  • reporter_id — BIGINT — 외래 키 → members.id — NOT NULL
  • target_member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • match_id — BIGINT — 외래 키 → matches.id
  • reason — VARCHAR(50) — NOT NULL
  • detail — VARCHAR(1000)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

review_tags

  • tag — VARCHAR(50) — 기본 키 — NOT NULL
  • review_id — BIGINT — 외래 키 → reviews.id — NOT NULL

reviews

  • id — BIGINT — 기본 키 — NOT NULL
  • match_id — BIGINT — 외래 키 → matches.id — NOT NULL
  • reviewer_id — BIGINT — 외래 키 → members.id — NOT NULL
  • target_member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • rating — INTEGER — NOT NULL

stadiums

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • latitude — DOUBLE PRECISION
  • longitude — DOUBLE PRECISION

teams

  • id — BIGINT — 기본 키 — NOT NULL
  • sport_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • short_name — VARCHAR(20)
  • emblem_image_key — VARCHAR(255)

terms

  • id — BIGINT — 기본 키 — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content_key — VARCHAR(255)
  • required — BOOLEAN — NOT NULL
  • effective_at — TIMESTAMP — NOT NULL