Table of Contents
Description
Table: relation_company stores the relationship of listed companies.
Data Schema
| Field | Type | NULL | Key | Default | Extra |
|---|---|---|---|---|---|
| id | INT(11) | the unique identifier of every record in this table | |||
| stock_id1 | INT(11) | ||||
| stock_id2 | INT(11) | ||||
| weight | DOUBLE(20,10) | the value of relation | |||
| year | INT(11) | ||||
| nweight | DOUBLE(20,10) | the normolized weight |
Record Example
| id | stock_id1 | stock_id2 | weight | year | nweight |
|---|---|---|---|---|---|
| 1 | 1 | 601328 | 9.696827534 | 2011 | 0.1336089177 |
| 2 | 1 | 300234 | 0.07141842 | 2011 | 0.0009840474 |
| 3 | 1 | 428 | 1.34609049 | 2011 | 0.0185472716 |
| 4 | 1 | 783 | 0.0793538 | 2011 | 0.001093386 |
| 5 | 1 | 2059 | 0.07141842 | 2011 | 0.0009840474 |
| 6 | 1 | 600015 | 0.16664298 | 2011 | 0.0022961106 |
| 7 | 1 | 600016 | 2.91014732 | 2011 | 0.0400978188 |
| 8 | 1 | 600754 | 0.07141842 | 2011 | 0.0009840474 |
| 9 | 1 | 600837 | 1.20315994 | 2011 | 0.0165778856 |
| 10 | 1 | 600895 | 0.1505495 | 2011 | 0.0020743646 |
