search

AnEA / living-history-swe

Automatically exported from code.google.com/p/living-history-swe
0 stars 0 forks source link

Review the initial database design #11

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Please review the initial database design submitted by Onat.

Original issue reported on code.google.com by hbi...@gmail.com on 26 Nov 2014 at 6:30

Attachments:

GoogleCodeExporter commented 8 years ago

Original comment by hbi...@gmail.com on 26 Nov 2014 at 6:34

GoogleCodeExporter commented 8 years ago 
Here are my comments:

* 'Timetype' table might be redundant. We can just store time format  in 
'Memory' table.
* In 'User' table, we may use email address as unique key, instead of userId. 
The user's email must be unique anyway.
* We need to separate location data from memory table to prevent data 
duplication.

I am not sure if we are required to implement memory comments(responses should 
be enough for us). We should check that from RSD document. @Eser, can you 
confirm this one?

Original comment by hbi...@gmail.com on 26 Nov 2014 at 6:53

GoogleCodeExporter commented 8 years ago 
* Timetype is not needed. Time format will be stored in the memory table as 
suggested by  Halil. 
* In the table for user, email address will be used as the unique key since all 
email addresses are already unique. 
* Location tags should be removed from the table related to memory. 
* According to RSD version 5.0, CommentMemory function is the only function 
that will be used in terms of user response function group. This one and only 
function enables the users to respond to the existing memories. And for this 
functionality, a few predefined responses will be used (such as "I remember 
that",  "I agree with that", etc.

Original comment by esergo...@gmail.com on 1 Dec 2014 at 1:14