Custom User Account Fields

[Rowbotronics]

We need a way to add custom fields to users through the UI. Otherwise it would be necessary to update the code any time a new user field is required, which would be tedious and error-prone.

Implementation possibilities:

• Create a new table per custom field named based on field name that contains user ID, and field value

• Create a table for all custom fields with columns for user ID, field ID, field value. Pair it with a table that maps custom field name, ID, and type. Entity Attribute Value Model?

• Use something like postgres json datatype to store all custom fields in a single column in the user table.

• Field type

  • Text
  • Number
  • Image
  • Date

• Default value

• Value