co
Tables (8)
Attendance
- attendance_id — INT — NOT NULL
- employee_id — INT
- date — DATE
- check_in — TIME
- check_out — TIME
Department
- department_id — INT — NOT NULL
- department_name — VARCHAR(100)
Employee
- employee_id (Key) — Primary key — NOT NULL
- employee_id — INT — NOT NULL
- first_name — VARCHAR(50)
- last_name — VARCHAR(50)
- department_id — INT
- position_id — INT
- email — VARCHAR(100)
- phone — VARCHAR(20)
- hire_date — DATE
Employee_Project
- employee_project_id — INT — NOT NULL
- employee_id — INT
- project_id — INT
- assigned_date — DATE
- role — VARCHAR(50)
Leave
- leave_id — INT — NOT NULL
- employee_id — INT
- leave_start — DATE
- leave_end — DATE
- leave_type — VARCHAR(50)
Position
- position_id — INT — NOT NULL
- position_title — VARCHAR(100)
Project
- project_id — INT — NOT NULL
- project_name — VARCHAR(100)
- start_date — DATE
- end_date — DATE
Salary
- salary_id — INT — NOT NULL
- employee_id — INT
- amount — DECIMAL(15,2)
- start_date — DATE
- end_date — DATE