This is an old revision of the document!
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) |
