20200401 김형균

테이블 (8)

Album (my_albums)

  • album_id — int(11) — 기본 키 — NOT NULL
  • album name (album_name) — VARCHAR(255)
  • Field2

Attempts (my_Attempts)

  • Year — CHAR(8) — 기본 키 — NOT NULL
  • Semester — CHAR(8) — 기본 키 — NOT NULL
  • Student id (Student_ID) — int(11) — 외래 키 → Student.Student id — NOT NULL
  • program id (program_id) — int(11) — 외래 키 → Student.program id — NOT NULL
  • Mark — VARCHAR(255)
  • Grade — VARCHAR(255)
  • Field

Course (my_Course)

  • couse id (course_id) — int(11) — 기본 키 — NOT NULL
  • Year (Year2) — CHAR(8) — 외래 키 → Attempts.Year — NOT NULL
  • Semester — CHAR(8) — 외래 키 → Attempts.Semester — NOT NULL
  • Student id (Student_ID) — int(11) — 외래 키 → Attempts.Student id — NOT NULL
  • program id (program_id) — int(11) — 외래 키 → Attempts.program id — NOT NULL
  • program id (program_id2) — int(11) — 외래 키 → Program.program id — NOT NULL
  • Name — VARCHAR(255)
  • CreditPoint (Credit_Points) — int(11)
  • YearCommenced (Year_Commenced) — CHAR(8)
  • Field

Played (my_played)

  • played (played_id) — int(11) — 기본 키 — NOT NULL
  • track id (track_id) — int(11) — 외래 키 → Track.track id — NOT NULL
  • album_id — int(11) — 외래 키 → Track.album_id — NOT NULL
  • Field

Program (my_Program)

  • program id (program_id) — int(11) — 기본 키 — NOT NULL
  • Name — VARCHAR(255)
  • CreditPoints (Credit_points) — int(11)
  • YearCommenced (Year_Commenced) — CHAR(8)
  • Field

Student (my_Student)

  • Student id (Student_ID) — int(11) — 기본 키 — NOT NULL
  • program id (program_id) — int(11) — 외래 키 → Program.program id — NOT NULL
  • GivenNames — VARCHAR(255)
  • Surname (SurName) — VARCHAR(255)
  • Date of Birth (Date_Of_Birth) — CHAR(8)
  • YearEnrolled (Year_Enrolled) — CHAR(8)

Track (my_track)

  • track id (track_id) — int(11) — 기본 키 — NOT NULL
  • album_id — int(11) — 외래 키 → Album.album_id — NOT NULL
  • track name (track_name) — VARCHAR(255)
  • time — CHAR(8)
  • Field

artist (my_artist)

  • artist id (artist_id) — int(11) — 기본 키 — NOT NULL
  • album_id — int(11) — 외래 키 → Album.album_id — NOT NULL
  • artist name (artist_name) — VARCHAR(255)
  • Field