On 2015/08/12 09:42, Johan De Meersman wrote:
- Original Message -
>From: "Richard Reina"
>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
- Original Message -
> From: "Richard Reina"
> 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?
I am ceating a database application with two different types of users,
clients and technicians. Both types of users have to create and account in
which they become "users". From there they can become clients or
technicians or perhaps even both. Since each type describe different
attributes -- use