사자가온다
테이블 (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