teamNoteTb

Table actions Table actions

2 rows where author_id = 24

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ team_id author_id content tags created_at updated_at enable pinned comment folder_id locked_by position
10053 5 5 24 24 我是 李上b [] 2026-05-15 21:46:26 2026-05-15 21:46:37 F F       0
10054 5 5 24 24   [] 2026-05-16 12:37:55 2026-05-16 12:37:55 F F       0

Advanced export

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

CSV options: 

CREATE TABLE teamNoteTb (
    id        INTEGER PRIMARY KEY AUTOINCREMENT,
    team_id   INTEGER NOT NULL REFERENCES teamTb(id),
    author_id INTEGER NOT NULL DEFAULT 1 REFERENCES userTb(id),
    content   TEXT    NOT NULL DEFAULT '',
    tags      TEXT    NOT NULL DEFAULT '[]',
    created_at TEXT   NOT NULL DEFAULT (datetime('now','localtime')),
    updated_at TEXT   NOT NULL DEFAULT (datetime('now','localtime')),
    enable    TEXT    NOT NULL DEFAULT 'T',
    pinned    TEXT    NOT NULL DEFAULT 'F',
    comment   TEXT    NOT NULL DEFAULT ''
, folder_id INTEGER DEFAULT NULL, locked_by INTEGER DEFAULT NULL, position INTEGER DEFAULT 0);