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.

434 B
Raw Blame
alter table tasks.tasks add column amount numeric(10, 2);

create table if not exists tasks.transactions(
	id serial primary key,
	name varchar not null
);

insert into tasks.transactions (id, name) values (1, 'Income'), (0, 'Expense');

alter table tasks.tasks add column transaction_type int;

alter table tasks.tasks add constraint fk_task_transa foreign key (transaction_type) references tasks.transactions(id) on delete set null;