식별관계 수정 prompt

테이블 (10)

Cus_Eval

  • Cus_Eval_id — 기본 키 — NOT NULL
  • Project_id — 외래 키 → Project.Project_id — NOT NULL
  • work_score
  • work_comment
  • communication_score
  • communication_comment
  • Employee_number — 외래 키 → Employee.Employee_number — NOT NULL
  • Customoer_id — 외래 키 → Customer.Customoer_id — NOT NULL

Customer

  • Customoer_id — 기본 키 — NOT NULL
  • Customer_name

Dept

  • Dept_id — 기본 키 — NOT NULL
  • Dept_name

Emp_Eval

  • Emp_Eval_id — 기본 키 — NOT NULL
  • Project_id — 외래 키 → Project.Project_id — NOT NULL
  • work_score
  • work_comment
  • communication_score
  • communication_comment
  • Eval_id — 외래 키 → Employee.Employee_number — NOT NULL
  • Employee_number — 외래 키 → Employee.Employee_number — NOT NULL

Emp_Proj

  • Emp_Proj_id — 기본 키 — NOT NULL
  • Role_id — 외래 키 → Role.Role_id — NOT NULL
  • Employee_number — 외래 키 → Employee.Employee_number — NOT NULL
  • Dept_id — 외래 키 → Employee.Dept_id — NOT NULL
  • part_start_date
  • part_end_date
  • Project_id — 외래 키 → Project.Project_id — NOT NULL

Employee

  • Employee_number — 기본 키 — NOT NULL
  • Dept_id — 외래 키 → Dept.Dept_id — 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
  • Dept_id — 외래 키 → Employee.Dept_id — NOT NULL
  • manager_position

PM_Eval

  • PM_Eval_id — 기본 키 — NOT NULL
  • Project_id — 외래 키 → Project.Project_id — NOT NULL
  • work_score
  • work_comment
  • communication_score
  • communication_comment
  • Eval_id — 외래 키 → Employee.Employee_number — NOT NULL
  • Employee_number — 외래 키 → Employee.Employee_number — NOT NULL

Project

  • Project_id — 기본 키 — NOT NULL
  • project_name
  • start_date
  • end_date
  • Customoer_id — 외래 키 → Customer.Customoer_id — NOT NULL
  • budget
  • project_organization

Role

  • Role_id — 기본 키 — NOT NULL
  • Role_name