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