학사관리
테이블 (12)
ENROLLMENT
- student_id — VARCHAR(10) — 외래 키 → STUDENT.student_id — NOT NULL
- lecture_id — VARCHAR(10) — 외래 키 → LECTURE.lecture_id — NOT NULL
- grade — VARCHAR(5)
INSTRUCTOR
- instructor_id — VARCHAR(10) — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- age — INT
- gender — CHAR(1)
LECTURE
- lecture_id — VARCHAR(10) — 기본 키 — NOT NULL
- lecture_time — VARCHAR(50)
- location — VARCHAR(100)
- subject_id — VARCHAR(10) — 외래 키 → SUBJECT.subject_id — NOT NULL
- instructor_id — VARCHAR(10) — 외래 키 → INSTRUCTOR.instructor_id — NOT NULL
NOTICE
- notice_id — VARCHAR(10) — 기본 키 — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- created_date — DATE
- instructor_id — VARCHAR(10) — 외래 키 → INSTRUCTOR.instructor_id — NOT NULL
- lecture_id — VARCHAR(10) — 외래 키 → LECTURE.lecture_id — NOT NULL
STUDENT
- student_id — VARCHAR(10) — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- address — VARCHAR(200)
SUBJECT
- subject_id — VARCHAR(10) — 기본 키 — NOT NULL
- subject_name — VARCHAR(100) — NOT NULL
enrollment
- student_id — VARCHAR(10) — 외래 키 → student.student_id — NOT NULL
- lecture_id — VARCHAR(10) — 외래 키 → lecture.lecture_id — NOT NULL
- grade — VARCHAR(5)
instructor
- instructor_id — VARCHAR(10) — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- age — INT
- gender — CHAR(1)
lecture
- lecture_id — VARCHAR(10) — 기본 키 — NOT NULL
- lecture_time — VARCHAR(50)
- location — VARCHAR(100)
- subject_id — VARCHAR(10) — 외래 키 → subject.subject_id — NOT NULL
- instructor_id — VARCHAR(10) — 외래 키 → instructor.instructor_id — NOT NULL
notice
- notice_id — VARCHAR(10) — 기본 키 — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- created_date — DATE
- instructor_id — VARCHAR(10) — 외래 키 → instructor.instructor_id — NOT NULL
- lecture_id — VARCHAR(10) — 외래 키 → lecture.lecture_id — NOT NULL
student
- student_id — VARCHAR(10) — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- address — VARCHAR(200)
subject
- subject_id — VARCHAR(10) — 기본 키 — NOT NULL
- subject_name — VARCHAR(100) — NOT NULL