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
Diperoleh dari "http://wiki.isikhnas.com/index.php?title=Translations:SMS_handler_setup/40/en&oldid=13216"