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