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)