Cloud_Artifact_RDS

Tables (10)

Behavior (BEHAVIOR)

  • ID (behavior_id) — INTEGER — Primary key — NOT NULL
  • Behavior_category (behavior_category) — BLOB — Primary key — NOT NULL
  • Behavior (behavior) — BLOB
  • Description (behavior_description) — BLOB — [관련 아티팩트가 생성되는 동작에 대한 설명] - 예) {실행파일).exe 실행 및 로그인

Cloud_Datacenter (CLOUD_DATACENTER)

  • ID (cd_id) — INTEGER — Primary key — NOT NULL
  • Country Code (country_code) — INTEGER — 국가 Code - 예) KR 82 -참고 : https://countrycode.org/

Cloud_Service (CLOUD_SERVICE)

  • ID (cs_id) — INTEGER — Primary key — NOT NULL — Cloud Service ID
  • Cloud Service Name (service_name) — VARCHAR
  • CSP (company_name) — VARCHAR — [CSP] - 클라우드 서비스 운영 회사명 기입
  • Version (version) — VARCHAR — [클라우드 서비스 최신 버전]
  • Cloud Type (cloud_type) — INTEGER — Foreign key → Cloud_Type.Cloud Type — NOT NULL — - SaaS (0) - IaaS (1) - DaaS (2) - PaaS (4)
  • ID (cd_id) — INTEGER — Foreign key → Cloud_Datacenter.ID — NOT NULL

Cloud_Service_Operator (CLOUD_SERVICE_OPERATOR)

  • ID (cs_op_id) — INTEGER — Primary key — NOT NULL
  • ID (cs_id) — INTEGER — Foreign key → Cloud_Service.ID — NOT NULL — Cloud Service ID
  • ID (os_id) — INTEGER — Foreign key → Device_Type.ID — NOT NULL
  • Operator Name (op_name) — VARCHAR
  • MD5 (md5) — VARCHAR — NOT NULL — - Web으로 접속하는 경우 null O
  • SHA1 (sha1) — VARCHAR — NOT NULL — - Web으로 접속하는 경우 null O
  • SHA256 (sha256) — VARCHAR — NOT NULL — - Web으로 접속하는 경우 null O

Cloud_Service_Operator (CLOUD_SERVICE_OPERATOR_ARTIFACT)

  • csoa_id — INTEGER — Primary key — NOT NULL
  • ID (data_id) — INTEGER — Foreign key → Operator_Aritifact.ID — NOT NULL
  • ID (cs_op_id) — INTEGER — Foreign key → Cloud_Service_Operator.ID — NOT NULL

Cloud_Type (CLOUD_TYPE)

  • Cloud Type (cloud_type) — INTEGER — Primary key — NOT NULL — - SaaS (0) - IaaS (1) - DaaS (2) - PaaS (4)
  • Cloud Type Name (type_name) — VARCHAR

Device_Type (DEVICE_TYPE)

  • ID (os_id) — INTEGER — Primary key — NOT NULL
  • OS Name (os_name) — VARCHAR
  • OS Version (os_version) — VARCHAR
  • Device Type (device_type) — CHAR(2) — - 00 : PC - 01 : Mobile - 02: Pad

Operator_Aritifact (OPERATOR_ARTIFACT)

  • ID (data_id) — INTEGER — Primary key — NOT NULL
  • Cloud Type (cloud_type) — INTEGER — Foreign key → Cloud_Type.Cloud Type — NOT NULL — - SaaS (0) - IaaS (1) - DaaS (2) - PaaS (4)
  • Path (path) — VARCHAR
  • File Prefix (file_prefix) — VARCHAR
  • Extension (extension) — VARCHAR
  • Obfuscation (obfuscation) — BOOLEAN
  • Encryption (encryption) — BOOLEAN
  • Content (content) — BLOB — [아티팩트의 핵심 내용] - 상세하게 적는 것이 아님 - 예) ( log 파일의 경우) 실행 관련 시각, 로그인 정보 - 확인할 수 있는 포괄적인 내용 기재

Scenario (SCENARIO)

  • ID (Scenario_id) — INTEGER — Primary key — NOT NULL
  • ID (behavior_id) — INTEGER — Foreign key → Behavior.ID — NOT NULL
  • Behavior_category (behavior_category) — BLOB — Foreign key → Behavior.Behavior_category — NOT NULL
  • Description (Scenario_desciption) — BLOB

User Scenario Data (USER_SCENARIO_DATA)

  • ID (artifact_id) — INTEGER — Primary key — NOT NULL
  • ID (Scenario_id) — INTEGER — Foreign key → Scenario.ID — NOT NULL
  • ID (data_id) — INTEGER — Foreign key → Operator_Aritifact.ID — NOT NULL
  • Behavior_category (behavior_category) — BLOB — Foreign key → Behavior.Behavior_category — NOT NULL