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 |