openapi.endpoint

↑ openapi schema

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
operation_id PK	`text`	No
path	`text`	No
http_method	`text`	No
security	`text`	No	'bearerAuth'::text
summary	`text`	No
method_source	`text`	No
method_name	`text`	No
method_params	`text`	Yes
active	`boolean`	No	true
rate_limit FK	`integer`	Yes		→ openapi.rate_limit_definition(id)

operation_id PK

text

path

text

http_method

text

security

text

'bearerAuth'::text

summary

text

method_source

text

method_name

text

method_params

text

Yes

active

boolean

true

rate_limit FK

integer

Yes

→ openapi.rate_limit_definition(id)

Primary Key

(operation_id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`rate_limit`	openapi.rate_limit_definition(id)	NO ACTION	NO ACTION	No	`endpoint_rate_limit_fkey`

rate_limit

openapi.rate_limit_definition(id)

NO ACTION

endpoint_rate_limit_fkey

Unique Constraints

path_and_method_once: (path, http_method)

Check Constraints

endpoint_http_method_check: CHECK http_method = ANY (ARRAY['get'::text, 'put'::text, 'post'::text, 'delete'::text, 'patch'::text])
endpoint_security_check: CHECK security = ANY (ARRAY['bearerAuth'::text, 'basicAuth'::text, 'cookieAuth'::text, 'paramAuth'::text])

Indexes

Index Method Definition

Index	Method	Definition
`endpoint_pkey` PK	btree	`CREATE UNIQUE INDEX endpoint_pkey ON openapi.endpoint USING btree (operation_id)`
`path_and_method_once` UNIQUE	btree	`CREATE UNIQUE INDEX path_and_method_once ON openapi.endpoint USING btree (path, http_method)`

endpoint_pkey PK

btree

CREATE UNIQUE INDEX endpoint_pkey ON openapi.endpoint USING btree (operation_id)

path_and_method_once UNIQUE

btree

CREATE UNIQUE INDEX path_and_method_once ON openapi.endpoint USING btree (path, http_method)

Referenced By

The following tables have foreign keys pointing to openapi.endpoint (8 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
openapi.endpoint_access_attempt_log	`endpoint`	`operation_id`	`endpoint_access_attempt_log_endpoint_fkey`
openapi.endpoint_ip_rate_limit_map	`endpoint`	`operation_id`	`endpoint_ip_rate_limit_map_endpoint_fkey`
openapi.endpoint_param	`endpoint`	`operation_id`	`endpoint_param_endpoint_fkey`
openapi.endpoint_perm_map	`endpoint`	`operation_id`	`endpoint_perm_map_endpoint_fkey`
openapi.endpoint_perm_set_map	`endpoint`	`operation_id`	`endpoint_perm_set_map_endpoint_fkey`
openapi.endpoint_response	`endpoint`	`operation_id`	`endpoint_response_endpoint_fkey`
openapi.endpoint_set_endpoint_map	`endpoint`	`operation_id`	`endpoint_set_endpoint_map_endpoint_fkey`
openapi.endpoint_user_rate_limit_map	`endpoint`	`operation_id`	`endpoint_user_rate_limit_map_endpoint_fkey`