CREATE TABLE projects ( id TEXT PRIMARY KEY, channel TEXT NOT NULL ); CREATE TABLE devlogs ( id TEXT PRIMARY KEY, project_id TEXT references projects(id) ON DELETE CASCADE NOT NULL );