...

• • An interface to configure SMS and email frequency

  • An interface to configure organisation(s) SMS API

  • An interface to configure organisation(s) Email Gateway

Database Structure

Entity 1:

...

sms_gateway_configurations

• • Id

  • identifier

...

• • Id

  • communication_preference

  • language_preference

  • high_priorities

  • medium_priorities

  • low priorities

Entity 2: SMSConfigurations

• • Id

  • organisation

  • auth_token

  • accountid

  • option

Entity 3:

...

email_gateway_configurations

• • Id

  • organisationidentifier

  • auth_token

  • auth_secret

  • port

  • host

  • port

  • username

  • app_idhost

  • option