보안점검 프로젝트

테이블 (12)

Checklist

  • checklist_id — SERIAL
  • service_id — INT — NOT NULL
  • checklist_item — VARCHAR(255) — NOT NULL
  • description — TEXT

ChecklistResult

  • result_id — SERIAL
  • scan_id — INT — NOT NULL
  • checklist_id — INT — NOT NULL
  • result — VARCHAR(50) — NOT NULL
  • details — TEXT

CloudAccount

  • account_id — SERIAL
  • user_id — INT — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • access_key — VARCHAR(255) — NOT NULL
  • secret_key — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

CloudResource

  • resource_id — SERIAL
  • account_id — INT — NOT NULL
  • resource_type — VARCHAR(50) — NOT NULL
  • resource_identifier — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

Notification

  • notification_id — SERIAL
  • user_id — INT — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

Scan

  • scan_id — SERIAL
  • account_id — INT — NOT NULL
  • scan_status — VARCHAR(50) — NOT NULL
  • scan_type — VARCHAR(50) — NOT NULL
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP

ScanResult

  • result_id — SERIAL
  • scan_id — INT — NOT NULL
  • resource_id — INT — NOT NULL
  • vulnerability_id — INT — NOT NULL
  • detected_at — TIMESTAMP
  • severity — VARCHAR(50) — NOT NULL

Service

  • service_id — SERIAL
  • service_name — VARCHAR(100) — NOT NULL

SystemLog

  • log_id — SERIAL
  • user_id — INT
  • log_type — VARCHAR(50) — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — TIMESTAMP

Untitled

    User

    • user_id — SERIAL
    • username — VARCHAR(50) — NOT NULL
    • email — VARCHAR(100) — NOT NULL
    • password_hash — VARCHAR(255) — NOT NULL
    • created_at — TIMESTAMP
    • last_login — TIMESTAMP

    Vulnerability

    • vulnerability_id — SERIAL
    • name — VARCHAR(255) — NOT NULL
    • description — TEXT — NOT NULL
    • severity — VARCHAR(50) — NOT NULL
    • remediation — TEXT — NOT NULL