ERD

Tables (8)

algorithm (Untitled5)

  • id (Key) — varchar(20) — Primary key — NOT NULL
  • grade (Field) — varchar(20)
  • acquisition_date (Field2) — datetime

attendance (Untitled6)

  • id (Key) — varchar(20) — Primary key — NOT NULL
  • attendance (Field) — tinyint(1)
  • sign_in (Field2) — datetime
  • sign_out (Field3) — datetime

grade (Untitled4)

  • id (Key) — varchar(20) — Primary key — NOT NULL
  • first_exam (Field) — varchar(3)
  • second_exam (Field2) — varchar(3)
  • third_exam (Field3) — varchar(3)

group (Untitled)

  • id (Key) — varchar(20) — Primary key — NOT NULL
  • group (Field4) — varchar(20) — NOT NULL

log (Untitled7)

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

region (Untitled2)

  • id (Key) — varchar(20) — Primary key — NOT NULL
  • name (Field) — varchar(20) — NOT NULL

student

  • id — varchar(20) — Primary key — NOT NULL
  • grade_id (Key2) — varchar(20) — Foreign key → grade.id — NOT NULL
  • log_id (Key4) — varchar(20) — Foreign key → log.id — NOT NULL
  • algorithm_id (Key6) — varchar(20) — Foreign key → algorithm.id — NOT NULL
  • teacher_id (Key7) — varchar(20) — Foreign key → teacher.id — NOT NULL
  • region_id (Key) — varchar(20) — Foreign key → region.id — NOT NULL
  • group_id (Key3) — varchar(20) — Foreign key → group.id — NOT NULL
  • attendance_id (Key5) — varchar(20) — Foreign key → attendance.id — NOT NULL
  • account (Field) — varchar(20) — NOT NULL
  • name (Field2) — varchar(100) — NOT NULL
  • hp (Field3) — varchar(20)
  • age (Field4) — varchar(5)
  • gender (Field5) — varchar(20)
  • curriculum (Field6) — varchar(20)

teacher (Untitled3)

  • id (Key) — varchar(20) — Primary key — NOT NULL
  • account (Field) — varchar(20) — NOT NULL
  • name (Field2) — varchar(20) — NOT NULL
  • hp (Field3) — varchar(20) — NOT NULL