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