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