Scribd
Upload
31 views4 pages

S. No Column Name Data Type Description Remarks: 1 Nam Number (20) Employee Name Primary Key 2 Loc Varchar (20) Location

The document describes the structure of multiple database tables, listing column names, data types, descriptions, and remarks for each table. It includes tables for employee information with columns like name, location, address, designation, and email. Other tables store data like employee IDs, names, dates of birth, addresses, and performance ratings. Additional tables track alerts, complaints, photos, and cautions issued by administrators.

Uploaded by

sonaiya software solutions
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
31 views4 pages

S. No Column Name Data Type Description Remarks: 1 Nam Number (20) Employee Name Primary Key 2 Loc Varchar (20) Location

The document describes the structure of multiple database tables, listing column names, data types, descriptions, and remarks for each table. It includes tables for employee information with columns like name, location, address, designation, and email. Other tables store data like employee IDs, names, dates of birth, addresses, and performance ratings. Additional tables track alerts, complaints, photos, and cautions issued by administrators.

Uploaded by

sonaiya software solutions
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/ 4

S.

Column Data type Description Remarks


No Name

Employee name Primary


1 nam Number(20) Key

2 Loc Varchar(20) Location

3 Add Varchar(1000) Address

4 Des Varchar(20) Designation

5 Email Varchar(30) Email ID of user

6 Joi date Date Joining date

S. No Column Data type Description Remarks


name
Primary Key
1 E id Number(20) Employee f ID

2 Name Varchar(20) Name of employee

3 Alias Varchar(30) Other name


name

4 DOB date Date of birth

5 Address Varchar(40) Address of the criminal

6 Reward Number(20) Performance of the employee

7 Status Varchar(30)` Status of the employee

S. Column Data type Description Remarks


No name
1 Alert Varchar(60) Alert message given
By the Administrator

S. Column Data type Description Remarks


No name
1 Alert Varchar(60) Alert message given
By the Administrator

S. No Column name Data type Description Remarks


1 cid Number(20) Complaint Identification
Number
2 Admin Varchar(30) Caution given by the
Caution Administrator to the
given complaint

S. Column Data type Description Remarks


No name
1 Photo Varchar(30) Path of the
photo
stored

S. No Column name Data type Description Remarks


1 Identity Number(20) Employee Identification
Number
2 Admin Varchar(30) Caution given by the
Caution Administrator to the
given complaint

You might also like