KH
테이블 (11)
ACCOUNT
- STUDENT_CODE — VARCHAR(255) — 외래 키 → INFORM.STUDENT_CODE — NOT NULL
- ACCOUNT_ID — VARCHAR(255)
- ACCOUNT_PASSWORD — VARCHAR(255)
CLASS
- CLASS_CODE — VARCHAR(255) — 기본 키 — NOT NULL
- LECTURE_CODE — VARCHAR(255) — NOT NULL
- TEACHER_CODE — VARCHAR(255) — NOT NULL
- CLASS_NAME — VARCHAR(255)
- ATTENDANCE_DATE_TIME — VARCHAR(255) — NOT NULL
COURSE
- STUDENT_CODE — VARCHAR(255) — 외래 키 → INFORM.STUDENT_CODE — NOT NULL
- CLASS_CODE — VARCHAR(255) — 외래 키 → CLASS.CLASS_CODE — NOT NULL
- LECTURE_CODE — VARCHAR(255) — 외래 키 → LECTURE.LECTURE_CODE — NOT NULL
EXAM_KIND
- EXAM_CODE — VARCHAR(255) — 기본 키 — NOT NULL
- EXAM_NAME — VARCHAR(255)
- EXAM_DATE — VARCHAR(255)
INFORM
- STUDENT_CODE — VARCHAR(255) — 기본 키 — NOT NULL
- STUDENT_NAME — VARCHAR(255)
- STUDENT_SEX — VARCHAR(255)
- STUDENT_BIRTH — VARCHAR(255)
- STUDENT_PHONE — VARCHAR(255)
- STUDENT_ADDRESS — VARCHAR(255)
- STUDENT_SCHOOL — VARCHAR(255)
- STUDENT_GRADE — VARCHAR(255)
- STUDENT_PHOTO — VARCHAR(255)
- STUDENT_MEMO — VARCHAR(255)
- STUDENT_ADMISSION_DATE — VARCHAR(255)
- STUDENT_STATUS — VARCHAR(255)
- STUDENT_DISCHARGE_DATE — VARCHAR(255)
- STUDENT_UPDATE — VARCHAR(255)
- STUDENT_PARENT — VARCHAR(255)
- STUDENT_PARENT_PHONE — VARCHAR(255)
- STUDENT_PARENT_MEMO — VARCHAR(255)
LECTURE
- LECTURE_CODE — VARCHAR(255) — 기본 키 — NOT NULL
- LECTURE_NAME — VARCHAR(255)
NOTICE
- NOTICE_CODE — VARCHAR(255) — 기본 키 — NOT NULL
- STUDENT_CODE — VARCHAR(255) — 외래 키 → INFORM.STUDENT_CODE — NOT NULL
- TEACHER_CODE — VARCHAR(255) — 외래 키 → TEACHER.TEACHER_CODE — NOT NULL
- NOTICE_DATE — VARCHAR(255)
- NOTICE_CONTENT — VARCHAR(255)
- NOTICE_TITLE — VARCHAR(255)
PROGRESS
- STUDENT_CODE — VARCHAR(255) — 외래 키 → COURSE.STUDENT_CODE — NOT NULL
- CLASS_CODE — VARCHAR(255) — 외래 키 → COURSE.CLASS_CODE — NOT NULL
- LECTURE_CODE — VARCHAR(255) — 외래 키 → COURSE.LECTURE_CODE — NOT NULL
- PROGRESS_1 — VARCHAR(255)
- PROGRESS_2 — VARCHAR(255)
- PROGRESS_3 — VARCHAR(255)
- PROGRESS_4 — VARCHAR(255)
- PROGRESS_5 — VARCHAR(255)
- PROGRESS_6 — VARCHAR(255)
- PROGRESS_7 — VARCHAR(255)
- PROGRESS_8 — VARCHAR(255)
- PROGRESS_9 — VARCHAR(255)
- PROGRESS_10 — VARCHAR(255)
SCORE
- STUDENT_CODE — VARCHAR(255) — 외래 키 → INFORM.STUDENT_CODE — NOT NULL
- EXAM_CODE — VARCHAR(255) — 외래 키 → EXAM_KIND.EXAM_CODE — NOT NULL
- SCORE_KOREAN — VARCHAR(255)
- SCORE_ENGLISH — VARCHAR(255)
- SCORE_MATH — VARCHAR(255)
- SCORE_SCIENCE — VARCHAR(255)
TEACHER
- TEACHER_CODE — VARCHAR(255) — 기본 키 — NOT NULL
- TEACHER_NAME — VARCHAR(255)
- TEACHER_CLASS — VARCHAR(255)
- TEACHER_PHONE — VARCHAR(255)
- TEACHER_ADDRESS — VARCHAR(255)
- TEACHER_PHOTO — VARCHAR(255)
- TEACHER_MEMO — VARCHAR(255)
- TEACHER_ENROLLMENT_DATE — VARCHAR(255)
- TEACHER_STATUS — VARCHAR(255)
- TEACHER_RESIGNATION_DATE — VARCHAR(255)
출석 (ATTENDED)
- ATTENDANCE_DATE_TIME — VARCHAR(255) — 기본 키 — NOT NULL
- STUDENT_CODE — VARCHAR(255) — NOT NULL
- ATTENDANCE_ATTENDANCE — VARCHAR(255)
- ATTENDANCE_LATE — VARCHAR(255)
- ATTENDANCE_EARLY — VARCHAR(255)
- ATTENDANCE_ABSENT — VARCHAR(255)