Pay
ER Diagram of HR Management Database

ER Diagram of HR Management Database

Branch department

ID: Department ID

BranchName: Department name

Visage Political Face

Visage: Political Face ID

VisageName: Political Identity

AddressBook address book

ID: employee ID

Name: name

Sex: gender

Phone: mobile phone number

QQ:QQ

E Mail: mailbox

Business position

ID: Job ID

BusinessName: job title

Duthcall title

ID: Title ID

DuthcallName: Title name

Folk nation

ID: National ID

FolkName: ethnic name

Individual introduction

ID: employee ID

Text: Personal introduction

Family members

ID: Member ID

E_ID: employee ID

Name: member name

Birthday: member birthday

Relationship: Relationship

Business: Position

Visage: the political face

WorkUnit: Unit

Phone: mobile phone number

WordPad memo

ID: record ID

BlotterDate: record time BlotterSort: record type Motif: record title

Wordpa: record content

RPRecord reward and punishment record

ID: Reward and punishment record ID

EID: Employee ID

RPKind: reward and punishment category

RPDate: Grant time

QuashDate: Release time QuashReason: Release reason SealName: Auditor name

RPKind reward and punishment category

ID: Award Love Category D

RPKind: reward and punishment category

Stufflnfo employee information

ID: employee ID

StuffName: Name

Birthday: birthday

Folk: Nationality

Kultur: educational level

Marriage: Marital status

Visage: the political face

Sex: gender

IDCard: ID number

WorkDate: work date

Worklength: length of service

MonthPay: salary

BankCard: bank card number

GraduateSchool: Graduate school

Phone: mobile phone number

Speciality: major

GraduateDate: Graduation time

Photo: Photo Adress: Address

Province: Hometown Province C

ity: hometown

Branch: Department

StartPactDate: contract start time

EndPactDate: contract end time

Kultur education

ID: Education level ID

KulturName: cultural level name

User administrator

ID: Administrator ID

UserName: Administrator name Name: Administrator account

Pass: Administrator password

EducationExp education experience

ID: Educational experience ID

EID: Employee ID

StartTime: start time

EndTime: End time

EduUnit: Educational unit

EduSpeciality: Education category

WorkExp work experience

ID: Educational experience ID

EID: Employee ID

StartTime: start time

EndTime: End time

EduUnit: Educational unit

EduSpeciality: Education category

TrainNote training record

ID: Training record ID

EID: Employee ID

TrainName: Training name StartTime: Start time EndTime: End time Speciality: Training specialty TrainUnit: Training location TrainText: Training content Charge: Cost

Effect: Effect

PayRecord Pay Record

ID: Payroll ID

EID: Employee ID

PayDate: Issuance time PickName: Receiver's name GiveName: Issuer's name PayNumber: Number of wages issued

UserPope administrator rights

ID: Administrator ID

PopelD: permission ID

PopeName: permission name Pope: permission identification

n:1

n:1

n:1

n:1

1:n

1:n

1:n

1:n

n:1

n:1

n:1

1:1

n:1

1:n

ER Diagram of HR Management Database

11
0
1
publish time: 2021-03-12
Viro

Personnel management, also known as human resource management, is a series of management activities for the country or a certain department to select, use, train, evaluate, reward and punish its staff in order to achieve certain goals. This template is an ER diagram of the personnel management database for reference.

See More Related Templates

ER Diagram from Dilshan
This is an ER diagram that I made, hope you can like it!
ER Diagram from Dilshan
21
0
0
DILSHAN SACHINDRA