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