test
Tables (5)
Attendance
- ATTENDANCE_ID — int(5) — Primary key — NOT NULL
- ATTENDANCE_DATE — datetime
- SIGN_IN — datetime
- SIGN_OUT — datetime
GROUP
- GROUP_ID — int(5) — Primary key — NOT NULL
- GROUP_TEACHER_ID — varchar(15) — NOT NULL
- GROUP_TEACHER_NAME — varchar(15) — NOT NULL
- GROUP_TEACHER_HP — varchar(15) — NOT NULL
REG
- REG_ID — int(5) — Primary key — NOT NULL
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime
Test_Score
- Score_ID — int(5) — Primary key — NOT NULL
- GRADE_ID — int(5) — NOT NULL
- GRADE_FIRST_EXAM — varchar(10) — NOT NULL
- GRADE_SECOND_EXAM — varchar(10) — NOT NULL
- GRADE_THIRD_EXAM — varchar(10) — NOT NULL
- ALGORITHM_GRADE — varchar(10) — NOT NULL
- ALGORITHM_ACQUISITION_DATE — datetime — NOT NULL
- GRADE_FIRST_PROJECT — varchar(10)
- GRADE_SECOND_PROJECT — varchar(10) — NOT NULL
- GRADE_THIRD_PROJECT — varchar(10) — NOT NULL
User
- STUDENT_ACCOUNT — varchar(255) — Primary key — NOT NULL
- GROUP_ID — int(5) — Foreign key → GROUP.GROUP_ID — NOT NULL
- Score_ID — int(5) — Foreign key → Test_Score.Score_ID — NOT NULL
- ATTENDANCE_ID — int(5) — Foreign key → Attendance.ATTENDANCE_ID — NOT NULL
- REG_ID — int(5) — Foreign key → REG.REG_ID — NOT NULL
- STUDENT_NAME — varchar(255) — NOT NULL
- STUDENT_HP — varchar(15) — NOT NULL
- STUDENT_AGE — int(5) — NOT NULL
- STUDENT_GENDER — varchar(5)
- STUDENT_CURRICULUM — int(5) — NOT NULL
- STUDENT_REGION — varchar(10) — NOT NULL
- STUDENT_GROUP — int(5) — NOT NULL