north-scape/relayboard

Relayboard: accessible team boards with audited actions, dependency maps, and shared web/MCP use cases.

• dodil-challenge
• dodil-challenge-boards

A remix template · 0 remixes · Remix north-scape/relayboard

schema.sql

-- Fresh remix schema. Keys are application-generated UUID strings; no sequences.
CREATE TABLE IF NOT EXISTS boards (
 id TEXT PRIMARY KEY,
 title TEXT NOT NULL,
 owner_email TEXT NOT NULL,
 revision INTEGER NOT NULL DEFAULT 0,
 created_at TIMESTAMP
);
CREATE TABLE IF NOT EXISTS memberships (
 id TEXT PRIMARY KEY,
 board_id TEXT NOT NULL,
 email TEXT NOT NULL,
 role TEXT NOT NULL CHECK (role IN ('member', 'viewer'))
);
CREATE TABLE IF NOT EXISTS cards (
 id TEXT PRIMARY KEY,
 board_id TEXT NOT NULL,
 list_name TEXT NOT NULL CHECK (list_name IN ('To do', 'Doing', 'Done')),
 title TEXT NOT NULL,
 assignee TEXT,
 due_date DATE,
 description TEXT NOT NULL,
 labels TEXT NOT NULL,
 blocked_by TEXT NOT NULL,
 revision INTEGER NOT NULL,
 checklist TEXT NOT NULL DEFAULT '[]',
 updated_at TIMESTAMP
);
CREATE TABLE IF NOT EXISTS activity (
 id TEXT PRIMARY KEY,
 board_id TEXT NOT NULL,
 card_id TEXT,
 actor TEXT NOT NULL,
 action TEXT NOT NULL,
 changes TEXT NOT NULL,
 event_at TIMESTAMP
);