Surplus: Difference between revisions
Jump to navigation
Jump to 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…' |
No edit summary |
||
| Line 1: | Line 1: | ||
==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