Modelize tables with 2 types of Users

[niqola]

Hi,
I don’t know how to deal with some data and tables.
I have 2 types of users:
The users for whom I have information in another database and I must retrieve the data.
The users for whom I have no information in the other database and I must enter the data
I thought about this model:

My DB:

Tbl_all_Users (
User_id (PK))

Tbl_Users_not_in_the_other_db(
User_id (FK),
Name,
Adresse)

The Other DB:

Tbl_Users_in_the_other_db(
User_id (PK),
Name,
Adresse)

The relations:

Tbl_all_Users (1)---------------------------------------------------> (0 or 1) Tbl_Users_not_in_the_other_db
And the table Tbl_Users_in_the_other_db is imported from the other db


What do you think about?
Thx.

 

[lespaul]

why not just check if the user exists in the other table and if not create them?

Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

 

[niqola]

Thx leslie. But I can't modify the data in the other database, just retrieve them.

 

[lespaul]

Then maybe you should set it up so that if nothing is returned from the other database, then see if they exist in your database and if not then add them to your database. That way you only have two tables, theirs which you can't modify and yours that you can.

HTH

Leslie