Encrypted Database Fields

In order to keep personal data secure, encryption at rest has been implemented on several tables (only on particular columns).

It is important to realise that encrypted columns cannot easily be aggregated.

Listed below are the tables that include encrypted columns:

Table

Encrypted Column

Table

Encrypted Column

referrals

name

 

email

 

phone

 

other_contact

 

postcode_outward_code

 

comments

 

referee_name

 

referee_email

 

referee_phone

notifications

recipient

 

message