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