Normalizing
eharetea

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.