prompt
Tables (10)
Cus_Eval
- Cus_Eval_id — Primary key — NOT NULL
- Project_id — Foreign key → Project.Project_id — NOT NULL
- work_score
- work_comment
- communication_score
- communication_comment
- Employee_number — Foreign key → Employee.Employee_number — NOT NULL
- Customoer_id — Foreign key → Customer.Customoer_id — NOT NULL
Customer
- Customoer_id — Primary key — NOT NULL
- Customer_name
Dept
- Dept_id — Primary key — NOT NULL
- Dept_name
Emp_Eval
- Emp_Eval_id — Primary key — NOT NULL
- Project_id — Foreign key → Project.Project_id — NOT NULL
- work_score
- work_comment
- communication_score
- communication_comment
- Eval_id — Foreign key → Employee.Employee_number — NOT NULL
- Employee_number — Foreign key → Employee.Employee_number — NOT NULL
Emp_Proj
- Emp_Proj_id — Primary key — NOT NULL
- Role_id — Foreign key → Role.Role_id — NOT NULL
- part_start_date
- part_end_date
- Employee_number — Foreign key → Employee.Employee_number — NOT NULL
- Project_id — Foreign key → Project.Project_id — NOT NULL
Employee
- Employee_number — Primary key — NOT NULL
- emp_name
- emp_resident_number
- emp_final_edu
- Dept_id — Foreign key → Dept.Dept_id — NOT NULL
- skill
- career
- emp_ID
- emp_PW
Manager
- Manager_id — Primary key — NOT NULL
- Employee_number — Foreign key → Employee.Employee_number — NOT NULL
- manager_position
PM_Eval
- PM_Eval_id — Primary key — NOT NULL
- Project_id — Foreign key → Project.Project_id — NOT NULL
- work_score
- work_comment
- communication_score
- communication_comment
- Eval_id — Foreign key → Employee.Employee_number — NOT NULL
- Employee_number — Foreign key → Employee.Employee_number — NOT NULL
Project
- Project_id — Primary key — NOT NULL
- project_name
- start_date
- end_date
- Customoer_id — Foreign key → Customer.Customoer_id — NOT NULL
- budget
- project_organization
Role
- Role_id — Primary key — NOT NULL
- Role_name