Learn how to create a table using the most widely-used data types (serial, varchar, integer, float, boolean, and date), and the most necessary constraints (NOT NULL and primary key).

 

CREATE TABLE directors (  id SERIAL PRIMARY KEY,  name VARCHAR(100) UNIQUE NOT NULL);CREATE TABLE movies (  id SERIAL PRIMARY KEY,  title VARCHAR(100) NOT NULL,  release_date DATE,  count_stars INTEGER,  director_id INTEGER);