catalog_tables: declaration250, apps
This data as json
| database_name | table_name | rootpage | sql |
|---|---|---|---|
| declaration250 | apps | 63 | CREATE TABLE apps ( id TEXT PRIMARY KEY, external INTEGER NOT NULL DEFAULT 0, name TEXT NOT NULL, description TEXT NOT NULL DEFAULT '', path TEXT NOT NULL, source TEXT NOT NULL DEFAULT '', metadata TEXT NOT NULL DEFAULT '{}', actor_id TEXT, is_private INTEGER NOT NULL DEFAULT 1, stored_queries TEXT NOT NULL DEFAULT '[]', current_version INTEGER, deleted_at TEXT, deleted_actor_id TEXT, created_at TEXT NOT NULL, updated_at TEXT NOT NULL, CHECK (external IN (0, 1)), CHECK (is_private IN (0, 1)) ) |