I am trying to end run certain parts of the Openfire database and have gotten a bit confused on two things.
The first bit of confusion is with the ofRoster table. I understand the purposes and values of all the other columns, except the rosterID. I have looked at the Openfire database that has populated this table, and I see no real corrolation to what the purpose of this column, and its value, are for. I have started going through the rest of the Openfire source code, and I have not been able to figure out the uses / purpose of the rosterID.
The second bit of confusion is with the entire openfire database. It would appear that there are not foreign keys / dependancies anywhere within the database. I tried to find a database schema that would outline / illustrate these such dependancies, but I was unable to do so.
Would anyone be able to tell me what the purpose of rosterID is? Also, would anyone know if there are any foreign keys / dependancies within the database? And, if so, where I could go to see that information?