prompt 식별관계테스트
테이블 (6)
Dept
- Dept_id — 기본 키 — NOT NULL
- Dept_name
Emp_Proj
- Emp_Proj_id — 기본 키 — NOT NULL
- Role_id — 외래 키 → Role.Role_id — NOT NULL
- part_start_date
- part_end_date
- Employee_number — 외래 키 → Employee.Employee_number — NOT NULL
- Project_id — 외래 키 → Project.Project_id — NOT NULL
Employee
- Employee_number — 기본 키 — NOT NULL
- emp_name
- emp_resident_number
- emp_final_edu
- skill
- career
- emp_ID
- emp_PW
Manager
- Manager_id — 기본 키 — NOT NULL
- Employee_number — 외래 키 → Employee.Employee_number — NOT NULL
- manager_position
Project
- Project_id — 기본 키 — NOT NULL
- project_name
- start_date
- end_date
- budget
- project_organization
Role
- Role_id — 기본 키 — NOT NULL
- Role_name