| attribute |
data type |
security heading |
member points |
search |
valid input guidelines |
|
|
|
|
|
| user_id |
bigint |
search |
not applicable |
yes |
|
| name |
varchar |
search |
not applicable |
yes |
|
| email |
varchar |
search |
not applicable |
yes |
|
| sex |
varchar |
basic |
not applicable |
yes |
m' (male) or 'f' (female) |
|
| address |
varchar |
basic |
1 point if listed |
yes |
|
| city |
varchar |
basic |
1 point if listed |
yes |
|
| state |
varchar |
basic |
1 point if listed |
yes |
|
| zipcode |
int |
basic |
1 point if listed |
yes |
|
| country |
varchar |
basic |
1 point if listed |
yes |
|
| metro_city |
varchar |
basic |
1 point if listed |
yes |
|
| metro_state |
varchar |
basic |
1 point if listed |
yes |
|
| hometown_city |
varchar |
basic |
1 point if listed |
yes |
|
| hometown_state |
varchar |
basic |
1 point if listed |
yes |
|
| birthday |
datetime |
basic |
1 point if listed |
yes |
|
| birthdate |
datetime |
basic |
1 point if listed |
yes |
String of form mm/dd/yy |
|
| hs_name |
varchar |
education |
1 point if listed |
yes |
|
| hs_year |
int |
education |
1 point if listed |
yes |
4 digit year ('05 -> 2005), between 1900-2100 |
|
| college_name |
varchar |
education |
1 point if listed |
yes |
|
| college_year |
int |
education |
1 point if listed |
yes |
4 digit year ('05 -> 2005), between 1900-2100 |
|
| status |
varchar |
education |
1 point if listed |
yes |
alumnus/alumna',
'grad student', 'undergrad', 'faculty', or 'staff' |
|
| quotes |
varchar |
about |
.01 per character |
yes |
|
| professional |
varchar |
about |
.01 per character |
yes |
|
| student |
varchar |
about |
.01 per character |
yes |
|
| about_me |
varchar |
about |
.01 per character |
yes |
|
| ei |
char |
personality |
1 point if listed |
yes |
'e' (extraversion) or
'I' (intraversion) |
|
| si |
char |
personality |
1 point if listed |
yes |
's' (sensing) or 'i'
(intuition) |
|
| tf |
char |
personality |
1 point if listed |
yes |
't' (thinking) or 'f' (feeling) |
|
| jp |
char |
personality |
1 point if listed |
yes |
'j' (judging) or 'p'
(perceiving) |
|
| clubs_orgs |
varchar |
personal |
3 points per item |
yes |
|
| interests |
varchar |
personal |
3 points per item |
yes |
|
| music |
varchar |
personal |
3 points per item |
yes |
|
| books |
varchar |
personal |
3 points per item |
yes |
|
| movies |
varchar |
personal |
3 points per item |
yes |
|
| tv |
varchar |
personal |
3 points per item |
yes |
|
| concentrations |
varchar |
personal |
3 points per item |
yes |
|
| relationship |
String |
social |
10 points if listed |
no |
'single', 'married', or 'in a relationship' |
|
| men |
boolean |
social |
10 points if listed |
no |
|
| women |
boolean |
social |
10 points if listed |
no |
|
| network |
boolean |
social |
10 points if listed |
no |
|
| friendship |
boolean |
social |
10 points if listed |
no |
|
| dating |
boolean |
social |
10 points if listed |
no |
|
| phone |
varchar |
offline_contact |
10 points if listed |
yes |
'xxx.xxx.xxxx' where x is a
number |
|
| mobile |
varchar |
offline_contact |
10 points if listed |
yes |
'xxx.xxx.xxxx' where x is a
number |
|
| aim_name |
varchar |
online_contact |
10 points if listed |
yes |
|
| website |
varchar |
online_contact |
10 points if listed |
yes |
|
| campus_address |
varchar |
offline_contact |
10 points if listed |
yes |
|
| user's friends |
long [] |
friend |
not applicable |
n/a |
|
| user's groups |
long [] |
group |
not applicable |
n/a |
|
| user's events |
long [] |
event |
not applicable |
n/a |
|
| user's wall |
String [] |
wall |
not applicable |
n/a |
|
| create_time |
datetime |
membership |
1 point per day |
n/a |
|
| last_modify_time |
datetime |
membership |
not applicable |
n/a |
|
| number of updates |
int |
membership |
.5 points per update |
n/a |
|
| member points |
int |
membership |
not applicable |
n/a |
|
| number of secrets |
int |
membership |
1000 points per secret |
n/a |
|
| rank |
char |
membership |
|
|
| member points |
rank |
|
| < 1000 points |
not available |
|
| 1000-4999 points |
bronze |
|
| 5000-9999 points |
silver |
|
| 10000-24999 points |
gold |
|
| > 25000 points |
platinum |
|
|
| Table WS2-1
- Summary of Attributes |
|
|
| attribute |
|
|
member points |
|
|
|
| friend |
|
8 points per entry |
|
| friend of friend |
|
4 points per entry |
|
| friend of friend of friend |
|
2 points per entry |
|
| friend of
friend of friend of friend |
|
2 points per entry |
|
| users blocked |
|
-1 point per entry |
|
| user blocked by others |
|
-2 points per entry |
|
|
| group administrator |
|
2 points per group |
|
| number of
group members |
|
.4 points per member |
|
| number of
group messages |
|
.2 points per message |
|
| number of groupies |
|
.3 points per member |
|
|
| group member |
|
1 point per group |
|
| number of
group members |
|
.2 points per member |
|
| number of
group messages |
|
.1 points per message |
|
|
| event administrator |
|
2 points per event |
|
| number of
event members |
|
.4 points per member |
|
| number of
event messages |
|
.2 points per message |
|
| number of event crashers |
|
.3 points per member |
|
|
| event member |
|
1 point per event |
|
| number of
event members |
|
.2 points per member |
|
| number of
event messages |
|
.1 points per message |
|
|
| sent messages |
|
1 point per message |
|
| private messages |
|
2 points per message |
|
| messages
from any type of friend |
|
.5 points per message |
|
|
| Table WS2-2
- Summary of Attributes |
|
|
|
|
|
|
|
|