Difference between revisions of "SMS tables"
From ecology
(Created page with "The eEcology SMS reciever (https://github.com/NLeSC/eEcology-SMS-reciever) service recieves SMS messages and stores them. The messages are stored in the PostgreSQL server at db....") |
(No difference)
|
Revision as of 10:08, 11 May 2015
The eEcology SMS reciever (https://github.com/NLeSC/eEcology-SMS-reciever) service recieves SMS messages and stores them.
The messages are stored in the PostgreSQL server at db.e-ecology.sara.nl in the eecology database and sms schema. The data can be inserted by the eEcology SMS reciever service. The data can be selected by users with the gps_read role.
Data is stored in 3 tables:
- raw_message
- message
- position