Sportify
Tables (6)
fan_highlights
- id — uuid — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- title — varchar — NOT NULL
- description — text
- hashtags — text
- video_url — text — NOT NULL
- thumbnail_url — text
- duration — int4
- view_count — int4
- like_count — int4
- is_public — boolean
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
highlight_clips
- id — uuid — Primary key — NOT NULL
- official_highlight_id — uuid — NOT NULL
- title — varchar — NOT NULL
- start_time — int4 — NOT NULL
- end_time — int4 — NOT NULL
- clip_type — varchar
- description — text
- created_at — timestamptz — NOT NULL
likes
- id — uuid — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- highlight_id — uuid — NOT NULL
- highlight_type — varchar — NOT NULL
- created_at — timestamptz — NOT NULL
official_highlights
- id — uuid — Primary key — NOT NULL
- title — varchar — NOT NULL
- description — text
- video_url — text — NOT NULL
- thumbnail_url — text
- league — varchar
- team_a — varchar
- team_b — varchar
- score_a — int4
- score_b — int4
- match_date — date
- duration — int4
- view_count — int4
- like_count — int4
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
profiles
- id — uuid — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- username — varchar
- full_name — varchar
- avatar_url — text
- bio — text
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
user_created_highlights
- id — uuid — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- official_highlight_id — uuid — NOT NULL
- title — varchar — NOT NULL
- selected_clips — uuid — NOT NULL
- clip_order — int4 — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL