folderTb

0 rows where user_id = 25

✎ View and edit SQL

This data as json

0 records

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<>'';