noteShareTb

0 rows where note_id = 303

✎ View and edit SQL

This data as json

0 records

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);