linkTb

Table actions Table actions

4 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: from_note_id, created_at (date)

id ▼ from_note_id to_note_id user_id created_at
9 30 316 1 2026-05-16 03:13:55
10 30 303 1 2026-05-16 03:13:59
13 335 328 1 2026-05-16 21:41:32
14 335 327 1 2026-05-16 21:41:34

Advanced export

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

CSV options: 

CREATE TABLE linkTb (
                id          INTEGER PRIMARY KEY AUTOINCREMENT,
                from_note_id INTEGER NOT NULL,
                to_note_id   INTEGER NOT NULL,
                user_id      INTEGER NOT NULL,
                created_at   TEXT NOT NULL DEFAULT (datetime('now','localtime')),
                UNIQUE(from_note_id, to_note_id)
            );
CREATE INDEX idx_link_from ON linkTb(from_note_id, user_id);