학교

테이블 (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