Student Management

Tables (9)

Grade (성적)

  • grade_id (성적 ID) — Primary key — NOT NULL
  • realationId (관계 ID) — Foreign key → TeachertoStuent.realationId — NOT NULL
  • date (날짜)
  • grade (성적)
  • created_at (생성일)
  • updated_at (수정일)

Homework (과제)

  • homeworkId (과제 ID) — Primary key — NOT NULL
  • realationId (관계 ID) — Foreign key → TeachertoStuent.realationId — NOT NULL
  • date (날짜)
  • content (숙제 내용)
  • created_at (생성일)
  • updated_at (수정일)

Progress (진도)

  • Key — Primary key — NOT NULL
  • realationId (관계 ID) — Foreign key → TeachertoStuent.realationId — NOT NULL
  • date (날짜)
  • progress (진도 현황)
  • created_at (생성일)
  • updated_at (수정일)

Schedule (일정)

  • schedule_id (Key) — Primary key — NOT NULL
  • realationId (관계 ID) — Foreign key → TeachertoStuent.realationId — NOT NULL
  • date (날짜)
  • content (내용)
  • created_at (생성일)
  • updated_at (수정일)

Student (학생)

  • student_id (학생 ID) — Primary key — NOT NULL
  • user_id (유저 ID) — Foreign key → User.user_id — NOT NULL

Teacher (선생님)

  • teacher_id (선생님 ID) — Primary key — NOT NULL
  • user_id (유저 ID) — Foreign key → User.user_id — NOT NULL

TeachertoStuent (선생님-학생 관계)

  • realationId (관계 ID) — Primary key — NOT NULL
  • student_id (학생 ID) — Foreign key → Student.student_id — NOT NULL
  • teacher_id (선생님 ID) — Foreign key → Teacher.teacher_id — NOT NULL

User (유저)

  • user_id (유저 ID) — Primary key — NOT NULL
  • name (이름)
  • email (이메일)
  • password (비밀번호)
  • type (유저 종류)
  • created_at (생성일)
  • updated_at (수정일)

check (출석체크)

  • Key — Primary key — NOT NULL
  • realationId (관계 ID) — Foreign key → TeachertoStuent.realationId — NOT NULL
  • date (날짜)
  • state (지각 or 결석 or 연기 or 출석 완료)
  • created_at (생성일)
  • updated_at (수정일)