vtm 3.0

Tables (14)

ASSET_DETAIL (자산 상세 정보)

  • id (ASSET_DETAIL_ID) — INT — Primary key — NOT NULL — primaryKey
  • id (ASSET_ID) — INT — Foreign key → ASSET_INFO.id — NOT NULL — primaryKey
  • name (ASSET_DETAIL_NAME) — varchar(256) — 자산명
  • ip (ASSET_IP) — varchar(64) — ip정보
  • manager (ASSET_MANAGER) — varchar(64) — 관리담당
  • status (ASSET_STATUS) — varchar(1) — NOT NULL — 접속상태
  • host_name (ASSET_HOST_NAME) — varchar(64) — host 명
  • url (ASSET_DETAIL_URL) — varchar(64) — url
  • cpu (ASSET_DETAIL_CPU) — varchar(64) — cpu
  • memory (ASSET_DETAIL_MEMOERY) — varchar(64) — memory
  • disk (ASSET_DETAIL_DISK) — varchar(64) — disk 정보
  • network_interface (ASSET_DETAIL_NETWORK_INTERFACE) — varchar(64) — network_interface
  • createDate (CREATE_DATE) — TIMESTAMP — NOT NULL — 생성일자
  • createUser (CREATE_USER) — varchar(64) — 생성자
  • updateDate (UPDATE_DATE) — TIMESTAMP — 수정일
  • updateUser (UPDATE_USER) — varchar(64) — 수정자

ASSET_INFO (자산정보)

  • id (ASSET_ID) — INT — Primary key — NOT NULL — primaryKey
  • name (ASSET_NAME) — varchar(256) — 자산명
  • type (ASSET_TYPE) — varchar(64) — 구분/유형
  • ip (ASSET_IP) — varchar(64) — ip정보
  • os_detail (ASEET_OS_DETAIL) — varchar(64) — os_detail
  • status (ASSET_RUNNINT_STATUS) — varchar(1) — NOT NULL — 운영여부
  • manager (ASSET_MANAGER) — varchar(64) — 관리담당
  • status (ASSET_STATUS) — varchar(1) — NOT NULL — 접속상태
  • os (ASSET_OS) — varchar(64) — os
  • createDate (CREATE_DATE) — TIMESTAMP — NOT NULL — 생성일자
  • createUser (CREATE_USER) — varchar(64) — 생성자
  • updateDate (UPDATE_DATE) — TIMESTAMP — 수정일
  • updateUser (UPDATE_USER) — varchar(64) — 수정자

ASSET_QUESTION (자산 질문 테이블)

  • id (ASSET_QUESTION_ID) — INT — Primary key — NOT NULL — primary key
  • id (ASSET_ID) — INT — Foreign key → ASSET_INFO.id — NOT NULL — primaryKey
  • question (ASSET_QUESTION) — varchar(64) — NOT NULL — question

ASSET_QUESTION_ANSWER (자산 정답 테이블)

  • id (answer_id) — INT — Primary key — NOT NULL — primary_Id
  • question_id (ASSET_QUESTION_ID) — INT — Foreign key → ASSET_QUESTION.id — NOT NULL — primary key
  • id (ASSET_ID) — INT — Foreign key → ASSET_QUESTION.id — NOT NULL — primaryKey
  • title (QUESTION_TITLE) — varchar(64) — NOT NULL — 답변 내용
  • point (ASSET_ANSWER) — INT — NOT NULL — 점수 값
  • select (ANSWER_SELECT) — varchar(1) — NOT NULL — 선택여부

CPE_TABLE (CPE 정보)

  • id (CPE_ID) — INT — Primary key — NOT NULL — primary key
  • id (CVE_ID) — varchar(64) — Foreign key → CVE_INFO.id — NOT NULL — cve_id
  • name (CPE_NAME) — varchar(64) — NOT NULL — cpe 명

CVE_INFO (CVE정보)

  • id (CVE_ID) — varchar(64) — Primary key — NOT NULL — cve_id
  • id (ASSET_ID) — INT — Foreign key → ASSET_INFO.id — NOT NULL — primaryKey
  • exploated (EPSS_EXPLOATED) — varchar(1) — NOT NULL — 취약점 노출 정보

CVE_RELATION_TABLE (CVE연관 관계 테이블)

  • id (RELATTION_ID) — INT — Primary key — NOT NULL — primary key
  • id (CVE_ID) — varchar(64) — Foreign key → CVE_INFO.id — NOT NULL — cve_id
  • id (EXPLOATED_ID) — INT — Foreign key → EXPLOATED_INFO.id — NOT NULL — primary key
  • id (CVE_ID2) — varchar(64) — Foreign key → EXPLOATED_INFO.id — NOT NULL — cve_id
  • id (PACKAGE_ID) — INT — Foreign key → PACKAGE_INFO.id — NOT NULL — primary key
  • id (CVE_ID3) — varchar(64) — Foreign key → PACKAGE_INFO.id — NOT NULL — cve_id
  • id (EPSS_ID) — INT — Foreign key → EPSS_INFO.id — NOT NULL — primary key
  • id (CVE_ID4) — varchar(64) — Foreign key → EPSS_INFO.id — NOT NULL — cve_id
  • id (CVSS_ID) — INT — Foreign key → CVSS_INFO.id — NOT NULL — primary key
  • id (CVE_ID5) — varchar(64) — Foreign key → CVSS_INFO.id — NOT NULL — cve_id
  • id (CPE_ID) — INT — Foreign key → CPE_TABLE.id — NOT NULL — primary key

CVSS_INFO (cvss_정보)

  • id (CVSS_ID) — INT — Primary key — NOT NULL — primary key
  • id (CVE_ID) — varchar(64) — Foreign key → CVE_INFO.id — NOT NULL — cve_id
  • version (CVSS_VERSION) — varchar(64) — NOT NULL — cvss 해당 버젼 정보
  • score (CVSS_SCORE) — FLOAT — NOT NULL — score 점수 값

EPSS_INFO (EPSS 정보)

  • id (EPSS_ID) — INT — Primary key — NOT NULL — primary key
  • id (CVE_ID) — varchar(64) — Foreign key → CVE_INFO.id — NOT NULL — cve_id
  • epss (EPSS_VALUE) — FlOAT — NOT NULL — Epss 점수 값
  • Percentage (EPSS_PERCENTAGE) — FlOAT — NOT NULL — 퍼센테이지 정보

EVENT_HISTORY (이벤트 정보)

  • id (EVENT_ID) — INT — Primary key — NOT NULL — primary key
  • user (EVENT_USER) — varchar(64) — 이벤트 유저
  • event_name (EVENT_NAME) — varchar(64) — 이벤트명
  • status (EVENT_STATUS) — varchar(1) — NOT NULL — 이벤트 상태값
  • event_content (EVENT_CONTENT) — varchar(200) — 이벤트 내용
  • start_time (START_TIME) — TIMESTAMP — NOT NULL — 이벤트 시작 시간
  • end_time (EVENT_END_TIME) — TIMESTAMP — 이벤트 종료시간

EXPLOATED_INFO (취약점 노출 정보)

  • id (EXPLOATED_ID) — INT — Primary key — NOT NULL — primary key
  • id (CVE_ID) — varchar(64) — Foreign key → CVE_INFO.id — NOT NULL — cve_id

PACKAGE_INFO (패키지 정보)

  • id (PACKAGE_ID) — INT — Primary key — NOT NULL — primary key
  • id (CVE_ID) — varchar(64) — Foreign key → CVE_INFO.id — NOT NULL — cve_id
  • package_name (PACKAGE_NAME) — varchar(64) — NOT NULL — 패키지 명

SSH_INFO (Untitled)

  • ssh_id (SSH_ID) — INT — Primary key — NOT NULL — primary_key
  • id (ASSET_ID) — INT — Foreign key → ASSET_INFO.id — NOT NULL — primaryKey
  • host (SSH_HOST) — varchar(64) — NOT NULL — host 정보
  • username (SSH_USERNAME) — varchar(64) — NOT NULL — username
  • password (SSH_PASSWORD) — varchar(80) — NOT NULL — 비밀번호
  • root (SSH_ROOT) — varchar(80) — root_passwrod
  • port (SSH_PORT) — INT — port 정보

USER (유저 테이블)

  • id (USER_ID) — INT — Primary key — NOT NULL — primary key
  • name (USER_NAME) — varchar(20) — 유저명
  • user_password (USER_PASSWORD) — varchar(20) — NOT NULL — user_passwrod