day1
Tables (5)
attendance
- 번호 (student_hp) — Foreign key → student.번호 — NOT NULL
- 날짜 (attendance_date)
- 출근 (attendance_signin)
- 퇴근 (attendance_signout)
grade
- 번호 (student_hp) — Foreign key → student.번호 — NOT NULL
- 첫번째 (grade_first_exam)
- 세번째 (grade_third_exam)
- 성적 (algorithm_grade)
- 취득일 (algorithm_acquistion_date)
- 두번째 (grade_second_exam)
group
- 지역 (student_region) — Primary key
- 샘아이디 (group_teacher_id)
- 샘이름 (group_teacher_name)
- 샘번호 (group_teacher_hp) — NOT NULL
project_grade
- 그룹번호 (studuent_group) — Primary key — NOT NULL
- 성적 (group_grade)
student
- 번호 (student_hp) — Primary key — NOT NULL
- 지역 (student_region) — Foreign key → group.지역
- 그룹번호 (studuent_group) — Foreign key → project_grade.그룹번호 — NOT NULL
- 계정 (student_account)
- 이름 (student_name)
- 성별 (student_gender)
- 나이 (student_age)
- 학기 (student_curriculum)
- 그룹 (student_group)