fssa-batch3 / fssa-batch3/sec_c_pranaw.murugesan__corejava_project_2

Employee Module | Employee Leave Details

Open
#7 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
0
Forks
1
PR merge metrics
No merged PRs in 30d

Description

- [x] Applying and approval of leaves

Only managers can approve a leave. Leave application table will have employee
applying for a leave and status is applied. Manager once approve status will change as approved

- [x] Tracking of leaves

Each leave type will have maximum leaves. CL will have 10 days,
sick leaves 5 days per year. For each employee it should show how many leaves are pending.

**employee_leave_details**
| Column | Data Type | Constraints |
|----------------|--------------|-----------------------------------------------|
| id | int | not null, auto_increment, primary key |
| employee_id | int | not null, foreign key (employee(id)) |
| leave_type | varchar(2) | not null, foreign key (leave_types(name)) |
| start_date | date | not null |
| end_date | date | not null |
| no_of_days | double | not null |
| leave_reason | varchar(100) | not null |
| status | varchar(20) | not null |
| applied_on | timestamp | default current_timestamp |
| manager_id | int | foreign key (employee(id)) |
| comments | varchar(200) | |

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.