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