SCC
Tables (9)
Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (PACKET_MONITORING)
- Key (id) — INT(4) — Foreign key → Security Control Center.Key — NOT NULL
- Field (packet_log) — TEXT
- Field (packet_time) — DATETIME
Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (LOGIN_MONITORING)
- Key (id) — INT(4) — Foreign key → Security Control Center.Key — NOT NULL
- Field (login_log) — TEXT
- Field (login_time) — DATETIME
Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (FILESYSTEM_ENCRYPTION)
- Key (id) — INT(4) — Foreign key → Security Control Center.Key — NOT NULL
- Field (encryption_log) — TEXT
- Field (encryption_parity) — ENUM('OK', 'ERROR')
- Field (encryption_time) — DATETIME
Copy Of Copy Of Copy Of Copy Of Untitled (FILESYSTEM_INTEGRITY)
- Key (id) — INT(4) — Foreign key → Security Control Center.Key — NOT NULL
- Field (integrity_log) — TEXT
- Field (integrity_parity) — ENUM('OK', 'ERROR')
- Field (integrity_time) — DATETIME
Copy Of Copy Of Copy Of Untitled (REMOTE_ATTESTATION)
- Key (id) — INT(4) — Foreign key → Security Control Center.Key — NOT NULL
- Field (attestation_log) — TEXT
- Field (attestation_parity) — ENUM('OK', 'ERROR')
- Field (attestation_time) — DATETIME
Copy Of Copy Of Untitled (SECURE_FW_UPDATE)
- Key (id) — INT(4) — Foreign key → Security Control Center.Key — NOT NULL
- Field (update_log) — TEXT
- Field (update_parity) — ENUM('OK', 'ERROR')
- Field (update_time) — DATETIME
Copy Of Untitled (SECURE_BOOT)
- Key (id) — INT(4) — Foreign key → Security Control Center.Key — NOT NULL
- Field (boot_log) — TEXT
- Field (boot_parity) — ENUM('OK', 'ERROR')
- Field (boot_time) — DATETIME
Security Control Center (SCC)
- Key (device_id) — INT(4) — Primary key — NOT NULL
- Field (name) — TEXT
- Field2 (user) — VARCHAR(11)
- Field3 (device) — ENUM('SecurePi', 'Sarduino')
- Field4 (location) — TEXT
- Field (ip) — VARCHAR(16)
- Field (firmware) — VARCHAR(11)
- Field (parity) — ENUM('OK', 'ERROR', 'UNKOWN')
- Field (id) — INT(4)
Untitled (SECURE_KEY_MANAGE)
- Key (id) — INT(4) — Foreign key → Security Control Center.Key — NOT NULL
- Field (key_log) — TEXT
- Field (key_parity) — ENUM('OK', 'ERROR')
- Field (key_time) — DATETIME