proxy_pool


Description

{“what”:“Registry of proxy servers with connection details and status.”,“why”:“Without it, the system lacks a source of proxy endpoints for routing traffic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:41.579463214+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()

{“what”:“Unique UUID assigned to each proxy entry; primary key.”,“why”:“Without it, rows cannot be uniquely identified for updates, deletion, or referencing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:41.752500502+00:00”}

host text 2147483647 null

{“what”:“Hostname or IP address of the proxy server.”,“why”:“Without it, the proxy endpoint is unknown and cannot be used for connections.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:41.867126494+00:00”}

port int4 10 null

{“what”:“TCP port number on which the proxy listens.”,“why”:“Without it, the connection cannot be established to the correct service port.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:41.980912752+00:00”}

protocol text 2147483647 'socks5'::text

{“what”:“Proxy protocol type, e.g., socks5 or http; default socks5.”,“why”:“Without it, the client does not know how to speak to the proxy; handshake fails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:42.051037738+00:00”}

username text 2147483647 √ null

{“what”:“Username for proxy authentication, if required.”,“why”:“Without it, proxies requiring authentication cannot be used; only open proxies work.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:42.080639622+00:00”}

password text 2147483647 √ null

{“what”:“Password for proxy authentication, paired with username.”,“why”:“Without it, authentication fails for proxies that require a password.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:42.103561739+00:00”}

country text 2147483647 √ null

{“what”:“Country code or name indicating the proxy’s geographic location.”,“why”:“Without it, cannot filter proxies by region for geo-targeted requests.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:42.175039271+00:00”}

provider text 2147483647 √ null

{“what”:“Name of the service or vendor that supplies the proxy.”,“why”:“Without it, cannot attribute costs or reliability issues to a specific provider.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:42.206075590+00:00”}

enabled bool 1 true

{“what”:“Flag indicating whether the proxy is currently usable; true by default.”,“why”:“Without it, disabled proxies would still be selected, causing connection failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:42.231871062+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp (with time zone) when the proxy entry was added.”,“why”:“Without it, cannot track proxy age or audit when entries were introduced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:42.257487448+00:00”}

Indexes

Constraint Name Type Sort Column(s)
proxy_pool_pkey Primary key Asc id
proxy_pool_host_port_key Must be unique Asc/Asc host + port

Relationships