DB설계텀프
테이블 (14)
AttendanceHistory
- AttendanceHistoryID — INT
- EmployeeID — INT — 외래 키 → Staff.EmployeeID
- DateTime — DATETIME
- DateTimeOfLeavingWork — DATETIME
Bonus
- BonusID — INT
- EmployeeID — INT — 외래 키 → Staff.EmployeeID
- Amount — DECIMAL(10, 2)
- PaymentDate — DATE
Department
- DepartmentID — INT
- DepartmentName — VARCHAR(255)
- Head — VARCHAR(255)
EducationHistory
- EducationHistoryID — INT
- EmployeeID — INT — 외래 키 → Staff.EmployeeID
- EducationID — INT — 외래 키 → Training.EducationID
Incentives
- IncentiveID — INT
- EmployeeID — INT — 외래 키 → Staff.EmployeeID
- IncentiveAmount — DECIMAL(10, 2)
- PaymentMonth — DATE
Leave
- LeaveID — INT
- EmployeeID — INT — 외래 키 → Staff.EmployeeID
- LeaveStartDate — DATE
- LeaveEndDate — DATE
PerformanceEvaluation
- EvaluationID — INT
- EmployeeID — INT — 외래 키 → Staff.EmployeeID
- EvaluationDate — DATE
- Score — DECIMAL(5, 2)
Position
- PositionID — INT
- PositionName — VARCHAR(255)
Project
- ProjectID — INT
- ProjectName — VARCHAR(255)
- StartDate — DATE
- EndDate — DATE
ProjectParticipation
- ParticipationID — INT
- EmployeeID — INT — 외래 키 → Staff.EmployeeID
- ProjectID — INT — 외래 키 → Project.ProjectID
Salary
- SalaryID — INT
- EmployeeID — INT — 외래 키 → Staff.EmployeeID
- SalaryAmount — DECIMAL(10, 2)
Staff
- EmployeeID — INT
- Name — VARCHAR(255)
- Age — INT
- DepartmentID — INT — 외래 키 → Department.DepartmentID
- Position — VARCHAR(255)
Training
- EducationID — INT
- TrainingName — VARCHAR(255)
- EducationDay — DATE
WorkingHours
- WorkingHoursID — INT
- EmployeeID — INT — 외래 키 → Staff.EmployeeID
- WorkingStartTime — TIME
- WorkingEndTime — TIME