Welcome Guest, Not a member yet? Register   Sign In
Setting up a Complex Database - Just looking for approval on structure
#1

[eluser]Gwarrior[/eluser]
I've read many guides on database normalization through my years as a web developer, but I am now on a fairly large project, and wondering if my structure is correct.

It is a Content Management System btw:

CONTENT DB

content table
id
page
trigger
is_new
post_date
group_name
is_loop
description


fields table
field_id
main_id
title
field_1
field_2
field_3
field_4
field_5
field_6
field_7
field_8
image_1
image_2
image_3
image_4
image_5
timestamp
author


groups table
group_id
group_name


Where 'main_id' in fields is the 'id' of the content table, and groups is simply there to create the dropdown where you can select which existing group you want to use when creating trigger.

Obviously there are some other features put in there like the 'is_loop' and 'is_new' which are both boolean values, but is the general structure right?

BTW, I'm using the MyISAM engine, but can use the InnoDB if you feel it would be appropriate.

Thanks in advance and I apologize if I didn't include enough pertinent information to answer the question.


Messages In This Thread
Setting up a Complex Database - Just looking for approval on structure - by El Forum - 10-04-2009, 09:02 PM



Theme © iAndrew 2016 - Forum software by © MyBB