Translations:SMS handler setup/40/en
Reference tables
Reference tables are in the reference schema. Structure varies but most have at least the following fields:
- id: unique record id
- code: an alpha code
- hier_code: a dot separated hierarchical code in the form 1.1.1. This is used to arrange data at different levels of detail, allowing more flexible analysis
- name: varchar[] - a text array field with the name in Indonesian at index 1, and English at index 2
- valid_from and valid_to: dates indicating the period of validity of the item. Valid_to may be null indicating ongoing validity.
- modified_by: user id of the last user to modify the value
- modified_on: timestamp of the last modification
- del: boolean flag for deleted