gogo
Tables (24)
Agent (AGNT)
- Agent ID (AGNT_ID) — INT(11) — Primary key — NOT NULL
- Agent Name (AGNT_NM) — VARCHAR(100)
- createdAt (CRT_DT) — DATETIME
- Agent Role (AGNT_ROLE) — VARCHAR(100)
CLASSIFICATION (COTN_CSLF)
- CLASSIFICATION ID (COTN_CSLF_ID) — INT(11) — Primary key — NOT NULL
- CLASSIFICATION Name (CSLF_NM) — VARCHAR(100)
- Parent Id (UP_CSRF_ID) — INT(11)
- Created At (CRT_DT) — DATETIME
- Depth (DPTH) — TINYINT
CONTENT COLLECT POLICY (COTN_CLCT_PLCY)
- POLICY ID (PLCY_ID) — INT — Primary key — NOT NULL
- POLICY TYPE CODE (PLCY_TYPE_CD) — CHAR(6)
- EXCN_DOW_CD_CN — VARCHAR(13)
- EXCN_TM_CN — CHAR(5)
- EXCN_SCHDL_CN
- CRT_DT — DATETIME
- UPD_DT — DATETIME
- Field
Common Code (CMN_CD)
- Code Id (CMN_CD_ID) — int(11) — Primary key — NOT NULL
- Code Name (CD_NM) — VARCHAR(100)
- Use Yes No (USE_YN) — CHAR(1)
- CODE CREATED AT (CRT_DT) — DATETIME
- CODE GROUP NAME (CD_GRP_NM) — VARCHAR(100)
- CODE (CD) — CHAR(3)
Content File (COTN_FILE)
- File ID (COTN_FILE_ID) — INT(11) — Primary key — NOT NULL
- File Name (COTN_FILE_NM) — VARCHAR(100)
- File Size (COTN_FILE_SZ) — FLOAT
- Created At (CRT_DT) — DATETIME
- File Path (COTN_FILE_PATH_NM) — VARCHAR(260)
EVENT CONTENT IMAGE (EVT_IMG)
- File ID (COTN_FILE_ID) — INT(11) — Foreign key → Content File.File ID — NOT NULL
- Key (EVT_COTN_ID) — Foreign key → 이벤트.Key — NOT NULL
- CLASSIFICATION ID (COTN_CSLF_ID) — INT(11) — Foreign key → 이벤트.CLASSIFICATION ID — NOT NULL
LLM CALL (LLM_CLOT)
- Call ID (LLM_CLOT_ID) — INT(11) — Primary key — NOT NULL
- Agent ID (AGNT_ID) — INT(11) — Foreign key → Agent.Agent ID — NOT NULL
- Prompt ID (LLM_PRMPT_ID) — INT(11) — Foreign key → Prompt.Prompt ID — NOT NULL
- Param ID (LLM_PARAM_ID) — INT(11) — Foreign key → LLM parameter.Param ID — NOT NULL
- Model ID (LLM_MDL_ID) — INT(11) — Foreign key → LLM model.Model ID — NOT NULL
- CLOT CREATED (CRT_DT) — DATETIME
- LLM_TYPE_CD — CHAR(6)
LLM LIIMIT FEE (LLM_LMT_AMT)
- Key — Primary key — NOT NULL
- Field
- Field2
LLM log (LLM_HSTRY)
- LLM log ID (LLM_HSTRY_ID) — INT(11) — Primary key — NOT NULL
- Call ID (LLM_CLOT_ID) — INT(11) — Foreign key → LLM CALL.Call ID — NOT NULL
- Response time (RSPNS_TM_SEC) — DECIMAL(10,2)
- Created At (CRT_DT) — DATETIME
- Success to response (RSPNS_SCS_YN) — CHAR(1)
- Query (QRY_CN) — varchar(4000)
- Answer (ANSR_CN) — varchar(4000)
- User ID (HSTRY_USR_ID) — varchar(100)
- TOKEN USAGE INPUST (INPT_TK_QTY) — INT(11)
- TOKEN USAGE OUTPUT (OTPT_TK_QTY) — INT(11)
- INPUT COST (INPT_TK_AMT) — DECIMAL(10,6)
- OUTPUT COST (OTPT_TK_AMT) — DECIMAL(10,6)
- TOTAL COST (TOT_TK_AMT) — DECIMAL(10,6)
LLM model (LLM_MDL)
- Model ID (LLM_MDL_ID) — INT(11) — Primary key — NOT NULL
- Model Name (MDL_NM) — VARCHAR(100)
- Created at (CRT_DT) — DATETIME
LLM parameter (LLM_PARAM)
- Param ID (LLM_PARAM_ID) — INT(11) — Primary key — NOT NULL
- Temperature (TEMP) — FLOAT
- Top_p (TOP_P) — FLOAT
- Top_k (TOP_K) — FL,OAT
- Thinking Mode (THNK_TYPE) — VARCHAR(4)
- Ai_Filter (AI_FILT_YN) — CHAR(1)
- Max Tokens (M_TK_QTY) — INT(11)
- Repetition Penalty (REP_PNTY) — FLOAT
- Created_at (CRT_DT) — DATETIME
MANUAL CLCT EXECUTION HISTROY (Untitled)
MANUAL FILE HISTORY (MNL_FILE_HSTRY)
- HSTRY ID (MNL_FILE_HSTRY_ID) — INT(11) — Primary key — NOT NULL
- Manual ID (MNL_COTN_ID) — INT(11) — Foreign key → Manual.Manual ID — NOT NULL
- File ID (COTN_FILE_ID) — INT(11) — Foreign key → Content File.File ID — NOT NULL
- CLASSIFICATION ID (COTN_CSLF_ID) — INT(11) — Foreign key → Manual.CLASSIFICATION ID — NOT NULL
- HISTORY CREATED AT (CRT_DT) — DATETIME
- VERSION NO (FILE_VER_NO) — INT(11)
- Created Datetime (Field)
Manual (MNL_COTN)
- Manual ID (MNL_COTN_ID) — INT(11) — Primary key — NOT NULL
- CLASSIFICATION ID (COTN_CSLF_ID) — INT(11) — Foreign key → CLASSIFICATION.CLASSIFICATION ID — NOT NULL
- Manual Name (MNL_COTN_NM) — VARCHAR(100)
- Created At (CRT_DT) — DATETIME
- Udated At (UPD_DT) — DATETIME
Prompt (LLM_PRMPT)
- Prompt ID (LLM_PRMPT_ID) — INT(11) — Primary key — NOT NULL
- Prompt Content (PRMPT_CN) — LONGTEXT
- Created At (CRT_DT) — DATETIME
- Prompt Expailn (PRMPT_EXPLN) — VARCHAR(4000)
Rag Log (RAG_HSTRY)
- RAG HSTRY ID (RAG_HSTRY_ID) — INT(11) — Primary key — NOT NULL
- LLM log ID (LLM_HSTRY_ID) — INT(11) — Foreign key → LLM log.LLM log ID — NOT NULL
- Content Type (COTN_TYPE) — CHAR(3)
- CONTENT ID (COTN_ID) — INT(11)
- HISTORY CREATED (CRT_DT) — DATETIME
SYSTEM CHANGE HISTORY (SYSTEM_CHG_HSTRY)
- Key — Primary key — NOT NULL
- Field
- Field2
WEB FILE HISTORY (WEB_FILE_HSTRY)
- HSTRY ID (WEB_FILE_HSTRY_ID) — INT(11) — Primary key — NOT NULL
- VERSION NO (FILE_VER_NO) — INT(11)
- HSTORY CREATED AT (CRT_DT) — DATETIME
- Field
Web Content (WEB_COTN)
- Web ID (WEB_COTN_ID) — INT(11) — Primary key — NOT NULL
- Site Id (SITE_ID) — VARCHAR(100) — Foreign key → web site list.Site Id — NOT NULL
- Title (SRC_KEY) — VARCHAR(100)
- Content (BBS_CN) — VARCHAR(4000)
- web content created at (CRT_DT) — DATETIME
- web content updated at (UPD_DT) — DATETIME
- BBS_ID — VARCHAR(100)
web collect err log (WEB_SITE_CLCT_ERR_HSTRY)
- ERR (ERR_ID) — Primary key — NOT NULL
- EXCN (EXCN_ID) — Foreign key → web collect execution log.EXCN — NOT NULL
- Site Id (SITE_ID) — Foreign key → web collect execution log.Site Id — NOT NULL
- STATUS CODE (ERR_CD_NM)
web collect execution log (WEB_SITE_CLCT_EXCN_HSTRY)
- EXCN (EXCN_ID) — Primary key — NOT NULL
- Site Id (SITE_ID) — Foreign key → web site list.Site Id — NOT NULL
- 전체건수 (Field)
- 성공건 (Field2)
- 실패건 (Field3)
- 소요시간 (Field4)
- 시작시간 (Field5)
- 끝난시간 (Field6)
web site list (WEB_SITE_CLCT)
- Site Id (SITE_ID) — Primary key — NOT NULL
- Site Name (SITE_NM)
- URL Address (URL_ADDR)
- WEB TYPE CODE (WEB_TYPE_CD)
- CREATED AT (CRT_DT)
민원 DB 연동 (GOYANG_MANUAL)
- Manual ID (MNL_COTN_ID) — INT(11) — Foreign key → Manual.Manual ID — NOT NULL
- CLASSIFICATION ID (COTN_CSLF_ID) — INT(11) — Foreign key → Manual.CLASSIFICATION ID — NOT NULL
- 고양 RDB에 있는 ID 값 (Field)
- DB VERSION NUMBER (DB_VER_NO) — INT(11)
- CREATED AT (CRT_DT) — DATETIME
이벤트 (EVT_COTN)
- Key (EVT_COTN_ID) — Primary key — NOT NULL
- CLASSIFICATION ID (COTN_CSLF_ID) — INT(11) — Foreign key → CLASSIFICATION.CLASSIFICATION ID — NOT NULL
- Field
- Field2