2020-03-09

Tables (6)

attendance (Untitled6)

  • id — int — Primary key — NOT NULL
  • ATTENDANCE_DAY — varchar(20) — NOT NULL

exam (Untitled4)

  • id — int — Primary key — NOT NULL
  • EXAM_NAME — varchar(100) — NOT NULL
  • EXAM_ORDER — int — NOT NULL
  • EXAM_CONTENTS — varchar(500)
  • EXAM_DATE — datetime — NOT NULL

student_attendance (Untitled7)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • attendance_id — int — Foreign key → attendance.id — NOT NULL
  • ATTENDANCE_SIGN_IN — datetime
  • ATTENDANCE_SIGN_OUT — datetime

student_exam (Untitled5)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • exam_id — int — Foreign key → exam.id — NOT NULL
  • EXAM_GRADE — varchar(20) — NOT NULL

teacher (Untitled)

  • id — int — Primary key — NOT NULL
  • TEACHER_NAME — varchar(20) — NOT NULL
  • TEACHER_HP — varchar(20) — NOT NULL

user

  • id — int — Primary key — NOT NULL
  • teacher_id — int — Foreign key → teacher.id — NOT NULL
  • 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
  • ALGORITHM_GRADE — varchar(20)
  • ALGORITHM_ACQUISITION_DATE — datetime
  • REG_USER — varchar(20)
  • REG_DT — datetime
  • LAST_USER — varchar(20)
  • LAST_DT — datetime