Livoa LogoLivoa
Department


DepartmentID (PK)

DepartmentName

HOD_ID (FK)

Description

Staff


StaffID (PK)

Name

Gender

DOB

Department (FK)

Designation

Qualification

Email

ContactNo

Address

Photo

RoleID IR

Attendance


AttendanceID (PK)

StaffID (FK)

Date

Status

Principal


PrincipalID (PK)

Name

Email

ContactNo

RoleID (FK)

UserRole


RoleID (PK)

RoleName

Permissions

Staff
Report
Records
Leave_Request


Leave_ID

Form_Date

To_Date

Department
Address
Join_Date
Salary
Salary
Arresss
Name
Address
Date
Report_ID
Generated_Date
Form
To_Date

ER Diagram

by Mayur

0
0 uses