Table Relationship for Telephone Complaint Database

IPO

Registered User.
Local time
Today, 23:09
Joined
Mar 16, 2010
Messages
20
Guys, can you assist with a database I am creating please. A bit of background... I need to create a database that records customer complaints relating to telephone call recording failures. When a call is picked up, it records directly to a channel. However, some of the calls are routed via a preprogrammed ID which then maps to an extension - how would I relate these tables?

Best example I can give is…

Mobile/cell #346573 - calls recorded on channel 1
Landline #7653453 - calls recorded on channel 2
SkypeID JohnT linked to landline extension #875343 - calls recorded on channel 3

I assume relationships will be…

Skype > Landline > Channel
Landline > Channel
Mobile/Cell > Channel

Does the above make sense? If yes, are my tables below correct?

tblIssue: IssueID, IssueType, IssueDetails, CustomerID, UserImpactedName, DateofIssue, TimeofIssue, LandlineID, Mobile/CellID, SkypeID

tblFollowup: FollowupID, FollowupType, FollowUpDetails
tblCustomer: CustomerID, CustomerName, CustomerInfo

tblRecordChannel: ChannelID, ChannelNumber

tblLandline: LandlineID, LandlineNumber, ChannelID
tblMobile/Cell: Mobile/CellID, Mobile/CellNumber, ChannelID
tblSkype: SkypeID, SkypeName, LandlineID

tblTeam: TeamMemberID, MemberName, EmailAddress, TelephoneNumber, SiteID
tblSite: SiteID, SiteName
 
Last edited:

Users who are viewing this thread

Back
Top Bottom