How can I Make this is Workbench
Hello..
I have this table that I named employee.
In this table I will put all th employees (very obvious huh?).
But I have a lot of tables connected to it. Like table previous_jobs and interview_date.
So I wanted to ask this:
How can I link these tables together in a relationship for when I delete a employee, the DB will delete all registries on other tables that have the same id of employee?
I tried to do that in workbench, but it didnt work.
Table employee:
id
name
email
security_number
Table previous_jobs:
id
id_emp
previous_job_name
admitted_date
out_of_job_date
Table interview_date:
id
id_emp
interview_date
Thx in advance
Subject
Views
Written By
Posted
How can I Make this is Workbench
2699
July 08, 2009 06:31AM
1719
July 13, 2009 12:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.