userTb

Table actions Table actions

0 rows where level_id = 3

✎ View and edit SQL

This data as json

0 records

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