Re: table desin question
- Date: Wed, 12 Aug 2015 14:50:23 -0400
- From: hsv@xxxxxxxx
- Subject: Re: table desin question
On 2015/08/12 09:42, Johan De Meersman wrote:
If there never are more client or technician records for one user, the
autoincrementing PK in the user table is enough, with the referential
key enough PK for each other table, too.
----- 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.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql