nuts-foundation/nuts-node

-- +goose ENVSUB ON
-- +goose Up
-- discovery_did_registration contains the DIDs that should be registered on the specified Discovery Service(s).
create table discovery_presentation_refresh
(
    -- service_id is the ID of the Discover Service that the DID should be registered on.
    -- It comes from the service definition.
    service_id   varchar(200) not null,
    -- subject_id is the subject that should be registered on the Discovery Service.
    subject_id   varchar(370) not null,
    -- parameters contains the registration parameters passed at activation.
    -- It is a JSON object that maps to map[string]interface{}
    parameters $TEXT_TYPE,
    -- next_refresh is the timestamp (seconds since Unix epoch) when the registration on the
    -- Discovery Service should be refreshed.
    next_refresh integer      not null,
    primary key (service_id, subject_id),
    constraint fk_discovery_presentation_refresh_service foreign key (service_id) references discovery_service (id) on delete cascade
);
-- index for the next_registration column, used when checking which registrations need to be refreshed
create index idx_discovery_presentation_refresh on discovery_presentation_refresh (next_refresh);

-- +goose Down
drop table discovery_presentation_refresh;