Hi David,
First, thank you for using Community! I see that you've posted several questions about the OnBase schema recently and want to make sure that you have the best information available to answer your questions.
The majority of commonly used tables and columns for reporting - including information about how Keywords and their various configurations relate to documents - can be found in the Database Reporting Guide posted here on Community. I encourage you to read through the document and save it as reference any time you are needing to write a query to select data from the OnBase database.
An additional suggestion - especially if the information you are looking for is not in the guide or if some of the table relationships in the guide aren't clear to you - is to use either Verbose from the OnBase Client/Configuration or Diagnostics Console with the database tab enabled from the Core to see what queries the software is generating when you perform a specific task.
Although this particular question is fairly well documented in the aforementioned guide, a good example would be your question here. Enable verbose in the Client (through the Help > About menu) and then retreive a document's keyword panel. Open up the verbose log, scroll to the bottom and you'll see the query/queries that OnBase issued to populate the keyword panel.
The guide also contains some important information and recommendations on querying the OnBase database to protect against introducing performance issues when reporting - some specific to indexes and some to isolation levels. It's a fairly thorough read over the most common things people need to query for.
Hope that helps.
Ansley
