3-3 최신으로
테이블 (22)
audit_boot_log
- logid — VARCHAR
- timestamp — DATETIME
- status — VARCHAR
- service — VARCHAR
- message — TEXT
audit_conman
- logid — INT
- timestamp — DATETIME
- host — VARCHAR
- service — VARCHAR
- processid — INT
- level — VARCHAR
- message — VARCHAR
- clientip — VARCHAR
audit_cron
- logid — INT
- timestamp — INT
- host — DATETIME
- processname — VARCHAR
- processid — VARCHAR
- user — INT
- command — VARCHAR
audit_dmseg
- logid — INT
- timestamp — DATETIME
- kernelversion — VARCHAR
- kernelbuild — VARCHAR
- gccversion — VARCHAR
- smpinfo — VARCHAR
- fullversion — VARCHAR
- commandline — TEXT
- supportedcpus — VARCHAR
- xsavefeatures — VARCHAR
- xstateOffset — INT
- xstateSizes — INT
- xstateFeatures — VARCHAR
- contextsize — INT
- format — VARCHAR
- mapid — INT
- logid1 — INT
- range — VARCHAR
- status — VARCHAR
audit_httpd
- logid — INT
- timestamp — DATETIME
- clientip — VARCHAR
- requestmethod — VARCHAR
- requesturl — VARCHAR
- querystring — VARCHAR
- protocol — VARCHAR
- responsecode — INT
- responsesize — INT
- useragent — VARCHAR
- errorlevel — VARCHAR
- message — VARCHAR
audit_messages
- logid — INT
- timestamp — DATETIME
- host — VARCHAR
- service — VARCHAR
- level — VARCHAR
- message — VARCHAR
audit_ppp
- logid — INT
- timestamp — DATETIME
- processname — VARCHAR
- processid — INT
- event — VARCHAR
- interface — VARCHAR
- device — VARCHAR
- authmethod — VARCHAR
- status — VARCHAR
- user — VARCHAR
- localip — VARCHAR
- remoteip — VARCHAR
audit_rpmkgs
- logid — INT
- package — INT
- package_name — VARCHAR
- version — VARCHAR
- architecture — VARCHAR
- installdate — DATETIME
- vendor — VARCHAR
- summary — VARCHAR
audit_samba
- logid — INT
- timestamp — DATETIME
- loglevel — INT
- component — VARCHAR
- file — VARCHAR
- line — INT
- server — VARCHAR
- clientip — VARCHAR
- service — VARCHAR
- user — VARCHAR
- uid — INT
- gid — INT
- processid — INT
- message — VARCHAR
audit_secure
- logid — INT
- timestamp — DATETIME
- host — VARCHAR(255)
- daemon — VARCHAR(50)
- pid — INT
- message — TEXT
- user — VARCHAR(100)
- source_ip — VARCHAR(50)
- port — INT
- service — VARCHAR(10)
- Result — VARCHAR(10)
- uid — INT
- session_status — VARCHAR(30)
- connection_status — VARCHAR(30)
audit_spooler
- logid — INT
- timestamp — DATETIME
- processname — VARCHAR
- processid — INT
- event — VARCHAR
- device — VARCHAR
- file — VARCHAR
- remotehost — VARCHAR
- status — VARCHAR
audit_vbox
- logid — INT
- timestamp — DATETIME
- virtual_box_version — VARCHAR
- build — VARCHAR
- hostos — VARCHAR
- cpu_model — VARCHAR
- cpu_cores — TINYINT
- vtx_enabled — BOOLEAN
- vm_state — VARCHAR
- guest_os — VARCHAR
- guest_additions — VARCHAR
- network — VARCHAR
- final_guest_state — VARCHAR
audit_xfer_log
- logid — INT
- timestamp — INT
- transferduration — INT
- remotehost — VARCHAR
- filesize — BIGINT
- filename — VARCHAR
- transfertype — CHAR
- direction — CHAR
- accessmode — CHAR
- user — VARCHAR
- servicename — VARCHAR
- authmethod — CHAR
- authuserid — VARCHAR
- completionstatus — CHAR
db_api_transaction
- transactionid — INT — 외래 키 → db_query_transaction.transactionid
- ip_address — VARCHAR(15)
- timestamp — DATETIME — 외래 키 → db_query_transaction.timestamp
- http_method — VARCHAR(10)
- request_url — VARCHAR(255)
- http_version — VARCHAR(10)
- status_code — INTEGER
- response_size — INTEGER
- referer — VARCHAR(255)
- user_agent — VARCHAR(500)
db_query_transaction
- transactionid — INT
- timestamp — DATETIME — 외래 키 → user_hr_db.timestamp
- datahash — TEXT
- calleraddress — VARCHAR(50) — 외래 키 → user_hr_db.calleraddress
- result — VARCHAR(20)
infra_anomaly_detection_snmp_trap
- timestamp — INT
- sourceIP — DATETIME
- agent_address — VARCHAR
- trapid — VARCHAR
- generic_trap — INT
- specific_trap — INT
- varbind_list — INT
- enterprise_oid — JSON
- message — VARCHAR
- snmpv3_engineid — TEXT
- snmpv3_username — VARCHAR
- snmpv3_securitylevel — VARCHAR
- snmpv3_authprotocol — VARCHAR
- snmpv3_privprotocol — VARCHAR
- detection_name — VARCHAR
- detection_threat_score — INT
- ml_threshold — INT
- mitre_tactics — VARCHAR
- mitre_techniques — VARCHAR
infra_anomaly_detection_tcp_response
- timestamp — INT
- host — VARCHAR
- daemon — INT
- pid — INT
- message — TIMESTAMP
- user — TIMESTAMP
- detection_name — VARCHAR
- detection_threat_score — INT
- ml_threshold — INT
- mitre_tactics — VARCHAR
- mitre_techniques — VARCHAR
ping_check
- timestamp — DATETIME
- target — VARCHAR(255)
- ip_address — VARCHAR(45)
- sequence — INT
- ttl — INT
- response_time — FLOAT
- packet_size — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
playbook
- rule — VARCHAR
snmp_trap
- timestamp — VARCHAR(100) — 외래 키 → infra_anomaly_detection_snmp_trap.timestamp
- sourceIP — DATETIME — 외래 키 → infra_anomaly_detection_snmp_trap.sourceIP
- agentaddress — VARCHAR(255) — 외래 키 → infra_anomaly_detection_snmp_trap.agent_address
- trapid — VARCHAR(255) — 외래 키 → infra_anomaly_detection_snmp_trap.trapid
- generictrap — INT — 외래 키 → infra_anomaly_detection_snmp_trap.generic_trap
- specifictrap — INT — 외래 키 → infra_anomaly_detection_snmp_trap.specific_trap
- varbindlist — INT — 외래 키 → infra_anomaly_detection_snmp_trap.varbind_list
- enterpriseoid — JSON — 외래 키 → infra_anomaly_detection_snmp_trap.enterprise_oid
- message — VARCHAR(500) — 외래 키 → infra_anomaly_detection_snmp_trap.message
- snmpv3_engineid — TEXT — 외래 키 → infra_anomaly_detection_snmp_trap.snmpv3_engineid
- snmpv3_username — VARCHAR(255) — 외래 키 → infra_anomaly_detection_snmp_trap.snmpv3_username
- snmpv3_securitylevel — VARCHAR(100) — 외래 키 → infra_anomaly_detection_snmp_trap.snmpv3_securitylevel
- snmpv3_authprotocol — VARCHAR(100) — 외래 키 → infra_anomaly_detection_snmp_trap.snmpv3_authprotocol
- snmpv3_privprotocol — VARCHAR(100) — 외래 키 → infra_anomaly_detection_snmp_trap.snmpv3_privprotocol
tcp_response
- logid — INT
- timestamp — DATETIME — 외래 키 → infra_anomaly_detection_tcp_response.timestamp
- host — VARCHAR(255) — 외래 키 → infra_anomaly_detection_tcp_response.host
- daemon — INT — 외래 키 → infra_anomaly_detection_tcp_response.daemon
- pid — INT — 외래 키 → infra_anomaly_detection_tcp_response.pid
- message — TIMESTAMP — 외래 키 → infra_anomaly_detection_tcp_response.message
- user — TIMESTAMP — 외래 키 → infra_anomaly_detection_tcp_response.user
user_hr_db
- caller — CHAR(50)
- type_data — CHAR(300)
- secret_key — CHAR(300)
- calleraddress — CHAR(50)
- user_id_real — CHAR(20)
- user_org — CHAR(50)
- timestamp — DATETIME
- message — CHAR(100)