Difference between revisions of "Surplus"

From LVL1
Jump to: navigation, search
 
Line 1: Line 1:
 
  
 
==Tables==
 
==Tables==
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 03: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.