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 — 계정