Anyone have some good ideas to add to a helpdesk database design?

Here is what I have so far.  Any ideas for any database entries that would be helpful for Issue Tracking and Management being able to see what is going on?  Or ideas that would help being able to search for known issues by adding changing things?  Also any ideas on a better way to structure the DB is welcome as well.

ISSUE            
            
IID            ISSUE ID
CID_COMPANY            CUSTOMER WITH ISSUE
CID_CONTACT            CONTACT ID
PID            ID OF PRODUCT WITH ISSUE
TYPE            ISSUE TYPE (INSTALLATION, PROGRAMMING, CONNECTIVITY, ETC)
OPENED            DATE
ISSUE_PRIORITY            LOW/MED/HIGH
ISSUE_CONTENT            TEXT
BID            
RID            RESPONSE ID'S
CLOSED            NULL OR DATE
            
            
COMPANY            
            
CID            COMPANY ID
NAME            COMPANY NAME
PHONE            
ADDRESS            
EMAIL            
CREATED_CUSTOMER            DATE
            
            
CONTACT            
            
CID            CONTACT ID
ROLE            CONTACT ROLE (MANAGER, IT, FORKLIFT DRIVER)
FIRSTNAME            
LASTNAME            
PASSWORD            
EMAIL            
PHONE            
ADDRESS            
CREATED_CONTACT            DATE

RESPONSE            
            
            
RID            RESPONSE ID
EID_RESPONSE            EMPLOYEE USER NAME RESPONDING TO ISSUE
TEXT            
FOLLOWUP            DATE OF FOLLOWUP AS LONG AS ISSUE.CLOSED IS NOT NULL
            
            
PRODUCT            
            
PID            PRODUCT ID
MANUFACTURER            PRODUCT MANUFACTURER
MODEL            MODEL NUMBER
CN            MANUFACTURE TYPE
ITEM_ID            ORDER NUMBER
SERIAL            SERIAL NUMBER OF PRODUCT
MAC            LAN ID
MEID/ESN            CELLULAR WAN ID
OS            OPERATING SYSTEM


EMPLOYEE            
            
EID            EMPLOYEE #
NAME            EMP NAME
TYPE            HELPDESK, SALES, ENGINEER
LVL 7
bill30Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TheTullCommented:
Honestly (you may not like my input), I don't know why you're trying to reinvent the wheel here when there are so many great free open source help desk ticket systems out there already.

My favorite is OSticket (http://osticket.com/index.php).  If you really want to build your own then maybe download and install one of these freebies and reference their tables to get some ideas.  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bill30Author Commented:
I have to tie it into an existing database, is the only reason.
0
bill30Author Commented:
I will look up existing databases.  But was looking for advice on what I had set up.
0
TheTullCommented:
I see, well you had a good solid start there to your tables.  What type of database were you using?  I would still try to use something already written myself since it's generally easier that way to get a fully featured system.  You might be able to tie them in easier than you think to, they mostly all have a pretty straightforward SQL back-end.  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Project Management

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.