erd-diagram

Tables (5)

TEACHER

  • Field (GROUP_TEACHER_ID) — VARCHAR(255) — NOT NULL
  • GROUP_TEACHER_NAME — VARCHAR(100) — NOT NULL
  • GROUP_TEACHER_HP — VARCHAR(20) — NOT NULL
  • STUDENT_ACCOUNT — VARCHAR(255) — Foreign key → USER.STUDENT_ACCOUNT — NOT NULL

USER (USER_INFO)

  • STUDENT_ACCOUNT — VARCHAR(255) — Primary key — 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

USER_INFO (USER_REGIST_INFO)

  • STUDENT_ACCOUNT — VARCHAR(255) — Foreign key → USER.STUDENT_ACCOUNT — NOT NULL
  • Field (REG_USER) — VARCHAR(20)
  • Field (REG_DT) — DATETIME
  • Field (LAST_USER) — VARCHAR(20)
  • Field (LAST_DT) — DATETIME

Untitled (GRADE)

  • STUDENT_ACCOUNT — VARCHAR(255) — Foreign key → USER.STUDENT_ACCOUNT — NOT NULL
  • Field (GRADE_FIRST_EXAM) — VARCHAR(3)
  • Field (GRADE_SECOND_EXAM) — VARCHAR(3)
  • Field (GRADE_THIRD_EXAM) — VARCHAR(3)
  • Field (ALGORITHM_GRADE) — VARCHAR(20)
  • Field (ALGORITHM_ACQUISITION_DATE) — DATETIME

Untitled (ATTENDANCE)

  • STUDENT_ACCOUNT — VARCHAR(255) — Foreign key → USER.STUDENT_ACCOUNT — NOT NULL
  • Field (ATTENDANCE_1/1) — TINYINT(0)
  • Field (ATTENDANCE_1/1_SIGN_IN) — DATETIME
  • Field2 (ATTENDANCE_1/1_SIGN_OUT) — DATETIME
  • Field2 (ATTENDANCE_1/2) — TINYINT(0)
  • Field2 (ATTENDANCE_1/2_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/2_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_1/3) — TINYINT(0)
  • Field (ATTENDANCE_1/3_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/3_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_1/4) — TINYINT(0)
  • Field (ATTENDANCE_1/4_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/4_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_1/5) — TINYINT(0)
  • Field (ATTENDANCE_1/5_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/5_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_1/6) — TINYINT(0)
  • Field (ATTENDANCE_1/6_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/6_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_1/7) — TINYINT(0)
  • Field (ATTENDANCE_1/7_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/7_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_1/8) — TINYINT(0)
  • Field (ATTENDANCE_1/8_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/8_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_1/9) — TINYINT(0)
  • Field (ATTENDANCE_1/9_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/9_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_1/10) — TINYINT(0)
  • Field (ATTENDANCE_1/10_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/10_SIGN_OUT) — DATETIME