Setting Foreign Keys to Null on Delete (038)

CREATE TABLE photos ( id SERIAL PRIMARY KEY, url VARCHAR(200), user_id INTEGER REFERENCES users(id) );

INSERT INTO photos (url, user_id) VALUES ('http:/one.jpg', 4), ('http:/two.jpg', 1), ('http:/25.jpg', 1), ('http:/36.jpg', 1), ('http:/754.jpg', 2), ('http:/35.jpg', 3), ('http:/256.jpg', 4);

DONATE TO THE SHOW!!! Donate any amount - https://bit.ly/2XmweLc

About Daniel Cortes: Daniel Cortes has been building complex JavaScript front ends for top organizations in the South for the past five years. With an innate ability to simplify complex topics, Daniel has been mentoring engineers on the job.

He also started the urban farm Microurb Farms in 2017. His mission with Microurb Farms is to show others how they can grow a lot of food on a small plot of land and even making a living from it if you so desire right from your own backyard.

Music commonly used on this channel:

Sweeps - https://www.youtube.com/c/SweepsBeats http://birocratic.com / @birocratic http://www.davidcuttermusic.com / @dcuttermusic www.otismacmusic.com / @OtisMacMusic ... https://www.youtube.com/watch?v=6Ikwrxn4aWs