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