openapi.endpoint_access_attempt_log

Cascading Deletes: Deleting rows from this table will cascade to: actor.usr, openapi.endpoint.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
request_id PK	`text`	No
attempt_time	`timestamp with time zone`	No	now()
endpoint FK	`text`	No		→ openapi.endpoint(operation_id)
allowed	`boolean`	No
ip_addr	`inet`	Yes
accessor FK	`integer`	Yes		→ actor.usr(id)
token	`text`	Yes

request_id PK

text

attempt_time

timestamp with time zone

now()

endpoint FK

text

allowed

boolean

ip_addr

inet

Yes

accessor FK

integer

Yes

token

text

Yes

(request_id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`accessor`	actor.usr(id)	CASCADE	CASCADE	No	`endpoint_access_attempt_log_accessor_fkey`
`endpoint`	openapi.endpoint(operation_id)	CASCADE	CASCADE	No	`endpoint_access_attempt_log_endpoint_fkey`

accessor

CASCADE

endpoint_access_attempt_log_accessor_fkey

endpoint

CASCADE

endpoint_access_attempt_log_endpoint_fkey

Index Method Definition

Index	Method	Definition
`endpoint_access_attempt_log_pkey` PK	btree	`CREATE UNIQUE INDEX endpoint_access_attempt_log_pkey ON openapi.endpoint_access_attempt_log USING btree (request_id)`
`access_accessor_attempt_time_idx`	btree	`CREATE INDEX access_accessor_attempt_time_idx ON openapi.endpoint_access_attempt_log USING btree (accessor, attempt_time)`

endpoint_access_attempt_log_pkey PK

btree

CREATE UNIQUE INDEX endpoint_access_attempt_log_pkey ON openapi.endpoint_access_attempt_log USING btree (request_id)

access_accessor_attempt_time_idx

btree

CREATE INDEX access_accessor_attempt_time_idx ON openapi.endpoint_access_attempt_log USING btree (accessor, attempt_time)