userTb

Table actions Table actions

1 row where level_id = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date)

id ▼ username nickname password level_id phone phone_bind created_at enable username_locked secre persona disposition api_key github_id
1 leedreamer 小李本人 Fuckyou86416503. king 1 17520074504 T 2026-05-09T14:58:29.574354 T F lucy     759c1f60f7a04eafa0f14b0242d4bede  

Advanced export

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

CSV options: 

CREATE TABLE "userTb" (
   [id] INTEGER PRIMARY KEY,
   [username] TEXT NOT NULL,
   [nickname] TEXT NOT NULL DEFAULT '',
   [password] TEXT NOT NULL,
   [level_id] INTEGER NOT NULL DEFAULT '2' REFERENCES [userLvlTb]([id]),
   [phone] TEXT NOT NULL DEFAULT '',
   [phone_bind] TEXT NOT NULL DEFAULT '',
   [email] TEXT NOT NULL DEFAULT '',
   [email_bind] TEXT NOT NULL DEFAULT '',
   [created_at] TEXT NOT NULL DEFAULT (datetime('now','localtime')),
   [enable] TEXT DEFAULT 'T',
   [username_locked] TEXT DEFAULT 'F',
   [secre] TEXT DEFAULT 'lucy',
   [persona] TEXT DEFAULT ''
, disposition TEXT DEFAULT '', api_key TEXT DEFAULT '', github_id TEXT DEFAULT '');
CREATE INDEX idx_userTb_level_id ON userTb(level_id);
CREATE UNIQUE INDEX idx_userTb_username ON userTb(username);
CREATE UNIQUE INDEX idx_user_api_key ON userTb(api_key) WHERE api_key IS NOT NULL AND api_key<>'';
CREATE UNIQUE INDEX idx_user_phone_active ON userTb(phone) WHERE phone IS NOT NULL AND phone<>'' AND enable='T';