Table of Contents
Description
Table: store employees' basic information in the company
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
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 |