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.
TypeScript graphviewkanban-boardnodejsproductivityproject-managementself-hostedtasktask-managementtask-managertodoapp
CREATE TABLE IF NOT EXISTS tasks.goals
(
id serial,
name varchar,
description varchar,
color varchar,
date_creation timestamp default now(),
owner int
constraint fr_goals_user_id
references tv_auth.users (id)
ON DELETE CASCADE,
creator_id int
constraint fr_task_creator_id
references tv_auth.users (id)
ON DELETE SET NULL,
history_section int
constraint fr_goals_history_list
references tasks.history_list (code)
ON DELETE SET NULL,
edit_date timestamp
);
CREATE UNIQUE INDEX IF NOT EXISTS goals_id ON tasks.goals (id);