Web lists-archives.com

Re: table desin question




----- Original Message -----
> From: "Richard Reina" <gatorreina@xxxxxxxxx>
> Subject: table desin question
> 
> Would this be the best way to design the schema and would it be best to
> make the client ID and technician ID the same as the user ID as they relate
> to the same person?


Close enough; but I think it would be preferrable to use a unique (autoincrement) PK for all three tables; and use a referential key in client and technician to point at user.

-- 
Unhappiness is discouraged and will be corrected with kitten pictures.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql