ff
Tables (14)
board
- board_id — BIGINT — Primary key — NOT NULL
- user_idx — BIGINT — NOT NULL
- content — TEXT
- parent_id — BIGINT
- category_idx — VARCHAR(255)
- title — VARCHAR(255) — NOT NULL
- views — INT — NOT NULL
- created_at — DATETIME — NOT NULL
chat_message
- message_id — BIGINT — Primary key — NOT NULL
- match_id — BIGINT — NOT NULL
- user_idx — BIGINT — NOT NULL
- content — VARCHAR(2000) — NOT NULL
- created_at — DATETIME — NOT NULL
comment
- comment_id — bigint(20) — Primary key — NOT NULL
- board_id — bigint(20) — Foreign key → board.board_id — NOT NULL
- user_idx — bigint(20) — Foreign key → user.user_idx — NOT NULL
- parent_id — bigint(20) — Foreign key → comment.comment_id
- content — text — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime
- del_check — tinyint(1) — NOT NULL
- user_idx — bigint(20) — NOT NULL
- del_check — tinyint(1) — NOT NULL
- liked_at — datetime — NOT NULL
- board_id — BIGINT — NOT NULL
- file_url — VARCHAR(255)
- file_name — VARCHAR(255)
- file_type — VARCHAR(30) — NOT NULL
- uploaded_at — DATETIME
league
- league_id — BIGINT — Primary key — NOT NULL
- league_name — VARCHAR(100) — NOT NULL
- league_nickname — VARCHAR(255)
- image_url — VARCHAR(500) — NOT NULL
- sport_id — BIGINT — NOT NULL
match_score
- match_id — BIGINT — Primary key — NOT NULL
- team_id — BIGINT — Primary key — NOT NULL
- score — INT — NOT NULL
match_status
- code — INT — Primary key — NOT NULL
- description — VARCHAR(50)
- type — VARCHAR(30)
matches
- match_id — BIGINT — Primary key — NOT NULL
- league_id — BIGINT — NOT NULL
- home_team_id — BIGINT — NOT NULL
- away_team_id — BIGINT — NOT NULL
- start_time — DATETIME — NOT NULL
- status_code — INT
matchtag
- matchtag_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — NOT NULL
- match_id — BIGINT — NOT NULL
refresh_tokens
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- jti — VARCHAR(36) — NOT NULL
- token_hash — VARCHAR(255) — NOT NULL
- issued_at — DATETIME — NOT NULL
- expires_at — DATETIME — NOT NULL
- revoked — TINYINT — NOT NULL
sport
- sport_id — BIGINT — Primary key — NOT NULL
- sport_code — VARCHAR(50) — NOT NULL
- sport_name — VARCHAR(100) — NOT NULL
team_info
- team_id — BIGINT — Primary key — NOT NULL
- team_name — VARCHAR(255) — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
user
- user_idx — BIGINT — Primary key — NOT NULL
- user_nickname — VARCHAR(30)
- introduction — VARCHAR(500)
- email — VARCHAR(100)
- password — VARCHAR(255)
- user_id — VARCHAR(255)
- bio — VARCHAR(255)
- profile_image — LONGTEXT
- del_check — TINYINT — NOT NULL
- del_user_idx — BIGINT
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME
user_oauth
- provider — VARCHAR(20) — Primary key — NOT NULL
- provider_user_id — VARCHAR(180) — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
verification_codes
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT
- channel — ENUM('email','phone') — NOT NULL
- destination — VARCHAR(255) — NOT NULL
- purpose — ENUM('signup','login','reset','change') — NOT NULL
- code_hash — VARCHAR(255) — NOT NULL
- expires_at — DATETIME — NOT NULL
- consumed_at — DATETIME