학사관리시스템_
테이블 (5)
courses
- course_id — INT — 기본 키 — NOT NULL
- course_code — VARCHAR(20) — NOT NULL
- course_name — VARCHAR(100) — NOT NULL
- credit — INT
- prof_id — INT — 외래 키 → professor.prof_id — NOT NULL
department
- dept_id — INT — 기본 키 — NOT NULL
- dept_name — VARCHAR(100) — NOT NULL
- telephone — VARCHAR(20)
enrollments
- course_id — INT — 외래 키 → courses.course_id — NOT NULL
- student_id — BIGINT — 외래 키 → student.student_id — NOT NULL
- score — INT
- enrolled_at — DATE
professor
- prof_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- phone — VARCHAR(20)
- dept_id — INT — 외래 키 → department.dept_id — NOT NULL
student
- student_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- phone — VARCHAR(20)
- birth_date — DATE
- created_at — DATE
- dept_id — INT — 외래 키 → department.dept_id — NOT NULL