Project_0309

Tables (5)

Attendance (attendance)

  • attendance_date (at_date) — date — Primary key — NOT NULL
  • student_account (st_acc) — varchar(20) — Foreign key → Student.student_account — NOT NULL
  • attendance_sign_in (at_si) — time
  • attendance_sign_out (at_so) — time

Grade (grade)

  • student_account (st_acc) — varchar(20) — Foreign key → Student.student_account — NOT NULL
  • grade_first_exam (gr_1st) — varchar(3)
  • grade_second_exam (gr_2nd) — varchar(3)
  • grade_third_exam (gr_3rd) — varchar(3)
  • algorithm_grade (gr_al) — varchar(20)
  • algorithm_acquisition_date (gr_aldate) — datetime

Group (group)

  • group_id (grp_id) — varchar(20) — Primary key — NOT NULL
  • group_teacher_id (grp_tid) — varchar(20) — NOT NULL
  • group_teacher_hp (grp_thp) — varchar(20) — NOT NULL

Project (project)

  • project_team_id (pjt_tid) — varchar(20) — Primary key — NOT NULL
  • project_domain (pjt_do) — varchar(20) — NOT NULL

Student (student)

  • student_account (st_acc) — varchar(20) — Primary key — NOT NULL
  • group_id (grp_id) — varchar(20) — Foreign key → Group.group_id — NOT NULL
  • project_team_id (pjt_tid) — varchar(20) — Foreign key → Project.project_team_id — NOT NULL
  • student_name (st_name) — varchar(100) — NOT NULL
  • student_hp (st_hp) — varchar(20)
  • student_ages (st_age) — varchar(5)
  • student_gender (st_gen) — varchar(20)
  • student_curriculum (st_cur) — varchar(20)
  • student_region (st_reg) — varchar(20)
  • student_id (st_id) — varchar(20) — NOT NULL