Scribd
Upload
48 views2 pages

Table Design

The document describes the design of multiple database tables. The tables include: Assignment details with an EmployeeID primary key; Complaint details with a ComplaintID primary key to track complaints; CustDetails with a CustomerID primary key to store customer information; Follow up details with a CustomerID reference key to track follow ups; and Status details with a ComplaintID reference key to track complaint states. The fields, data types, sizes and descriptions are provided for each table.

Uploaded by

srini_cmag
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
48 views2 pages

Table Design

The document describes the design of multiple database tables. The tables include: Assignment details with an EmployeeID primary key; Complaint details with a ComplaintID primary key to track complaints; CustDetails with a CustomerID primary key to store customer information; Follow up details with a CustomerID reference key to track follow ups; and Status details with a ComplaintID reference key to track complaint states. The fields, data types, sizes and descriptions are provided for each table.

Uploaded by

srini_cmag
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

TABLE DESIGN

TABLE NAME PRIMARY KEY : Assignment details :Employee ID DATATYP FIELD NAME EmployeeID EmployeeName ComplaintID PerformanceStatu s E int varchar int varchar SIZE 4 50 4 50 DESCRIPTION EmployeeID EmployeeName ComplaintID PerformanceStatu s

TABLE NAME: complaint details PRIMARY KEY: ComplaintID DATATYP FIELD NAME ComplaintID Description ComplaintTim E int varchar SIZE 4 50 50 8 50 DESCRIPTION ComplaintID Description ComplaintTime ComplaintDate CustomerNam e

e varchar ComplaintDate datetime CustomerNam e varchar

TABLE NAME: CustDetails PRIMARY KEY: CustomerID DATATYP FIELD NAME CustomerID CustomerNam e Address PhoneNo E int varchar varchar numeric SIZE 4 50 50 9 DESCRIPTION CustomerID CustomerNam e Address PhoneNo

EmailID varchar 50 ContactPerson varchar 50 TABLE NAME: follow up details REFERENCE KEY: CustomerID DATATYP FIELD NAME CustomerID NoOfFollowUp LastPersonService d CustomerFeedbac k E int int varchar varchar

EmailID ContactPerson

SIZE 4 4 50 50

DESCRIPTION CustomerID NoOfFollowUp LastPersonService d CustomerFeedbac k

TABLE NAME: status details REFERENCE KEY: ComplaintID

DATATYP FIELD NAME ComplaintID StartingDate MiddleState PreFinalState FinalState E int varchar varchar varchar varchar SIZE 4 50 50 50 50

DESCRIPTIO N ComplaintID StartingDate MiddleState PreFinalState FinalState

You might also like