Table: `hosts`

Canonical host registry. Hosts are identified by full DNS name in fqdn.

legacy_id exists for compatibility with the current UI/API, but it is not the canonical identity.

Columns

Column	Type	Null	Default	Notes
`fqdn`	`TEXT`	no	none	Canonical full host name. Primary key.
`legacy_id`	`TEXT`	no	none	Short ID used by the existing UI/API. Unique.
`status`	`TEXT`	no	`'active'`	Host lifecycle state, currently `active`, `planned`, or `retired`.
`hosts_ip`	`TEXT`	no	`''`	Legacy compatibility column. The current app model keeps one canonical routable IP and mirrors it here.
`dns_ip`	`TEXT`	no	`''`	Canonical routable IP for the host. The current UI/API expose this as a single `ip` field.
`monitoring`	`TEXT`	no	`'pending'`	Monitoring state.
`notes`	`TEXT`	no	`''`	Operator notes.
`created_at`	`TEXT`	no	none	ISO UTC creation timestamp.
`updated_at`	`TEXT`	no	none	ISO UTC update timestamp.

Keys And Indexes

Primary key: fqdn
Unique key: legacy_id

Relationships

Referenced by:

host_aliases.host_fqdn
host_roles.host_fqdn
host_sources.host_fqdn
host_flags.host_fqdn
host_ssh.host_fqdn
vhosts.host_fqdn
dhcp_leases.host_fqdn
mdns_observations.host_fqdn
certificates.host_fqdn
work_order_actions.host_fqdn

Definition

CREATE TABLE IF NOT EXISTS hosts (
    fqdn TEXT PRIMARY KEY,
    legacy_id TEXT NOT NULL UNIQUE,
    status TEXT NOT NULL DEFAULT 'active',
    hosts_ip TEXT NOT NULL DEFAULT '',
    dns_ip TEXT NOT NULL DEFAULT '',
    monitoring TEXT NOT NULL DEFAULT 'pending',
    notes TEXT NOT NULL DEFAULT '',
    created_at TEXT NOT NULL,
    updated_at TEXT NOT NULL
);

Table: hosts

Columns

Keys And Indexes

Relationships

Definition

Table: `hosts`