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.

467 B
Raw Blame
import { integer, pgSchema, timestamp, jsonb } from "drizzle-orm/pg-core";
import { sql } from "drizzle-orm";

export const GraphRelationsSchema = pgSchema('tasks').table('task_relations', {
    id: integer().primaryKey().generatedAlwaysAsIdentity(),
    fromTaskId: integer('from_task_id'),
    toTaskId: integer('to_task_id'),
    goalId: integer('goal_id'),
    nodeMetadata: jsonb('node_metadata'),
    createdAt: timestamp('created_at').default(sql`now()`),
});