Rheebros_HR_Project

Tables (3)

Employee (employee)

  • id — INT — Primary key — NOT NULL
  • EEID — CHAR(15) — NOT NULL
  • Password (password) — VARCHAR(255) — NOT NULL
  • LastName (lastName) — VARCHAR(255)
  • MiddleName (middleName) — VARCHAR(255)
  • FirstName (firstName) — VARCHAR(255) — NOT NULL
  • hireDate — Date — NOT NULL
  • Ethnicity (rehireDate) — Date — NOT NULL
  • DateOfTerminated (terminationDate) — Date — NOT NULL
  • Position (position) — CHAR(30) — NOT NULL
  • Department (department) — CHAR(30) — NOT NULL
  • Gender (gender) — CHAR(10) — NOT NULL
  • Address (phone) — VARCHAR(255)
  • Job Status (DOLStatus) — CHAR(2) — NOT NULL
  • Permission (permission) — INT — NOT NULL
  • ETC (birthDate) — Date
  • Field (payType) — VARCHAT(10)
  • Field — CHAR(10)

Training (training)

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • DateOfUpload (dateOfUpdated) — Date
  • name (Field) — VARCHAR(255)

Training_information (employee_training)

  • id — INT — Primary key — NOT NULL
  • EEID (EE_ID) — INT — Foreign key → Employee.id — NOT NULL
  • TRID (TR_ID) — INT — Foreign key → Training.id — NOT NULL
  • result — CHAR(10)
  • Field (title) — CHAR(10)
  • Field (result_date) — Date
  • Field (deadline_date) — Date