user

Tables (6)

Admin (admin)

  • Admin_id (admin_id) — INT(4) — Primary key — NOT NULL
  • Reg_dt (reg_dt) — DATETIME
  • Last_user (last_user) — VARCHAR(20)
  • Last_dt (last_dt) — DATETIME
  • Reg_user (reg_user) — VARCHAR(20) — NOT NULL

Attendance (attendance)

  • Student_id (student_id) — INT(4) — Primary key — NOT NULL
  • Student_id (student_id2) — INT(4) — Foreign key → Student.Student_id — NOT NULL
  • Attendance (attendance) — TINYINT(1)
  • Attendance_sign_in (attendance_sign_in) — DATETIME
  • Attendance_sign_out (attendance_sign_out) — DATETIME

Grade (grade)

  • Student_id (student_id) — INT(4) — Primary key — NOT NULL
  • First_exam (first_exam) — VARCHAR(3)
  • Second_exam (second_exam) — VARCHAR(3)
  • Third_exam (third_exam) — INT(4)
  • Algorithm_grade (algorithm_grade) — VARCHAR(3)
  • Algorithm_acquistion_date (algorithm_acquistion_date) — DATETIME

Group (group)

  • Group_id (group_id) — INT(4) — Primary key — NOT NULL
  • Teacher_id (teacher_id) — VARCHAR(20)
  • Teacher_name (teacher_name) — VARCHAR(20)
  • Teacher_HP (teacher_hp) — VARCHAR(20)
  • Region_num (region_num) — VARCHAR(20)

Project (project)

  • Student_id (student_id) — INT(4) — Primary key — NOT NULL
  • Team (team) — VARCHAR(10) — NOT NULL
  • Project_subject (project_subject) — VARCHAR(10) — NOT NULL
  • Project_title (project_title) — VARCHAR(10) — NOT NULL
  • Project_grade (project_grade) — VARCHAR(3) — NOT NULL

Student (student)

  • Student_id (student_id) — INT(4) — Primary key — NOT NULL
  • Student_id (student_id_grade) — INT(4) — Foreign key → Grade.Student_id — NOT NULL
  • Student_id (student_id_project) — INT(4) — Foreign key → Project.Student_id — NOT NULL
  • Account (account) — VARCHAR(20)
  • Name (name) — VARCHAR(100)
  • HP (hp) — VARCHAR(20)
  • Age (age) — VARCHAR(5)
  • Gender (gender) — VARCHAR(20)
  • Curricullum (curricullum) — VARCHAR(20)
  • Region (region) — VARCHAR(20)
  • Group (group) — VARCHAR(20) — NOT NULL
  • Group_id (group_id) — INT(4) — Foreign key → Group.Group_id — NOT NULL
  • Admin_id (admin_id) — INT(4) — Foreign key → Admin.Admin_id — NOT NULL