Differences
This shows you the differences between two versions of the page.
|
projs:clans:docs:dataset_db_relation_company_component [2014/01/27 11:18] yoyoliliu created |
projs:clans:docs:dataset_db_relation_company_component [2014/01/28 00:59] (current) yoyoliliu |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Description ====== | ====== Description ====== | ||
| + | Table: store employees' basic information in the company | ||
| + | |||
| ====== Table format ====== | ====== Table format ====== | ||
| + | ^ Field ^ Type ^ NULL ^Key ^Default ^Extra ^ | ||
| + | | id | INT(11) | | | | the unique identifier of every record in this table| | ||
| + | | rcid1 | INT(11) | | | | refer to id in relation_company| | ||
| + | | pid1 | INT(11) | | | | person who worked in stock_id1 in relation_company| | ||
| + | | position_rank1 | INT(11) | | | | the position rank of pid1 in stock_id1 in relation_company| | ||
| + | | pid2 | INT(11) | | | | person who worked in stock_id1 in relation_company| | ||
| + | | rcid2 | INT(11) | | | | refer to id in relation_company| | ||
| + | | position_rank2 | INT(11) | | | | the position rank of pid2 in stock_id2 in relation_company| | ||
| + | | weight | DOUBLE(20,10) | | | | | | ||
| + | | type | VARCHAR(11) | | | | if type is t, it means this person worked in both company, if type is w, it means these two people used to be colleague, if type is e, it means these two people are alumni| | ||
| + | | year | INT(11) | | | | | | ||
| + | |||
| ====== Record example ====== | ====== Record example ====== | ||
| + | ^id ^rcid1 ^pid1 ^position_rank1 ^pid2 ^rcid2 ^position_rank2 ^weight ^type ^year ^ | ||
| + | | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1.0 | t | 2011 | | ||
| + | | 2 | 2 | 1 | 1 | 159634 | 156370 | 0 | 0.00793538 | w | 2011 | | ||
| + | | 3 | 3 | 1 | 1 | 22366 | 16108 | 3 | 0.14956561 | w | 2011 | | ||
| + | | 4 | 4 | 1 | 1 | 73187 | 37743 | 9 | 0.00793538 | w | 2011 | | ||
| + | | 5 | 5 | 1 | 1 | 117642 | 59517 | 3 | 0.00793538 | w | 2011 | | ||
| + | | 6 | 6 | 1 | 1 | 163660 | 167002 | 1 | 0.00793538 | w | 2011 | | ||
| + | | 7 | 6 | 1 | 1 | 163662 | 167002 | 3 | 0.00793538 | w | 2011 | | ||
| + | | 8 | 7 | 1 | 1 | 163945 | 167545 | 1 | 0.12381549 | w | 2011 | | ||
| + | | 9 | 7 | 1 | 1 | 163962 | 167545 | 3 | 0.09470667 | w | 2011 | | ||
| + | | 10 | 8 | 1 | 1 | 300049 | 226800 | 0 | 0.00793538 | w | 2011 | | ||
| + | |||
| ====== Change log ====== | ====== Change log ====== | ||
