OnAV for Linux

Tables (12)

installation

  • installation_id — uuid — NOT NULL
  • installation_code — core.code_64 — NOT NULL
  • display_name — varchar(200) — NOT NULL
  • status — text — NOT NULL
  • retired_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • row_version — core.row_version — NOT NULL

integrity_assignment

  • server_node_id — uuid — NOT NULL
  • installation_id — uuid — NOT NULL
  • integrity_baseline_id — uuid — NOT NULL
  • assignment_generation — bigint — NOT NULL
  • assigned_by_membership_id — uuid
  • assigned_at — timestamptz — NOT NULL
  • row_version — core.row_version — NOT NULL

integrity_baseline

  • integrity_baseline_id — uuid — NOT NULL
  • installation_id — uuid — NOT NULL
  • version_no — core.positive_int — NOT NULL
  • status — text — NOT NULL
  • entry_count — core.positive_int — NOT NULL
  • entry_set_digest — core.sha256_digest — NOT NULL
  • created_by_membership_id — uuid
  • activated_at — timestamptz
  • retired_at — timestamptz
  • created_at — timestamptz — NOT NULL

integrity_baseline_entry

  • integrity_entry_id — uuid — NOT NULL
  • installation_id — uuid — NOT NULL
  • integrity_baseline_id — uuid — NOT NULL
  • entry_ordinal — core.positive_int — NOT NULL
  • path_value_id — uuid — NOT NULL
  • path_equality_token — core.sha256_digest — NOT NULL
  • entry_kind — text — NOT NULL
  • expected_digest — core.sha256_digest
  • expected_size_bytes — bigint
  • expected_mode — integer
  • expected_owner — varchar(128)
  • created_at — timestamptz — NOT NULL

integrity_check_result

  • integrity_check_result_id — uuid — NOT NULL
  • installation_id — uuid — NOT NULL
  • integrity_run_id — uuid — NOT NULL
  • integrity_entry_id — uuid — NOT NULL
  • check_status — text — NOT NULL
  • actual_digest — core.sha256_digest
  • actual_size_bytes — bigint
  • actual_mode — integer
  • actual_owner — varchar(128)
  • error_code — core.code_64
  • checked_at — timestamptz — NOT NULL
  • created_at — timestamptz — NOT NULL

integrity_run

  • integrity_run_id — uuid — NOT NULL
  • installation_id — uuid — NOT NULL
  • server_node_id — uuid — NOT NULL
  • integrity_baseline_id — uuid — NOT NULL
  • run_generation — core.positive_int — NOT NULL
  • trigger_kind — text — NOT NULL
  • status — text — NOT NULL
  • expected_check_count — core.positive_int — NOT NULL
  • accepted_check_count — core.nonnegative_int — NOT NULL
  • actual_check_set_digest — core.sha256_digest
  • started_at — timestamptz
  • completed_at — timestamptz
  • failure_code — core.code_64
  • created_at — timestamptz — NOT NULL

scope

  • scope_id — uuid — NOT NULL
  • installation_id — uuid — NOT NULL
  • scope_type — text — NOT NULL
  • scope_code — core.code_64 — NOT NULL
  • status — text — NOT NULL
  • retired_at — timestamptz
  • notification_feed_sequence — bigint — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • row_version — core.row_version — NOT NULL

server_node

  • server_node_id — uuid — NOT NULL
  • installation_id — uuid — NOT NULL
  • node_code — core.code_64 — NOT NULL
  • node_name — varchar(200) — NOT NULL
  • status — text — NOT NULL
  • bootstrap_generation — bigint — NOT NULL
  • last_seen_at — timestamptz
  • retired_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • row_version — core.row_version — NOT NULL

server_node_bootstrap_token

  • bootstrap_token_id — uuid — NOT NULL
  • installation_id — uuid — NOT NULL
  • server_node_id — uuid — NOT NULL
  • purpose_code — core.code_64 — NOT NULL
  • token_digest — core.sha256_digest — NOT NULL
  • status — text — NOT NULL
  • issued_by_membership_id — uuid
  • issued_at — timestamptz — NOT NULL
  • expires_at — timestamptz — NOT NULL
  • used_at — timestamptz
  • revoked_at — timestamptz
  • revoke_reason_code — core.code_64
  • created_at — timestamptz — NOT NULL

server_node_credential

  • server_node_credential_id — uuid — NOT NULL
  • installation_id — uuid — NOT NULL
  • server_node_id — uuid — NOT NULL
  • predecessor_id — uuid
  • version_no — core.positive_int — NOT NULL
  • certificate_serial — varchar(160) — NOT NULL
  • certificate_fingerprint — core.sha256_digest — NOT NULL
  • subject_dn — varchar(1000) — NOT NULL
  • not_before — timestamptz — NOT NULL
  • not_after — timestamptz — NOT NULL
  • status — text — NOT NULL
  • activated_at — timestamptz
  • retired_at — timestamptz
  • revoked_at — timestamptz
  • revocation_reason — varchar(1000)
  • created_at — timestamptz — NOT NULL

server_safety_state

  • server_node_id — uuid — NOT NULL
  • installation_id — uuid — NOT NULL
  • safety_state — text — NOT NULL
  • latest_selftest_run_id — uuid
  • latest_integrity_run_id — uuid
  • reason_code — core.code_64
  • source_vector_digest — core.sha256_digest
  • evaluated_at — timestamptz — NOT NULL
  • row_version — core.row_version — NOT NULL

server_selftest_policy_version

  • selftest_policy_version_id — uuid — NOT NULL
  • installation_id — uuid — NOT NULL
  • version_no — core.positive_int — NOT NULL
  • status — text — NOT NULL
  • required_component_codes — text — NOT NULL
  • required_component_count — core.positive_int — NOT NULL
  • component_set_digest — core.sha256_digest — NOT NULL
  • valid_from — timestamptz
  • valid_until — timestamptz
  • created_by_membership_id — uuid
  • activated_at — timestamptz
  • retired_at — timestamptz
  • created_at — timestamptz — NOT NULL