create table security_schemes (
  type text references security_scheme_types not null,
  description text,
  name text,
  in text references api_key_in_types,
  flow text,
  authorization_url text,
  token_url text,
  scopes 
);
comment on table security_schemes is '
  TODO: Consider making this a union type of the three different schemes (and their required fields)
';

comment on column security_schemes.name is '
  Required for apiKey
';
comment on column security_schemes.in is '
  Required for apiKey
';
comment on column security_schemes.flow is '
  Required for oauth2
';
comment on column security_schemes.authorization_url is '
  Required for oauth2
';
comment on column security_schemes.token_url is '
  Required for oauth2
';
comment on column security_schemes.scopes is '
  Required for oauth2
';