Differences
This shows you the differences between two versions of the page.
|
projs:clans:docs:dataset_db_relation_company [2014/01/22 18:11] yoyoliliu created |
projs:clans:docs:dataset_db_relation_company [2014/01/28 01:02] (current) yoyoliliu |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| Table: relation_company stores the relationship of listed companies. | Table: relation_company stores the relationship of listed companies. | ||
| ====== Data Schema ====== | ====== 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 ====== | ====== 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 | | ||
| + | |||
| ====== Change Log ====== | ====== Change Log ====== | ||
