MySQL Forums
Forum List  »  MySQL Workbench

How can I Make this is Workbench
Posted by: Felipe lisbao
Date: July 08, 2009 06:31AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
How can I Make this is Workbench
2699
July 08, 2009 06:31AM


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.