데일리
테이블 (3)
ATTENDANCE
- ATTENDANCE_NO — INT — 기본 키
- STUDENT_HP — varchar(20)
- IS_ATTENDANCE — tinyint(1)
- # — 1은
- ATTENDANCE_SIGN_OUT — datetime
Algorithm (Untitled)
- ALGORITHM_NO — INT — 기본 키 — NOT NULL
- ALGORITHM_GRADE
- ALGORITHM_ACQUISITION_DATE — datetime
- STUDENT_HP — varchar(20)
- Field2
user
- STUDENT_ACCOUNT — varchar(20) — NOT NULL
- STUDENT_NAME — varchar(100) — NOT NULL
- STUDENT_HP — varchar(20)
- STUDENT_AGE — varchar(5)
- STUDENT_GENDER — varchar(20)
- STUDENT_CURRICULUM — varchar(20)
- STUDENT_REGION — varchar(20)
- STUDENT_GROUP — varchar(20) — NOT NULL
- GROUP_TEACHER_ID — varchar(20) — NOT NULL
- GROUP_TEACHER_NAME — varchar(20) — NOT NULL
- GROUP_TEACHER_HP — varchar(20) — NOT NULL
- GRADE_FIRST_EXAM — varchar(3)
- GRADE_SECOND_EXAM — varchar(3)
- GRADE_THIRD_EXAM — varchar(3)
- ALGORITHM_GRADE — varchar(20)
- ALGORITHM_ACQUISITION_DATE — datetime
- ATTENDANCE_1/1 — tinyint(1)
- ATTENDANCE_1/1_SIGN_IN — datetime
- ATTENDANCE_1/1_SIGN_OUT — datetime
- ATTENDANCE_1/2 — tinyint(1)
- ATTENDANCE_1/2_SIGN_IN — datetime
- ATTENDANCE_1/2_SIGN_OUT — datetime
- ATTENDANCE_1/3 — tinyint(1)
- ATTENDANCE_1/3_SIGN_IN — datetime
- ATTENDANCE_1/3_SIGN_OUT — datetime
- ATTENDANCE_1/4 — tinyint(1)
- ATTENDANCE_1/4_SIGN_IN — datetime
- ATTENDANCE_1/4_SIGN_OUT — datetime
- ATTENDANCE_1/5 — tinyint(1)
- ATTENDANCE_1/5_SIGN_IN — datetime
- ATTENDANCE_1/5_SIGN_OUT — datetime
- ATTENDANCE_1/6 — tinyint(1)
- ATTENDANCE_1/6_SIGN_IN — datetime
- ATTENDANCE_1/6_SIGN_OUT — datetime
- ATTENDANCE_1/7 — tinyint(1)
- ATTENDANCE_1/7_SIGN_IN — datetime
- ATTENDANCE_1/7_SIGN_OUT — datetime
- ATTENDANCE_1/8 — tinyint(1)
- ATTENDANCE_1/8_SIGN_IN — datetime
- ATTENDANCE_1/8_SIGN_OUT — datetime
- ATTENDANCE_1/9 — tinyint(1)
- ATTENDANCE_1/9_SIGN_IN — datetime
- ATTENDANCE_1/9_SIGN_OUT — datetime
- ATTENDANCE_1/10 — tinyint(1)
- ATTENDANCE_1/10_SIGN_IN — datetime
- ATTENDANCE_1/10_SIGN_OUT — datetime
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime