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