Схема базы данных¶

START TRANSACTION;

DO $EF$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM pg_namespace WHERE nspname = 'jwks') THEN
        CREATE SCHEMA jwks;
    END IF;
END $EF$;

CREATE EXTENSION IF NOT EXISTS pg_trgm;

CREATE TABLE jwks.key_infos (
    id uuid NOT NULL,
    public_key jsonb NOT NULL,
    created_at timestamp without time zone NOT NULL,
    CONSTRAINT pk_key_infos PRIMARY KEY (id)
);
COMMENT ON TABLE jwks.key_infos IS 'Ключ. # Описание модели';
COMMENT ON COLUMN jwks.key_infos.id IS 'Идентификатор ключа, соответсвует kid. # Тип: Guid';
COMMENT ON COLUMN jwks.key_infos.public_key IS 'Публичный ключ';
COMMENT ON COLUMN jwks.key_infos.created_at IS 'Дата создания. # Тип: DateTime';

CREATE INDEX ix_key_infos_public_key ON jwks.key_infos USING gin (public_key jsonb_path_ops);


COMMIT;