Skip to content

Extra fields should not exist in numbered fields like field_1, field_2, etc. #559

@brassy-endomorph

Description

@brassy-endomorph

Is your feature request related to a problem? Please describe.

We have several fields named field_name_X where X is an int. This limits us to a finite number and forces us to manually create an array to iterate over. We also would need some strange logic to keep them full at the smaller index (e.g., field_1 will never be null if field_2 is non-null).

Describe the solution you'd like

We should use a second table and join it to the users table. This is preferrable to making each field its own array since they are strictly relatated.

Describe alternatives you've considered

We could have one field called extra_fields in the current table that is a JSONB[] type which contains objects that have three fields: label, value, and verified. This looser schema could lead to the introduction of errors, and it would be preferable to use PG to enforce a strict schema.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    Status

    BL-P6 - Code & Doc Enhancements

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions