Scribd
Upload
113 views9 pages

Database Design: Table 1: LOGIN Descriptions

The document describes the database design for an employee management system. It outlines 17 tables with fields and data types to store information about users, jobs, employees, applications, leaves, loans, and other human resource related data. The tables are designed to link to each other through foreign keys to track entities and their relationships.

Uploaded by

ANJALI K
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
113 views9 pages

Database Design: Table 1: LOGIN Descriptions

The document describes the database design for an employee management system. It outlines 17 tables with fields and data types to store information about users, jobs, employees, applications, leaves, loans, and other human resource related data. The tables are designed to link to each other through foreign keys to track entities and their relationships.

Uploaded by

ANJALI K
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 9

DATABASE DESIGN

Table 1: LOGIN
FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
User id INT(10) Primary key User id
password VARCHAR(20) Password of user
Type VARCHAR(20) Type of user

Table 2: SECTION
FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
section id INT(10) Primary key section id
Name VARCHAR(20) Name of section
Description VARCHAR(20) Description of
sections

Table 3: JOB MASTER


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Job id INT(10) Primary key Job id
Job name VARCHAR(20) Name of job
Experience INT(10) Job experience
Qualification VARCHAR(20) Qualification of job
Salary INT(10) Salary
Section id INT(10) Foreign key Section id
Description VARCHAR(20) To store description
Status VARCHAR(20) To store status

Table 4: VACANCY
FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Vac_id INT(10) Primary key Vacancy id
Job_id INT(10) Foreign key Job id
qualification VARCHAR(20) To store
qualification
experience VARCHAR(20) To store experience
Announce date DATE Date of job
announce
Last date DATE last date of
application
No.of vacancies INT(10) Number of job
vacancies
Status VARCHAR(20) Status

Table 5: APPLICATION
FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
C id INT(10) Primary key candidate id
Name VARCHAR(20) Name of applicant
Address VARCHAR(20) Address of
applicant
Phone INT(10) Phone number
Email VARCHAR(20) To store email id
Gender VARCHAR(20) Gender of
applicant
Age INT(10) Age of applicant
Vac id INT(10) Foreign key Vacancy id
Application date DATE To store date of
application
Photo VARCHAR(20) Store photo of
applicant
Status VARCHAR(20) To store status
Table 6: EMPLOYEE
FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Emp_id INT(10) Primary key Employee id
Name VARCHAR(20) Name of employee
House name VARCHAR(20) To store address
Place VARCHAR(20) To store place of
employee
Post VARCHAR(20) Post
District VARCHAR(20) District
Pin INT(10) To store Pincode
State VARCHAR(20) To store state
DOB DATE Date of birth
Gender VARCHAR(20) Gender of
employee
Join date DATE Joining date
Photo VARCHAR(20) Photo of employee
Status VARCHAR(20) To store status

Table 7: EMPLOYEE DUTY


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Duty id INT(10) Primary key Duty id
Emp id INT(10) Foreign key Employee id
Shift no INT(10) Shift number
Allotted date DATE To store allotted
date

Table 8: EMPLOYEE JOB DETAILS


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Emp id INT(10) Primary key Employee id
Section id INT(10) Foreign key Section id
Job id INT(10) Foreign key Job id
Basic salary INT(10) To store basic
salary of job
Emp type VARCHAR(20) Type of employee
Status VARCHAR(20) To store status
Salary increment VARCHAR(20) Store salary
details increment details of
job

Table 9: SHIFT
FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Shift id INT(10) Primary key Shift id
Shift no INT(10) Shift number of
duty
Time DATETIME Time of shift
Description VARCHAR(20) To store
Description
Status VARCHAR(20) To store status

Table 10: LOAN MASTER


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Loan id INT(10) Primary key Loan id
Loan Name VARCHAR(20) Name of loan
Criteria VARCHAR(20) Loan criteria
Max limit INT(10) Maximum amount
for loan
Status VARCHAR(20) To store status

Table 11: LOAN APPLICATION


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Loan app id INT(10) Primary key Id of loan
application
Loan id INT(10) Foreign key Id of loan
Emp id INT(10) Foreign key Employee id
Request amt INT(10) Requested loan
amount
Application date DATE Date of loan
application
Sanction amt INT(10) Amount of loan
sanction
Sanction date DATE Loan sanction date
Remark VARCHAR(20) To store remark
Status VARCHAR(20) To store status

Table 12: SCHOLARSHIP


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
S id INT(10) Primary key Scholarship id
S Name VARCHAR(20) Name of
Scholarship
Criteria VARCHAR(20) Scholarship criteria
Max limit VARCHAR(20) Maximum amount
for scholarship
Status VARCHAR(20) To store status

Table 13: SCHOLARSHIP APPLICATION


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
S app id INT(10) Primary key Id of scholarship
application
s id INT(10) Foreign key Id of scholarship
Emp id INT(10) Foreign key Employee id
Application date DATE Date of scholarship
application
Requirements VARCHAR(20) To Store
requirements
Remark VARCHAR(20) To store remarks
of application
Status VARCHAR(20) To store status

Table 14: LEAVE MASTER


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Leave id INT(10) Primary key Leave id
Category VARCHAR(20) Category of leaves
No.of leave INT(10) Leave days

Table 15: LEAVE APPLICATION


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
L_app id INT(10) Primary key Id of leave
application
Emp id INT(10) Foreign key Employee id
Category name VARCHAR(20) Leave category
No.of days VARCHAR(20) Number of days of
leaves
Starting date VARCHAR(20) Starting dte of
leave
Remark DATE To store remarks of
application
Status VARCHAR(20) To store status
Table 16: EMPLOYEE LEAVE MASTER
FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
E leave id INT(10) Primary key Employee leave id
Emp id INT(10) Foreign key Employee id
Medical VARCHAR(20) To Store medical
leave
PL VARCHAR(20) To Store privilege
leave
Special VARCHAR(20) To Store special
leave
Other VARCHAR(20) Any other leaves
Year VARCHAR(20) Store Year of leave

Table 17: BONUS


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Bon_id INT(10) Primary key Bonus_id
Emp id INT(10) Employee id
Year VARCHAR(20) Store Year
Bonus amt VARCHAR(20) Bonus amount

Table 18: SALARY STATEMENT


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Emp id INT(10) Primary key Employee id

Month INT(10) Salary Month

Year INT(10) Year of salary

Basic salary INT(10) To store basic


salary
Allowance VARCHAR(20) To store allowance
Deduction VARCHAR(20) To store deduction
from salary
Net salary VARCHAR(20) To store net salary

Table 19: INTERVIEW LIST


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS

Int id INT(10) Primary key Interview id


Interview details VARCHAR(20) To store interview
details
Vacancy no INT(10) Number of job
vacancies
Location VARCHAR(20) Location of job
Job name VARCHAR(20) Name of job
Time datetime Interview time

Table 20: SELECTION LIST

FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS


Vac no INT(10) Primary key Vacancy number
Int id VARCHAR(20) Foreign key Interview id
Emp id VARCHAR(20) Employee id

Table 21: Retirement


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Ret_id INT(10) Primary key Retirement id
Emp_id INT(10) Foreign key Employee id
Join_date VARCHAR(20) Joining date of
employee
Ret_date VARCHAR(20) Retirement date
Reason VARCHAR(20) Reason

Table 21: Complaint


FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTIONS
Com_id INT(10) Primary key Complaint id
Emp_id INT(10) Foreign key
Complaint VARCHAR(20)

You might also like