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.

714 B
Raw Blame
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);