What database field type should I use for an encoded user ID?

[HenryParadiz]

Maybe I'm blind but I can't seem to find the field type definition for a user ID.

Is a char (6) enough?

[GordonFitbit · Accepted solution]

Hi @HenryParadiz,

Unfortunately, we don't have documentation on the field type definition for the user ID.  At a minimum, you can define the value as a char(6), but you might want to define the string a little larger as our user base increases.

Gordon