Differences
This shows you the differences between two versions of the page.
projs:clans:docs:dataset_db_relation_company [2014/01/27 11:11] yoyoliliu |
projs:clans:docs:dataset_db_relation_company [2014/01/28 01:02] (current) yoyoliliu |
||
---|---|---|---|
Line 3: | Line 3: | ||
====== Data Schema ====== | ====== Data Schema ====== | ||
^ Field ^ Type ^ NULL ^Key ^Default ^Extra ^ | ^ Field ^ Type ^ NULL ^Key ^Default ^Extra ^ | ||
- | | id| INT(11)| | | | | | + | | id| INT(11)| | | | the unique identifier of every record in this table| |
| stock_id1 | INT(11) | | | | | | | stock_id1 | INT(11) | | | | | | ||
| stock_id2 | INT(11) | | | | | | | stock_id2 | INT(11) | | | | | | ||
- | | weight | DOUBLE(20,10) | | | | | | + | | weight | DOUBLE(20,10) | | | | the value of relation| |
| year | INT(11) | | | | | | | year | INT(11) | | | | | | ||
- | | nweight | DOUBLE(20,10) | | | | | | + | | 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 ====== |