Difference between revisions of "Surplus"

From LVL1
Jump to: navigation, search
(Created page with '==Surplus system== ===Tables=== List of tables needed User point distribution table trans_id //self incrementing ID<br> time_stamp //time stamp<br> user_id //user ID<b…')
 
Line 1: Line 1:
==Surplus system==
 
  
===Tables===
+
 
 +
==Tables==
 
List of tables needed
 
List of tables needed
  
User point distribution table
+
===User point distribution table===
  
 
trans_id    //self incrementing ID<br>
 
trans_id    //self incrementing ID<br>
Line 13: Line 13:
  
  
product list table
+
===product list table===
  
 
prod_id      //self incrementing ID<br>
 
prod_id      //self incrementing ID<br>

Revision as of 23:21, 1 October 2010


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