자기주도

테이블 (9)

Attendance

  • ATTENDANTCE_ID (ATTENDANCE_ID) — 기본 키 — NOT NULL
  • STUDENT_ID — 외래 키 → User.STUDENT_ID — NOT NULL
  • ATTENDANCE_DATE — datetime
  • ATTENDANCE_SIGN_IN
  • ATTENDANCE_SIGN_OUT

Domain

  • DOMAIN_ID — 기본 키 — NOT NULL
  • DOMAIN_NAME

Grade

  • GRADE_ID — 기본 키 — NOT NULL
  • STUDENT_ID — 외래 키 → User.STUDENT_ID — NOT NULL
  • FIRST_EXAM
  • SECOND_EXAM
  • THIRD_EXAM

Group

  • GROUP_ID — 기본 키 — NOT NULL
  • REGION_ID — 외래 키 → Region.REGION_ID — NOT NULL
  • GROUP_TEACHER_ID — 외래 키 → Teacher.GROUP_TEACHER_ID — NOT NULL
  • GROUP_NUMBER

Project

  • PROJECT_ID — 기본 키 — NOT NULL
  • DOMAIN_ID — 외래 키 → Domain.DOMAIN_ID — NOT NULL
  • GROUP_ID — 외래 키 → Group.GROUP_ID — NOT NULL
  • PROJECT_NAME

ProjectGrade

  • PROJECT_GRADE_ID — 기본 키 — NOT NULL
  • PROJECT_ID — 외래 키 → Project.PROJECT_ID — NOT NULL
  • PROJECT_GRADE

Region

  • REGION_ID — 기본 키 — NOT NULL
  • REGION_NAME

Teacher

  • GROUP_TEACHER_ID — 기본 키 — NOT NULL
  • GROUP_TEACHER_ACCOUNT
  • GROUP_TEACHER_NAME
  • GROUP_TEACHER_HP

User

  • STUDENT_ID — 기본 키 — NOT NULL
  • GROUP_ID — 외래 키 → Group.GROUP_ID — NOT NULL
  • STUDENT_ACCOUNT
  • STUDENT_NAME
  • STUDENT_HP
  • STUDENT_AGE
  • STUDENT_GENDER
  • STUDENT_CURRICULUM
  • STUDENT_REG_DT — datetime
  • STUDENT_LAST_DT — datetime
  • ALGORITHM_RANK