df
Tables (10)
batch_job_log
- job_id — SERIAL
- conv_id — INT — NOT NULL
- conv_end_dt — TIMESTAMPTZ — NOT NULL
- job_type — VARCHAR(20)
- status — VARCHAR(10)
- retry_count — INT
- err_msg — TEXT
- container_id — VARCHAR(50)
- started_at — TIMESTAMPTZ
- last_modified_dt — TIMESTAMPTZ
conv_detail (consult_detail)
- conv_id — INT — Foreign key → conv_master.conv_id
- conv_context — JSONB
- result_data — JSONB
- summary_content — TEXT
conv_master (consult_master)
- conv_id — INT — Primary key
- user_uid — VARCHAR(20) — NOT NULL
- user_name — VARCHAR(10)
- user_grade — VARCHAR(10)
- last_conv_summary — TEXT
- season_keywords — VARCHAR(255)
- reward_cd — VARCHAR(20)
- reward_nm — VARCHAR(100)
- reward_yyyymm — VARCHAR(6)
- reward_item_cd — VARCHAR(20)
- reward_cup_cnt — INT
- phrase_cd — VARCHAR(20)
- gosa_hanja_ctt — VARCHAR(100)
- gosa_huneum_ctt — TEXT
- gosa_mean_ctt — TEXT
- eng_phrs_ctt — TEXT
- scenario_type — VARCHAR(10)
- conv_type — VARCHAR(5)
detail_code
- group_code — VARCHAR(50)
- code_value — VARCHAR(50)
- code_name — VARCHAR(100)
- is_use — BOOLEAN
- created_at — TIMESTAMPTZ
group_code
- group_code — VARCHAR(50)
- group_name — VARCHAR(100)
- description — TEXT
- is_use — BOOLEAN
- created_at — TIMESTAMPTZ
learning_stats
- conv_id — INT — Foreign key → conv_master.conv_id
- att_total — INT
- att_done — INT
- lrn_total — INT
- lrn_done — INT
- score — INT
- ko_done — INT
- ko_per — INT
- math_done — INT
- math_per — INT
- eng_done — INT
- eng_per — INT
- sci_done — INT
- sci_per — INT
- soc_done — INT
- soc_per — INT
- award_1st_dt — TIMESTAMPTZ
- award_2st_dt — TIMESTAMPTZ
- award_3st_dt — TIMESTAMPTZ
- strong_subject — VARCHAR(10)
- weak_subject — VARCHAR(10)
monthly_keyword
- month — VARCHAR
- keyword — TEXT
- keyword_order — INT
scenario_manage
- scenario_id — VARCHAR(50)
- myhome_ctt — TEXT
- has_prev_month_history — INT
- has_prev_2month_history — INT
- ctt — TEXT
- is_ot — INT
- delete_yn — VARCHAR(10)
- version — VARCHAR(10)
step_detail
- step_pk — BIGINT
- conv_id — VARCHAR(50)
- scenario_no — INT
- step_id — VARCHAR(50)
- transition — JSONB
- duration — INT
- duration_mode — VARCHAR(20)
user_conv_history
- user_id — VARCHAR(30)
- last_conv_id — INT
- conv_count — INT
- conv_id_ot — INT
- upd_dt — TIMESTAMPTZ
- conv_id (conv_id2) — INT — Foreign key → conv_master.conv_id