학교
테이블 (6)
Consultations
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → Users.id — NOT NULL
- consultation_date — TIMESTAMP
- title — VARCHAR(255)
- status — VARCHAR(50)
Questions
- id — BIGINT — 기본 키 — NOT NULL
- survey_id — BIGINT — 외래 키 → Surveys.id — NOT NULL
- text — VARCHAR(1000) — NOT NULL
- min_score — INT
- max_score — INT
SurveyAssignments
- id — BIGINT — 기본 키 — NOT NULL
- survey_id — BIGINT — 외래 키 → Surveys.id — NOT NULL
- user_id — BIGINT — 외래 키 → Users.id — NOT NULL
- assigned_date — TIMESTAMP — NOT NULL
SurveyResults
- id — BIGINT — 기본 키 — NOT NULL
- consultation_id — BIGINT — 외래 키 → Consultations.id
- user_id — BIGINT — 외래 키 → Users.id — NOT NULL
- survey_type — VARCHAR(20)
- depression — INT
- anxiety — INT
- joy — INT
- anger — INT
- fatigue — INT
- loneliness — INT
- stability — INT
- self_satisfaction — INT
- comments — TEXT
- submission_date — TIMESTAMP — NOT NULL
Surveys
- id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- created_by — BIGINT — 외래 키 → Users.id
- creation_date — TIMESTAMP — NOT NULL
Users
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- age — INT
- occupation — VARCHAR(100)
- enabled — BOOLEAN — NOT NULL
- refreshToken — VARCHAR(1000)
- createdAt — TIMESTAMP — NOT NULL