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