tbls-gh-pages

user

Description

Table Definition ```sql CREATE TABLE user ( id INTEGER PRIMARY KEY AUTOINCREMENT, screen_name TEXT NOT NULL UNIQUE, password TEXT NOT NULL, email TEXT NOT NULL UNIQUE, created_at DATETIME DEFAULT CURRENT_TIMESTAMP ) ```

Columns

Name Type Default Nullable Children Parents Comment
id INTEGER   true user_profile user_status    
screen_name TEXT   false      
password TEXT   false      
email TEXT   false      
created_at DATETIME CURRENT_TIMESTAMP true      

Constraints

Name Type Definition
id PRIMARY KEY PRIMARY KEY (id)
sqlite_autoindex_user_2 UNIQUE UNIQUE (email)
sqlite_autoindex_user_1 UNIQUE UNIQUE (screen_name)

Indexes

Name Definition
sqlite_autoindex_user_2 UNIQUE (email)
sqlite_autoindex_user_1 UNIQUE (screen_name)

Relations

er

Generated by tbls