Translations:SMS handler setup/42/en
Data tables
Data tables are stored in the 'data' schema. Their structure depends on the data required, but they must have have the following fields which are automatically updated:
- id: unique record id
- userid: integer referencing the user ID of the submitting user (from the 'users' table);
- report_date: timestamp of data submission
- msgid bigint: the unique id of the incoming SMS message
- created_on and modified_on: dates
- created_by and modified_by: user IDs
- del: deleted flag