revocation_requests

-1 rows


Description

Each (issuer, key) pair gets a single revocation request. Individual attempts to request revocation are recorded in the type-specific tables below. You might think you’d only need one attempt to request a revocation, but systems fail, so we keep a record of every attempt, for evidence of systemic attempts to avoid receive problem reports.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
revocation_candidates.revocation_request_id revocation_candidates_revocation_request_id_fkey R
revocation_request_emails.revocation_request_id revocation_request_emails_revocation_request_id_fkey R
revocation_request_pwnedkey_p10s.revocation_request_id revocation_request_pwnedkey_p10s_revocation_request_id_fkey R
spki_fingerprint bytea 2147483647 null
issuer_id uuid 2147483647 null
issuers.id revocation_requests_issuer_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
revocation_requests_pkey Primary key Asc id
revocation_requests_spki_fingerprint_issuer_id_key Must be unique Asc/Asc spki_fingerprint + issuer_id

Relationships

Close relationships within degrees of separation