Event Rules
News Feed Table Event Type Action Shortcuts SHARING view action, comment
When a share is completed
post 1 record in the event (i.e. news_feed) table post a record in the event_entities table for each entity involved (e.g. person, item, community, etc)
When someone starts sharing an item
post 1 record in the event table post a record in the event_entities table for each entity involved (e.g. person, item, community, etc)
ADD ITEM
view item, comment
When someone leaves negative feedback
post 1 record in the event table post a record in the event_entities table for each entity involved (e.g. person, item, community, etc)
NEGATIVE FEEDBACK
view feedback (this shortcut will load the action in question), comment
When a gift is given
post 1 record in the event (i.e. news_feed) table post a record in the event_entities table for each entity involved (e.g. person, item, community, etc)
GIFTING
view action, comment
When trust is established
post 1 record in the event (i.e. news_feed) table post a record in the event_entities table for each entity involved (e.g. person, item, community, etc)
TRUST ESTABLISHED
comment
When trust is withdrawn
post 1 record in the event (i.e. news_feed) table post a record in the event_entities table for each entity involved (e.g. person, item, community, etc)
TRUST WITHDRAWN
comment
When an item is marked as damaged
post 1 record in the event (i.e. news_feed) table post a record in the event_entities table for each entity involved (e.g. person, item, community, etc)
ITEM DAMAGED
view item, comment
When an item is marked as repaired
post 1 record in the event (i.e. news_feed) table post a record in the event_entities table for each entity involved (e.g. person, item, community, etc)
ITEM REPAIRED
view item, comment
post 1 record in the event (i.e. news_feed) table post a record in the event_entities table for each entity involved (e.g. person, item, community, etc)
FB FRIEND JOIN
view profile, comment
When a Facebook friend joins sharedearth. net (ignore this one if its difficult)
If TYPE equals
User's involvement (calculated at display time)
Then Display
Example
SHARING
You are involved as the gifter
(person_short_name) borrowed your (object_type)
John borrowed your bike
You are involved as the requestor
You borrowed (person_short_name)'s (object_type) (trusted_short_name) shared their (object_type) with (other_party_short_name)
You borrowed Dan's bike
One trusted person is involved as the requestor Two trusted people or no trusted people are involved (e.g. you trust both people, or you belong to the same group and trust neither)
(trusted_short_name) borrowed (other_party_short_name)'s (object_type)
John borrowed Dan's bike
Action shortcuts view action, comment view action, comment view action, comment view action, comment
(gifter_short_name) shared their (object_type) with (requestor_short_name)
Dan shared their bike with John
view action, comment
You added the item
You are now sharing your (object_type)
You are now sharing your bike
Someone else added the item
(person_short_name) is now sharing their (object_type)
Dan is now sharing their bike
The negative feedback is for you
(person_short_name) left negative feedback about you
John left negative feedback about you
You left negative feedback for someone else
You left negative feedback about (person_short_name)
You left negative feedback about John
It relates to other people
(receiver_full_name) received negative feedback from (giver_full_name)
Dan Gooden received negative feedback from John Keys
You are involved as the gifter
You gifted your (object_type) to (person_short_name)
You gifted your bike to John
You are involved as the requestor
You received (gifter_short_name)'s (object_type)
You received Dan's bike
One trusted person is involved as the gifter One trusted person is involved as the requestor Two trusted people or no trusted people are involved (e.g. you trust both people, or you belong to the same group and trust neither)
(trusted_short_name) gifted their (object_type) to (other_party_short_name) (trusted_short_name) received (other_party_short_name)'s (object_type)
Dan gifted their bike to John John received Dan's bike
(trusted_short_name) gifted their (object_type) to (other_party_short_name)
Dan gifted their bike to John
You are involved
You have established a trusted relationship with (other_party_short_name) (trusted_short_name) has established a trusted relationship with (other_party_full_name)
You have established a trusted relationship with John John has established a trusted relationship with Dan Gooden
comment
(person_1_short_name) and (person_2_short_name) have established a trusted relationship
John and Dan have established a trusted relationship
comment
You withdrew trust Someone else withdrew trust for you One trusted person is involved Two trusted people or no trusted people are involved (e.g. you trust both people, or you belong to the same group and trust neither)
You have withdrawn your trust for (other_party_full_name) (other_party_full_name) has withdrawn their trust for you (trusted_short_name) has withdrawn their trust for (other_party_full_name)
You have withdrawn your trust for John Keys Dan Gooden has withdrawn their trust for you Dan has withdrawn their trust for John Keys
comment comment comment
(withdrawer_short_name) has withdrawn their trust for (other_party_short_name)
Dan has withdrawn their trust for John
comment
ITEM DAMAGED
You own the item Someone else own's the item
Your item ((object_type)) is broken (owners_short_name)'s item ((object_type)) is broken
Your item (bike) is broken Dan's item (bike) is broken
view item view item
ITEM REPAIRED
You own the item Someone else own's the item
Your item ((object_type)) has been repaired (owners_short_name)'s item ((object_type)) has been repaired
Your item (bike) has been repaired Dan's item (bike) has been repaired
view item, request view item, request
FB FRIEND JOIN
You are friends with this person on FB
(friends_full_name) has connected to sharedearth.net
Dan Gooden has connected to sharedearth.net
establish trust, comment
SHAREAGE
You are involved as the gifter
(person_name) borrowed your (object_type)
John borrowed your bike
You are involved as the requestor
You borrowed (person_name)'s (object_type)
You borrowed Dan's bike
One trusted person is involved as the gifter
(trusted_name) lent their (object_type) to (other_party_name)
Dan lent their bike to John
One trusted person is involved as the requestor Two trusted people or no trusted people are involved (e.g. you trust both people, or you belong to the same group and trust neither)
(trusted_name) borrowed (other_party_name)'s (object_type)
John borrowed Dan's bike
view action, comment view action, comment view action, comment view action, comment
(gifter_name) lent their (object_type) to (requestor_name)
Dan lent their bike to John
view action, comment
New item ask (short term)
(asker name\You) (need\need) to borrow (indefinite article) (object_type)
Dan needs to borrow rollerskates
New item ask (long term)
(asker name\You) (needs\need) (indefinite article) (object_type)
You need a fridge
view ask, share mine, comment view ask, gift mine, shareage mine, comment
New assistance ask
(asker name\You) (needs\need) (ask)
James needs IT help
view ask, offer, comment
One trusted person is involved as the gifter
ADD ITEM
NEGATIVE FEEDBACK
GIFTING
TRUST ESTABLISHED
One trusted person is involved Two trusted people or no trusted people are involved (e.g. you trust both people, or you belong to the same group and trust neither) TRUST WITHDRAWN
ITEM ASK
ASSISTANCE ASK
Dan shared their bike with John
view item, comment view item, request, comment view feedback, comment view feedback, comment view feedback, comment view action, comment view action, comment view action, comment
view action, comment
comment
No
Activity Type shared their shared started sharing a gifted a received a gifted gifted received assistance 7 from
Primary User Dan Andrea Dan Dan Andrea John
Item bike bike bike brush brush time
Secondary User Andrea Dan
Bill
time
John
8 gifted
Gazza
gardening
James
assistance to
James James James James
gardening gardening spade help moving
Gazza
assistance from skills
Dan
bike
Bill
Bill
bike
Dan
1 2 3 4 5 6
9 10 11 12 13 14
15 16
received is requesting is requesting a is requesting posted negative feedback after sharing received negative feedback after sharing posted negative feedback after sharing their received negative feedback after sharing
Andrea Dan Bill
Dan
bike
Bill
Bill
bike
Dan
Request ID 1 with 's to from to
with
Post Construction Dan shared their bike with Andrea Andrea shared Dan's bike Dan started sharing a bike Dan gifted a brush to Andrea Andrea received a gifted brush from Dan John gifted time to Bill
TYPE SHARING SHARING ADD ITEM ITEM GIFTING ITEM GIFTING TIME GIFTING
Bill received assistance from John Gazza gifted gardening assistance to James James received gardening assistance from Gazza James is requesting gardening skills James is requesting a spade James is requesting help moving Dan posted negative feedback after sharing Bill's bike Bill received negative feedback after sharing Dan's bike
TIME GIFTING
Dan posted negative feedback after sharing their bike with Bill Bill received negative feedback after sharing Dan's bike
SKILL GIFTING SKILL GIFTING SKILL REQUEST GENERAL ITEM GENERAL REQUEST GENERAL REQUEST FEEDBACK FEEDBACK
FEEDBACK FEEDBACK
Relevancy Examples someone trusted in a village making a request trusted network sharing in a village untrusted in a village making a request untrusted in a village making a request trusted network sharing trusted network making a request one side trusted in a village sharing trusted network giving away an item
trusted 4 4
4 4 4 4
trusted 2
village 2 2 2 2
2
community 1
1 2
request \ gift 3 0 3 3 0 3 0 3
above average 1 1
-1
total 10 9 6 5 7 6 6 7
Distinct Num People 5 2 5 5 15 15 2 3 1 3 1 2 1 3 4 4 5 10
Number Gift Actions 32 100 50 200 200 180 5 3 100 15 1 2 100 4 4 7 8 19
Positive Feedback 100 75 100 100 34 96 100 98 87 98 100 99.99 100 100 100 100 100 100
Summarised Value 5.6 4.5 6.5 14 8.16 22.08 1.25 2.107 4.35 2.695 0.05 1.09989 5 2.2 3.2 3.35 4.4 9.95
