Table descriptions

phonetic_word - Store two encodings of phonetic word

  • usually Metaphore and Soundex encoding
  • links the to respective person, camp, org uuid

contact - stores the communication details of an entity

  • a phone, IM, etc
  • can be linked to a person, organization, camp
  • the type is customizable and defined by opt_contact_type

user_preferences - table to store personalization information for a particular user

  • fields include the person uuid, the module, the key and the value

sector - store the aid/support sector associated to a organization, person or group

  • the sector type is customizable by opt_sector

QR Code
QR Code sql:search (generated for current page)