noteShareTb

Table actions Table actions

1 row where note_id = 342

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ note_id from_user_id to_user_id permission created_at updated_at folder_key dismissed position
2 342 342 1 1 23 23 read 2026-05-21 01:17:06 2026-05-21 01:18:00 friend T 0

Advanced export

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

CSV options: 

CREATE TABLE noteShareTb (
                id           INTEGER PRIMARY KEY AUTOINCREMENT,
                note_id      INTEGER NOT NULL REFERENCES noteTb(id) ON DELETE CASCADE,
                from_user_id INTEGER NOT NULL REFERENCES userTb(id),
                to_user_id   INTEGER NOT NULL REFERENCES userTb(id),
                permission   TEXT    NOT NULL DEFAULT 'read' CHECK(permission IN ('read','write')),
                created_at   TEXT    NOT NULL DEFAULT (datetime('now','localtime')),
                updated_at   TEXT    NOT NULL DEFAULT (datetime('now','localtime')), folder_key TEXT NOT NULL DEFAULT 'friend', dismissed TEXT NOT NULL DEFAULT 'F', position INTEGER DEFAULT 0,
                UNIQUE(note_id, to_user_id)
            );
CREATE INDEX idx_note_share_to ON noteShareTb(to_user_id, note_id);
CREATE INDEX idx_note_share_from ON noteShareTb(from_user_id, note_id);
CREATE INDEX idx_note_share_inbox ON noteShareTb(to_user_id, dismissed, folder_key);