리벤그리다 외주
테이블 (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