edr-erd

테이블 (18)

EDR이벤트

  • edr_event_id — BIGINT — 기본 키 — NOT NULL
  • ingest_batch_id — BIGINT — 외래 키 → 수집배치.ingest_batch_id
  • endpoint_id — BIGINT — 외래 키 → 엔드포인트.endpoint_id — NOT NULL
  • event_id — UUID — NOT NULL
  • batch_id — UUID
  • agent_id — VARCHAR(64) — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • occurred_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • ingested_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • process_name — VARCHAR(255)
  • process_path — VARCHAR(1024)
  • pid — INTEGER
  • ppid — INTEGER
  • command_line — TEXT
  • user_name — VARCHAR(255)
  • file_path — VARCHAR(1024)
  • file_action — VARCHAR(30)
  • file_hash_sha256 — CHAR(64)
  • remote_ip — INET
  • remote_domain — VARCHAR(255)
  • remote_port — INTEGER
  • protocol — VARCHAR(30)
  • raw_payload — JSONB — NOT NULL
  • schema_version — INTEGER — NOT NULL
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_delete — BOOLEAN — NOT NULL

agent_auth_keys

  • agent_auth_key_id — BIGINT — 기본 키 — NOT NULL
  • endpoint_id — BIGINT — 외래 키 → endpoints.endpoint_id — NOT NULL — 엔드포인트ID
  • token_hash — VARCHAR(255) — NOT NULL — 토큰해시
  • cert_fingerprint — VARCHAR(128) — 인증서지문
  • issued_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 발급일시
  • expires_at — TIMESTAMP WITH TIME ZONE — 만료일시
  • revoked_at — TIMESTAMP WITH TIME ZONE — 폐기일시
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 생성일시
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 수정일시
  • is_delete — BOOLEAN — NOT NULL — 삭제여부

alerts

  • alert_id — BIGINT — 기본 키 — NOT NULL
  • endpoint_id — BIGINT — 외래 키 → endpoints.endpoint_id — NOT NULL — 엔드포인트ID
  • ingest_batch_id — BIGINT — 외래 키 → ingest_batches.ingest_batch_id — 수집배치ID
  • edr_event_id — BIGINT — 외래 키 → edr_events.edr_event_id — NOT NULL — EDR이벤트ID
  • rule_code — VARCHAR(100) — NOT NULL — 룰코드
  • rule_name — VARCHAR(200) — NOT NULL — 룰명
  • rule_version — INTEGER — NOT NULL — 룰버전
  • mitre_tactic_code — VARCHAR(20) — MITRE전술코드
  • mitre_tactic_name — VARCHAR(100) — MITRE전술명
  • mitre_technique_code — VARCHAR(30) — MITRE기법코드
  • mitre_technique_name — VARCHAR(200) — MITRE기법명
  • title — VARCHAR(200) — NOT NULL — 경보제목
  • summary — TEXT — NOT NULL — 경보요약
  • severity — VARCHAR(20) — NOT NULL — 심각도
  • risk_score — NUMERIC(5,2) — NOT NULL — 위험점수
  • status — VARCHAR(30) — NOT NULL — 경보상태
  • assigned_user_id — BIGINT — 외래 키 → users.user_id — 담당사용자ID
  • detected_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 탐지일시
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 생성일시
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 수정일시
  • is_delete — BOOLEAN — NOT NULL — 삭제여부

edr_events

  • edr_event_id — BIGINT — 기본 키 — NOT NULL
  • ingest_batch_id — BIGINT — 외래 키 → ingest_batches.ingest_batch_id — 수집배치ID
  • endpoint_id — BIGINT — 외래 키 → endpoints.endpoint_id — NOT NULL — 엔드포인트ID
  • event_id — UUID — NOT NULL — 이벤트ID
  • batch_id — UUID — 배치ID
  • agent_id — VARCHAR(64) — NOT NULL — 에이전트ID
  • event_type — VARCHAR(50) — NOT NULL — 이벤트유형
  • occurred_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 발생일시
  • ingested_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 적재일시
  • process_name — VARCHAR(255) — 프로세스명
  • process_path — VARCHAR(1024) — 프로세스경로
  • pid — INTEGER — 프로세스ID
  • ppid — INTEGER — 부모프로세스ID
  • command_line — TEXT — 명령줄
  • user_name — VARCHAR(255) — 실행사용자
  • file_path — VARCHAR(1024) — 파일경로
  • file_action — VARCHAR(30) — 파일행위
  • file_hash_sha256 — CHAR(64) — 파일SHA256해시
  • remote_ip — INET — 원격IP
  • remote_domain — VARCHAR(255) — 원격도메인
  • remote_port — INTEGER — 원격포트
  • protocol — VARCHAR(30) — 프로토콜
  • raw_payload — JSONB — NOT NULL — 원본페이로드JSON
  • schema_version — INTEGER — NOT NULL — 스키마버전
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 생성일시
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 수정일시
  • is_delete — BOOLEAN — NOT NULL — 삭제여부

endpoints

  • endpoint_id — BIGINT — 기본 키 — NOT NULL
  • agent_id — VARCHAR(64) — NOT NULL — 에이전트ID
  • hostname — VARCHAR(255) — NOT NULL — 호스트명
  • os_type — VARCHAR(30) — NOT NULL — 운영체제유형
  • os_version — VARCHAR(100) — 운영체제버전
  • ip_address — INET — IP주소
  • agent_version — VARCHAR(50) — 에이전트버전
  • status — VARCHAR(30) — NOT NULL — 엔드포인트상태
  • last_seen_at — TIMESTAMP WITH TIME ZONE — 마지막수신일시
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 생성일시
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 수정일시
  • is_delete — BOOLEAN — NOT NULL — 삭제여부

incident_alerts

  • incident_alert_id — BIGINT — 기본 키 — NOT NULL
  • incident_id — BIGINT — 외래 키 → incidents.incident_id — NOT NULL — 인시던트ID
  • alert_id — BIGINT — 외래 키 → alerts.alert_id — NOT NULL — 경보ID
  • linked_by_user_id — BIGINT — 외래 키 → users.user_id — 연결사용자ID
  • linked_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 연결일시
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 생성일시
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 수정일시
  • is_delete — BOOLEAN — NOT NULL — 삭제여부

incidents

  • incident_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(200) — NOT NULL — 인시던트제목
  • description — TEXT — 인시던트설명
  • severity — VARCHAR(20) — NOT NULL — 대표심각도
  • status — VARCHAR(30) — NOT NULL — 인시던트상태
  • owner_user_id — BIGINT — 외래 키 → users.user_id — 담당사용자ID
  • closed_at — TIMESTAMP WITH TIME ZONE — 종료일시
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 생성일시
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 수정일시
  • is_delete — BOOLEAN — NOT NULL — 삭제여부

ingest_batches

  • ingest_batch_id — BIGINT — 기본 키 — NOT NULL
  • endpoint_id — BIGINT — 외래 키 → endpoints.endpoint_id — NOT NULL — 엔드포인트ID
  • batch_id — UUID — NOT NULL — 배치ID
  • agent_batch_sequence — BIGINT — 에이전트배치순번
  • event_count — INTEGER — NOT NULL — 전체이벤트수
  • accepted_event_count — INTEGER — NOT NULL — 수락이벤트수
  • rejected_event_count — INTEGER — NOT NULL — 거절이벤트수
  • status — VARCHAR(30) — NOT NULL — 배치처리상태
  • kafka_topic — VARCHAR(100) — NOT NULL — 카프카토픽
  • kafka_metadata_json — JSONB — 카프카메타데이터JSON
  • received_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 수신일시
  • published_at — TIMESTAMP WITH TIME ZONE — 발행일시
  • error_message — TEXT — 오류메시지
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 생성일시
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 수정일시
  • is_delete — BOOLEAN — NOT NULL — 삭제여부

local_event_buffer

  • local_event_buffer_id — BIGINT — 기본 키 — NOT NULL
  • endpoint_id — BIGINT — 외래 키 → endpoints.endpoint_id — 엔드포인트ID
  • event_id — UUID — NOT NULL — 이벤트ID
  • batch_id — UUID — 배치ID
  • event_type — VARCHAR(50) — NOT NULL — 이벤트유형
  • payload_json — JSONB — NOT NULL — 이벤트원문JSON
  • collected_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 수집일시
  • status — VARCHAR(30) — NOT NULL — 전송상태
  • retry_count — INTEGER — NOT NULL — 재시도횟수
  • last_error — TEXT — 마지막오류
  • next_retry_at — TIMESTAMP WITH TIME ZONE — 다음재시도일시
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 생성일시
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 수정일시
  • is_delete — BOOLEAN — NOT NULL — 삭제여부

users

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL — 이메일
  • password_hash — VARCHAR(255) — NOT NULL — 비밀번호해시
  • name — VARCHAR(100) — NOT NULL — 사용자명
  • role — VARCHAR(30) — NOT NULL — 사용자권한
  • status — VARCHAR(30) — NOT NULL — 계정상태
  • last_login_at — TIMESTAMP WITH TIME ZONE — 최근로그인일시
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 생성일시
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL — 수정일시
  • is_delete — BOOLEAN — NOT NULL — 삭제여부

경보

  • alert_id — BIGINT — 기본 키 — NOT NULL
  • endpoint_id — BIGINT — 외래 키 → 엔드포인트.endpoint_id — NOT NULL
  • ingest_batch_id — BIGINT — 외래 키 → 수집배치.ingest_batch_id
  • edr_event_id — BIGINT — 외래 키 → EDR이벤트.edr_event_id — NOT NULL
  • rule_code — VARCHAR(100) — NOT NULL
  • rule_name — VARCHAR(200) — NOT NULL
  • rule_version — INTEGER — NOT NULL
  • mitre_tactic_code — VARCHAR(20)
  • mitre_tactic_name — VARCHAR(100)
  • mitre_technique_code — VARCHAR(30)
  • mitre_technique_name — VARCHAR(200)
  • title — VARCHAR(200) — NOT NULL
  • summary — TEXT — NOT NULL
  • severity — VARCHAR(20) — NOT NULL
  • risk_score — NUMERIC(5,2) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • assigned_user_id — BIGINT — 외래 키 → 사용자.user_id
  • detected_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_delete — BOOLEAN — NOT NULL

로컬이벤트버퍼

  • local_event_buffer_id — BIGINT — 기본 키 — NOT NULL
  • endpoint_id — BIGINT — 외래 키 → 엔드포인트.endpoint_id
  • event_id — UUID — NOT NULL
  • batch_id — UUID
  • event_type — VARCHAR(50) — NOT NULL
  • payload_json — JSONB — NOT NULL
  • collected_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • retry_count — INTEGER — NOT NULL
  • last_error — TEXT
  • next_retry_at — TIMESTAMP WITH TIME ZONE
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_delete — BOOLEAN — NOT NULL

사용자

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • last_login_at — TIMESTAMP WITH TIME ZONE
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_delete — BOOLEAN — NOT NULL

수집배치

  • ingest_batch_id — BIGINT — 기본 키 — NOT NULL
  • endpoint_id — BIGINT — 외래 키 → 엔드포인트.endpoint_id — NOT NULL
  • batch_id — UUID — NOT NULL
  • agent_batch_sequence — BIGINT
  • event_count — INTEGER — NOT NULL
  • accepted_event_count — INTEGER — NOT NULL
  • rejected_event_count — INTEGER — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • kafka_topic — VARCHAR(100) — NOT NULL
  • kafka_metadata_json — JSONB
  • received_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • published_at — TIMESTAMP WITH TIME ZONE
  • error_message — TEXT
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_delete — BOOLEAN — NOT NULL

에이전트인증키

  • agent_auth_key_id — BIGINT — 기본 키 — NOT NULL
  • endpoint_id — BIGINT — 외래 키 → 엔드포인트.endpoint_id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • cert_fingerprint — VARCHAR(128)
  • issued_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • expires_at — TIMESTAMP WITH TIME ZONE
  • revoked_at — TIMESTAMP WITH TIME ZONE
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_delete — BOOLEAN — NOT NULL

엔드포인트

  • endpoint_id — BIGINT — 기본 키 — NOT NULL
  • agent_id — VARCHAR(64) — NOT NULL
  • hostname — VARCHAR(255) — NOT NULL
  • os_type — VARCHAR(30) — NOT NULL
  • os_version — VARCHAR(100)
  • ip_address — INET
  • agent_version — VARCHAR(50)
  • status — VARCHAR(30) — NOT NULL
  • last_seen_at — TIMESTAMP WITH TIME ZONE
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_delete — BOOLEAN — NOT NULL

인시던트

  • incident_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • severity — VARCHAR(20) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • owner_user_id — BIGINT — 외래 키 → 사용자.user_id
  • closed_at — TIMESTAMP WITH TIME ZONE
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_delete — BOOLEAN — NOT NULL

인시던트경보

  • incident_alert_id — BIGINT — 기본 키 — NOT NULL
  • incident_id — BIGINT — 외래 키 → 인시던트.incident_id — NOT NULL
  • alert_id — BIGINT — 외래 키 → 경보.alert_id — NOT NULL
  • linked_by_user_id — BIGINT — 외래 키 → 사용자.user_id
  • linked_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_delete — BOOLEAN — NOT NULL