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 (수정일)