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)