Working with NOT NULL, UNIQUE, and DEFAULT

NOT NULL

CREATE TABLE books (title VARCHAR(255) NOT NULL);

UNIQUE

CREATE TABLE employees (email VARCHAR(255) UNIQUE);

DEFAULT

CREATE TABLE users (status VARCHAR(10) DEFAULT 'active');