Difference between revisions of "Surplus"
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…') |
|||
(One intermediate revision by the same user not shown) | |||
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 12: | ||
− | product list table | + | ===product list table=== |
prod_id //self incrementing ID<br> | prod_id //self incrementing ID<br> | ||
Line 21: | Line 20: | ||
prod_owner //who is taking charge of this product<br> | prod_owner //who is taking charge of this product<br> | ||
status //status as in active/purchased/abandoned | status //status as in active/purchased/abandoned | ||
+ | |||
+ | ===admin table=== | ||
+ | |||
+ | open_id //self incrementing ID<br> | ||
+ | open_date //this will outline the date that points can be spent<br> | ||
+ | close_date //this will outline cut off date for using point<br> | ||
+ | surplus //this is the surplus for the month.<br> |
Latest revision as of 04:51, 2 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
admin table
open_id //self incrementing ID
open_date //this will outline the date that points can be spent
close_date //this will outline cut off date for using point
surplus //this is the surplus for the month.