Table of Contents
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 |
