실습
테이블 (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)