ㄴㄴㄴ
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