2020_03_09

Tables (5)

Group Teacher (group_teacher)

  • Group Teacher Id (GROUP_TEACHER_ID) — VARCHAR(20) — Primary key — NOT NULL
  • Group Teacher Name (GROUP_TEACHER_NAME) — VARCHAR(20) — NOT NULL
  • Group Teacher Hp (GROUP_TEACHER_HP) — VARCHAR(20) — NOT NULL

Student (student)

  • Student Id (STUDENT_ACCOUNT) — VARCHAR(20) — Primary key — NOT NULL
  • Student Name (STUDENT_NAME) — VARCHAR(100) — NOT NULL
  • Student Hp (STUDENT_HP) — VARCHAR(20)
  • Student Age (STUDENT_AGE) — VARCHAR(5)
  • Student Gender (STUDENT_GENDER) — VARCHAR(20)
  • Student Curriculum (STUDENT_CURRICULUM) — VARCHAR(20)
  • Student Region (STUDENT_REGION) — VARCHAR(20)
  • Student Group (STUDENT_GROUP) — VARCHAR(20) — NOT NULL
  • Group Teacher Id (GROUP_TEACHER_ID) — VARCHAR(20) — Foreign key → Group Teacher.Group Teacher Id — NOT NULL
  • Reg User (REG_USER) — VARCHAR(20)
  • Reg Dt (REG_DT) — DATETIME
  • Last User (LAST_USER) — VARCHAR(20)
  • Last Dt (LAST_DT) — DATETIME

Student Algorithm (student_algorithm)

  • Student Id (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Student.Student Id — NOT NULL
  • Algorithm grade (ALGORITHM_GRADE) — VARCHAR(20)
  • Algorithm Acquisition Date (ALGORITHM_ACQUISITION_DATE) — DATETIME

Student Attendance (student_attendance)

  • Student Id (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Student.Student Id — NOT NULL
  • Attendance 1/1 Sign In (ATTENDANCE_1/1_SIGN_IN) — DATETIME
  • Attendance 1/1 Sign Out (ATTENDANCE_1/1_SIGN_OUT) — DATETIME
  • Attendance 1/2 (ATTENDANCE_1/2) — TINYINT(1)
  • Attendance 1/2 Sign In (ATTENDANCE_1/2_SIGN_IN) — DATETIME
  • Attendance 1/2 Sign Out (ATTENDANCE_1/2_SIGN_OUT) — DATETIME
  • Attendance 1/3 (ATTENDANCE_1/3) — TINYINT(1)
  • Attendance 1/3 Sign In (ATTENDANCE_1/3_SIGN_IN) — DATETIME
  • Attendance 1/3 Sign Out (ATTENDANCE_1/3_SIGN_OUT) — DATETIME
  • Attendance 1/4 (ATTENDANCE_1/4) — TINYINT(1)
  • Attendance 1/4 Sign In (ATTENDANCE_1/4_SIGN_IN) — DATETIME
  • Attendance 1/4 Sign Out (ATTENDANCE_1/4_SIGN_OUT) — DATETIME
  • Attendance 1/5 (ATTENDANCE_1/5) — TINYINT(1)
  • Attendance 1/5 Sign In (ATTENDANCE_1/5_SIGN_IN) — DATETIME
  • Attendance 1/5 Sign Out (ATTENDANCE_1/5_SIGN_OUT) — DATETIME
  • Attendance 1/6 (ATTENDANCE_1/6) — TINYINT(1)
  • Attendance 1/6 Sign In (ATTENDANCE_1/6_SIGN_IN) — DATETIME
  • Attendance 1/6 Sign Out (ATTENDANCE_1/6_SIGN_OUT) — DATETIME
  • Attendance 1/7 (ATTENDANCE_1/7) — TINYINT(1)
  • Attendance 1/7 Sign In (ATTENDANCE_1/7_SIGN_IN) — DATETIME
  • Attendance 1/7 Sign Out (ATTENDANCE_1/7_SIGN_OUT) — DATETIME
  • Attendance 1/8 (ATTENDANCE_1/8) — TINYINT(1)
  • Attendance 1/8 Sign In (ATTENDANCE_1/8_SIGN_IN) — DATETIME
  • Attendance 1/8 Sign Out (ATTENDANCE_1/8_SIGN_OUT) — DATETIME
  • Attendance 1/9 (ATTENDANCE_1/9) — TINYINT(1)
  • Attendance 1/9 Sign In (ATTENDANCE_1/9_SIGN_IN) — DATETIME
  • Attendance 1/9 Sign Out (ATTENDANCE_1/9_SIGN_OUT) — DATETIME
  • Attendance 1/10 (ATTENDANCE_1/10) — TINYINT(1)
  • Attendance 1/10 Sign In (ATTENDANCE_1/10_SIGN_IN) — DATETIME
  • Attendance 1/10 Sign Out (ATTENDANCE_1/10_SIGN_OUT) — DATETIME
  • Attendance 1/1 (ATTENDANCE_1/1) — TINYINT(1)

Student Grade (student_grade)

  • Student Id (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Student.Student Id — NOT NULL
  • Grade First Exam (GRADE_FIRST_EXAM) — VARCHAR(3)
  • Grade Second Exam (GRADE_SECOND_EXAM) — VARCHAR(3)
  • Grade Third Exam (GRADE_THIRD_EXAM) — VARCHAR(3)