장학생선별시스템

테이블 (3)

course_list (Untitled3)

  • Key (id) — not null — 기본 키 — NOT NULL
  • Field
  • Key (student_id) — not null — 외래 키 → student.Key — NOT NULL
  • Key (subject_id) — not null — 외래 키 → subject.Key — NOT NULL
  • Field2 (average_achievement) — not null
  • Field2 (department_rank) — not null

student (Untitled)

  • Key (id) — not null — 기본 키 — NOT NULL
  • Field (name) — not null
  • Field (student_number) — not null
  • Field (department) — not null
  • Field (grade) — not null
  • Field (phone) — null
  • Field (credits_earned) — not null
  • filed (department_rank) — not null
  • Field (scholarship) — not null

subject (Untitled2)

  • Key (id) — not null — 기본 키 — NOT NULL
  • Field (name) — not null
  • Field (middle_score) — not null
  • Field (final_score) — not null
  • Field (achievement) — not null
  • Field (credit) — not null
  • fk (student_id) — not null — 외래 키 → student.Key — NOT NULL