Hello, I have the following structure:
people ------------- | id | name | ------------- | 1 | John | | 2 | Mary | ------------- cities ---------------- | id | city | ---------------- | 1 | Glasgow | | 2 | Madrid | | 3 | Berlin | ---------------- travel_expenditures ----------------------------------------------- | id | date | id_people | id_city | per_diem | ----------------------------------------------- | 1 | 05.08 | 1 | 1 | 1.600 | | 2 | 05.09 | 2 | 3 | 2.000 | | 3 | 06.12 | 1 | 2 | 1.000 | ----------------------------------------------- The `people` and `cities` tables aren't going to be very populated, so a thought to merge them into something like this: central_data ----------------------- | id | name | type | ----------------------- | 1 | John | P | | 2 | Glasgow | C | | 3 | Mary | P | | 4 | Madrid | C | | 5 | Berlin | C | ----------------------- where central_data.type is P for people and C for cities. Do you think it is a good ideea ? -- Best regards, Ciprian Trofin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
