Re: table desin question
- Date: Wed, 12 Aug 2015 15:42:39 +0200 (CEST)
- From: Johan De Meersman <vegivamp@xxxxxxxxx>
- Subject: 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