Skip to content

TaskView is a self-hosted project and task management platform focused on clarity, ownership, and control. TaskView is built for teams that want a transparent, self-hosted alternative to SaaS task managers.

613 B
Raw Blame
create table if not exists collaboration.roles (
    id serial primary key,
    name varchar not null,
    goal_id int constraint fr_colab_roles references tasks.goals (id) on delete cascade,
    created timestamptz default (now() at time zone 'UTC'),
    unique (goal_id, name),
    check (name <> '')
);

create table collaboration.permissions_to_role (
    role_id int constraint fk_colab_perm_role_id references collaboration.roles (id) on delete cascade,
    permission_id int constraint fk_colab_perm_perm_id references tv_auth.permissions (id) on delete cascade,
    primary key (role_id, permission_id)
);