사자가온다

테이블 (17)

관리자 테이블 (admin)

  • id — uuid — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • user_name — character — NOT NULL
  • password — character — NOT NULL
  • name — character — NOT NULL
  • role — admin_role_enum — NOT NULL
  • refresh_token — character — NOT NULL

교사 (teacher)

  • id — uuid — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • email — character — NOT NULL
  • password — character — NOT NULL
  • phone_number — character — NOT NULL
  • name — character — NOT NULL
  • is_active — boolean — NOT NULL
  • is_deleted — boolean — NOT NULL
  • is_verified — boolean — NOT NULL
  • profile — character — NOT NULL
  • grade — teacher_grade_enum — NOT NULL
  • class_name — character — NOT NULL
  • message — character — NOT NULL
  • sign — character — NOT NULL
  • school_id — integer
  • field — teacher_field_enum — NOT NULL
  • approval_status — teacher_approval_status_enum — NOT NULL
  • changed_approval_status_at — timestamp — NOT NULL

교사 상담 시간표 (timetable)

  • id — integer — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • day_of_week — timetable_day_of_week_enum — NOT NULL
  • start_time — character — NOT NULL
  • end_time — character — NOT NULL
  • teacher_id — uuid — NOT NULL

교사 상담 타입 테이블 (teacher_consultation_type)

  • field — teacher_consultation_type_field_enum — 기본 키 — NOT NULL
  • consultation_type_id — integer — 기본 키 — NOT NULL

교사 수신동의 테이블 (marketing_teacher)

  • email — character — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • password — character — NOT NULL
  • phone_number — character — NOT NULL
  • name — character — NOT NULL
  • is_active — boolean — NOT NULL
  • is_deleted — boolean — NOT NULL
  • is_verified — boolean — NOT NULL
  • profile — character — NOT NULL
  • grade — marketing_teacher_grade_enum — NOT NULL
  • class_name — character — NOT NULL
  • message — character — NOT NULL
  • sign — character — NOT NULL
  • approval_status — marketing_teacher_approval_status_enum — NOT NULL
  • field — marketing_teacher_field_enum — NOT NULL
  • school_name — character — NOT NULL
  • changed_approval_status_at — timestamp — NOT NULL

교사 알람 테이블 (teacher_notification)

  • id — integer — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • title — character — NOT NULL
  • content — character — NOT NULL
  • is_read — boolean — NOT NULL
  • link — character — NOT NULL
  • related_info — character — NOT NULL
  • teacher_id — uuid

배너관련 테이블 (banner)

  • id — integer — 기본 키 — NOT NULL
  • title — character — NOT NULL
  • image — character — NOT NULL
  • description — character — NOT NULL
  • link — character — NOT NULL
  • idx — integer — NOT NULL

상담 타입 테이블 (consultation_type)

  • id — integer — 기본 키 — NOT NULL
  • name — character — NOT NULL
  • parent_id — integer — 외래 키 → 상담 타입 테이블.id
  • color — character

상담예약 테이블 (consultation_confirmation)

  • id — integer — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • status — consultation_confirmation_status_enum — NOT NULL
  • consultation_id — integer — NOT NULL
  • message — character — NOT NULL

상담일지 테이블 (consultation_content)

  • id — integer — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • summary — character — NOT NULL
  • detail — character — NOT NULL
  • consultation_id — integer — NOT NULL

상담테이블 (consultation)

  • id — integer — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • start_at — timestamp — NOT NULL
  • end_at — timestamp — NOT NULL
  • status — consultation_status_enum — NOT NULL
  • message — character — NOT NULL
  • type_id — integer
  • teacher_id — uuid
  • student_id — uuid
  • school_id — integer

설문지 테이블 (assessment)

  • id — integer — 기본 키 — NOT NULL
  • student_id — uuid — 외래 키 → 학생 테이블.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • 심리검사번호 (assessment_no) — integer
  • 설문항목 (assessment_content) — json
  • 설문지링크 (assessment_link) — character

챗봇 테이블 (chatbot)

  • session_id — uuid — 기본 키 — NOT NULL
  • student_id — uuid — 외래 키 → 학생 테이블.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • history — json
  • isfinished — boolean

학교 (school)

  • id — integer — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • standard_code — character — NOT NULL
  • region — character — NOT NULL
  • address — character — NOT NULL
  • name — character — NOT NULL
  • type — school_type_enum — NOT NULL
  • code — character

학생 수신동의 테이블 (marketing_student)

  • email — character — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • password — character — NOT NULL
  • phone_number — character — NOT NULL
  • name — character — NOT NULL
  • is_active — boolean — NOT NULL
  • is_deleted — boolean — NOT NULL
  • is_verified — boolean — NOT NULL
  • profile — character — NOT NULL
  • grade — marketing_student_grade_enum — NOT NULL
  • class_name — character — NOT NULL
  • attendance_num — integer — NOT NULL
  • school_name — character — NOT NULL
  • is_public — boolean — NOT NULL

학생 알람 테이블 (student_notification)

  • id — integer — 기본 키 — NOT NULL
  • student_id — uuid — 외래 키 → 학생 테이블.id — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • title — character — NOT NULL
  • content — character — NOT NULL
  • is_read — boolean — NOT NULL
  • link — character — NOT NULL
  • related_info — character — NOT NULL

학생 테이블 (student)

  • id — uuid — 기본 키 — NOT NULL
  • name — character — NOT NULL
  • is_active — boolean — NOT NULL
  • email — character — NOT NULL
  • password — character — NOT NULL
  • phone_number — character — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • profile — character — NOT NULL
  • grade — student_grade_enum — NOT NULL
  • school_id — integer
  • is_deleted — boolean — NOT NULL
  • class_name — character — NOT NULL
  • attendance_num — integer — NOT NULL
  • is_verified — boolean — NOT NULL
  • is_public — boolean — NOT NULL