arrow_backward All Templates

Users template

A table of users for a website or app
Open in Table Builder

Columns

add
Name
Type
Nullable
Default Value
Comment
Primary
id
autoincrement
(NULL)
(NULL)
first_name
varchar(255)
(NULL)
(NULL)
last_name
varchar(255)
(NULL)
(NULL)
email
varchar(255)
(NULL)
(NULL)
created_at
timestamp
NOW()
(NULL)
updated_at
timestamp
NOW()
(NULL)

Generated SQL

content_copyCopy
create table "users" (
  "id" serial primary key,
  "first_name" varchar(255) null,
  "last_name" varchar(255) null,
  "email" varchar(255) not null,
  "created_at" timestamp not null default NOW(),
  "updated_at" timestamp not null default NOW()
)