The table user_custom_fields.value column has PostgreSQL type text. So it can store a LOT, and you can read more about that in PostgreSQL docs (search for TOAST).
We are discussing moving some heavy data plugins to their own tables, and how to deal with plugin removal and table ownership here: Adding jsonb columns for custom fields