Hardware Sales And Service

  • Uploaded by: rajesh
  • 0
  • 0
  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Hardware Sales And Service as PDF for free.

More details

  • Words: 166
  • Pages: 2
Customer details Field Name cname sno addr mno nop rps dop war

primary key: sno Type varchar(50) bigint nchar(10) bigint int float datetime int

Description Customer name Serial Number address Mobile no Number of system purchased Rate per system Date of purchased Warranty

Employee details Field Name eid ename gen [add] pno jd qu desi exp

primary key : eid Type nvarchar(50) nvarchar(50) varchar(50) nvarchar(50) bigint datetime varchar(50) varchar(50) nvarchar(50)

Description Employee ID Employee Name Gender Address Phone number Joined date Qualification Designation Experience

Feed back Field Name Name date eid mno mih

primary key:mno Type varchar(50) datetime nvarchar(50) bigint nvarchar(MAX)

Description Name Date Email ID Mobile number May I help you

Reply Field Name eid yn mno

primary key:eid Type nvarchar(MAX) text bigint

Salary details Field Name eid ename bs cps nos tc np

Description Email ID Yes/No Mobile no primary key:eid

Type nvarchar(50) varchar(50) float float int float float

Description Employee ID Employee name Basic salary Commission Number of system Total commission Net pay

Related Documents


More Documents from ""

The Edge - Issue 1
November 2019 26
Operation Topac
October 2019 22
Fn1590870-p-wh5046
August 2019 32