I need to customize DNN Profiles in such a way, that a single user has same profile field values across Portals.

Before designing my own Profile Provider, I am studying DNN Profile architecture deeply. I could not get across 2 fields being used in the Process.

The first one is the "DefinitionID" field in the "Lists" table. This field has a value of -1 for all List entries except for some entries. All of them have a value of 107, and I feel like all of those List entries are related in some way or the other to the Forum Module. What exactly does this field denote???

Second, the "PropertyText" Field in "UserProfile" table. This field has a value of 'NULL" for all rows. Still, in the GetProfile DNN Stored Procedure, if the Value field is NULL, then this field is selected. But, nowhere this field is being updated from the code. When UpdateProfile is called, only PropertyValue is sent to the database, not PropertyText. Any help would be appreciated!!!

I suspected that DefinitionID would relate to ModuleDefinitionID. However, when I checked the ModuleDefinitions table, there was no Module with DefID 107. As there is no PK/FK relationship between ModuleDefnitions & Lists on DefinitonID, I concluded that I was wrong.

However, after your reply, I checked my Admin logs, and found I had deleted a Forum module earlier, whose ID was 107, and as I said, those fields I believed are related to Forum Module, one way or the other. But, when a module is deleted, isn't it expected to clean up its trail left behind in the database???

And thanx regarding your reply on PropertyValue & Text. That cleaned up a lot of doubts. Is there any specific reason to choose the size 3750 ( I mean its not a power of 2)?

Also, there is one last field I couldn't get across in the entire Profile backend.

What does "ProfileData" field in Profile table mean, having entries like:

" border=0>referredTextEditor" type="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">RICH

This RICH string is in every ProfileData field Does that make a user rich???