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