Create
Query
cards.db
—
users
audit_log
cards
email_verification_tokens
invitations
migrations
organisation_settings
organisations
password_reset_tokens
sqlite_sequence
user_settings
users
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into users
id
Primary key.
TEXT
email
TEXT NOT NULL
password_hash
TEXT NOT NULL
organisation_id
TEXT
role
TEXT (default 'member')
email_verified
INTEGER (default 0)
created_at
DATETIME (default CURRENT_TIMESTAMP)
updated_at
DATETIME (default CURRENT_TIMESTAMP)
Insert
Cancel