Surplus

From LVL1
Revision as of 23:21, 1 October 2010 by Joepugh (Talk | contribs)

Jump to: navigation, search


Tables

List of tables needed

User point distribution table

trans_id //self incrementing ID
time_stamp //time stamp
user_id //user ID
prod_id //ID of product that are putting the point in
point_val //monetary value of the point being placed in the product


product list table

prod_id //self incrementing ID
prod_name //name of product
prod_discrip //detailed description with a link
prod_value //Value of product
prod_owner //who is taking charge of this product
status //status as in active/purchased/abandoned