Saturday, January 13, 2007

Overview

The data is stored in ONE table, this is a weak design for simplicity.Later I will try to improve it, using relational tables.

Looks like another table s needed
The one containing... PEOPLE. Because ideas/creations come from always from somebody. This is a mandatory.

More to thing about: The relation between the themes.

field description example
the_code the_code 10
the_root root 1
the_referer origin 1
the_theme theme Music
f1 Song Title
f2 Author
f3 Gender
f4

f5

Preparation

What to do:
  • Try to make some useful and dynamic place where logged people can send its posts.
  • Not so many tables, buttons or other distracting objects.

How:
  • Use mySQL as DB to create table(s) with the data to be stored/displayed
  • Use PHP as programming language
  • Use Apache as http server
  • Ajax? Instant response