Now, if we try to insert to movies table some new data which contains director_id is not inside directors table, it will report error
[PostgreSQL] Use Foreign Keys to Ensure Data Integrity in Postgres
标签：post new ted direct har about pos cto table
[PostgreSQL] Use Foreign Keys to Ensure Data Integrity in Postgres
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 REFERENCES directors(id)
);