schoolProject

Tables (11)

CONSULTATION

  • consultation_id — VARCHAR2(36)
  • user_id — VARCHAR2(36) — NOT NULL — 사용자
  • counselor_id — VARCHAR2(36) — NOT NULL — 상담사
  • consultation_date — TIMESTAMP — NOT NULL — 상담
  • status — VARCHAR2(50) — NOT NULL — 상담

COUNSELOR

  • counselor_id — VARCHAR2(36)
  • google_id — VARCHAR2(255) — NOT NULL — Google
  • email — VARCHAR2(255) — NOT NULL — 상담사
  • name — VARCHAR2(255) — 상담사
  • created_at — TIMESTAMP — NOT NULL — 계정

CUSTOM_QUESTION

  • custom_question_id — VARCHAR2(36)
  • counselor_id — VARCHAR2(36) — NOT NULL — 질문
  • question_text — CLOB — NOT NULL — 질문
  • question_type — VARCHAR2(50) — NOT NULL — 질문
  • options — CLOB — 선택형
  • created_at — TIMESTAMP — NOT NULL — 질문
  • is_active — NUMBER(1) — NOT NULL — 질문

CUSTOM_SURVEY_ANSWER

  • custom_answer_id — VARCHAR2(36)
  • custom_response_session_id — VARCHAR2(36) — NOT NULL — 관련
  • custom_question_id — VARCHAR2(36) — NOT NULL — 답변한
  • answer_value — CLOB — NOT NULL — 사용자

CUSTOM_SURVEY_FORM

  • custom_survey_form_id — VARCHAR2(36)
  • counselor_id — VARCHAR2(36) — NOT NULL — 양식
  • form_name — VARCHAR2(255) — NOT NULL — 설문
  • description — CLOB — 설문
  • created_at — TIMESTAMP — NOT NULL — 양식
  • is_active — NUMBER(1) — NOT NULL — 양식

CUSTOM_SURVEY_FORM_QUESTION

  • custom_survey_form_id — VARCHAR2(36) — Primary key — NOT NULL
  • custom_question_id — VARCHAR2(36) — Primary key — NOT NULL — 질문
  • order_index — NUMBER(3) — NOT NULL — 양식

CUSTOM_SURVEY_RESPONSE_SESSION

  • custom_response_session_id — VARCHAR2(36)
  • user_id — VARCHAR2(36) — NOT NULL — 응답한
  • custom_survey_form_id — VARCHAR2(36) — NOT NULL — 응답한
  • consultation_id — VARCHAR2(36) — 관련
  • submitted_at — TIMESTAMP — NOT NULL — 응답

EMOTION_TYPE

  • emotion_type_id — NUMBER(2)
  • name — VARCHAR2(100) — NOT NULL — 감정
  • question_example — CLOB — NOT NULL — 설문

SURVEY_RESPONSE

  • survey_response_id — VARCHAR2(36)
  • survey_session_id — VARCHAR2(36) — NOT NULL — 관련
  • emotion_type_id — NUMBER(2) — NOT NULL — 응답한
  • score — NUMBER(2) — NOT NULL — 0~10점
  • comments — VARCHAR2(255) — 간단한

SURVEY_SESSION

  • survey_session_id — VARCHAR2(36)
  • consultation_id — VARCHAR2(36) — NOT NULL — 관련
  • survey_type — VARCHAR2(10) — NOT NULL — 설문
  • submitted_at — TIMESTAMP — NOT NULL — 설문

USER_ACCOUNT

  • user_id — VARCHAR2(36)
  • google_id — VARCHAR2(255) — NOT NULL — Google
  • email — VARCHAR2(255) — NOT NULL — 사용자
  • display_name — VARCHAR2(255) — 사용자
  • created_at — TIMESTAMP — NOT NULL — 계정