Design challenge

Turn an ER model into tables and add indexes.

Design challenge

The expert final begins. First challenge: design the users table with id SERIAL PRIMARY KEY, email TEXT UNIQUE, password_hash TEXT. This table feeds the whole final.

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  email TEXT UNIQUE,
  password_hash TEXT
);

Design sets up the base table.

The table users is created.

Exercise Design challenge

Create the users table with id SERIAL PRIMARY KEY, email TEXT UNIQUE, password_hash TEXT.

Show example solution

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  email TEXT UNIQUE,
  password_hash TEXT
);

Test yourself

What is used as the primary key?
- created_at
- email TEXT
- password_hash
- id SERIAL
Show answer

id SERIAL — id SERIAL is used as the primary key.
Email constraint
```
email TEXT ____
```
Show answer
```
email TEXT UNIQUE
```
Design challenge: match the terms

id

id
email

email
SERIAL

auto
UNIQUE

unique

Next lesson: Optimization challenge

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies