youtube
Tables (4)
MUSICS (Untitled4)
- MUSIC_ID (Key) — INT — Primary key — NOT NULL
- MUSIC_TITLE (Field) — VARCHAR(50)
- MUIC_DESC (Field2) — TEXT
- MUSIC_CODE (Field4) — VARCHAR(200)
- TAG (Field3) — TEXT
- THUMBNAIL (Field5) — VARCHAR(100)
PLAYLISTS (Untitled2)
- PLAYLIST_ID (Key) — INT — Primary key — NOT NULL
- USER_ID (Key2) — INT — Foreign key → USER_INFO.USER_ID — NOT NULL
- PLAYLIST_TITLE (Field) — VARCHAR(100)
- PLAYLIST_DESC (Field2) — TEXT
- PLAYLIST_CODE (Field3) — VARCHAR(200)
PLAYLIST_MUSICS (Untitled3)
- PM_ID (Key) — INT — Primary key — NOT NULL
- PLAYLIST_ID (Key2) — INT — Foreign key → PLAYLISTS.PLAYLIST_ID — NOT NULL
- MUSIC_KEY (Key3) — INT — Foreign key → MUSICS.MUSIC_ID — NOT NULL
USER_INFO (Untitled)
- USER_ID (Key) — INT — Primary key — NOT NULL
- USER_NAME (Field) — VARCHAR(20)
- USER_NICKNAME (Field2) — VARCHAR(20)
- PHONE (Field3) — VARCHAR(20)
- EMAIL (Field4) — VARCHAR(30)
- JOIN_DATE (Field5) — DATE
- USER_BIRTH (Field6) — DATE