Employee Management tasks

Employee
employee_id:int(pk-Auto)
first_name
last_name:
dob
sex
primary_email
secondary_email
mobile no

Join_date

dept_id *-1
role_id *-1

permanent_address_id 1-1

current_address_id 1-1

Academic Back Ground
AcademicBackGroundId  : pk-int
Institute : Str
Affiliated University : Str
Contact Details : Address    - Contact Details(Address)
Qualification : Str
Specialization : Str
CourseStartDate : Date
Course End Date : Date
Registration Number : Str
Marks Obtained : int
Course status : Str


Academic Back Ground
Institute : Name of the Institute / College

Affiliated University : Affiliated University
Contact Details : Contact Details(Address)
Qualification : Qualification (Type of Degree)
Specialization : Specialization (Major Subject)
CourseStartDate : Course Duration (DD/MM/YYYY)
Course End Date
Registration Number : Registration Number / Enrollment No
Marks Obtained : Marks Obtained / Class Obtained
Course status : Course Completed (Yes / No)





Mhshwari :-
-------------------
SalaryOfferd
Salary_Offerd_id : pk-int
emp_id : fk-int
basic  : int
house_Rent_Allowance : int
special_Allowance : int
conveyance_Allowance : int
medical_Allowance: int
company’s_contribution_to _PF : int
Incentive(performance pay) : int
pay_on(month or year) : str


Employment History
EmploymentHistoryId : pk-int
Employer : String
Agency_Details {Provide Agency Details if on Contract} :String
Location (City, State) : Str
Contact Details : Str
Employee Code  (If applicable) : Str
Employment_Start_Date (dd/mm/yyyy)
Employment_End_Date
Designation : Str
Last Salary Drawn (CTC) : int
Reason for Leaving : Str
Reporting Manager : Str
HR Manager : Str
employee_id (fk)



SalaryOfferd
Salary_Offerd_id :pk
emp_id : fk
basic
house_Rent_Allowance
special_Allowance
conveyance_Allowance
medical_Allowance
company’s_contribution_to _PF
Incentive(performance pay)
pay_on(month or year)

Project

project_id:int(pk-Auto)

project_name

project_number

location

client_id:int(fk)*-1

create_date

update_date

create()


Permision
permision_id
permision_name
module_id :int(fk- many to one)
role_id :int(fk- many to one)
create_date

update_date



Module
module_id
module_name
create_date
update_date



-------------------------------------

Client

client_id:int(pk-Auto)

client_name

create_date

updat_date

create()

getById

update()

delete()

getAll()

Neelima:-
-------------------

Salary
salary_id
employee_id *-1
salary_month
Salary_date
create_date
update_date
create()
getById()
update()
delete()
getAll()

Leave

leave_id:int(pk-Auto)

leave_status_id:int(fk) *-1

leave_type_id:int(fk) *-1

leave_from:date

leave_to:date

create_date:date

update_date:date

create()

getById() update()

Rekha :-

EmployeeStatus

employee_status_id

employee_status

create_date

update_date

create()

getById()

update()

delete()

getAll()

Swatha:-

Employee
employee_id : in (pk)
dept_id
role_id
first_name
last_name
dob
sex
primary_email
secondary_email
mobile no
Join_date
bank_details_id
permanent_address_id
current_address_id
create_date
update_date
employee_status_id: fk (many to one)
mobile_no

manager_id 1-*

                                                 




EmployeeStatus
employee_status_id   : int (pk)
employee_status
create_date
update_date
create()
getById()
update()
delete()
getAll()

Archive :-


EmployeeController :-

Bank Details (Rekha ) :


1.create -post

BankDetails

bank_details_id(pk, Auto incement)

name-s

account_number-int

ifsc_code-s

create_date-date

update_date-date

create()

getById()

update()

delete()

getAll()

-----------------

LeaveStatus

leave_status_id

leave_satus_name

create_date

updat_date

Address
address_id
address
city
State
Country
pincode
create_date
updat_date

10-3-2018  LeaveType(Neelima):-

create()

getById()

update()

delete()

getAll()

Table:- LeaveType

leave_type_id

leave_type_name

create_date

updat_date

Role(maheshwari) :

getAllDepartments()-get

deleteDeparment(deptId)-delete
updateDepartment(deptId, Department)-put

Deparment (neelima) :-

deleteDeparment(deptId)-delete
updateDepartment(deptId, Department)-put
getAllDepartments()-get