CMS Database Design

July 22, 2009 by paulhenry
Filed under: Developement Projects 

Hi all, it has been a while since I posted something new. I have been on a trip fixing up a house, but hey! I have been getting lots of programming in during my free time.

I think I have pretty much finalized the database design for the Competition Management System that is under development. Here is an image:
cms_db.jpg

Everything grouped under Registered Competition Tables basically all depends on a single competition entry into the Competitions table. Notice the separate accounts table, every type of account, except for admins, is linked from that table to either a Competition entry, a school entry or a team entry via the links table. This also allows for multiple links from a single account.

Comments

One Comment on CMS Database Design

  1. How I Lost 30 Pounds in 30 Days Without Diet on Fri, 24th Jul 2009 5:51 am
  2. Thanks for posting about this, I would love to read more about this topic.