장학생선별시스템
테이블 (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