test

Tables (19)

ai_job

  • job_id — VARCHAR(100) — Primary key — NOT NULL
  • resource_type — VARCHAR(20) — NOT NULL
  • resource_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • progress — SMALLINT — NOT NULL
  • result — JSONB
  • error_code — VARCHAR(100)
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

ai_practice_chat

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → ai_practice_session.id — NOT NULL
  • user_message — VARCHAR(500) — NOT NULL
  • ai_response — TEXT
  • status — VARCHAR(20) — NOT NULL
  • is_retry — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • completed_at — TIMESTAMP

ai_practice_session

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • target_persona_id — BIGINT — Foreign key → persona.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

ai_simulation_message

  • id — BIGSERIAL — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → ai_simulation_session.id — NOT NULL
  • sequence_no — INT — NOT NULL
  • speaker — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

ai_simulation_report

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → ai_simulation_session.id — NOT NULL
  • overall_score — DECIMAL(5,2)
  • summary — TEXT
  • conversation_flow_grade — CHAR(1)
  • question_exchange_grade — CHAR(1)
  • interest_expression_grade — CHAR(1)
  • initiative_balance_grade — CHAR(1)
  • detail_result — JSONB
  • created_at — TIMESTAMP — NOT NULL
  • completed_at — TIMESTAMP

ai_simulation_session

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • max_rounds — SMALLINT — NOT NULL
  • my_persona_id — BIGINT — Foreign key → persona.id — NOT NULL
  • target_persona_id — BIGINT — Foreign key → persona.id — NOT NULL
  • message_count — INT — NOT NULL
  • started_at — TIMESTAMP
  • finished_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

build_items

  • id — BIGSERIAL — Primary key — NOT NULL
  • session_id — UUID — Foreign key → build_sessions.id — NOT NULL
  • step — INT — NOT NULL
  • question_kind — VARCHAR(20) — NOT NULL
  • question_sequence — INT — NOT NULL
  • question — TEXT — NOT NULL
  • answer — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • answered_at — TIMESTAMP

build_sessions

  • id — UUID — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • current_step — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • completed_at — TIMESTAMP

chat_delegation

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT
  • requester_member_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • tone — VARCHAR(20)
  • draft_candidates — JSONB
  • selected_draft_index — SMALLINT
  • selected_draft — TEXT
  • final_message — TEXT
  • recommend_chat_end — BOOLEAN
  • end_reason — VARCHAR(30)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • completed_at — TIMESTAMP

face_analysis

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • profile_image_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • job_id — VARCHAR(100) — Foreign key → ai_job.job_id
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

face_analysis_result

  • id — BIGINT — Primary key — NOT NULL
  • face_analysis_id — BIGINT — Foreign key → face_analysis.id — NOT NULL
  • summary — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

face_compatibility

  • id — BIGINT — Primary key — NOT NULL
  • member_result_id — BIGINT — Foreign key → face_analysis_result.id — NOT NULL
  • target_result_id — BIGINT — Foreign key → face_analysis_result.id — NOT NULL
  • score — DECIMAL(5,2) — NOT NULL
  • detail_report — JSONB
  • created_at — TIMESTAMP — NOT NULL

persona

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • build_session_id — UUID — Foreign key → build_sessions.id — NOT NULL
  • system_prompt — TEXT — NOT NULL
  • personality_summary — JSONB
  • style_source_sha256 — VARCHAR(64)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

persona_trait

  • id — BIGSERIAL — Primary key — NOT NULL
  • persona_id — BIGINT — Foreign key → persona.id — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • label — VARCHAR(20) — NOT NULL
  • observation_count — SMALLINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

persona_trait_extraction

  • id — BIGSERIAL — Primary key — NOT NULL
  • persona_id — BIGINT — Foreign key → persona.id — NOT NULL
  • source_session_id — BIGINT — Foreign key → ai_practice_session.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

photo_verification

  • id — BIGSERIAL — Primary key — NOT NULL
  • profile_image_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • is_frontal — BOOLEAN — NOT NULL
  • confidence — DECIMAL(3,2) — NOT NULL
  • reason_code — VARCHAR(30)
  • reason — TEXT
  • created_at — TIMESTAMP — NOT NULL

saju_analysis

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • birth_date — DATE — NOT NULL
  • birth_time — VARCHAR(20)
  • sex — VARCHAR(10) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • input_snapshot — JSONB
  • job_id — VARCHAR(100) — Foreign key → ai_job.job_id
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

saju_analysis_result

  • id — BIGINT — Primary key — NOT NULL
  • saju_analysis_id — BIGINT — Foreign key → saju_analysis.id — NOT NULL
  • summary — TEXT — NOT NULL
  • detail_result — JSONB
  • created_at — TIMESTAMP — NOT NULL

saju_compatibility

  • id — BIGINT — Primary key — NOT NULL
  • requester_result_id — BIGINT — Foreign key → saju_analysis_result.id — NOT NULL
  • target_result_id — BIGINT — Foreign key → saju_analysis_result.id — NOT NULL
  • score — DECIMAL(5,2) — NOT NULL
  • detail_result — JSONB
  • created_at — TIMESTAMP — NOT NULL