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)