쇼츠킹
테이블 (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)