folderTb

Table actions Table actions

3 rows where user_id = 26

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ user_id folder parent_folder_id system_key undeletable
54 26 26 分享给我的   shared_root T
55 26 26 来自陌生人 54 shared_stranger T
56 26 26 来自好友 54 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<>'';