SKT POC
Tables (7)
call_analyze_res (통화분석)
- id — int(11) — Primary key — NOT NULL
- call_id — varchar(20) — NOT NULL
- stt_id — varchar(20)
- prt_id — varchar(20) — NOT NULL
- category — varchar(20)
- parent_category — varchar(20)
- call_report_name — varchar(50)
- claude_check — varchar(100)
- reg_date — varchar(50)
- conversation_content — text
- confirm_list — text
- author — varchar(100)
- sort_no — varchar(100)
category
- id — int(11) — Primary key — NOT NULL
- category — varchar(100)
- parent_category — varchar(100)
claude_data
- prt_id — varchar(100) — Primary key — NOT NULL
- claude_data — text
- input_token — varchar(100)
- output_token — varchar(100)
- time — varchar(100)
claude_link_res (프롬포트)
- prt_id — varchar(20) — Primary key — NOT NULL
- division — varchar(15)
- category — varchar(20)
- parent_category — varchar(20)
- prompt_name — varchar(50)
- prompt_category — varchar(100)
- reg_date — varchar(50)
- prompt — text
- author — varchar(100)
- provider — varchar(100)
- model — varchar(100)
- frequency_penalty — int(11)
- max_token — int(11)
- temperature — int(11)
- presence_penalty — int(11)
manual_res (매뉴얼)
- manual_id — varchar(100) — Primary key — NOT NULL
- prt_id — varchar(20) — NOT NULL
- category — varchar(20)
- parent_category — varchar(20)
- call_category — varchar(100)
- manual_name — varchar(50)
- reg_date — varchar(50)
- manual — text
- flow_chart — text
- author — varchar(100)
menu
- id — int(11) — Primary key — NOT NULL
- parent_category — varchar(100)
- category — varchar(100)
tb_stt_mgmt (STT 리스트)
- stt_id — varchar(20) — Primary key — NOT NULL
- category — varchar(50)
- parent_category — varchar(100)
- call_date — varchar(50)
- counsel_type — varchar(50)
- call_time — varchar(20)
- conversation — text
- author — varchar(20)
- reg_date — varchar(100)