자기주도
테이블 (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