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