직며듦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