보안점검 프로젝트
테이블 (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
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