과제용
테이블 (11)
Album (Untitled)
- AlbumNum (Key) — intger — 기본 키 — NOT NULL
- AlbumCode (Key2) — char(15) — 기본 키 — NOT NULL
- Title (Field) — Varchar(30)
- Price (Field2) — int
- Tracks (Field3) — char(3)
- Duration (Field4) — time
- Rate (Field5) — char(20)
- ReleaseDate (Field6) — date
- grade (Field7) — float
- PubCode (Key3) — integer — 외래 키 → Publisher.PubCode — NOT NULL
Group (Untitled6)
- groupNum (Key) — char(5) — 기본 키 — NOT NULL
- foundingDay (Field) — date
- Genre (Field2) — char(40)
- description (Field3) — text
- LableNum (Key2) — Varchar(3) — 외래 키 → Lable.LableNum — NOT NULL
- name (Field4) — char(30)
Group_people (Untitled7)
- pNum (Key) — varchar(3) — 외래 키 → people.pNum — NOT NULL
- groupNum (Key2) — char(5) — 외래 키 → Group.groupNum — NOT NULL
- role (Field) — varchar(100)
Lable (Untitled2)
- LableNum (Key) — Varchar(3) — 기본 키 — NOT NULL
- foundingDay (Field) — date
- Name (Field2) — char(30)
- CEO (Field3) — char(30)
- description (Field4) — text
- location (Field5) — char(80)
- phone (Field6) — char(50)
MV (Untitled8)
- MvNum (Key3) — Varchar(4) — 기본 키 — NOT NULL
- SongNum (Key2) — Varchar(3) — 외래 키 → Song.SongNum — NOT NULL
- AlbumNum (Key) — Varchar(3) — 외래 키 → Song.AlbumNum — NOT NULL
- releaseDate (Field) — date
- Duration (Field2) — time
- rate (Field3) — char(20)
MV_People (Untitled10)
- MvNum (Key3) — Varchar(4) — 외래 키 → MV.MvNum — NOT NULL
- SongNum (Key2) — Varchar(3) — 외래 키 → MV.SongNum — NOT NULL
- AlbumNum (Key) — Varchar(3) — 외래 키 → MV.AlbumNum — NOT NULL
- pNum (Key4) — varchar(3) — 외래 키 → people.pNum — NOT NULL
- role (Field) — varchar(100)
Publisher (Untitled11)
- PubCode (Key) — char(30) — 기본 키 — NOT NULL
- name (Field) — char(30)
- phone (Field2) — char(20)
- fax (Field3) — char(40)
- foundingDay (Field4) — date
- location (Field5) — char(100)
Song (Untitled4)
- SongNum (Key2) — Varchar(3) — 기본 키 — NOT NULL
- AlbumNum (Key) — Varchar(3) — 외래 키 → Album.AlbumNum — NOT NULL
- Title (Field) — Varchar(30)
- Duration (Field2) — time
- ReleaseDate (Field3) — date
- Genre (Field4) — char(40)
- lyrics (Field5) — text
- TjsongNum (Field6) — Varchar(30)
- KysongNum (Field7) — Varchar(30)
- grade (Field8) — float
- rate (Field9) — char(20)
Song_Group (Untitled9)
- SongNum (Key2) — Varchar(3) — 외래 키 → Song.SongNum — NOT NULL
- AlbumNum (Key) — Varchar(3) — 외래 키 → Song.AlbumNum — NOT NULL
- groupNum (Key3) — char(5) — 외래 키 → Group.groupNum — NOT NULL
Song_People (Untitled5)
- SongNum (Key2) — Varchar(3) — 외래 키 → Song.SongNum — NOT NULL
- AlbumNum (Key) — Varchar(3) — 외래 키 → Song.AlbumNum — NOT NULL
- pNum (Key3) — varchar(3) — 외래 키 → people.pNum — NOT NULL
- role (Field) — varchar(100)
people (Untitled3)
- pNum (Key) — integer — 기본 키 — NOT NULL
- Name (Field) — char(50)
- Birth (Field2) — date
- Gender (Field3) — char(3)
- description (Field4) — text
- LableNum (Key2) — Varchar(3) — 외래 키 → Lable.LableNum — NOT NULL