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.

311 B
Raw Blame
CREATE TABLE IF NOT EXISTS tasks.sprint_user_capacity (
    sprint_id       INTEGER NOT NULL REFERENCES tasks.sprints(id) ON DELETE CASCADE,
    user_id         INTEGER NOT NULL REFERENCES tv_auth.users(id) ON DELETE CASCADE,
    hours           NUMERIC(10, 2) NOT NULL,
    PRIMARY KEY (sprint_id, user_id)
);