Bt_Prom_Mng_Ver_Rls
Tables (9)
PROMPT_CATEGORY (프롬프트 분류(고객 지원, 코드 리뷰 등등))
- SYS_ID — VARCHAR(36) — NOT NULL
- CATEGORY_CD ("CUSTOMER SUPPORT") — VARCHAR(50) — NOT NULL
- CATEGORY_NM_KO ("고객지원", "문서작성" 등) — VARCHAR(100) — NOT NULL
- CATEGORY_NM_EN — VARCHAR(100)
- CATEGORY_DESC — VARCHAR(500)
- PARENT_CATEGORY_ID — VARCHAR(36) — Foreign key → PROMPT_CATEGORY.SYS_ID
- SORT_ORDER — INT
- ICON_NM — VARCHAR(50)
- COLOR_CD — VARCHAR(20)
- SYS_CRT_BY — VARCHAR(50) — NOT NULL
- SYS_CRT_DTTM — DATETIME — NOT NULL
- SYS_MDF_BY — VARCHAR(50)
- SYS_MDF_DTTM — DATETIME
- SYS_ACTV_FLG — CHAR(1)
- TNT_REL_RID — VARCHAR(36) — NOT NULL
PROMPT_MASTER (프롬프트 기본 정보(이름, 설명, 상태))
- SYS_ID — VARCHAR(36) — NOT NULL
- PROMPT_CD — VARCHAR(100) — NOT NULL
- PROMPT_NM ("Customer Support Agent") — VARCHAR(200) — NOT NULL
- PROMPT_DESC ("고객 지원 챗봇 시스템 프롬프트") — VARCHAR(1000)
- CATEGORY_ID — VARCHAR(36) — Foreign key → PROMPT_CATEGORY.SYS_ID
- STATUS_CD ("ACTIVE") — VARCHAR(20) — NOT NULL
- IS_FEATURED — CHAR(1)
- IS_SHARED — CHAR(1)
- CURRENT_VERSION_ID — VARCHAR(36) — Foreign key → PROMPT_VERSION.SYS_ID
- CURRENT_VERSION_NO ("v2.1") — VARCHAR(20)
- USAGE_CNT (12400) — BIGINT
- OWNER_USER_ID — VARCHAR(36)
- OWNER_TEAM_ID — VARCHAR(36)
- SYS_CRT_BY — VARCHAR(50) — NOT NULL
- SYS_CRT_DTTM — DATETIME — NOT NULL
- SYS_MDF_BY — VARCHAR(50)
- SYS_MDF_DTTM — DATETIME
- SYS_ACTV_FLG — CHAR(1)
- TNT_REL_RID — VARCHAR(36) — NOT NULL
PROMPT_RELEASE (어떤 버전이 어떤 환경에 배포됐는지)
- SYS_ID — VARCHAR(36) — NOT NULL
- PROMPT_ID — VARCHAR(36) — Foreign key → PROMPT_MASTER.SYS_ID — NOT NULL
- VERSION_ID — VARCHAR(36) — Foreign key → PROMPT_VERSION.SYS_ID — NOT NULL
- ENV_ID — VARCHAR(36) — Foreign key → RELEASE_ENVIRONMENT.SYS_ID — NOT NULL
- RELEASE_STATUS_CD ("ACTIVE") — VARCHAR(20) — NOT NULL
- RELEASED_BY — VARCHAR(50)
- RELEASED_DTTM — DATETIME
- ROLLBACK_VERSION_ID — VARCHAR(36)
- ROLLBACK_BY — VARCHAR(50)
- ROLLBACK_DTTM — DATETIME
- ROLLBACK_REASON — VARCHAR(500)
- RELEASE_TAG ("stable") — VARCHAR(50)
- SYS_CRT_BY — VARCHAR(50) — NOT NULL
- SYS_CRT_DTTM — DATETIME — NOT NULL
- SYS_MDF_BY — VARCHAR(50)
- SYS_MDF_DTTM — DATETIME
- SYS_ACTV_FLG — CHAR(1)
- TNT_REL_RID — VARCHAR(36) — NOT NULL
PROMPT_RELEASE_HISTORY (배포 이력 (감사 로그))
- SYS_ID — VARCHAR(36) — NOT NULL
- RELEASE_ID — VARCHAR(36) — Foreign key → PROMPT_RELEASE.SYS_ID — NOT NULL
- PROMPT_ID — VARCHAR(36) — Foreign key → PROMPT_MASTER.SYS_ID — NOT NULL
- VERSION_ID — VARCHAR(36) — Foreign key → PROMPT_VERSION.SYS_ID — NOT NULL
- ENV_ID — VARCHAR(36) — Foreign key → RELEASE_ENVIRONMENT.SYS_ID — NOT NULL
- ACTION_CD ("DEPLOY") — VARCHAR(20) — NOT NULL
- ACTION_DESC ("v2.4.0을 Development에 배포") — VARCHAR(500)
- PREV_VERSION_ID — VARCHAR(36)
- ACTION_BY ("admin") — VARCHAR(50) — NOT NULL
- ACTION_DTTM — DATETIME — NOT NULL
- SYS_CRT_BY — VARCHAR(50) — NOT NULL
- SYS_CRT_DTTM — DATETIME — NOT NULL
- SYS_MDF_BY — VARCHAR(50)
- SYS_MDF_DTTM — DATETIME
- SYS_ACTV_FLG — CHAR(1)
- TNT_REL_RID — VARCHAR(36) — NOT NULL
PROMPT_SHARE (팀 공유 설정)
- SYS_ID — VARCHAR(36) — NOT NULL
- PROMPT_ID — VARCHAR(36) — Foreign key → PROMPT_MASTER.SYS_ID — NOT NULL
- SHARE_TYPE_CD ("TEAM") — VARCHAR(20) — NOT NULL
- SHARE_TARGET_ID ("dev-team-uuid") — VARCHAR(36)
- PERMISSION_CD ("USE" (사용만 가능, 수정은 불가)) — VARCHAR(20) — NOT NULL
- SHARED_BY — VARCHAR(50) — NOT NULL
- SHARED_DTTM — DATETIME — NOT NULL
- EXPIRES_DTTM — DATETIME
- SYS_CRT_BY — VARCHAR(50) — NOT NULL
- SYS_CRT_DTTM — DATETIME — NOT NULL
- SYS_MDF_BY — VARCHAR(50)
- SYS_MDF_DTTM — DATETIME
- SYS_ACTV_FLG — CHAR(1)
- TNT_REL_RID — VARCHAR(36) — NOT NULL
PROMPT_USAGE_STATS (사용량 통계 (12.4K 같은 숫자))
- SYS_ID — VARCHAR(36) — NOT NULL
- PROMPT_ID — VARCHAR(36) — Foreign key → PROMPT_MASTER.SYS_ID — NOT NULL
- VERSION_ID — VARCHAR(36) — Foreign key → PROMPT_VERSION.SYS_ID
- STATS_DATE ("2026-01-19") — DATE — NOT NULL
- CALL_CNT (1250) — BIGINT
- SUCCESS_CNT — BIGINT
- FAIL_CNT — BIGINT
- TOTAL_INPUT_TOKENS (125000) — BIGINT
- TOTAL_OUTPUT_TOKENS — BIGINT
- TOTAL_COST (TOTAL_COST: 0.0125) — DECIMAL(15,6)
- AVG_RESPONSE_TIME — DECIMAL(10,2)
- MAX_RESPONSE_TIME — DECIMAL(10,2)
- MIN_RESPONSE_TIME — DECIMAL(10,2)
- SYS_CRT_BY — VARCHAR(50) — NOT NULL
- SYS_CRT_DTTM — DATETIME — NOT NULL
- SYS_MDF_BY — VARCHAR(50)
- SYS_MDF_DTTM — DATETIME
- SYS_ACTV_FLG — CHAR(1)
- TNT_REL_RID — VARCHAR(36) — NOT NULL
PROMPT_VERSION (버전별 프롬프트 내용)
- SYS_ID — VARCHAR(36) — NOT NULL
- PROMPT_ID — VARCHAR(36) — Foreign key → PROMPT_MASTER.SYS_ID — NOT NULL
- VERSION_NO ("v2.4.0") — VARCHAR(20) — NOT NULL
- VERSION_MAJOR (2) — INT — NOT NULL
- VERSION_MINOR (4) — INT — NOT NULL
- VERSION_PATCH (0) — INT
- SYSTEM_PROMPT (너는 친절한 고객 상담사야" (역할 정의)) — TEXT
- USER_PROMPT_TMPL ("고객이 {{question}}라고 물었어" (사용자 질문)) — TEXT
- ASSISTANT_PROMPT ("네, 답변드리겠습니다..." (AI 응답 시작 유도)) — TEXT
- VERSION_DESC (버전 설명) — VARCHAR(500)
- COMMIT_ID — VARCHAR(50)
- STATUS_CD — VARCHAR(20) — NOT NULL
- IS_CURRENT ("Y") — CHAR(1)
- MODEL_ID — VARCHAR(36)
- TEMPERATURE — DECIMAL(3,2)
- MAX_TOKENS — INT
- TOP_P — DECIMAL(3,2)
- RESPONSE_FORMAT_ID — VARCHAR(36)
- SYS_CRT_BY — VARCHAR(50) — NOT NULL
- SYS_CRT_DTTM — DATETIME — NOT NULL
- SYS_MDF_BY — VARCHAR(50)
- SYS_MDF_DTTM — DATETIME
- SYS_ACTV_FLG — CHAR(1)
- TNT_REL_RID — VARCHAR(36) — NOT NULL
PROMPT_VERSION_CHANGE (버전별 변경사항 (CHANGES 목록))
- SYS_ID — VARCHAR(36) — NOT NULL
- VERSION_ID ("v2.4.0의 UUID") — VARCHAR(36) — Foreign key → PROMPT_VERSION.SYS_ID — NOT NULL
- CHANGE_TYPE_CD ("ADD") — VARCHAR(20) — NOT NULL
- CHANGE_DESC ("멀티턴 대화 컨텍스트 처리") — VARCHAR(500) — NOT NULL
- SORT_ORDER (1) — INT
- SYS_CRT_BY — VARCHAR(50) — NOT NULL
- SYS_CRT_DTTM — DATETIME — NOT NULL
- SYS_MDF_BY — VARCHAR(50)
- SYS_MDF_DTTM — DATETIME
- SYS_ACTV_FLG — CHAR(1)
- TNT_REL_RID — VARCHAR(36) — NOT NULL
RELEASE_ENVIRONMENT (배포 환경 정의( Dev / Staging / Prod))
- SYS_ID — VARCHAR(36) — NOT NULL
- ENV_CD ("DEV") — VARCHAR(50) — NOT NULL
- ENV_NM_KO ("개발") — VARCHAR(100) — NOT NULL
- ENV_NM_EN — VARCHAR(100) — NOT NULL
- ENV_DESC — VARCHAR(500)
- SORT_ORDER (1) — INT
- IS_PROTECTED — CHAR(1)
- APPROVAL_REQUIRED — CHAR(1)
- SYS_CRT_BY — VARCHAR(50) — NOT NULL
- SYS_CRT_DTTM — DATETIME — NOT NULL
- SYS_MDF_BY — VARCHAR(50)
- SYS_MDF_DTTM — DATETIME
- SYS_ACTV_FLG — CHAR(1)
- TNT_REL_RID — VARCHAR(36) — NOT NULL