openapi.authen_attempt_log

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
request_id PK	`text`	No
attempt_time	`timestamp with time zone`	No	now()
ip_addr	`inet`	Yes
cred_user	`text`	Yes
token	`text`	Yes

request_id PK

text

attempt_time

timestamp with time zone

now()

ip_addr

inet

Yes

cred_user

text

Yes

token

text

Yes

(request_id)

Index Method Definition

Index	Method	Definition
`authen_attempt_log_pkey` PK	btree	`CREATE UNIQUE INDEX authen_attempt_log_pkey ON openapi.authen_attempt_log USING btree (request_id)`
`authen_cred_user_attempt_time_idx`	btree	`CREATE INDEX authen_cred_user_attempt_time_idx ON openapi.authen_attempt_log USING btree (attempt_time, cred_user)`
`authen_ip_addr_attempt_time_idx`	btree	`CREATE INDEX authen_ip_addr_attempt_time_idx ON openapi.authen_attempt_log USING btree (attempt_time, ip_addr)`

authen_attempt_log_pkey PK

btree

CREATE UNIQUE INDEX authen_attempt_log_pkey ON openapi.authen_attempt_log USING btree (request_id)

authen_cred_user_attempt_time_idx

btree

CREATE INDEX authen_cred_user_attempt_time_idx ON openapi.authen_attempt_log USING btree (attempt_time, cred_user)

authen_ip_addr_attempt_time_idx

btree

CREATE INDEX authen_ip_addr_attempt_time_idx ON openapi.authen_attempt_log USING btree (attempt_time, ip_addr)