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)