MySQL database
11 aug 2015 11:41am
tables/fields
registration [table]
mem_id (key)
screenname
emailaddress
password
homebase_id
agegroup_id
gender_id
bio (optional)
avatarimage
member activity (explorer/creator) [table]
mem_id (key)
creator_flag - have they created one or more stories?
exploreposition_id - where in the world do they stand?
num_stories - # of stories explored
num_chapters
num_subchapters
avg_storytime
num_comments - comments given to others' stories
num_likes - likes given to others' stories
num_links - external page links clicked
num_definitions - definitions explored (see definitions)
etc
story [table]
story_id (key)
title
ts_1st_pub - timestamp first published
ts_last_edit
num_edits - number of times the creator has added/deleted/edited any part of the story
position_id - what community sphere is the story in?
total_accum_time - the time all explorers spend within a story
story_mem [table] - what members are connected to what stories
story_id (key)
mem_id
community [table]
story_id (key)
comm_name
num_stories
num_subcomm
chapters [table]
story_id (key)
title
ts_1st_pub
ts_last_edit
num_edits
subchapters [table]
story_id (key)
title
ts_1st_pub
ts_last_edit
num_edits
tags [table] - keywords (tags) creator specifies w/ story
story_id (key)
tag_name
likes [table]
story_id (key)
mem_id
type (e.g. thumbs up vs. neutral vs. thumbs down)
comments [table]
story_id (key)
mem_id
comment_text
nav_next_story [table] - tracks story to story nav
story_id1 (key) - from story
story_id2 - to story
mem_id - who's navigating
nav_next_chapter [table] - tracks chapter to chapter nav within a story
story_id (key)
chapter_id1 - from chapter
chapter_id2 - to chapter
mem_id - who's navigating
(more coming)
tbd