Changes between Version 6 and Version 7 of BluePrint/SocialMedia/GHC2013SocialMediaHITProcessing


Ignore:
Timestamp:
10/05/13 07:19:39 (8 years ago)
Author:
Pat Tressel
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • BluePrint/SocialMedia/GHC2013SocialMediaHITProcessing

    v6 v7  
    3838=== Add database tables for message processing tasks ===
    3939
     40Received messages are stored in the "message log" table, msg_message.[[BR]]
     41https://github.com/flavour/eden/blob/master/modules/s3db/msg.py#L93
     42(This is a special kind of table called (in Eden terminology) a "superentity". This is like a superclass
     43but for database tables. Records in multiple specialized tables have "parent" records in a shared
     44superentity table, so other tables can refer to any of the specialized tables without needing a foreign
     45key field for every one.)
     46
     47We want to add a table that joins to this to hold the data entered by a worker for a message.
     48That table will need fields for:
     49 * A foreign key reference to the msg_message table. Here is another table with such a reference:[[BR]]
     50   https://github.com/flavour/eden/blob/master/modules/s3db/msg.py#L1609
     51 r A category that the worker will assign. This can be just a text field.
     52 * A location that the worker will enter either by filling out a form and / or clicking on a map.
     53   There is a standard widget for selecting locations that will be included automatically if the
     54   location is specified as in this example:
    4055=== Add a controller to generate task pages for workers ===
    4156