pill

Tables (10)

Content (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • type (Field)
  • title (Field2)
  • description (Field3)
  • thumbnail_url (Field4)
  • tags (Field5)
  • average_rating (Field6)
  • review_count (Field7)
  • watcher_count (Field8)
  • created_at (Field9)

Conversation (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • id (uuid) — Foreign key → users.id — NOT NULL
  • user1_id (Field)
  • user2_id (Field2)
  • created_at (Field3)

DM (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → Conversation.id — NOT NULL
  • id (uuid) — Foreign key → Conversation.id — NOT NULL
  • conversation_id (Field)
  • sender_id (Field2)
  • receiver_id (Field3)
  • content (Field4)
  • created_id (Field5)
  • read_at (Field6)

Follow (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • id (uuid) — Foreign key → users.id — NOT NULL
  • follower_id (Field)
  • follower_id (Field2)

Notification (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • id (uuid) — Foreign key → users.id — NOT NULL
  • receiver_id (Field)
  • title (Field2)
  • content (Field3)
  • level (Field4)
  • created_at (Field5)
  • read_at (Field6)

Playlist (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • owner_id (Field)
  • title (Field2)
  • description (Field3)
  • updated_at (Field4)

PlaylistContent (Untitled5)

  • id (Key) — Foreign key → Playlist.id — NOT NULL
  • id (Key2) — Foreign key → Content.id — NOT NULL
  • playlist_id (Field)
  • content_id (Field2)

PlaylistSubscription (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • id (uuid) — Foreign key → users.id — NOT NULL
  • id (Key2) — Foreign key → Playlist.id — NOT NULL
  • playlist_id (Field)
  • user_id (Field2)
  • created_id (Field3)

reviews (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • id (uuid) — Foreign key → users.id — NOT NULL
  • id (Key2) — Foreign key → Content.id — NOT NULL
  • content_id (Field)
  • author_id (Field2)
  • text (Field3)
  • rating (Field4)
  • created_at (Field5)

users (Untitled)

  • id (uuid) — Primary key — NOT NULL
  • email (VARCHAR)
  • password (Field)
  • name (Field2)
  • profile_image_url (Field3)
  • role (Field4)
  • locked (Field5)
  • created_at (DATETIME)