이러닝 과제

테이블 (3)

Score

  • Key (ID) — INT — 기본 키 — NOT NULL
  • (Student_id) — INT — 외래 키 → Student.ID — NOT NULL
  • Key (Subject_id) — INT — 외래 키 → Subject.Key — NOT NULL
  • Field (Grade) — INT

Student

  • (ID) — INT — 기본 키 — NOT NULL
  • Field (NAME) — VARCHAR(255)
  • Field (Address) — VARCHAR(255)
  • Field (Telephone) — VARCHAR(255)
  • Field (Email) — VARCHAR(255)
  • Field (StudentNo) — VARCHAR(255)

Subject

  • Key (ID) — INT — 기본 키 — NOT NULL
  • Field (Name) — VARCHAR(255)