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