====== Description ====== Table: company_rank stores the PageRank of listed companies. ====== Data Schema ====== ^ Field ^ Type ^ NULL ^Key ^Default ^Extra^ | id | INT(11)| | | | the unique identifier of every record in this table| | stock_id | INT(20) | | | | foreign key from companyinfor| | out | DOUBLE(20,10) | | | | the total weight of all the edge the stock_id link| | pr| DOUBLE(20,10) | | | | the pagerank value| | sn | DOUBLE(20,10) | | | | the pagerank value of last iteration| | year | INT(11) | | | | | ====== Record Example ====== ^id ^stock_id ^out ^pr ^sn ^year ^ | 1 | 1 | 275.227338 | 0.0023965758 | 0.0023962873 | 2011 | | 2 | 2 | 896.491072 | 0.0027156872 | 0.0027146824 | 2011 | | 3 | 3 | 0.002334 | 6.2175e-05 | 6.2175e-05 | 2011 | | 4 | 4 | 188.033596 | 0.0010019374 | 0.0010016491 | 2011 | | 5 | 5 | 23.891249 | 0.0003777211 | 0.0003779822 | 2011 | | 6 | 6 | 57.78583 | 0.0005844488 | 0.0005847818 | 2011 | | 7 | 7 | 21.882441 | 0.0005939521 | 0.0005940207 | 2011 | | 8 | 8 | 1.878604 | 0.0002534733 | 0.0002534821 | 2011 | | 9 | 9 | 80.179004 | 0.0006854677 | 0.00068579 | 2011 | | 10 | 10 | 51.704216 | 0.0010034586 | 0.0010035409 | 2011 | ====== Change Log ======