KSOX
Tables (4)
assessment_log (평가 로그)
- Id — int4 — Primary key — NOT NULL
- session_key (세션키) — varchar(100)
- status (상태) — varchar(20)
- llm_model_name (LLM 모델 명) — varchar(50)
- assessment_type (평가 유형) — varchar(50)
- pre_assessment_prompt (사전평가프롬프트) — text
- pre_assessment_summary_prompt (사전평가요약프롬프트) — text
- data_extraction_prompt (데이터 추출 프롬프트) — text
- attribute_assessment_prompts (요소 별 평가 프롬프트) — jsonb
- conclusion_prompt (결과 프롬프트) — text
- summary_prompt (종합 요약 결과 프롬프트) — text
- pre_assessment_input_message (?) — text
- pre_assessment_summary_input_message (??) — text
- data_extraction_input_message (???) — text
- attribute_assessment_input_messages (????) — jsonb
- conclusion_input_message (?????) — text
- summary_input_message (??????) — text
- pre_assessment_summary_result (사전 평가 결과) — text
- summary_result (종합 요약 결과) — text
- control_element_id (통제 요소) — int4
- created_at (생성일) — timestamp
- created_by_id (생성자) — text
control_element (통제요소)
- id — int4 — Primary key — NOT NULL
- control_element_key (통제요소 키값) — varchar(100)
- cycle (통제 대분류) — text
- process (과정) — text
- subprocess (서브과정) — text
- control_code (통제코드) — text
- control_name (통제명) — text
- control_description (통제설명) — text
- risk_description (위험요소) — text
- control_type (통제구분) — varchar(100)
- control_cycle (통제 주기) — varchar(100)
- status (상태)
- population (모집단 정보) — varchar(100)
- test_attributes (Field12) — text
- required_evidences (Field13) — text
- test_attributes_converted (변환된 검사 요소) — text
- required_evidences_converted (변환된 필요 증빙) — text
- similar_controls (유사통제 정보) — text
- test_attributes (통제 요소) — jsonb
- rcm_id (RCM) — int4
- created_at (생성시각) — timestamp
- updated_at (수정시각) — imestamp
- owner (소유자) — int4
custom_user (사용자)
- id — int4 — Primary key — NOT NULL
- employee_number (UserCode) — varchar(255)
- username (이름) — varchar(30)
- department (부서) — varchar(30)
- email (이메일) — varchar(30)
- password (비밀번호) — text
- is_staff (스태프) — bool
- is_superuser (관리자) — bool
- is_activate (활성여부) — bool
- date_joind (가입일) — timestamp
- last_login (마지막 로그인시간) — timestamp
- engagement_team_id (ETcode) — int4
engagement_team (ETCode)
- Id — int4 — Primary key — NOT NULL
- client_name (이름) — varchar(100)
- client_code (UserCode) — varchar(20)
- client_description (설명) — text
- created_at (생성시간) — timestamp
- updated_at (수정시간) — timestamp