Satellites

`satellites`

Pulsar satellites: tenant (null = global), encrypted secret, bound instance id, status, version, reported geo and connectivity (IPv4/IPv6), manual location and address, last heartbeat and sync, round-trip times, traceroute to the portal, web console grant, latest load sample.

45 columns

Column	Type	Null	Default	References
`id` PK	`bigint(20) unsigned`
`uuid` unique	`uuid`
`tenant_id`	`bigint(20) unsigned`	yes		`tenants` on delete cascade
`name`	`varchar(255)`
`description`	`text`	yes
`secret`	`text`
`status`	`varchar(16)`		`pending`
`registered_at`	`timestamp`	yes
`instance_id`	`varchar(255)`	yes
`version`	`varchar(255)`	yes
`hostname`	`varchar(255)`	yes
`public_ip`	`varchar(255)`	yes
`ipv4`	`tinyint(1)`	yes
`ipv6`	`tinyint(1)`	yes
`connectivity_checked_at`	`timestamp`	yes
`remote_ip`	`varchar(255)`	yes
`ip_info`	`longtext`	yes
`asn`	`varchar(255)`	yes
`as_name`	`varchar(255)`	yes
`provider`	`varchar(255)`	yes
`city`	`varchar(255)`	yes
`region`	`varchar(255)`	yes
`country`	`varchar(8)`	yes
`latitude`	`decimal(9,6)`	yes
`longitude`	`decimal(9,6)`	yes
`last_seen_at`	`timestamp`	yes
`last_sync_at`	`timestamp`	yes
`ws_connected`	`tinyint(1)`		`0`
`portal_rtt_ms`	`double`	yes
`portal_http_rtt_ms`	`double`	yes
`portal_trace`	`longtext`	yes
`portal_trace_at`	`timestamp`	yes
`capabilities`	`longtext`	yes
`queue_size`	`int(10) unsigned`		`0`
`sync_version`	`varchar(255)`	yes
`console_grant`	`longtext`	yes
`console_used_at`	`timestamp`	yes
`console_revoked_at`	`timestamp`	yes
`offline_notified_at`	`timestamp`	yes
`created_at`	`timestamp`	yes
`updated_at`	`timestamp`	yes
`load_sample`	`longtext`	yes
`address`	`varchar(300)`	yes
`manual_latitude`	`decimal(9,6)`	yes
`manual_longitude`	`decimal(9,6)`	yes

Indexes: tenant_id · uuid (unique)

`satellite_tags`

Tags of a satellite with their source: auto (from the geo lookup: AS, provider, city, country), env (from PULSAR_TAGS) or manual (set in Polaris; the only source of zone=).

7 columns

Column	Type	Null	Default	References
`id` PK	`bigint(20) unsigned`
`satellite_id`	`bigint(20) unsigned`			`satellites` on delete cascade
`key`	`varchar(64)`
`value`	`varchar(255)`
`source`	`varchar(16)`		`manual`
`created_at`	`timestamp`	yes
`updated_at`	`timestamp`	yes

Indexes: satellite_id, key, value (unique)

`satellite_heartbeats`

One row per heartbeat: round-trip times, websocket state, queue size and load. Pruned after POLARIS_RETENTION_HEARTBEATS days.

14 columns

Column	Type	Null	Default	References
`id` PK	`bigint(20) unsigned`
`satellite_id`	`bigint(20) unsigned`			`satellites` on delete cascade
`rtt_ms`	`double`	yes
`http_rtt_ms`	`double`	yes
`ws_connected`	`tinyint(1)`		`0`
`queue_size`	`int(10) unsigned`		`0`
`created_at`	`timestamp`		`current_timestamp()`
`run_slots`	`smallint(5) unsigned`	yes
`runs_busy`	`smallint(5) unsigned`	yes
`runs_waiting`	`smallint(5) unsigned`	yes
`busy_pct`	`double`	yes
`cpu_load`	`double`	yes
`cpus`	`smallint(5) unsigned`	yes
`mem_pct`	`double`	yes

Indexes: satellite_id, created_at

`satellite_logs`

Log lines the satellite ships and events Polaris records about it (offline, back online, rejected results). Pruned after POLARIS_RETENTION_LOGS days.

7 columns

Column	Type	Null	Default	References
`id` PK	`bigint(20) unsigned`
`satellite_id`	`bigint(20) unsigned`			`satellites` on delete cascade
`level`	`varchar(16)`
`message`	`text`
`context`	`longtext`	yes
`logged_at`	`timestamp`	yes
`created_at`	`timestamp`		`current_timestamp()`

Indexes: satellite_id, logged_at

`satellite_target`

Which satellites watch a target: set in the Add targets wizard, used by the automatic plans.

5 columns

Column	Type	Null	References
`id` PK	`bigint(20) unsigned`
`satellite_id`	`bigint(20) unsigned`		`satellites` on delete cascade
`target_id`	`bigint(20) unsigned`		`targets` on delete cascade
`created_at`	`timestamp`	yes
`updated_at`	`timestamp`	yes

Indexes: satellite_id, target_id (unique) · target_id

`satellite_test_plan`

Which satellites run a test plan.

2 columns

Column	Type	Null	Default	References
`satellite_id` PK	`bigint(20) unsigned`			`satellites` on delete cascade
`test_plan_id` PK	`bigint(20) unsigned`			`test_plans` on delete cascade

Indexes: test_plan_id