MDPlaylist

Tables (6)

Like (Untitled3)

  • user_no (Key2) — Foreign key → User.user_no — NOT NULL
  • playlist_no (Key) — Foreign key → Playlist.playlist_no — NOT NULL

Playlist (Untitled5)

  • playlist_no (Key) — Primary key — NOT NULL
  • user_no (Key2) — Foreign key → User.user_no — NOT NULL
  • video_title (Field3)
  • video_url (Field)
  • duration (Field2)
  • channel_name (Field4)
  • emotion (Field6)
  • occasion (Field7)

PlaylistGroup (Untitled2)

  • playlist_group_no (Key) — Primary key — NOT NULL
  • user_no (Key2) — Foreign key → User.user_no — NOT NULL
  • playlist_name (Field)

PlaylistVideo (Untitled6)

  • playlist_no (Key2) — Foreign key → PlaylistGroup.playlist_group_no — NOT NULL
  • video_no (Key3) — Foreign key → Playlist.playlist_no — NOT NULL
  • order_no (Field)

Review (Untitled4)

  • review_no (Key) — Primary key — NOT NULL
  • user_no (Key2) — Foreign key → User.user_no — NOT NULL
  • review_content (Field2)
  • review_regdate (Field3)

User (Untitled)

  • user_no (Key) — Primary key — NOT NULL
  • user_id (Field)
  • user_pw (Field2)
  • user_name (Field3)
  • user_tf (Field4)