ClimbX
Tables (22)
contribution_tag (유형 기여)
- tag (태그 코드) — varchar(32) — Primary key — NOT NULL
- contribution_id (기여 ID) — bigint — Foreign key → contributions.contribution_id — NOT NULL
contributions (기여)
- contribution_id (기여 ID) — bigint — Primary key — NOT NULL
- user_id (유저ID) — bigint — Foreign key → user_accounts.user_id — NOT NULL — AUTO_INCREMENT
- problem_id (문제 ID) — bigint — Foreign key → problems.problem_id — NOT NULL
- tier (투표 티어) — varchar(16) — NOT NULL
- comment (유저 의견) — varchar(256)
- is_accepted (유저 제출 상태) — TINYINT — NOT NULL
groups (그룹)
- group_id (그룹 ID) — bigint — Primary key — NOT NULL
- group_type (그룹 종류) — varchar — NOT NULL
- group_name (그룹 이름) — varchar — NOT NULL
gym_areas (벽(구역))
- gym_area_id (벽 ID) — bigint — Primary key — NOT NULL
- gym_id (암장 ID) — bigint — Foreign key → gyms.gym_id — NOT NULL
- area_name (이름) — varchar(32) — NOT NULL
- area_image_cdn_url (벽 이미지 URL) — varchar(256)
gyms (암장)
- gym_id (암장 ID) — bigint — Primary key — NOT NULL
- name (암장 이름) — VARCHAR(64) — NOT NULL
- latitude (암장 위도) — DOUBLE
- longitude (암장 경도) — DOUBLE
- address (암장 주소) — VARCHAR(128)
- phone_number (암장 전화번호) — VARCHAR(64)
- map_2d_urls (2d 맵 이미지 종류) — json
- metadata (매장 메타데이터) — json
notifications (알림)
- notification_id (알림 ID) — bigint — Primary key — NOT NULL
- user_id (유저ID) — bigint — Foreign key → user_accounts.user_id — NOT NULL — AUTO_INCREMENT
- group_id (그룹 ID) — bigint
- type (알림의 타입) — varchar — NOT NULL
- actor_id (알림 트리거 주체) — bigint
- message_content (메시지 내용) — varchar — NOT NULL
- message_title (메시지 제목) — varchar — NOT NULL
- is_read (읽음 여부) — TINYINT — NOT NULL
- priority (중요도) — int — NOT NULL
origin_pose_metrics (동작 메트릭)
- Key — Primary key — NOT NULL
- pose_data (Field)
precomputed_pose_metrics (가공 이후 동작 메트릭)
- Key — Primary key — NOT NULL
- Field
problem_reviews (문제 리뷰)
- review_id (리뷰 ID) — bigint — Primary key — NOT NULL
- problem_id (문제 ID) — bigint — Foreign key → problems.problem_id — NOT NULL
- user_id (유저ID) — bigint — Foreign key → user_accounts.user_id — NOT NULL — AUTO_INCREMENT
- context (내용) — varchar(256) — NOT NULL
problem_tags (문제 유형)
- tag (태그 코드) — varchar(32) — Primary key — NOT NULL
- problem_id (문제 ID) — bigint — Foreign key → problems.problem_id — NOT NULL
- priority (가중치 합) — integer — NOT NULL
problems (문제)
- problem_id (문제 ID) — bigint — Primary key — NOT NULL
- gym_id (암장 ID) — bigint — Foreign key → gyms.gym_id — NOT NULL
- gym_area_id (벽 ID) — bigint — Foreign key → gym_areas.gym_area_id — NOT NULL
- local_level (문제 난이도 색) — varchar(32) — NOT NULL
- hold_color (홀드 색) — varchar(32) — NOT NULL
- problem_rating (문제 레이팅) — integer — NOT NULL
- problem_tier (문제 티어) — varchar(16) — NOT NULL
- primary_tag (최상위 태그) — varchar(32)
- secondary_tag (2번째 태그) — varchar(32)
- problem_image_cdn_url (이미지 url) — varchar(256)
- active_status (문제 상태(active, inactive)) — varchar(16) — NOT NULL
rival_relationships (라이벌 정보)
- rival_id (라이벌 ID) — bigint — Primary key — NOT NULL
- source (라이벌 송신자) — bigint — Foreign key → user_accounts.user_id — NOT NULL — AUTO_INCREMENT
- destination (라이벌 수신자) — bigint — Foreign key → user_accounts.user_id — NOT NULL — AUTO_INCREMENT
- status (라이벌 상태) — boolean — NOT NULL
seasons
- season_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- is_current — TINYINT(1) — NOT NULL
- recalculation_completed — TINYINT(1) — NOT NULL
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
standard_levels (표준 난이도)
- standard_level_name (표준 레벨 이름) — varchar(32) — NOT NULL
- start_rating (표준 레벨 시작 레이팅) — integer — NOT NULL
- end_rating (표준 레벨 끝 레이팅) — integer — NOT NULL
submissions (제출)
- video_id (비디오ID) — binary(16) — Foreign key → videos.video_id — NOT NULL
- problem_id (문제 ID) — bigint — Foreign key → problems.problem_id — NOT NULL
- status (상태) — varchar(32) — NOT NULL
- status_reason (상태 변경 사유) — varchar(256)
- appeal_content (이의제기 내용) — varchar{256)
- appeal_status (이의제기 상태) — varchar(32)
user_accounts (유저)
- user_id (유저ID) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- role (권한) — varchar(32) — NOT NULL
- nickname (닉네임) — varchar(64) — NOT NULL
- status_message (상태 메세지) — varchar(128)
- user_field (유저 활동 지역) — varchar(64)
- profile_image_cdn_url (프로필 사진 URL) — varchar(256)
- last_login_date (마지막 접속 날짜) — DATETIME — NOT NULL
- fcm_token (fcm 토큰) — varchar(512_
user_auths (유저 소셜로그인)
- auth_id (auth ID) — bigint — Primary key — NOT NULL
- user_id (유저ID) — bigint — Foreign key → user_accounts.user_id — NOT NULL — AUTO_INCREMENT
- provider (소셜플랫폼) — varchar(32) — NOT NULL
- provider_user_id (소셜플랫폼의 사용자 ID) — varchar(128) — NOT NULL
- provider_email (유저 email) — varchar(128)
- is_primary (Field) — boolean — NOT NULL
user_event_histories (유저 이벤트 히스토리)
- create_at (생성 일자) — DATETIME — Primary key — NOT NULL
- user_id (유저ID) — bigint — Foreign key → user_accounts.user_id — NOT NULL — AUTO_INCREMENT
- event_type (이벤트 종류) — varchar(32) — NOT NULL
- event_data (추가데이터) — json
- event_id (이벤트 id) — bigint — NOT NULL
user_group (유저 그룹 연결)
- user_id (유저ID) — bigint — Foreign key → user_accounts.user_id — NOT NULL — AUTO_INCREMENT
- group_id (그룹 ID) — bigint — Foreign key → groups.group_id — NOT NULL
- created_at (그룹 참여 일자) — datetime — NOT NULL
user_ranking_histories (유저 랭킹 히스토리)
- criteria (Key) — varchar(32) — Primary key — NOT NULL
- created_at (Key2) — DATETIME — Primary key — NOT NULL
- user_id (유저ID) — bigint — Foreign key → user_accounts.user_id — NOT NULL — AUTO_INCREMENT
- history_id (기록 id) — bigint — NOT NULL
- value (값) — integer — NOT NULL
- season_id (시즌 id) — int — NOT NULL
user_stats (유저 스탯)
- stat_id (statID) — bigint — Foreign key → user_accounts.user_id — NOT NULL — AUTO_INCREMENT
- user_id (Field) — bigint — NOT NULL
- season_id — integer — NOT NULL
- rating (레이팅) — bingint — NOT NULL
- current_streak (현재 스트릭) — integer — NOT NULL
- contribution_count (기여 수) — integer — NOT NULL
- submission_count (제출 수) — integer — NOT NULL
- solved_count (푼 문제 수) — integer — NOT NULL
- longest_streak (최대 스트릭) — integer — NOT NULL
- rival_count (라이벌 수) — integer — NOT NULL
- top_problem_rating (상위 50문제 레이팅 합) — integer — NOT NULL
videos (비디오)
- video_id (비디오ID) — binary(16) — Primary key — NOT NULL
- user_id (유저ID) — bigint — Foreign key → user_accounts.user_id — NOT NULL
- file_size (파일 크기) — bigint — NOT NULL
- original_s3_url (원본 S3 URL) — varchar(512)
- hls_s3_url (HLS S3 URL) — varchar(512)
- thumbnail_s3_url (썸네일 S3 URL) — varchar(512)
- hls_cdn_url (HLS CDN URL) — varchar(512)
- thumbnail_cdn_url (썸네일 CDN URL) — varchar(512)
- duration_seconds (영상 길이) — integer
- job_id (MediaConvert job ID) — varchar(256)
- status (현재 영상 처리 상태) — varchar(32) — NOT NULL
- processed_at (HLS 변환 시각) — datetime