| | 40 | Received messages are stored in the "message log" table, msg_message.[[BR]] |
| | 41 | https://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 |
| | 43 | but for database tables. Records in multiple specialized tables have "parent" records in a shared |
| | 44 | superentity table, so other tables can refer to any of the specialized tables without needing a foreign |
| | 45 | key field for every one.) |
| | 46 | |
| | 47 | We want to add a table that joins to this to hold the data entered by a worker for a message. |
| | 48 | That 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: |
