Page 1 of 1

database structure question

PostPosted: Tue Feb 21, 2012 10:17 am
by Dataguru
I want to end up with and app that for program staff detects the user's program at login and displays only info related to their program.
Right now, I have it set up like the bottom diagram in the image below, but I'm now leaning toward the top structure being the best way to do it.
Which is the better way to structure the db in the context of how Xataface works?

Image

Thanks,
Betty

Re: database structure question

PostPosted: Tue Feb 21, 2012 12:08 pm
by Dataguru
Here's a better representation of the joins. They're all one to many (left to right)

Image