Cleaning some data out of database

[catdude]

I've been experimenting with SNMP items, adjusting multiplier values, etc (for example, reading octet values and converting to bits/second). In the process of this experimentation I've ended up with some invalid data in the database. I'd like to be able to clean out the data values for the period where I was experimenting.

Could anyone point me to documentation on the database schema so I can figure out what I need to delete?

[aib]

It's not easy to do it manually.
The fastest solution can be change History Storage period and Trend Storage period to the lowest number (like 1 day) and wait until Housekeeping process remove all data automatically and correctly.

[catdude]

I can do that, thanks. Makes sense, if the schema is very complicated.

[aib]

Yes, it's complicated.
Attached image is only the list of Tables without links.

[catdude]

And it's unfortunately very difficult to initially document the relationships between tables, and to keep those relationships documented as the software changes. I've had that problem on my own projects, and they haven't been nearly as large as Zabbix.