home / kengdb / userIntegrationTb

userIntegrationTb

Table actions Table actions
  • Edit table schema

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

id ▼ user_id source token meta_json created_at updated_at
3 1 notion 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 {} 2026-05-22 01:34:04 2026-05-22 01:34:04

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE userIntegrationTb (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                user_id INTEGER NOT NULL,
                source TEXT NOT NULL,
                token TEXT NOT NULL DEFAULT '',
                meta_json TEXT NOT NULL DEFAULT '{}',
                created_at TEXT NOT NULL DEFAULT (datetime('now','localtime')),
                updated_at TEXT NOT NULL DEFAULT (datetime('now','localtime')),
                UNIQUE(user_id, source)
            );
CREATE INDEX idx_user_integration_user ON userIntegrationTb(user_id, source);
Powered by Datasette · Queries took 1.2ms