과제용

테이블 (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