noteTb

Table actions Table actions

1 row where folder_id = 38

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ user_id content tags created_at updated_at enable pinned folder_id comment position visibility
331 1 1 # 财务秘书 你自己分析一下 <｜DSML｜function_calls> <｜DSML｜invokename="query_ledger"> <｜DSML｜parametername="days"string="false">30</｜DSML｜parameter> <｜DSML｜parametername="direction"string="true">收入</｜DSML｜parameter> </｜DSML｜invoke> </｜DSML｜function_calls> [] 2026-05-16 02:06:38 2026-05-16 02:07:00 T F 38 38   0 public

Advanced export

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

CSV options: 

CREATE TABLE "noteTb" (
                    id INTEGER PRIMARY KEY,
                    user_id INTEGER DEFAULT NULL REFERENCES userTb(id),
                    content TEXT NOT NULL DEFAULT '',
                    tags TEXT DEFAULT '[]',
                    created_at TEXT NOT NULL DEFAULT (datetime('now','localtime')),
                    updated_at TEXT NOT NULL DEFAULT (datetime('now','localtime')),
                    enable TEXT DEFAULT 'T',
                    pinned TEXT DEFAULT 'F',
                    folder_id INTEGER DEFAULT NULL REFERENCES folderTb(id),
                    comment TEXT DEFAULT '', position INTEGER DEFAULT 0, visibility TEXT NOT NULL DEFAULT 'private');
CREATE INDEX idx_note_visibility ON noteTb(user_id, visibility, enable);