web_edi_test_v1
Tables (30)
aips_logs
- id — bigint — Primary key — NOT NULL
- received_at — timestamp
- event_stime — datetime(3)
- event_etime — datetime(3)
- device_id — varchar(50)
- signature_id — int
- attack_name — varchar(255)
- priority — varchar(20)
- src_ip — varchar(45)
- src_port — int
- src_mac — varchar(17)
- dst_ip — varchar(45)
- dst_port — int
- protocol — varchar(10)
- action — varchar(20)
- packet_direction — varchar(10)
- payload — text
- raw_log — text
boannews_news
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- url — varchar(255) — NOT NULL
- post_date — date
- crawled_at — timestamp — NOT NULL
calendar_events
- id — int — Primary key — NOT NULL
- event_date — date — NOT NULL
- title — varchar(255) — NOT NULL
- user_id — int — Foreign key → login_info.id
- author — varchar(255)
- created_at — timestamp
course_materials
- id — int — Primary key — NOT NULL
- course_id — int — NOT NULL — 연결된 강좌 ID (URL형은 ID 그대로, 파일형은 10000번대)
- file_name — varchar(255) — NOT NULL — 사용자에게 보여줄 파일명
- file_path — varchar(255) — NOT NULL
- file_size — varchar(50) — 파일 용량(예: 1.2MB)
- description — text — 파일 설명
- created_at — datetime
courses
- course_id — int — Primary key — NOT NULL
- course_name — varchar(100) — NOT NULL
- video_url — varchar(255)
- total_duration — int — 영상의 총 길이 (초 단위)
- quiz_id — int
- category — varchar(50) — NOT NULL
- course_summary — text
courses_file
- file_course_id — int — Primary key — NOT NULL
- course_name — varchar(255) — NOT NULL
- category — varchar(50)
- total_duration — int
- file_path — varchar(255) — NOT NULL
- course_summary — text
- created_at — timestamp
dashboard_summary
- id — bigint — Primary key — NOT NULL
- widget_name — varchar(50) — NOT NULL
- rank — int — NOT NULL
- data_col1 — varchar(255)
- data_col2 — varchar(255)
- data_col3 — varchar(255)
- data_col4 — varchar(255)
- last_updated — datetime
ebu_tech_news
- id — int — Primary key — NOT NULL
- title — varchar(500) — NOT NULL — 뉴스 제목
- url — varchar(750) — NOT NULL — 뉴스 상세 링크
- crawled_at — datetime — 수집 일시
- published_date — date — 게시일(추출 가능한 경우)
eset_component_status
- id — int — Primary key — NOT NULL
- category_name — varchar(50) — NOT NULL — 항목 (에이전트, Endpoint 등)
- latest_ver — int — 최신 버전 수
- outdated_ver — int — 오래된 버전 수
- removed_ver — int — 제거된 버전 수
- snapshot_ts — datetime — NOT NULL — 수집 시간
eset_computers_history
- id — int — Primary key — NOT NULL
- snapshot_ts — datetime — NOT NULL — 수집 시점
- computer_name — varchar(255) — 컴퓨터 이름
- parent_group — varchar(255) — 상위 그룹
- ip_address — varchar(255) — IP 주소
- last_connected — varchar(255) — 마지막으로 연결됨
- last_connected_ip — varchar(255) — 마지막 연결 IP
- managed_by — varchar(512) — 관리되는 사용자
- security_product — varchar(255) — 보안 제품
- product_version — varchar(255) — 제품 버전
- os_name_and_version — varchar(255) — OS 이름 및 버전
- hw_model — varchar(255) — 하드웨어 모델
- hw_manufacturer — varchar(255) — 하드웨어 제조업체
- status — varchar(255) — 상태
- status_and_problems — varchar(512) — 상태 및 문제 요약
- problems — varchar(255) — 발생한 문제
eset_dashboard_overview_history
- id — bigint — Primary key — NOT NULL
- total_devices — int — NOT NULL
- ok — int — NOT NULL
- needs_attention — int — NOT NULL
- security_risk — int — NOT NULL
- snapshot_ts — datetime — NOT NULL
- created_at — timestamp — NOT NULL
eset_license_history
- id — bigint — Primary key — NOT NULL
- seats_total — int — NOT NULL
- seats_used — int — NOT NULL
- snapshot_ts — datetime — NOT NULL
eset_threat_events
- id — bigint — Primary key — NOT NULL
- ingested_at — timestamp
- occured_at — datetime — NOT NULL
- severity — varchar(20)
- hostname — varchar(255)
- ipv4 — varchar(15)
- os_name — varchar(255)
- group_name — varchar(255)
- source_uuid — char(36)
- threat_type — varchar(100)
- threat_name — varchar(255)
- scanner_id — varchar(100)
- engine_version — varchar(50)
- object_type — varchar(50)
- object_uri — text
- action_taken — varchar(100)
- threat_handled — tinyint(1)
- username — varchar(255)
- process_name — text
- hash — char(40)
eset_threat_trends
- id — int — Primary key — NOT NULL
- chart_type — varchar(50) — NOT NULL — 차트 종류 (예: severity, detection_method)
- event_date — date — NOT NULL — 이벤트 발생일
- series_name — varchar(50) — NOT NULL — 데이터 계열 명 (예: high, medium, block)
- event_count — int — 이벤트 수
- snapshot_ts — datetime — NOT NULL — 데이터 수집 시간
internal_board
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- author — varchar(50)
- created_at — timestamp
- user_id — int — Foreign key → login_info.id
ip_exclusion_list
- id — int — Primary key — NOT NULL
- ip_address — varchar(50) — NOT NULL — IP 주소 또는 CIDR 대역 (예: 10.130.16.0/24)
- description — varchar(255) — 설명 (예: 내부 개발서버 대역)
- created_at — timestamp
kisa_news
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- url — varchar(512) — NOT NULL
- post_date — date
- crawled_at — timestamp
kisa_security_notices
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- url — varchar(512) — NOT NULL
- post_date — date
- crawled_at — timestamp — NOT NULL
kisa_vulnerabilities
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- post_date — date
- url — varchar(512) — NOT NULL
- crawled_at — timestamp — NOT NULL
login_info
- id — int — Primary key — NOT NULL
- username — varchar(50) — NOT NULL
- password_hash — varchar(255) — NOT NULL
- role — enum('admin', 'viewer')
- is_active — tinyint(1)
- created_at — timestamp
- last_login — timestamp
- last_activity_time — timestamp
- real_name — varchar(50) — 사용자 실명
- team_name — varchar(100) — 소속 팀
- company — enum('SBS', 'SBSi', '스튜디오S')
manuals
- id — int — Primary key — NOT NULL
- category — varchar(50) — NOT NULL
- title — varchar(255) — NOT NULL
- content — longtext
- created_at — timestamp
- updated_at — timestamp
nas_file_events
- id — bigint — Primary key — NOT NULL
- nas_log_id — int — Foreign key → nas_logs.id — NOT NULL
- event_type — varchar(50)
- file_path — text
- file_size — varchar(50)
- event_user — varchar(100)
- source_ip — varchar(50)
nas_logs
- id — int — Primary key — NOT NULL
- log_time — datetime
- host — varchar(100)
- content — text
- raw_log — text
- raw_hash — char(64)
- time — timestamp — NOT NULL
paloalto_system_logs
- id — bigint — Primary key — NOT NULL
- time_generated — datetime — Primary key — NOT NULL
- receive_time — timestamp — NOT NULL
- device_name — varchar(255)
- serial_number — varchar(255)
- log_subtype — varchar(50)
- vsys — varchar(50)
- event_id — varchar(255)
- severity — enum('informational','low','medium','high','critical') — NOT NULL
- description — text
- raw_log — text
- PARTITION — p_2025_09
- PARTITION — p_2025_10
- PARTITION — p_2025_11
- PARTITION — p_2025_12
- PARTITION — p_max_value
paloalto_threat_logs
- id — bigint — Primary key — NOT NULL
- time_generated — datetime — Primary key — NOT NULL
- receive_time — timestamp — NOT NULL
- device_name — varchar(255)
- serial_number — varchar(255)
- log_subtype — varchar(50)
- vsys — varchar(50)
- src_ip — varchar(45) — NOT NULL
- dst_ip — varchar(45) — NOT NULL
- nat_src_ip — varchar(45)
- nat_dst_ip — varchar(45)
- src_port — int
- dst_port — int
- rule_name — varchar(255)
- application — varchar(255)
- protocol — varchar(50)
- action — varchar(50)
- threat_id — varchar(255)
- threat_name — text
- url_category — varchar(255)
- severity — varchar(50)
- direction — varchar(50)
- src_zone — varchar(255)
- dst_zone — varchar(255)
- misc — text
- raw_log — text
- PARTITION — p_2025_09
- PARTITION — p_2025_10
- PARTITION — p_2025_11
- PARTITION — p_2025_12
- PARTITION — p_max_value
paloalto_traffic_logs
- id — bigint — Primary key — NOT NULL
- time_generated — datetime — Primary key — NOT NULL
- receive_time — timestamp — NOT NULL
- device_name — varchar(255)
- serial_number — varchar(255)
- log_subtype — varchar(50)
- vsys — varchar(50)
- src_ip — varchar(45) — NOT NULL
- dst_ip — varchar(45) — NOT NULL
- nat_src_ip — varchar(45)
- nat_dst_ip — varchar(45)
- src_port — int
- dst_port — int
- nat_src_port — int
- nat_dst_port — int
- rule_name — varchar(255)
- src_user — varchar(255)
- dst_user — varchar(255)
- application — varchar(255)
- protocol — varchar(50)
- action — varchar(50)
- session_id — bigint
- session_end_reason — varchar(50)
- src_zone — varchar(255)
- dst_zone — varchar(255)
- inbound_if — varchar(255)
- outbound_if — varchar(255)
- bytes_sent — bigint
- bytes_received — bigint
- packets_sent — bigint
- packets_received — bigint
- src_country — varchar(100)
- dst_country — varchar(100)
- raw_log — text
- PARTITION — p_2025_09
- PARTITION — p_2025_10
- PARTITION — p_2025_11
- PARTITION — p_2025_12
- PARTITION — p_max_value
program_files
- program_id — varchar(50) — Primary key — NOT NULL — 프로그램 고유 ID (예: eset-pc-normal)
- file_url — varchar(255) — 업로드된 파일의 경로
- updated_at — timestamp — NOT NULL
quiz_table
- id — int — Primary key — NOT NULL
- video_url — varchar(255)
- question — text — NOT NULL
- hint — text
- option_1 — text — NOT NULL
- option_2 — text — NOT NULL
- option_3 — text — NOT NULL
- option_4 — text — NOT NULL
- answer_index — tinyint — NOT NULL — 1, 2, 3, 4 중 정답 보기의 번호
- answer_rationale — text
security_board
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- author — varchar(100) — NOT NULL
- file_name — varchar(255)
- stored_file_path — varchar(255)
- category — varchar(50)
- views — int
- is_notice — tinyint(1)
- created_at — datetime
- updated_at — datetime
- user_id — int
user_course_progress
- progress_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → login_info.id — NOT NULL
- course_id — int — Foreign key → courses.course_id — NOT NULL
- watched_duration — int — 시청한 시간 (초 단위)
- status — enum('진행중', '완료', '시청완료')
- updated_at — timestamp
- quiz_passed — tinyint(1) — NOT NULL