dmslanes/lanes

Lanes - team task boards with roles, history and an MCP endpoint for Claude and ChatGPT

• dodil-challenge
• dodil-challenge-boards

A remix template · 0 remixes · Remix dmslanes/lanes

schema.sql

-- Lanes tables. Applied once by the remix to the new bucket (DataK3, Postgres wire).
-- Natural keys chosen by the app (no SERIAL). Timestamps are ISO-8601 text.
CREATE TABLE IF NOT EXISTS workspaces (id TEXT PRIMARY KEY, name TEXT NOT NULL, created_by TEXT NOT NULL, created_at TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS memberships (id TEXT PRIMARY KEY, workspace_id TEXT NOT NULL, email TEXT NOT NULL, role TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS boards (id TEXT PRIMARY KEY, workspace_id TEXT NOT NULL, name TEXT NOT NULL, created_at TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS lists (id TEXT PRIMARY KEY, board_id TEXT NOT NULL, name TEXT NOT NULL, position BIGINT NOT NULL);
CREATE TABLE IF NOT EXISTS cards (id TEXT PRIMARY KEY, workspace_id TEXT NOT NULL, board_id TEXT NOT NULL, list_id TEXT NOT NULL, number BIGINT NOT NULL, title TEXT NOT NULL, description TEXT, assignee TEXT, due_date TEXT, labels TEXT, position BIGINT NOT NULL, created_at TEXT, updated_at TEXT, version BIGINT NOT NULL, blocked_by TEXT);
CREATE TABLE IF NOT EXISTS card_numbers (number BIGINT PRIMARY KEY, claimed_at TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS activity (id TEXT PRIMARY KEY, card_id TEXT NOT NULL, board_id TEXT NOT NULL, actor TEXT NOT NULL, happened_at TEXT NOT NULL, action TEXT NOT NULL, changes TEXT);