In HP QC defect screen whenever a user changes data, automatically that will reflect in the history tab, refer example in the screen shot.
Can I know where this data is stored on HP QC DB tales (I mean list of tables)?
We have verified audit log table, there we can see only id values, based on this identity values data is stored on various tables by QC , hence do you have any idea on the same. Like how this DB designed and what kind of SQL query we have to write in the query builder (for joining what are tableís columns we have to use).
Let me know in case you need any further clarification.
You need to look more closely at the Documentation Library web page for your QC system. I'm pretty sure you'll find a document under the API References section that includes the phrase "Database Reference" in its title.
(Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)