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