Nurfog
f6a3f6aedf
feat: implement PluginsPage for managing plugins with create, toggle, and delete functionalities feat: create PedagogicalAnalyticsPage for displaying course analytics including quality metrics, discrimination index, and curricular suggestions Co-authored-by: Copilot <copilot@github.com>
12 lines
557 B
SQL
12 lines
557 B
SQL
CREATE TABLE IF NOT EXISTS lesson_collaborative_canvases (
|
|
lesson_id UUID PRIMARY KEY REFERENCES lessons(id) ON DELETE CASCADE,
|
|
organization_id UUID NOT NULL REFERENCES organizations(id) ON DELETE CASCADE,
|
|
canvas_state JSONB NOT NULL DEFAULT '{}'::jsonb,
|
|
updated_by UUID REFERENCES users(id) ON DELETE SET NULL,
|
|
updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_lesson_collaborative_canvases_org_id
|
|
ON lesson_collaborative_canvases (organization_id);
|