*****************************************************************************************************

					Tables in our database
					-----------------------

*****************************************************************************************************



+--------------------+
| Tables_in_group802 |
+--------------------+
| members            |
| pre                |
| prediction         |
| regression         |
| stock_table        |
| stocks             |
+--------------------+



1.Table used for collecting data from yahoo finance
  -------------------------------------------------

+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| ID            | int(11)     | YES  |     | NULL    |       |
| stock         | varchar(64) | YES  |     | NULL    |       |
| value         | varchar(16) | YES  |     | NULL    |       |
| changepoints  | varchar(16) | YES  |     | NULL    |       |
| open          | varchar(16) | YES  |     | NULL    |       |
| intra_top     | varchar(16) | YES  |     | NULL    |       |
| intra_down    | varchar(16) | YES  |     | NULL    |       |
| date          | varchar(10) | YES  |     | NULL    |       |
| time          | varchar(6)  | YES  |     | NULL    |       |
| unixtime      | int(12)     | YES  |     | NULL    |       |
| reallocaltime | int(12)     | YES  |     | NULL    |       |
| md5           | varchar(32) | YES  |     | NULL    |       |
+---------------+-------------+------+-----+---------+-------+

2.Table for checking login
  ------------------------

+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| ID       | int(11)     |      | PRI | NULL    | auto_increment |
| USERNAME | varchar(65) |      |     |         |                |
| PASSWORD | varchar(65) |      |     |         |                |
+----------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)


3.Table for storing final data from regression
  ---------------------------------------------

+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| ticker     | varchar(4)   | YES  |     | NULL    |       |
| prediction | varchar(4)   | YES  |     | NULL    |       |
| value      | decimal(7,3) | YES  |     | NULL    |       |
| confidence | decimal(5,2) | YES  |     | NULL    |       |
| profit     | decimal(7,2) | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+

4.Table used for storing the actual and predicted values for last 7 days.
  -----------------------------------------------------------------------


+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| ticker | varchar(20) | YES  |     | NULL    |       |
| day1   | varchar(20) | YES  |     | NULL    |       |
| day2   | varchar(20) | YES  |     | NULL    |       |
| day3   | varchar(20) | YES  |     | NULL    |       |
| day4   | varchar(20) | YES  |     | NULL    |       |
| day5   | varchar(20) | YES  |     | NULL    |       |
| day6   | varchar(20) | YES  |     | NULL    |       |
| day7   | varchar(20) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+

5.Table used for storing the Regression coefficients
  --------------------------------------------------


+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| ticker | varchar(20) | YES  |     | NULL    |       |
| day1   | varchar(20) | YES  |     | NULL    |       |
| day2   | varchar(20) | YES  |     | NULL    |       |
| day3   | varchar(20) | YES  |     | NULL    |       |
| day4   | varchar(20) | YES  |     | NULL    |       |
| day5   | varchar(20) | YES  |     | NULL    |       |
| day6   | varchar(20) | YES  |     | NULL    |       |
| day7   | varchar(20) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+




