userTb

Table actions Table actions

5 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: password, level_id, phone, phone_bind, email, email_bind, enable, username_locked, github_id, 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  
23 leedreamer2 leedreamer2 888 free 2 13424452443 T 2026-05-14 19:16:37 T T lucy     1c2c6a299a8e0913d34346c376cf0f53  
24 lsc bb   free 2 18028603140 T 2026-05-15 21:44:39 T T lucy     fdffea9011eb003a8e1d76ea8937c5ad  
25 leedreamer4gmail leedreamer   free 2     2026-05-20 23:02:33 F F lucy     ee9b2faa381847e5bb923de9572fdd22 260185721
26 leedreamer4gmail1 国际李 92925488b28ab12584ac8fcaa8a27a0f497b2c62940c8f4fbc8ef19ebc87c43e free 2     2026-05-20 23:50:17 T F lucy     69838fbc676847408e2ad46bc35aa4c3 260185721

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