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