Security_Project

Tables (5)

Alert

  • alert_id — SERIAL
  • user_id — INTEGER
  • cve_id — VARCHAR(20)
  • program_id — INTEGER
  • alert_date — TIMESTAMP
  • is_read — BOOLEAN

CVE

  • cve_id — VARCHAR(20)
  • description — TEXT
  • severity — VARCHAR(10)
  • published_date — DATE
  • cpe_uri — TEXT

Program

  • program_id — SERIAL
  • program_name — VARCHAR(100) — NOT NULL
  • version — VARCHAR(50)
  • installed_path — TEXT
  • user_id — INTEGER

ProgramCVE

  • id — SERIAL
  • program_id — INTEGER
  • cve_id — VARCHAR(20)
  • matched_at — TIMESTAMP

User

  • user_id — SERIAL
  • username — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP