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

Change log

 
projs/clans/docs/dataset_db_relation_company_component.txt · Last modified: 2014/01/28 00:59 by yoyoliliu     Back to top