day1
Tables (5)
attendance (Untitled4)
- attendance_id (Key) — long — Primary key — NOT NULL
- attendance_date (Field) — datetime
- sign_in (Field2) — datetime
- sign_out (Field3) — datetime
grade (Untitled5)
- grade_id (Key) — long — Primary key — NOT NULL
- grade_first_exam (Field) — varchar
- grade_second_exam (Field2) — varchar
- grade_third_exam (Field3) — varchar
- algorithm_grade (Field4) — varchar
- algorithm_acquisition_date (Field5) — datetime
group (Untitled3)
- group_id (Key) — long — Primary key — NOT NULL
- group_teacher_id (Field) — varchar
- group_teacher_name (Field2) — varchar
- group_teacher_hp (Field3) — varchar
reg (Untitled2)
- reg_id (Key) — long — Primary key — NOT NULL
- reg_user (Field) — varchar
- reg_dt (Field2) — datetime
- last_user (Field3) — varchar
- last_dt (Field4) — datetime
user (Untitled)
- user_id (Key) — long — Primary key — NOT NULL
- reg_id (Key6) — long — Foreign key → reg.reg_id — NOT NULL
- group_id (Key2) — long — Foreign key → group.group_id — NOT NULL
- attendance_id (Key3) — long — Foreign key → attendance.attendance_id — NOT NULL
- grade_id (Key4) — long — Foreign key → grade.grade_id — NOT NULL
- student_account (Field) — varchar
- student_name (Field2) — varchar
- student_age (Field3) — varchar
- student_hp (Field4) — varchar
- student_gender (Field5) — varchar
- student_region (Field6) — varchar
- student_curriculum (Field7) — varchar