3Daet.com | Normalizing

A basic model of a normalized database.

MySQL normalization.

Date Created:Friday December 29th, 2006 03:41 AM
Date Modified:Friday August 01st, 2008 03:03 AM

users

user_id
email
password
registration_date

projects

project_id
title
path
username
date_created
approved

files

file_id
proj_id
title
upload_date
username
revision_num

comments

comment_id
link_id
type
comment

categories

category_id
parent_id
title

pages

page_id
title
description

viewdisplay

view_id
page_id
title

associations

assoc_id
link_id
category_id
type

type is used so projects and files can be in a category.
That way as projects grow, files within a project may not be just one file modified...
but a project of multiple files modified.

associations allows linkage of a type ( project, file ) to have multiple categores

categories, files, and projects have comments.