0309

Tables (6)

Untitled (user)

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

Untitled (group)

  • Key (id) — integer — Foreign key → Untitled.Key — NOT NULL
  • Field (teacher_id) — varchar(20)
  • Field (teacher_name) — varchar(20)
  • Field (teacher_hp) — varchar(20)

Untitled (student)

  • Key (id) — integer — Foreign key → Untitled.Key — NOT NULL
  • Field (account) — varchar(20)
  • Field2 (name) — varchar(100)
  • Field3 (hp) — varchar(20)
  • Field4 (age) — varchar(5)
  • Field5 (gender) — varchar(20)
  • Field6 (curriculum) — varchar(20)
  • Field (region) — varchar(20)
  • Field2 (group) — varchar(20)

Untitled (algorithm)

  • Key (id) — integer — Foreign key → Untitled.Key — NOT NULL
  • Field (grade) — varchar(20)
  • Field2 (acquisition_date) — datetime

Untitled (grade)

  • Key (id) — integer — Foreign key → Untitled.Key — NOT NULL
  • Field (first_exam) — varchar(3)
  • Field2 (second_exam) — varchar(3)
  • Field3 (third_exam) — varchar(3)
  • Field (project1_score) — varchar(3)
  • Field2 (project2_score) — varchar(3)
  • Field3 (project3_score) — varchar(3)

Untitled (attendance)

  • Key (id) — integer — Foreign key → Untitled.Key — NOT NULL
  • Field (1/1) — tinyint(1)
  • Field2 (1/1_sign_in) — datetime
  • Field3 (1/1_sign_out) — datetime
  • Field4 (1/2) — tinyint(10)
  • Field5 (1/2_sigin_in) — datetime
  • Field6 (1/2_sign_out) — datetime
  • Field7 (1/3) — tinyint(1)
  • Field8 (1/3_sign_in) — datetime
  • Field9 (1/3_sign_out) — datetime