首页 > 代码库 > [PostgreSQL] Use Foreign Keys to Ensure Data Integrity in Postgres
[PostgreSQL] Use Foreign Keys to Ensure Data Integrity in Postgres
Every movie needs a director and every rented movie needs to exist in the store. How do we make sure something in another table exists before inserting new data? This lesson will teach us about foreign keys and references.
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 REFERENCES directors(id));
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
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。