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