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