teamNoteTb

Table actions Table actions

2 rows where team_id = 2

✎ 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
10012 2 2 1 1 2对笔记 [] 2026-05-12 19:11:30 2026-05-12 19:11:36 T F asdf     0
10013 2 2 1 1 阿斯顿发斯蒂芬 [] 2026-05-12 19:11:40 2026-05-12 19:11:43 T F   22   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);