openapi.endpoint_param

↑ openapi schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('openapi.endpoint_param_id_seq'::regclass)

endpoint FK

text

No

→ openapi.endpoint(operation_id)

name

text

No

required

boolean

No

false

in_part

text

No

'query'::text

fm_type

text

Yes

schema_type FK

text

Yes

→ openapi.json_schema_datatype(name)

schema_format FK

text

Yes

→ openapi.json_schema_format(name)

array_items FK

text

Yes

→ openapi.json_schema_datatype(name)

default_value

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

array_items

openapi.json_schema_datatype(name)

NO ACTION

NO ACTION

No

endpoint_param_array_items_fkey

endpoint

openapi.endpoint(operation_id)

CASCADE

CASCADE

No

endpoint_param_endpoint_fkey

schema_format

openapi.json_schema_format(name)

NO ACTION

NO ACTION

No

endpoint_param_schema_format_fkey

schema_type

openapi.json_schema_datatype(name)

NO ACTION

NO ACTION

No

endpoint_param_schema_type_fkey

Unique Constraints

  • endpoint_and_name_once: (endpoint, name)

Check Constraints

  • array_items_requires_array_type: CHECK

  • endpoint_param_in_part_check: CHECK in_part = ANY (ARRAY['path'::text, 'query'::text, 'header'::text, 'cookie'::text])

  • endpoint_param_name_check: CHECK name ~ '^\w+$'::text

  • format_requires_type: CHECK

Indexes

Index Method Definition

endpoint_param_pkey PK

btree

CREATE UNIQUE INDEX endpoint_param_pkey ON openapi.endpoint_param USING btree (id)

endpoint_and_name_once UNIQUE

btree

CREATE UNIQUE INDEX endpoint_and_name_once ON openapi.endpoint_param USING btree (endpoint, name)
Previous
Next