day1

Tables (5)

attendance (Untitled4)

  • attendance_id (Key) — long — Primary key — NOT NULL
  • attendance_date (Field) — datetime
  • sign_in (Field2) — datetime
  • sign_out (Field3) — datetime

grade (Untitled5)

  • grade_id (Key) — long — Primary key — NOT NULL
  • grade_first_exam (Field) — varchar
  • grade_second_exam (Field2) — varchar
  • grade_third_exam (Field3) — varchar
  • algorithm_grade (Field4) — varchar
  • algorithm_acquisition_date (Field5) — datetime

group (Untitled3)

  • group_id (Key) — long — Primary key — NOT NULL
  • group_teacher_id (Field) — varchar
  • group_teacher_name (Field2) — varchar
  • group_teacher_hp (Field3) — varchar

reg (Untitled2)

  • reg_id (Key) — long — Primary key — NOT NULL
  • reg_user (Field) — varchar
  • reg_dt (Field2) — datetime
  • last_user (Field3) — varchar
  • last_dt (Field4) — datetime

user (Untitled)

  • user_id (Key) — long — Primary key — NOT NULL
  • reg_id (Key6) — long — Foreign key → reg.reg_id — NOT NULL
  • group_id (Key2) — long — Foreign key → group.group_id — NOT NULL
  • attendance_id (Key3) — long — Foreign key → attendance.attendance_id — NOT NULL
  • grade_id (Key4) — long — Foreign key → grade.grade_id — NOT NULL
  • student_account (Field) — varchar
  • student_name (Field2) — varchar
  • student_age (Field3) — varchar
  • student_hp (Field4) — varchar
  • student_gender (Field5) — varchar
  • student_region (Field6) — varchar
  • student_curriculum (Field7) — varchar