Customer Database

[David Ilvedson]

I think it's too complicated...KISS is my motto...

David Ilvedson, RPT
Pacifica, CA  94044

----- Original message ----------------------------------------
From: Kerry <kkean at neo.rr.com>
To: "Pianotech List" <pianotech at ptg.org>
Received: 4/16/2008 7:38:54 AM
Subject: RE: Customer Database


>That's an interesting and useful design, thanks for sharing it Scott. The
>one thing I would suggest changing is the relationship between Bookings and
>Invoices which I believe needs to be many-to-many, using an intermediate
>table, since one invoice normally can involve more than one appointment. 

>Kerry Kean




>-----Original Message-----
>From: Scott Jackson [mailto:scottwaynejackson at hotmail.com] 
>Sent: Tuesday, April 15, 2008 12:00 PM
>To: Pianotech List
>Subject: Re: Customer Database

>If anyone is developing their own database, there is a data model (schema)
>available at:
>http://www.databaseanswers.org/data_models/piano_tuners/index.htm
>http://www.databaseanswers.org/data_models/piano_tuners/piano_tuners_with_at
>tributes_print_version.htm

>This design was at the request of Robin Stevens, and made available to
>members of the Australasian Piano Tuners Ass. Robin may care to comment on
>it's usefulness or otherwise.

>Scott Jackson


>----- Original Message ----- 
>From: Michelle Smith
>To: 'Pianotech List'
>Sent: Saturday, April 12, 2008 11:01 PM
>Subject: Customer Database

>Hi guys.  I've been talking to my brother-in-law (who is a programmer) about
>creating a customer database for my business.  It would of course have all
>the usual fields concerning customer information, piano information and date
>the piano was last tuned.

>Has anyone seen a piece of software like this?  I don't want to reinvent the
>wheel.