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

[eluser]rogierb[/eluser]
If this is for a contentmanagement system, you might want to add multilanguage support, extended publication (when, what time, specific roles, end date/time, when modified etc.) and ordering.

If there's going to be a lot of content, then splitting in groups might no be enough. Maybe some form of categories per group? or groups per category?

As for the content itself, 3 fields will normaly do: Title, intro and content. I've used this for FAQ. news, articles and so on. If there is need for more fields, just add another table like Jedd and Kgill suggested.
I call mine "content_detail" where everything besides content and publication data is stored. Files, fields, dates, whatever I like and need.


Messages In This Thread
Setting up a Complex Database - Just looking for approval on structure - by El Forum - 10-05-2009, 06:40 AM



Theme © iAndrew 2016 - Forum software by © MyBB