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