음악사이트
테이블 (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)