revocation_status

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

candidate_id

uuid

2147483647

√

null

revoked

bool

1

√

null

next_check_time

timestamp

29,6

√

null

time_taken_to_revoke

interval

49,6

√

null

notified_at

timestamp

29,6

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT rc.id AS candidate_id,
    (mroc.cert_status = 1) AS revoked,
        CASE
            WHEN (mroc.http_request_issued_at IS NULL) THEN '1970-01-01 00:00:00'::timestamp without time zone
            WHEN (rc.not_after < now()) THEN NULL::timestamp without time zone
            WHEN (mroc.revocation_timestamp IS NULL) THEN (mroc.http_request_issued_at + '00:01:00'::interval)
            WHEN (mroc.revocation_timestamp < (mroc.http_request_issued_at - '7 days'::interval)) THEN (mroc.http_request_issued_at + '06:00:00'::interval)
            ELSE (mroc.http_request_issued_at + ('00:01:00'::interval * (exp((0.00000973 * EXTRACT(epoch FROM (mroc.http_request_issued_at - LEAST(mroc.http_request_issued_at, mroc.revocation_timestamp))))))::double precision))
        END AS next_check_time,
        CASE
            WHEN (mroc.revocation_timestamp IS NULL) THEN ((GREATEST(srr.sent_at, rc.first_sct_time))::timestamp with time zone - now())
            ELSE (mroc.revocation_timestamp - GREATEST(srr.sent_at, rc.first_sct_time))
        END AS time_taken_to_revoke,
    srr.sent_at AS notified_at
   FROM ((revocation_candidates rc
     JOIN successful_revocation_requests srr ON ((rc.revocation_request_id = srr.id)))
     LEFT JOIN most_recent_ocsp_checks mroc ON ((mroc.revocation_candidate_id = rc.id)))
  WHERE (rc.not_after > now());

Description

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views