avalond
Tables (24)
alembic_version
- version_num — varchar(32) — Primary key — NOT NULL
branches
- branch_id — int — Primary key — NOT NULL
- branch_name — varchar(255) — NOT NULL
- branch_phone — varchar(20) — NOT NULL
- branch_address — text
check_homeworks
- check_homework_id — int — Primary key — NOT NULL
- student_id — int — Foreign key → students.student_id — NOT NULL
- homework_id — int — Foreign key → homeworks.homework_id — NOT NULL
- class_id — int — Foreign key → classes.class_id — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime
- checker_id — int — Foreign key → users.user_id — NOT NULL — user_id
class_sessions
- session_id — int — Primary key — NOT NULL
- class_id — int — Foreign key → classes.class_id — NOT NULL
- subject_id — int — Foreign key → subjects.subject_id — NOT NULL
- classtime_id — int — Foreign key → classtime.time_id — NOT NULL
- teacher_id — int — Foreign key → users.user_id
- session_date — date — NOT NULL
- curri_detail_id — int — Foreign key → curriculum_detail.curri_detail_id
- is_rescheduled — tinyint(1) — NOT NULL
- original_date — date
- notes — text
- session_order — int — NOT NULL
- weekday — enum('Mon','Tue','Wed','Thu','Fri','Sat','Sun') — NOT NULL
class_students
- belong_id — int — Primary key — NOT NULL
- class_id — int — Foreign key → classes.class_id — NOT NULL
- student_id — int — Foreign key → students.student_id — NOT NULL
classes
- class_id — int — Primary key — NOT NULL
- semester_id — int — Foreign key → semesters.semester_id — NOT NULL
- curriculum_id — int — Foreign key → curriculums.curriculum_id — NOT NULL
- class_name — varchar(100) — NOT NULL
- attend_day — varchar(100) — NOT NULL — 구분자 /
- kr_homeroom — int — Foreign key → users.user_id — NOT NULL
- fr_homeroom — int — Foreign key → users.user_id — NOT NULL
- is_active — tinyint(1) — NOT NULL
- schedule_details_json — json — NOT NULL
classtime
- time_id — int — Primary key — NOT NULL
- start_time — time — NOT NULL
- end_time — time — NOT NULL
consultations
- consultation_id — int — Primary key — NOT NULL
- student_id — int — Foreign key → students.student_id — NOT NULL
- semester_id — int — Foreign key → semesters.semester_id — NOT NULL
- consultant_id — int — Foreign key → users.user_id — NOT NULL — user_id
- consultation_name — varchar(255)
- consultation_detail — text
- created_at — datetime — NOT NULL
- updated_at — datetime
- is_deleted — tinyint(1) — NOT NULL
curriculum_detail
- curri_detail_id — int — Primary key — NOT NULL
- curriculum_id — int — Foreign key → curriculums.curriculum_id — NOT NULL
- subject_id — int — Foreign key → subjects.subject_id — NOT NULL
- DAY — int — NOT NULL
- progress — varchar(100) — NOT NULL
curriculums
- curriculum_id — int — Primary key — NOT NULL
- curriculum_name — varchar(100) — NOT NULL
holidays
- holiday_id — int — Primary key — NOT NULL
- holiday_name — varchar(255) — NOT NULL
- holiday_date — date — NOT NULL
homeworks
- homework_id — int — Primary key — NOT NULL
- curri_detail_id — int — Foreign key → curriculum_detail.curri_detail_id — NOT NULL
- subject_id — int — Foreign key → subjects.subject_id — NOT NULL
- tag_name — varchar(20) — NOT NULL
- is_online — tinyint(1) — NOT NULL
- homework_name — varchar(100) — NOT NULL
- homework_contents — text
semesters
- semester_id — int — Primary key — NOT NULL
- branch_id — int — Foreign key → branches.branch_id — NOT NULL
- semester_name — varchar(50) — NOT NULL
- semester_start_at — date — NOT NULL
- season — enum('Spring','Summer','Fall','Winter') — NOT NULL
- semester_end_at — date — NOT NULL
student_comment
- comment_id — int — Primary key — NOT NULL
- student_id — int — Foreign key → students.student_id — NOT NULL
- comment — text — NOT NULL
- comment_user_id — int — Foreign key → users.user_id — NOT NULL — user_id
- created_at — datetime — NOT NULL
students
- student_id — int — Primary key — NOT NULL
- branch_id — int — Foreign key → branches.branch_id — NOT NULL
- student_name — varchar(20) — NOT NULL
- english_name — varchar(100)
- student_phone — varchar(20)
- parent_phone — varchar(20)
- school — varchar(255)
- s_year — int
- birthday — date
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
- status — enum('ACTIVE','ON_LEAVE','WITHDRAWN','DELETED') — NOT NULL
subjects
- subject_id — int — Primary key — NOT NULL
- subject_name — varchar(100) — NOT NULL
- subject_nick — varchar(20) — NOT NULL
talents
- talent_id — int — Primary key — NOT NULL
- student_id — int — Foreign key → students.student_id — NOT NULL
- semester_id — int — Foreign key → semesters.semester_id — NOT NULL
- created_at — datetime — NOT NULL
- giver_id — int — Foreign key → users.user_id — NOT NULL — user_id
- value — int — NOT NULL
teacher_assignments
- user_id — int — Foreign key → users.user_id — NOT NULL
- subject_id — int — Foreign key → subjects.subject_id — NOT NULL
- class_id — int — Foreign key → classes.class_id — NOT NULL
- time_id — int — Foreign key → classtime.time_id — NOT NULL
- weekday — enum('Mon','Tue','Wed','Thu','Fri') — NOT NULL
test
- test_id — int — Primary key — NOT NULL
- class_id — int — Foreign key → classes.class_id — NOT NULL
- subject_id — int — Foreign key → subjects.subject_id — NOT NULL
- test_title — varchar(100) — NOT NULL
- test_day — date — NOT NULL
- classtime_ids — json
test_results
- result_id — int — Primary key — NOT NULL
- test_id — int — Foreign key → test.test_id — NOT NULL
- student_id — int — Foreign key → students.student_id — NOT NULL
- score — int — NOT NULL
todos
- todo_id — int — Primary key — NOT NULL
- curri_detail_id — int — Foreign key → curriculum_detail.curri_detail_id — NOT NULL
- subject_id — int — Foreign key → subjects.subject_id — NOT NULL
- todo_type — enum('NOTICE','BEFORE','IN') — NOT NULL
- todo_thing — text — NOT NULL
users
- user_id — int — Primary key — NOT NULL
- branch_id — int — Foreign key → branches.branch_id — NOT NULL
- username — varchar(20) — NOT NULL
- password_hash — varchar(255) — NOT NULL
- name — varchar(20) — NOT NULL
- email — varchar(100)
- phone — varchar(20)
- birthday — date
- is_foreign — tinyint(1) — NOT NULL
- role — enum('SUPER_ADMIN','ADMIN','MANAGER','TEACHER','ASSISTANT') — NOT NULL
- status — enum('ACTIVE','INACTIVE','SUSPENDED','DELETED') — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
단어 시험 결과 (voca_test)
- 단어시험ID (voca_test_id) — int — Primary key — NOT NULL
- 학생ID (Key) — Primary key — NOT NULL
- 반ID (Key2) — Primary key — NOT NULL
- 점수 (Key3) — NOT NULL
- 회차 (Field) — enum(0,1,2,3)
- 통과 여부 (Field2)
- 커트라인 (Field3)
- 응시 여부 (Field4)
단어시험 (voca)
- 보카ID (voca_id) — int — Primary key — NOT NULL
- 반ID (Key2) — Primary key — NOT NULL
- 시험 단어 갯수 (Field)