--- targets

create table targets (
    id bigint primary key,
    project_id bigint not null references projects(id),
    "type" varchar not null,
    enabled boolean not null,

    reaction_time varchar,
    response_time varchar,
    inactivity_time varchar,

    created_at timestamptz not null,
    updated_at timestamptz not null,
    deleted_at timestamptz
);

create sequence targets_id_seq;

create unique index targets_project_ix on targets(project_id, "type");
