shareLinkTb

0 rows where note_id = 341

✎ View and edit SQL

This data as json

0 records

CREATE TABLE shareLinkTb (
                token        TEXT PRIMARY KEY,
                note_id      INTEGER NOT NULL REFERENCES noteTb(id) ON DELETE CASCADE,
                from_user_id INTEGER NOT NULL REFERENCES userTb(id),
                expires_at   TEXT DEFAULT NULL,
                view_count   INTEGER DEFAULT 0,
                created_at   TEXT NOT NULL DEFAULT (datetime('now','localtime'))
            );
CREATE INDEX idx_share_link_note ON shareLinkTb(note_id, from_user_id);