쇼츠킹

테이블 (12)

AIInsight

  • id — UUID
  • challenge_id — UUID — 외래 키 → Challenge.id
  • challenge_summary — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • best_comment_summary — TEXT

Bookmark

  • id — UUID
  • user_id — UUID — 외래 키 → User.id
  • challenge_id — UUID — 외래 키 → Challenge.id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Challenge

  • id — UUID
  • creator_id — UUID — 외래 키 → Creator.id
  • title — VARCHAR(255)
  • description — TEXT
  • country_code — CHAR(2)
  • category — VARCHAR(50)
  • thumbnail_url — VARCHAR(500)
  • video_url — VARCHAR(500)
  • video_duration — INT
  • views_24h_growth — INT
  • total_views — BIGINT
  • total_likes — INT
  • total_comments — INT
  • upload_date — TIMESTAMP
  • discovered_date — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • transcript — VARCHAR(500)
  • video_id — VARCHAR(100)

ChallengeMetadata

  • trend_score — FLOAT
  • engagement_rate — FLOAT
  • performance_ratio — FLOAT
  • is_trending — BOOLEAN
  • id — UUID
  • created_at — DATE
  • updated_at — DATE

ChallengeTag

  • challenge_id — UUID — 외래 키 → Challenge.id
  • tag_id — UUID — 외래 키 → Tag.id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

CognitoUser

  • sub — UUID
  • name — VARCHAR(100)
  • email — VARCHAR(255)
  • profile_url — VARCHAR(255)

Comment

  • id — UUID
  • challenge_id — UUID — 외래 키 → Challenge.id
  • author_name — VARCHAR(100)
  • author_profile_url — VARCHAR(500)
  • content — TEXT
  • likes — INT
  • posted_at — TIMESTAMP
  • is_best — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Creator

  • id — UUID
  • channel_name — VARCHAR(100)
  • profile_url — VARCHAR(500)
  • channel_url — VARCHAR(500)
  • subscriber_count — INT
  • country_code — CHAR(2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

EngagementMetrics

  • id — UUID
  • measured_at — TIMESTAMP
  • views — BIGINT
  • likes — INT
  • comments — INT
  • engagement_score — DECIMAL(8,2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • challenge_id — UUID
  • views_diff — INT
  • likes_diff — INT
  • comments_diff — INT
  • engagement_diff — INT

KillingPoint

  • id — UUID
  • challenge_id — UUID — 외래 키 → Challenge.id
  • loop_start — INT
  • loop_end — INT
  • title — VARCHAR(100)
  • description — TEXT
  • learning_tip — TEXT
  • order — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Tag

  • id — UUID
  • name — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

User

  • id — UUID
  • email — VARCHAR(255)
  • cognito_sub — VARCHAR(100)
  • profile_url — VARCHAR(500)
  • created_at — TIMESTAMP
  • last_login_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • role — VARCHAR(15)
  • name — VARCHAR(100)