ClimeMate

Tables (7)

AnalyzedDatas (분석 데이터)

  • id (분석 데이터 id) — BIGINT — Primary key — NOT NULL
  • video_id (영상 id) — BIGINT — Foreign key → Videos.id — NOT NULL
  • result_json (결과) — TEXT
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP
  • deleted_at (삭제일) — TIMESTAMP

ExerciseInfos (운동 정보)

  • id (운동 정보 id) — BIGINT — Primary key — NOT NULL
  • video_id (영상 id) — BIGINT — Foreign key → Videos.id — NOT NULL
  • started_at (운동 시작 시간) — TIMESTAMP — NOT NULL
  • ended_at (운동 종료 시간) — TIMESTAMP — NOT NULL
  • succeeded (성공 여부) — TINYINT — NOT NULL
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP
  • deleted_at (삭제일) — TIMESTAMP

ExerciseSessions (운동 세션)

  • id (세션 id) — BIGINT — Primary key — NOT NULL
  • user_id (유저 id) — BIGINT — Foreign key → Users.id — NOT NULL — AUTO INCREMENT
  • location (운동 장소) — VARCHAR(40) — NOT NULL
  • started_at (시작시간) — TIMESTAMP — NOT NULL
  • ended_at (종료시간) — TIMESTAMP
  • duration (총 운동 시간) — BIGINT
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP
  • deleted_at (삭제일) — TIMESTAMP

Holds (홀드 인식 정보)

  • id (홀드 ID) — BIGINT — Primary key — NOT NULL
  • id (영상 id) — BIGINT — Foreign key → Videos.id — NOT NULL
  • x (x좌표) — DOUBLE PRECISION — NOT NULL
  • y (y좌표) — DOUBLE PRECISION — NOT NULL
  • polygon (홀드 인식 결과) — JSONB
  • hold_type (홀드 타입) — VARCHAR(6) — NOT NULL
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP
  • deleted_at (삭제일) — TIMESTAMP

Trial (시도)

  • id (시도 id) — BIGINT — Primary key — NOT NULL
  • session_id (세션 id) — BIGINT — Foreign key → ExerciseSessions.id — NOT NULL
  • user_id (유저 id) — BIGINT — Foreign key → ExerciseSessions.user_id — NOT NULL — AUTO INCREMENT
  • difficulty (난이도) — VARCHAR(10) — NOT NULL
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP
  • deleted_at (삭제일) — TIMESTAMP

Users (유저 데이터)

  • id (유저 id) — BIGINT — Primary key — NOT NULL — AUTO INCREMENT
  • userEmail (유저 로그인 아이디) — VARCHAR(40) — NOT NULL
  • userPw (유저 로그인 비밀번호) — VARCHAR(60) — NOT NULL
  • nickname (닉네임) — VARCHAR(40) — NOT NULL
  • height (키) — FLOAT — NOT NULL
  • weight (몸무게) — FLOAT — NOT NULL
  • reach (팔길이) — FLOAT
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP
  • deleted_at (삭제일) — TIMESTAMP
  • role (역할) — VARCHAR(6) — NOT NULL

Videos (운동 영상)

  • id (영상 id) — BIGINT — Primary key — NOT NULL
  • trial_id (시도 id) — BIGINT — Foreign key → Trial.id — NOT NULL
  • exercise_session_id (세션 id) — BIGINT — Foreign key → Trial.session_id — NOT NULL
  • user_id (유저 id) — BIGINT — Foreign key → Users.id — NOT NULL — AUTO INCREMENT
  • video_filekey (영상 파일 키) — VARCHAR(50)
  • thumbnail_filekey (썸네일 파일 키) — VARCHAR(50)
  • isAnalyzed (영상 분석 여부) — BOOLEAN — NOT NULL
  • session_id (영상 분석 세션 id) — VARCHAR(255)
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP
  • deleted_at (삭제일) — TIMESTAMP