Database structure advice needed

pc · 2018-01-23, 12:19 PM

I would definitely use one table and sort the required outpud by just changing the variables by AND and OR LIKE in mysql query.

But if you want to use same db and call by aliases in other places other table just for aliases sound like best bet. You just need to join tables by id for same person. I guess id would numerical. Then its easy to join tables by id and get the values from other table.

Option number 2 sounds better but its more code writing. But then your db would be very flexible for other projects.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

2018-01-23, 12:19 PM	#2
pc Shift Out / X-On Join Date: Jul 2007 Location: unknown Posts: 2,298	I would definitely use one table and sort the required outpud by just changing the variables by AND and OR LIKE in mysql query. But if you want to use same db and call by aliases in other places other table just for aliases sound like best bet. You just need to join tables by id for same person. I guess id would numerical. Then its easy to join tables by id and get the values from other table. Option number 2 sounds better but its more code writing. But then your db would be very flexible for other projects.