Table Design

Document Sample
Table Design Powered By Docstoc
					Data Base Design

DATABASE DESIGN

TABLE NAME USERS_LIST AM_APP_MAST CALL HISTORY GM_EMP CALLS_CLOSED CALLS_TEST CALLS_READY AM_USER_DEALER_MASTER_TEMP CALLS_DEPLOYED CALLS_IT AM_ DEALER _LOC_TEMP CALLS_LOGGED

DESCRIPTION User List To Hold the Module and Form Name To Maintain History of the Call To Hold the Employee Names of Dealers All Closed Calls Call Under Test Status Call Under Ready Status Dealer User Mapping Call Ready for deployment Call in IT Status Dealer Information Call Logging Information

Table Name: USERS_LIST Field Name UserName Password ModuleAssigned Email ModuleLeadEmail FullName Role UserType Data Type nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar Description Name of the Company Employee Unique Password to every Employee What are the modules assigned to Employee Email of the Employee Name of the Module Leader Full name of the Employee Role of the Employee Type of the User

Table Name: AM_APP_MAST Field Name MODULE_NAME APP_TYPE APP_TITLE Data Type nvarchar nvarchar nvarchar Description Unique name for every Module Refers Type of the Application Refers Title of the Application

Support Desk

Data Base Design

Table Name: CALL HISTORY Field Name Call ID Status ModifiedBy ModifiedDate Data Type nvarchar nvarchar Nvarchar Date\Time Description Unique Identification for every Call Status of the Call Call Modifier of the Employee Call modified date

Table Name: GM_EMP Field Name Dealer_Map_cd EMP_NAME LOC_CD Data Type nvarchar nvarchar nvarchar Description Unique Identification for every Dealer Employee Name Description of enquiry

Table Name: CALLS_CLOSED Field Name CallsID CloseDate ClosedBy ModifiedDate Remarks Data Type nvarchar Date\Time Nvarchar Date\Time Nvarchar Description Unique Identification for every calls Closing date of the Calls Name of the Employee Modified Date of the Calls Remarks about the Calls

Table Name: CALLS_TEST Field Name CallID ExpectedResult Status Remarks ModifiedBY ModifiedDate Data Type nvarchar nvarchar nvarchar nvarchar nvarchar Date\Time Description Unique Identification for every Calls Refers the Expected result of the calls Refer the Status of the Every Call Remarks about the Calls Call Modifier of the Employee Call modified date

Support Desk

Data Base Design

Table Name: CALLS_READY Field Name CallID FromDate ToDate NoOfHours ScriptName ModifiedBy ModifiedDate Data Type nvarchar Date\Time Date\Time Date\Time nvarchar nvarchar Date\Time Description Unique Identification for every Call Calls starting date Calls closing date Numbers of Hours for each calls processing Name of the Script used in particular call Call Modifier of the Employee Call modified date

Table Name: AM_USER_DEALER_MASTER_TEMP Field Name PARENT_GROUP USER_ID DEALER_MAP_CD ROLE_CD DEALER_TYPE LOC_CD CREATED_BY COMP_CODE PRIMARY_LOCN_YN Data Type nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar Description Refer the Parent of the Group Unique Identification of every User Refers the Dealers Location Role of the User Type of the Dealer Refers the Dealers Location Name of the Creator Refers the Company code Refer Location of the every Dealer

Table Name: CALLS_DEPLOYED Field Name CallID DeployedDate SentTo ModifiedBy ModifiedDate Data Type nvarchar Date/Time nvarchar nvarchar Date\Time Description Unique Identification for every Call Refers the Deployed Date of the Call Refers the Client\Employee Address Call Modifier of the Employee Call modified date

Support Desk

Data Base Design

Table Name: CALLS_IT Field Name CallID ImpactDate DesignDesc ModifiedBy ModifiedDate Data Type nvarchar Date/Time nvarchar nvarchar Date\Time Description Unique Identification for every Call Refers the Impact Date of the Call Refers the design description of the call Call Modifier of the Employee Call modified date

Table Name: AM _DEALER_LOC _TEMP Field Name PARENT_GROUP DEALER_MAP_CD LOC_CD DEALER_NAME DEALER_ADDRESS1 LOC_DESC NETWORK1 NETWORK2 SUBNET FROM_HOST TO_HOST MUL_DEALER_CD DEALER_SUPER_USER_MAIL_IN Data Type nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar Description Refer the Parent of the Group Refers the Dealers Location Refers the Unique ID Dealers Location Refers the Dealers Name Refers the Dealers Address Refers the Dealers Location Description Refers the Dealer Network1 Refers the Dealer Network2 Refers the Dealer Subnet Dealers from Host Address Dealers to Host Address Dealers Identification Dealers Mail ID

Support Desk

Data Base Design

Table Name: CALLS_LOGGED Field Name CallID CallType ModuleName FormName Classification Reported Impact ProblemDesc FileName ContactPerson ContactNo EmailID DMSUserID Status MapCode LocCode CreatedDate CreatedBy PopShown AssignedTo WiproResponse MulPriority MulResponse EffortEstimated EffortActual ScheduleDatebaselined ScheduleDaterevised CloseDate MrNo Source Data Type nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar nvarchar Date\Time Nvarchar Nvarchar Nvarchar Nvarchar Nvarchar Nvarchar Nvarchar Nvarchar Nvarchar Nvarchar Date\Time nvarchar nvarchar Description Unique Identification for every Call Type of the Call Name of the Module Name of the form Refers Classification of the Call Refers the Report of the Call Refers Impact of the particular Call Refers the Problem Description Name of the File Name of Contact Person Contact Number of the Person E-Mail ID of the Person Unique Identification for every DMS User Status of the Calls Refers the Dealers Code Refers the Dealers Location Refers the Application create Date Name of the person Refers Name of the Person Refers the Company Response Refers the Priority of the Call Refers the Response by Company Effort given to particular Module Actual Effort to particular Module Schedule of the call Schedule of the Revised Date Date of Calls Closed Refers Master Report Number Name of the Source

Support Desk


				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:160
posted:1/8/2008
language:English
pages:5