Page 1 of 1

Expanding the built-in user table or adding a new one?

Posted: Sat May 27, 2023 11:13 am
by camti
Hello,
I have a question about nubuilder's user table:
I was wondering, if it is okay to expand it with additional fields or if it should rather be left intact?

I am asking, since I want to add some fields about users, such as certifications/ qualifications, with expiry dates.
However, this other information about a user could also be added into a separate table and be linked from there, I guess.

Any reason to leave the user table "as is", or can I go ahead and expand it?

Thanks in advance for your pointers!

Re: Expanding the built-in user table or adding a new one?

Posted: Sat May 27, 2023 11:19 am
by kev1n
Hi,

It is not recommened to modfiy nuBuilder's core tables (prefixed with zzzz-).
During system updates, they will be reset/restored to their initial state.

Creating a separate table specifically for storing this additional information and establishing a relationship with the user table through a suitable key, such as a user ID, would be the better option. This way, you can associate the certifications/qualifications data with the corresponding user without modifying the core user table.

Re: Expanding the built-in user table or adding a new one?

Posted: Sat May 27, 2023 3:24 pm
by camti
Great - thank you for the super quick response; good thing I asked. Will proceed as suggested then.