리벤그리다 외주

테이블 (11)

tb_dsac_raw (Untitled5)

  • user_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • test_round (Field) — TINYINT — NOT NULL
  • raw_scores (Field2) — JSON — NOT NULL
  • demand_direct_score (Field3) — INT
  • demand_indirect_score (Field4) — INT
  • question_score (Field5) — INT
  • affirmation_score (Field6) — INT
  • ritualization_score (Field7) — INT
  • total_score (Field8) — INT

tb_dsac_summary (CopyOfUntitled5)

  • user_id — BIGINT — 외래 키 → tb_dsac_raw.user_id — NOT NULL
  • first_dsac_score (Field) — INT — NOT NULL
  • second_dsac_score (Field2) — INT
  • dsac_growth_rate (Field3) — DECIMAL(5,2)

tb_final_report (CopyOfUntitled42)

  • user_id (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • needed_training_area (Field) — JSON — NOT NULL
  • training_content (Field5) — TEXT — NOT NULL
  • improvement (Field2) — TEXT — NOT NULL

tb_metrics (CopyOfUntitled4)

  • session_id (Key2) — BIGINT — 기본 키 — NOT NULL
  • utterance_id (Key3) — BIGINT — 외래 키 → tb_utterance.utterance_id — NOT NULL
  • question_id (Key22) — BIGINT — 외래 키 → tb_utterance.question_id — NOT NULL
  • session_id (Key32) — BIGINT — 외래 키 → tb_utterance.session_id — NOT NULL
  • user_id — BIGINT — 외래 키 → tb_utterance.user_id — NOT NULL
  • tenant_id (Key322) — BIGINT — 외래 키 → tb_utterance.tenant_id — NOT NULL
  • reaction_time (Field) — INT — NOT NULL
  • coherence_score (Field5) — INT — NOT NULL
  • repetition_ratio (Field2) — INT — NOT NULL
  • avg_sentence_length (Field3) — INT — NOT NULL
  • grammar_score (Field4) — INT — NOT NULL
  • recall_score (Field6) — INT — NOT NULL

tb_question (Untitled3)

  • question_id (Key) — BIGINT — 기본 키 — NOT NULL
  • question_content (Field) — TEXT — NOT NULL
  • question_category (Field2) — VARCHAR(50) — NOT NULL

tb_report (CopyOfUntitled43)

  • report_id (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • session_id (Key2) — BIGINT — 외래 키 → tb_session.session_id — NOT NULL
  • utterance_id (Key22) — BIGINT — 외래 키 → tb_session.utterance_id — NOT NULL
  • question_id (Key222) — BIGINT — 외래 키 → tb_session.question_id — NOT NULL
  • problem_solving_score (Field2) — INT — NOT NULL
  • calculation_score (Field3) — INT — NOT NULL
  • memory_focus_score (Field4) — INT — NOT NULL
  • spatial_ability_score (Field6) — INT — NOT NULL
  • music_touch_score (Field7) — INT — NOT NULL
  • language_score (Field8) — INT — NOT NULL
  • ratio (Field9) — FLOAT(5,2) — NOT NULL
  • total_comment (Field10) — TEXT

tb_session (Untitled)

  • session_id (Key) — BIGINT — 기본 키 — NOT NULL
  • tenant_id (Key3) — BIGINT — 외래 키 → tb_tenant.tenant_id — NOT NULL
  • user_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • utterance_id (Key2) — BIGINT — 외래 키 → tb_utterance.utterance_id — NOT NULL
  • question_id (Key22) — BIGINT — 외래 키 → tb_utterance.question_id — NOT NULL
  • session_id (Key32) — BIGINT — 외래 키 → tb_utterance.session_id — NOT NULL
  • session_start_time (Field3) — TIMESTAMP — NOT NULL
  • session_end_time (Field4) — TIMESTAMP
  • session_status (Field5) — ENUM — NOT NULL — active, closed, error 중 택일 (디폴트: active)

tb_tenant (Untitled2)

  • tenant_id (Key) — BIGINT — 기본 키 — NOT NULL
  • tenant_name (Field) — VARCHAR(200) — NOT NULL

tb_user (사용자)

  • user_id — BIGINT — 기본 키 — NOT NULL
  • tenant_id (Key) — BIGINT — 외래 키 → tb_tenant.tenant_id — NOT NULL
  • user_email — VARCHAR(255)
  • user_role — ENUM — viewer, manager, admin 중 택일 (디폴트: viewer)
  • user_personal_info_agree — BOOLEAN — NOT NULL
  • create_date — TIMESTAMP
  • update_date — TIMESTAMP

tb_user_private (사용자 민감 정보)

  • user_id (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • user_name (이름) — VARCHAR(100) — NOT NULL
  • user_birthday (생년월일) — VARCHAR(20) — NOT NULL
  • user_phone_number (전화번호) — VARCHAR(20) — NOT NULL
  • user_image (이미지) — TEXT — NOT NULL

tb_utterance (Untitled4)

  • utterance_id (Key) — BIGINT — 기본 키 — NOT NULL
  • question_id (Key2) — BIGINT — 외래 키 → tb_question.question_id — NOT NULL
  • session_id (Key3) — BIGINT — 외래 키 → tb_session.session_id — NOT NULL
  • user_id — BIGINT — 외래 키 → tb_session.user_id — NOT NULL
  • utterance_id (Key22) — BIGINT — 외래 키 → tb_session.utterance_id — NOT NULL
  • tenant_id (Key32) — BIGINT — 외래 키 → tb_session.tenant_id — NOT NULL
  • week (Field2) — INT
  • date (Field3) — DATE
  • utterance_answer (Field6) — TEXT
  • is_correct (Field7) — BOOLEAN — NOT NULL