Relational DB

[CliffLandin]

I am quite new to relational database programming and I have a quick question.I have created a table that contains job information. The main id is the jobid which is SERIAL. I also have a table that contains photos for each job. They are associated with the job by the jobid.

My question is "If I delete a job, does the jobid for jobs after the deleted job in the table stay the same?"

In other words,"Will the photos for job 6 still be associated with job 6 after I delete job 3?"

I know this is pretty basic, but I just don't want to put a bunch of work into this to have to change it.

When in doubt, go flat out!

http://www.soprisinteractive.com

 

[ceco]

if you execute DELETE FROM jobs WHERE jobid = 3
only the rows with jobid = 3 are delete, and no other modifications are made to the table (except if you have defined triggers, or rules)

you can see the idea behind FOREIGN KEYS so the the pictures for the job are deleted either (which is different from the question)

 

[CliffLandin]

Ah, thanks so much. I will look into FOREIGN KEYS.

When in doubt, go flat out!

http://www.soprisinteractive.com