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