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)