실습

테이블 (4)

Admin

  • Key (admin_id) — varchar2(100) — 기본 키 — NOT NULL
  • Field (admin_pw) — varchar2(100)

Grades

  • Key (grade_id) — int — 기본 키 — NOT NULL
  • Field (score) — varchar2(10)
  • Key (student_id) — int — 외래 키 → Students.Key — NOT NULL
  • Key (subject_id) — int — 외래 키 → Subject.Key — NOT NULL

Students

  • Key (student_id) — int — 기본 키 — NOT NULL
  • Field (login_id) — varchar2(100)
  • Field (login_pw) — varchar2(100)
  • Field (name) — varchar2(100)
  • Field (phone) — varchar2(100)
  • Field (birth) — date
  • Field (major) — varchar2(100)
  • Field (grade_level) — int

Subject

  • Key (subject_id) — int — 기본 키 — NOT NULL
  • Field (subject_name) — varchar2(100)
  • Field (professor) — varchar2(100)