음악사이트

테이블 (7)

ARTIST (Untitled2)

  • aid (Key) — int — 기본 키 — NOT NULL
  • name (Field) — char(255)

COMMENT (Untitled6)

  • cid (Key) — int — 기본 키 — NOT NULL
  • mpid (Key2) — int — 외래 키 → MY_PLAYLIST.mpid — NOT NULL
  • uid (Key22) — int — 외래 키 → MY_PLAYLIST.uid — NOT NULL
  • comment (Field) — TEXT

MUSIC (Untitled5)

  • mid (Key) — int — 기본 키 — NOT NULL
  • aid (Key2) — int — 외래 키 → ARTIST.aid — NOT NULL
  • like (Field) — int
  • title (Field2) — char(255)
  • video_code (Field3) — char(255)

MY_PLAYLIST (Untitled3)

  • mpid (Key) — int — 기본 키 — NOT NULL
  • uid (Key2) — int — 외래 키 → USER.uid — NOT NULL
  • title (Field)
  • like (Field2)
  • pub_date (Field3)

PLAYLIST (Untitled4)

  • pid (Key) — int — 기본 키 — NOT NULL
  • mpid (Key2) — int — 외래 키 → MY_PLAYLIST.mpid — NOT NULL
  • uid (Key22) — int — 외래 키 → MY_PLAYLIST.uid — NOT NULL
  • mid (Key3) — int — 외래 키 → MUSIC.mid — NOT NULL
  • aid (Key23) — int — 외래 키 → MUSIC.aid — NOT NULL
  • like (Field) — int

PROFILE (Untitled7)

  • pid (Key) — 기본 키 — NOT NULL
  • uid (Key2) — int — 외래 키 → USER.uid — NOT NULL
  • mid (Key3) — int — 외래 키 → MUSIC.mid — NOT NULL
  • aid (Key22) — int — 외래 키 → MUSIC.aid — NOT NULL
  • pid (Key4) — int — 외래 키 → PLAYLIST.pid — NOT NULL
  • mpid (Key23) — int — 외래 키 → PLAYLIST.mpid — NOT NULL
  • uid (Key222) — int — 외래 키 → PLAYLIST.uid — NOT NULL
  • mid (Key32) — int — 외래 키 → PLAYLIST.mid — NOT NULL
  • aid (Key232) — int — 외래 키 → PLAYLIST.aid — NOT NULL
  • Field

USER (Untitled)

  • uid (Key) — int — 기본 키 — NOT NULL
  • name (Field) — char(255)
  • password (Field2) — int
  • email (Field3)