folderTb

Table actions Table actions

7 rows where user_id = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: folder, system_key, undeletable

id ▼ user_id folder parent_folder_id system_key undeletable
32 23 23 folder     F
33 23 23 folder     F
34 23 23 folder     F
35 23 23 folder     F
48 23 23 分享给我的   shared_root T
49 23 23 来自陌生人 48 shared_stranger T
50 23 23 来自好友 48 shared_friend T

Advanced export

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

CSV options: 

CREATE TABLE folderTb (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    user_id INTEGER NOT NULL,
    folder TEXT NOT NULL, parent_folder_id INTEGER DEFAULT NULL, system_key TEXT DEFAULT '', undeletable TEXT DEFAULT 'F',
    FOREIGN KEY(user_id) REFERENCES userTb(id)
);
CREATE UNIQUE INDEX idx_folder_user_system_key ON folderTb(user_id, system_key) WHERE system_key IS NOT NULL AND system_key<>'';