I propose the following data model (mysql db, right?)

(work in progress)

• user table (created on sandbox environment 6/19/06)
  • id - int(11), autoincrement
  • username - char(20)
  • password - char (20)
  • email - char(40)
  • ipaddress - char(15)

• pledge table (created on sandbox environment 6/19/06)
  • id - int(11), autoincrement
  • subscription (bit or true/false)
  • amount - (currency data type?)
  • userid - int(11), lookup to user table
  • projectid - int(11), lookup to project table
  • source - char(6), paypal/cc (should be another table and have a lookup back to this table, but...this is simpler)
  • commentid - int(11), to track the blog post's comment. I was thinking the pledges could be treated as comments for the project's blog post...we can leverage wordpress so we don't have to re-work the comment structure

• project table (created on sandbox environment 6/19/06)
  • id - int(11), autoincrement
  • postid - int(11), to track the blog post id of the project
  • required_amount - (currency data type?)
  • total - (currency data type?)
  • target_date - date/time

! not yet complete, ran out of time this morning :)

 Create your own free wiki!Support CommunityPublic, not yet premium Privacy Policy RSS