ㄴㄴㄴ

Tables (5)

analysis

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → users.id — NOT NULL — 분석
  • wannabe_id — uuid — Foreign key → wannabes.id — 비교
  • video_id — uuid — Foreign key → videos_origin.id — NOT NULL — 분석
  • status — analysis_status — NOT NULL — 분석
  • progress_pct — int — 전체
  • retry_count — int — NOT NULL — 재시도
  • error_message — text — 실패
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

users

  • id — uuid — Primary key — NOT NULL — 사용자
  • status — user_status — NOT NULL
  • last_login_at — timestamptz — 마지막
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz — 소프트

videos_edited

  • id — uuid — Primary key — NOT NULL
  • origin_id — uuid — Foreign key → videos_origin.id — NOT NULL — 원본
  • analysis_id — uuid — Foreign key → analysis.id — NOT NULL — 분석
  • clip_start_sec — numeric(7,2) — NOT NULL — 클립
  • clip_end_sec — numeric(7,2) — NOT NULL — 클립
  • width — int — NOT NULL — AI
  • height — int — NOT NULL — AI
  • status — video_edited_status — NOT NULL — 클립
  • file_name — text — NOT NULL
  • s3_bucket — text — NOT NULL
  • s3_key — text — NOT NULL
  • content_type — text — NOT NULL
  • size_bytes — bigint
  • duration_sec — numeric(7,2) — 클립
  • thumbnail_url — text — 썸네일
  • result_json — jsonb — AI
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

videos_origin

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → users.id — NOT NULL — 업로드한
  • status — video_origin_status — NOT NULL — 영상
  • file_name — text — NOT NULL
  • s3_bucket — text — NOT NULL — MinIO/S3
  • s3_key — text — NOT NULL — MinIO/S3
  • content_type — text — NOT NULL — MIME
  • size_bytes — bigint — 파일
  • duration_sec — numeric(7,2) — 영상
  • width — int — 가로
  • height — int — 세로
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

wannabes

  • id — uuid — Primary key — NOT NULL
  • name — text — NOT NULL — 선수
  • handedness — handedness — 손잡이
  • gender — gender — 성별
  • image_url — text — 선수
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz